| Column |
Type |
Size |
Nulls |
Auto |
Default |
Children |
Parents |
| obj_oid |
int8 |
19 |
|
|
|
| task.depends_on
|
fktask_depends_on_oid |
| task.parent_oid
|
fktask_parent_oid |
|
|
| index |
serial |
10 |
|
√ |
nextval('task_index_seq'::regclass) |
|
|
| label |
varchar |
2147483647 |
√ |
|
null |
|
|
| parent_oid |
int8 |
19 |
√ |
|
null |
|
| task.obj_oid
|
fktask_parent_oid |
|
| depends_on |
int8 |
19 |
√ |
|
null |
|
| task.obj_oid
|
fktask_depends_on_oid |
|
| scheduled_start_time |
timestamp |
29,6 |
√ |
|
null |
|
|
| scheduled_length |
varchar |
2147483647 |
√ |
|
null |
|
|
| scheduled_end_time |
timestamp |
29,6 |
√ |
|
null |
|
|
| time_log |
int8 |
19 |
√ |
|
null |
|
|
| actual_start_time |
timestamp |
29,6 |
√ |
|
null |
|
|
| actual_end_time |
timestamp |
29,6 |
√ |
|
null |
|
|
| agency_job_number |
varchar |
2147483647 |
√ |
|
null |
|
|
| department_job_number |
varchar |
2147483647 |
√ |
|
null |
|
|
| estimate_p |
bool |
1 |
√ |
|
null |
|
|
| started_p |
bool |
1 |
√ |
|
null |
|
|
| task_status |
varchar |
2147483647 |
|
|
|
|
|
| main_contact_oid |
int8 |
19 |
√ |
|
null |
|
|
| client_oid |
int8 |
19 |
√ |
|
null |
|
|
| created_at |
timestamp |
29,6 |
√ |
|
null |
|
|
| updated_at |
timestamp |
29,6 |
√ |
|
null |
|
|
| deleted |
bool |
1 |
√ |
|
null |
|
|
Table contained 0 rows at Wed May 11 15:14 EDT 2011
|
