Table mob_odm2.odm2.affiliations Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
affiliationid serial 10  √  nextval('odm2.affiliations_affiliationid_seq'::regclass)
actionby.affiliationid fk_actionpeople_affiliations C
dataloggerprogramfiles.affiliationid fk_dataloggerprogramfiles_affiliations C
modelaffiliations.affiliationid fk_modelaffiliations_affiliations C
personid int4 10
people.personid fk_affiliations_people C
organizationid int4 10  √  null
organizations.organizationid fk_affiliations_organizations C
isprimaryorganizationcontact bool 1  √  null
affiliationstartdate date 13
affiliationenddate date 13  √  null
primaryphone varchar 50  √  null
primaryemail varchar 255
primaryaddress varchar 255  √  null
personlink varchar 255  √  null

Table contained 0 rows at Fri Mar 08 15:58 PST 2019

Indexes:
Column(s) Type Sort Constraint Name
affiliationid Primary key Asc affiliations_pkey

Close relationships  within of separation: