SchemaSpy - Table ss674pr.forecast_manager

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
id	char	36
name	varchar	255	√	null
date_entered	datetime	19	√	null
date_modified	datetime	19	√	null
modified_user_id	char	36	√	null
created_by	char	36	√	null
description	text	65535	√	null
deleted	bit	1	√	0
assigned_user_id	char	36	√	null
team_id	char	36	√	null
team_set_id	char	36	√	null
quota	decimal	26,6	√	null
best_case	decimal	26,6	√	null
best_case_adjusted	decimal	26,6	√	null
likely_case	decimal	26,6	√	null
likely_case_adjusted	decimal	26,6	√	null
worst_case	decimal	26,6	√	null
worst_case_adjusted	decimal	26,6	√	null
currency_id	char	36	√	null
base_rate	double	22	√	null
timeperiod_id	char	36	√	null
draft	int	11	√	0
user_id	char	36	√	null
opp_count	int	5	√	null
pipeline_opp_count	int	5	√	0
pipeline_amount	decimal	26,6	√	0.000000
closed_amount	decimal	26,6	√	0.000000

Analyzed at Tue Dec 10 01:37 UTC 2013

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
team_set_id	Performance	Asc	idx_forecast_manager_worksheets_tmst_id
assigned_user_id + user_id + timeperiod_id + draft + deleted	Performance	Asc/Asc/Asc/Asc/Asc	idx_manager_worksheets_user_timestamp_assigned_user