SpecimenCategories
From Species File Help
(Difference between revisions)
m |
m |
||
Line 1: | Line 1: | ||
'''tblSpecimenCategories''' contains categories of specimens (male, female, egg, etc.). | '''tblSpecimenCategories''' contains categories of specimens (male, female, egg, etc.). | ||
− | *SpmnCategoryID, integer, 4 bytes, primary key, identifier for the category | + | * SpmnCategoryID, integer, 4 bytes, primary key, identifier for the category |
− | *FileID, integer, 4 bytes, = tblFiles.FileID | + | * [[Files|FileID]], integer, 4 bytes, = tblFiles.FileID |
− | *SingularName, text, 30 characters maximum | + | * SingularName, text, 30 characters maximum |
− | *PluralName, text, 30 characters maximum | + | * PluralName, text, 30 characters maximum |
− | *SeqNum, integer, 2 bytes, used to specify the list sequence in dropdownlists | + | * SeqNum, integer, 2 bytes, used to specify the list sequence in dropdownlists |
− | *LastUpdate, smalldatetime, date and time row last updated | + | * LastUpdate, smalldatetime, date and time row last updated |
− | *ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change | + | * ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change |
− | *CreatedOn, smalldatetime, date and time row was created | + | * CreatedOn, smalldatetime, date and time row was created |
− | *CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row | + | * CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row |
[[Category:SpecimenTables]] | [[Category:SpecimenTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 09:35, 7 September 2012
tblSpecimenCategories contains categories of specimens (male, female, egg, etc.).
- SpmnCategoryID, integer, 4 bytes, primary key, identifier for the category
- FileID, integer, 4 bytes, = tblFiles.FileID
- SingularName, text, 30 characters maximum
- PluralName, text, 30 characters maximum
- SeqNum, integer, 2 bytes, used to specify the list sequence in dropdownlists
- LastUpdate, smalldatetime, date and time row last updated
- ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
- CreatedOn, smalldatetime, date and time row was created
- CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row