autonumberingscheme

Table info.

Title Auto Numbering Scheme
Description Auto Numbering Scheme

Fields

Name Type Required Index Hidden On form Title Pick list Description
AutoNumberingSchemeID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
FormatName varchar(64) Format Name
IsNumericOnly bit(1) Is Numeric Only Yes if number scheme is only numeric.
SchemeClassName varchar(64) Scheme Class Name schemeClassName
SchemeName varchar(64) MUL Scheme Name Name of the scheme (sequence).
TableNumber int(11) Table Number tableNumber
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK8227D14F5327F942 ModifiedByAgentID
FK8227D14F7699B003 CreatedByAgentID
PRIMARY AutoNumberingSchemeID
SchemeNameIDX SchemeName

One-to-many relationships

Name Field Related table Related field
FK46F04F2AFE55DD76 AutoNumberingSchemeID autonumsch_coll AutoNumberingSchemeID
FKA8BE493FE55DD76 AutoNumberingSchemeID autonumsch_div AutoNumberingSchemeID
FKA8BE5C3FE55DD76 AutoNumberingSchemeID autonumsch_dsp AutoNumberingSchemeID

Many-to-one relationships

Name Field Related table Related field
FK8227D14F5327F942 ModifiedByAgentID agent AgentID
FK8227D14F7699B003 CreatedByAgentID agent AgentID