sp_organization

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
sp_organization_id serial 10 √ nextval('sgn_people.sp_organization_sp_organization_id_seq'::regclass)
attribution_to.organization_id organization_id_fk R
name varchar 255 null
department varchar 255 √ null
unit varchar 255 √ null
address text 2147483647 √ null
country varchar 255 √ null
phone_number varchar 40 √ null
fax varchar 40 √ null
contact_email varchar 255 √ null
webpage varchar 255 √ null
description text 2147483647 √ null
upload_account_name varchar 40 √ null
shortname varchar 20 null

Indexes

Constraint Name Type Sort Column(s)
sp_organization_pkey Primary key Asc sp_organization_id

Check Constraints

Constraint Name Constraint
sp_organization_shortname_check (((shortname IS NULL) OR (lower((shortname)::text) = (shortname)::text)))

Relationships

Close relationships within degrees of separation