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 |
|
|
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 |
|
|
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 |
|
|
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 |
|
|
acl_team_set_id |
char |
36 |
√ |
|
null |
|
|
currency_id |
char |
36 |
√ |
|
-99 |
|
|
base_rate |
decimal |
26,6 |
√ |
|
null |
|
|
Analyzed at Fri Sep 13 08:38 UTC 2019
|