project

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('project_id_seq'::regclass)
event.project_id fk_3bae0aa7166d1f9c N
project.parent_id fk_2fb3d0ee727aca70 C
project_meta.object_id fk_ee63dc2d232d562b C
name varchar 255 null
db_update.name Implied Constraint R
short_description text 2147483647 √ null
long_description text 2147483647 √ null
create_timestamp timestamp 29,6 null
status int2 5 null
agent_id int4 10 √ null
agent.id fk_2fb3d0ee3414710b C
is_verified bool 1 false
type int2 5 null
parent_id int4 10 √ null
project.id fk_2fb3d0ee727aca70 C
starts_on timestamp 29,6 √ null
ends_on timestamp 29,6 √ null
update_timestamp timestamp 22 √ null
subsite_id int4 10 √ null
subsite.id fk_2fb3d0eebddfbe89 N

Indexes

Constraint Name Type Sort Column(s)
project_pk Primary key Asc id
idx_2fb3d0eec79c849a Performance Asc subsite_id

Relationships

Close relationships within degrees of separation