SchemaSpy - Table webco_3.5.5.public.task

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Default
obj_oid	int8	19
label	varchar	2147483647	√	null
parent	int8	19	√	null
children	varchar	2147483647	√	null
depends_on	int8	19	√	null
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_length	varchar	2147483647	√	null
actual_end_time	timestamp	29,6	√	null
due_date	timestamp	29,6	√	null
agency_job_number	varchar	2147483647	√	null
department_job_number	varchar	2147483647	√	null
completed_p	bool	1	√	null
estimate_p	bool	1	√	null
task_status	varchar	2147483647	√	null
main_contact_id	int8	19	√	null
tags	varchar	2147483647	√	null
created_at	timestamp	29,6	√	null
updated_at	timestamp	29,6	√	null
original_oid	int8	19	√	null
time_of_change	timestamp	29,6	√	null
last_checked	timestamp	29,6	√	null
agent	int8	19	√	null

Table contained 0 rows at Mon Mar 15 14:58 EDT 2010

Indexes:

Column(s)	Type	Sort	Constraint Name
obj_oid	Primary key	Asc	task_changes_pkey