commonnametxcitation

Table info.

Title Common Name Tx Citation
Description Common Name Tx Citation

Fields

Name Type Required Index Hidden On form Title Pick list Description
CommonNameTxCitationID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Number1 float(20,10) Number1 number1
Number2 float(20,10) Number2 number2
Remarks text Remarks remarks
Text1 text Text1 User definable.
Text2 text Text2 User definable.
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
ModifiedByAgentID int(11) MUL
ReferenceWorkID int(11) MUL
CreatedByAgentID int(11) MUL
CommonNameTxID int(11) MUL

Indexes

Name Fields Unique Nullable
FK829B50E115A0FFF2 CommonNameTxID
FK829B50E15327F942 ModifiedByAgentID
FK829B50E169734F30 ReferenceWorkID
FK829B50E17699B003 CreatedByAgentID
PRIMARY CommonNameTxCitationID

Many-to-one relationships

Name Field Related table Related field
FK829B50E115A0FFF2 CommonNameTxID commonnametx CommonNameTxID
FK829B50E15327F942 ModifiedByAgentID agent AgentID
FK829B50E169734F30 ReferenceWorkID referencework ReferenceWorkID
FK829B50E17699B003 CreatedByAgentID agent AgentID