Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
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 Fri Jan 17 09:29 UTC 2014
|