SchemaSpy - Table ss716pr.forecast

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
parent_id	char	36	√	null
parent_type	varchar	255	√	null
opportunity_id	char	36	√	null
opportunity_name	varchar	255	√	null
account_name	varchar	255	√	null
account_id	char	36	√	null
campaign_id	char	36	√	null
campaign_name	varchar	255	√	null
product_template_id	char	36	√	null
product_template_name	varchar	255	√	null
category_id	char	36	√	null
category_name	varchar	255	√	null
sales_status	varchar	255	√	null
likely_case	decimal	26,6	√	null
best_case	decimal	26,6	√	null
worst_case	decimal	26,6	√	null
base_rate	decimal	26,6	√	null
currency_id	char	36	√	null
date_closed	date	10	√	null
date_closed_timestamp	int	11	√	null
sales_stage	varchar	255	√	null
probability	double	22	√	null
commit_stage	varchar	50	√	null
draft	int	11	√	0
next_step	varchar	100	√	null
lead_source	varchar	50	√	null
product_type	varchar	255	√	null
list_price	decimal	26,6	√	null
cost_price	decimal	26,6	√	null
discount_price	decimal	26,6	√	null
discount_amount	decimal	26,6	√	null
quantity	int	5	√	1
total_amount	decimal	26,6	√	null

Analyzed at Thu Mar 06 08:42 UTC 2014

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
date_modified	Performance	Asc	forecast_worksheetsmod
team_set_id	Performance	Asc	idx_forecast_worksheets_tmst_id
commit_stage	Performance	Asc	idx_forecastworksheet_commit_stage
sales_stage	Performance	Asc	idx_forecastworksheet_sales_stage
deleted + assigned_user_id	Performance	Asc/Asc	idx_worksheets_assigned_del
deleted + assigned_user_id + draft + date_closed_timestamp + parent_type	Performance	Asc/Asc/Asc/Asc/Asc	idx_worksheets_assigned_del_time_draft_parent_type
parent_id + parent_type	Performance	Asc/Asc	idx_worksheets_parent