FLDP

1236 rows


Description

Junction table between citation and observation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
FLDP_ID INT UNSIGNED 10 √ null
FLDO_ID INT UNSIGNED 10 √ null
FLDO.FLDO_ID FLDP_ibfk_1C
CITATION_ID INT UNSIGNED 10 √ null
CITATION.CITATION_ID FLDP_ibfk_2C

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc FLDP_ID
CITATION_ID Performance Asc CITATION_ID
FLDO_ID Performance Asc FLDO_ID

Relationships

Close relationships within degrees of separation