| 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 |
|
| users.id
|
Defined in XML R |
|
| created_by |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| description |
text |
65535 |
√ |
|
null |
|
|
| deleted |
bit |
1 |
√ |
|
0 |
|
|
| assigned_user_id |
char |
36 |
√ |
|
null |
|
| users.id
|
Defined in XML R |
|
| team_id |
char |
36 |
√ |
|
null |
|
| teams.id
|
Defined in XML R |
|
| 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 |
decimal |
26,6 |
√ |
|
null |
|
|
| timeperiod_id |
char |
36 |
√ |
|
null |
|
|
| draft |
bit |
1 |
√ |
|
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 |
|
|
| manager_saved |
bit |
1 |
√ |
|
0 |
|
|
Analyzed at Fri Dec 05 08:33 UTC 2014
|
