sp_organization - cxgn_breedbase.sgn

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 10 of 13 entries

Indexes

Search:

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

Showing 1 to 1 of 1 entries

Check Constraints

Search:

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

Showing 1 to 1 of 1 entries

Relationships

Close relationships within degrees of separation

One
Two degrees