accessioncitation

Table info.

Title Accession Citations
Description Accession Citations

Fields

Name Type Required Index Hidden On form Title Pick list Description
AccessionCitationID int(11) PRI
TimestampCreated datetime Timestamp Created Timestamp Created
TimestampModified datetime Timestamp Modified Timestamp Modified
Version int(11) Version Version
FigureNumber varchar(50) Figure Number Figure Number
IsFigured bit(1) Is Figured Is Figured
PageNumber varchar(50) Page Number Page Number
PlateNumber varchar(50) Plate Number Plate Number
Remarks text Remarks Remarks
ReferenceWorkID int(11) MUL
CreatedByAgentID int(11) MUL
AccessionID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK9ED8DF0B3925EE20 AccessionID
FK9ED8DF0B5327F942 ModifiedByAgentID
FK9ED8DF0B69734F30 ReferenceWorkID
FK9ED8DF0B7699B003 CreatedByAgentID
PRIMARY AccessionCitationID

Many-to-one relationships

Name Field Related table Related field
FK9ED8DF0B3925EE20 AccessionID accession AccessionID
FK9ED8DF0B5327F942 ModifiedByAgentID agent AgentID
FK9ED8DF0B69734F30 ReferenceWorkID referencework ReferenceWorkID
FK9ED8DF0B7699B003 CreatedByAgentID agent AgentID