SITP

841 rows


Description

Junction table between citation and site

Columns

Column Type Size Nulls Auto Default Children Parents Comments
SITP_ID INT UNSIGNED 10 √ null
SITE_ID INT UNSIGNED 10 √ null
SITE.SITE_ID SITP_ibfk_1C
CITATION_ID INT UNSIGNED 10 √ null
CITATION.CITATION_ID SITP_ibfk_2C

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc SITP_ID
CITATION_ID Performance Asc CITATION_ID
SITE_ID Performance Asc SITE_ID

Relationships

Close relationships within degrees of separation