organisation

4 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('organisation_id_seq'::regclass)
application.org_id application_org_id_fkeyR
permission_join.organisation_id permission_join_organisation_id_fkeyR
review_assignment.organisation_id review_assignment_organisation_id_fkeyR
review_assignment_assigner_join.organisation_id review_assignment_assigner_join_organisation_id_fkeyR
user_organisation.organisation_id user_organisation_organisation_id_fkeyR
name varchar 2147483647 √ null
registration varchar 2147483647 √ null
address varchar 2147483647 √ null
logo_url varchar 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
organisation_pkey Primary key Asc id
organisation_name_key Must be unique Asc name
organisation_registration_key Must be unique Asc registration

Relationships

Close relationships within degrees of separation