IFWIS Core v2.3

Overview | API | Model | About | Contact

Data Model

Entity Relationship Diagram

Select a table from the entity relationship (ER) diagram to learn more or jump to the list of Tables.

ER Diagram Image

Tables

Schema Table Description
dbo FIELD Common FIELD descriptions. May be instantiated as a FIELD_Instance in one or more ways.
dbo FIELD_DataDate Stores extended date fields
dbo FIELD_DataDecimal Stores extended decimal fields
dbo FIELD_DataFile Stores related files
dbo FIELD_DataInteger Stores extended integer fields
dbo FIELD_DataMemo Stores extended memo fields
dbo FIELD_DataSchema Generates a Schema representation for a given Domain.
dbo FIELD_DataText Stores extended text fields
dbo FIELD_Instance Builds instances of FIELDs to construct Schemas for extended node types
dbo NODE Basic unit of information. An object, or node.
dbo NODE_Permission Permission settings for a given node. Who may Create, Read, Update, Delete, eXecute or change Permissions.
dbo VERSION Stores multiple versions of a given NODE.
dbo VERSION_Approval Allows Versions to pass through an approval loop of required and optional reviewers.
dbo VERSION_Usage Relates NODEs to one another. A given VERSION may be related many NODEs.
dbo VOCAB The root type of data and also stores relationships between data. In most databases, each record in this list would be a different table in the database.

[dbo].[FIELD] : Common FIELD descriptions. May be instantiated as a FIELD_Instance in one or more ways.
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
FieldIDInt4NYNPrimary key
FieldNVarChar (255)255NNNMachine readable name
TypeNVarChar (255)255NNNType of data (int, string)
ModuleNVarChar (255)255NNNDefault module for manipulating this field (form-textbox, form-select, form-input-radio)
ActiveUserDefinedDataType1NNNIs Active?
StorageTypeNVarChar (255)255NNNDatabase storage type: class and property.
StorageModuleNVarChar (255)255NNNModule for CRUD actions. Default is field_sql_storage
StorageVocabIDUserDefinedDataType4YNNVocabulary in which identifiers are stored, VERSION_Usage only, else -99
LockedUserDefinedDataType1NNNIs Locked (In Use)?
DataNVarChar (255)255YNNStores Data used in field validation.
CardinalityUserDefinedDataType1NNNHas Cardinality?
DeletedUserDefinedDataType1NNNIs Deleted?
AUD_NUserUserDefinedDataType256YNNCreated By
AUD_NDateUserDefinedDataType4YNNCreated On
AUD_EUserUserDefinedDataType256YNNLast Edited By
AUD_EDateUserDefinedDataType4YNNLast Edited On

[dbo].[FIELD_DataDate] : Stores extended date fields
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
DataDateIDInt4NYNPrimary key
DataDateDateTime8YNNDate Data
VersionIDUserDefinedDataType4NNYLink to VERSION table
InstanceIDUserDefinedDataType4NNNLink to FIELD_Instance table
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On

[dbo].[FIELD_DataDecimal] : Stores extended decimal fields
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
DataDecimalIDInt4NYNPrimary key
DataDecimalDecimal (30,15)17YNNDecimal Data
VersionIDUserDefinedDataType4NNYLink to VERSION table
InstanceIDUserDefinedDataType4NNNLink to FIELD_Instance table
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On

[dbo].[FIELD_DataFile] : Stores related files
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
DataFileIDInt4NYNPrimary key
DataFileNVarChar (255)255YNN
VersionIDUserDefinedDataType4NNYLink to VERSION table
InstanceIDUserDefinedDataType4NNN
FilePathNVarChar (255)255YNN
FileMimeNVarChar (255)255YNN
FileSizeInt4YNN
FileTypeNVarChar (50)50YNN
FileWidthSmallInt2YNN
FileHeightSmallInt2YNN
FileDurationTime5YNN
WeightUserDefinedDataType2NNN
AUD_NUserUserDefinedDataType256NNN
AUD_NDateUserDefinedDataType4NNN
AUD_EUserUserDefinedDataType256NNN
AUD_EDateUserDefinedDataType4NNN

[dbo].[FIELD_DataInteger] : Stores extended integer fields
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
DataIntegerIDInt4NYNPrimary key
DataIntegerInt4YNNInteger Data
VersionIDUserDefinedDataType4NNYLink to VERSION table
InstanceIDUserDefinedDataType4NNNLink to FIELD_Instance table
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On

[dbo].[FIELD_DataMemo] : Stores extended memo fields
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
DataMemoIDInt4NYNPrimary key
DataMemoNVarCharMax-1YNNMemo Data
VersionIDUserDefinedDataType4NNYLink to VERSION table
InstanceIDUserDefinedDataType4NNNLink to FIELD_Instance table
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On

[dbo].[FIELD_DataSchema] : Generates a Schema representation for a given Domain.
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
DataSchemaIDInt4NYNPrimary key
DataSchemaVarChar (255)255YNNSchema Formatting Rule
VersionIDUserDefinedDataType4NNNLink to VERSION table
InstanceIDUserDefinedDataType4NNNLink to FIELD_Instance table
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On

[dbo].[FIELD_DataText] : Stores extended text fields
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
DataTextIDInt4NYNPrimary key
DataTextNVarChar (255)255YNNText Data
VersionIDUserDefinedDataType4NNYLink to VERSION table
InstanceIDUserDefinedDataType4NNNLink to FIELD_Instance table
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On

[dbo].[FIELD_Instance] : Builds instances of FIELDs to construct Schemas for extended node types
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
InstanceIDInt4NYNPrimary key
InstanceNVarChar (255)255NNNMachine name
DescriptionNVarChar (2000)2000YNNFriendly Description
FieldIDUserDefinedDataType4NNNLink to FIELD table
BundleIDUserDefinedDataType4NNNLink to FIELD_Bundle table (in development)
RequiredUserDefinedDataType1NNNIs Required?
NullableUserDefinedDataType1NNNIs Nullable?
MinRecurrenceUserDefinedDataType2NNNMinimum Recurrence
MaxRecurrenceUserDefinedDataType2NNNMaximum Recurrence
DefaultValueNVarChar (255)255YNNDefault Value
LUVocabIDInt4YNNLink to VOCAB table
SettingsNVarChar (2000)2000YNNInstance-specific settings
DisplayNVarChar (255)255YNNDisplay settings
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256YNNCreated By
AUD_NDateUserDefinedDataType4YNNCreated On
AUD_EUserUserDefinedDataType256YNNLast Edited By
AUD_EDateUserDefinedDataType4YNNLast Edited On

[dbo].[NODE] : Basic unit of information. An object, or node.
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
NodeIDInt4NYNPrimary key
URIVarChar (255)255NNNUniversal Resource Indicator
VersionIDInt4YNNLink to VERSION table
DescriptionUserDefinedDataType2000YNNDescription of NODE purpose
TypeIDUserDefinedDataType4NNNLink to VOCAB table
PublishTinyInt1NNNIs Published?
PublishDateDateTime8NNNDate of Publishing
ExpireDateDateTime8NNNDate of Publishing Expiration
CommentUserDefinedDataType1NNNComments Allowed?
PromoteUserDefinedDataType1NNNAdvertise this content?
ModerateUserDefinedDataType1NNNModerate Comments?
StickyUserDefinedDataType1NNNSticky at the Top of Lists?
LicenseTinyInt1NNNWhat license is this content?
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On
XIDUserDefinedDataType73YNNExternal Imported Identifier

[dbo].[NODE_Permission] : Permission settings for a given node. Who may Create, Read, Update, Delete, eXecute or change Permissions.
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
PermissionIDInt4NYNPrimary key
NodeIDUserDefinedDataType4NNYLink to NODE table
RoleNameNVarChar (256)256YNNName of Role
cUserDefinedDataType2NNNCreate?
rUserDefinedDataType2NNNRead?
uUserDefinedDataType2NNNUpdate?
dUserDefinedDataType2NNNDeleted?
xUserDefinedDataType2NNNExecute?
pUserDefinedDataType2NNNChange Permissions?
AUD_NUserUserDefinedDataType256YNNCreated By
AUD_NDateUserDefinedDataType4YNNCreated On
AUD_EUserUserDefinedDataType256YNNLast Edited By
AUD_EDateUserDefinedDataType4YNNLast Edited On

[dbo].[VERSION] : Stores multiple versions of a given NODE.
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
VersionIDInt4NYNPrimary key
NodeIDUserDefinedDataType4NNYLink to NODE table
OriginIDUserDefinedDataType4YNNOriginal Node TypeID
TitleUserDefinedDataType255NNNFriendly Title (H1)
BodyNVarCharMax-1YNNBody (Main Content)
ReleaseTinyInt1YNNVersion ready for Release?
StartDateDateTime8YNNStart or Begin Date
EndDateDateTime8YNNEnd or Completion Date
XMinUserDefinedDataType9YNNMinimum X Bounding Coordinate-180 - 180
XMaxUserDefinedDataType9YNNMaximum X Bounding Coordinate-180 - 180
YMinUserDefinedDataType9YNNMinimum Y Bounding Coordinate-90 - 90
YMaxUserDefinedDataType9YNNMaximum Y Bounding Coordinate-90 - 90
AUD_NUserUserDefinedDataType256YNNCreated By
AUD_NDateUserDefinedDataType4YNNCreated On
AUD_EUserUserDefinedDataType256YNNLast Edited By
AUD_EDateUserDefinedDataType4YNNLast Edited On

[dbo].[VERSION_Approval] : Allows Versions to pass through an approval loop of required and optional reviewers.
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
ApprovalIDInt4NYNPrimary key
ApprovalSmallInt2NNNApproved (1), No Action (0), Not Approved (-1)
UserNameNVarChar (256)256NNNName of User
VersionIDInt4NNYLink to VERSION table
RequiredUserDefinedDataType1NNNIs Required?
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On

[dbo].[VERSION_Usage] : Relates NODEs to one another. A given VERSION may be related many NODEs.
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
UsageIDInt4NYNPrimary key
UsageUserDefinedDataType255YNNOverride of VERSION.Title for this Usage
VersionIDUserDefinedDataType4NNYLink to VERSION table
VocabIDUserDefinedDataType4NNNLink to VOCAB table
InstanceIDUserDefinedDataType4YNNLink to FIELD_Instance table
ParentNodeIDInt4YNNLink to NODE table
EchelonNodeIDInt4YNNLink to NODE table WHERE NODE.Type = Echelon
WeightUserDefinedDataType2NNNOrder
AUD_NUserUserDefinedDataType256NNNCreated By
AUD_NDateUserDefinedDataType4NNNCreated On
AUD_EUserUserDefinedDataType256NNNLast Edited By
AUD_EDateUserDefinedDataType4NNNLast Edited On
XIDUserDefinedDataType73YNNExternal Imported Identifier

[dbo].[VOCAB] : The root type of data and also stores relationships between data. In most databases, each record in this list would be a different table in the database.
Column Datatype Size Nullable InPrimaryKey IsForeignKey Description Domain
VocabIDInt4NYNPrimary key
VocabUserDefinedDataType255NNNMachine Name
DescriptionUserDefinedDataType2000YNNFriendly Description
HelpUserDefinedDataType2000YNNHelp for this Vocabulary
VersionRequiredUserDefinedDataType1YNNVersion is Required?
VersionMultipleUserDefinedDataType1NNNVersion may be multiple?
VersionLUVocabIDUserDefinedDataType4NNNLookup Vocabulary for Version
VersionLUExpressionUserDefinedDataType2000YNNLookup Vocabulary filter expression
ParentNodeRequiredUserDefinedDataType1NNNParent Node is Required?
ParentNodeMultipleUserDefinedDataType1NNNParent Node may be multiple?
ParentNodeLUVocabIDUserDefinedDataType4NNNLookup Vocabulary for Parent Node
ParentNodeLUExpressionUserDefinedDataType2000YNNLookup Vocabulary filter expression
EchelonNodeRequiredUserDefinedDataType1NNNEchelon Node is required?
EchelonNodeMultipleUserDefinedDataType1NNNEchelon Node may be multiple?
EchelonNodeLUVocabIDUserDefinedDataType4NNNLookup Vocabular for Echelon Node
EchelonNodeLUExpressionUserDefinedDataType2000YNNLookup Vocabulary filter expression
WeightUserDefinedDataType2NNNOrder
ParentVocabIDUserDefinedDataType4NNNParent Vocabulary
DefaultNodeIDUserDefinedDataType4NNNDefault Node for Vocabulary
AUD_NUserUserDefinedDataType256YNNCreated By
AUD_NDateUserDefinedDataType4YNNCreated On
AUD_EUserUserDefinedDataType256YNNLast Edited By
AUD_EDateUserDefinedDataType4YNNLast Edited On

What is IFWIS Core?

  • An Overview
    Goals, design principles and some examples of using IFWIS Core
  • Core API
    Learn about the application programming interface (API) for interacting with our biological records.
  • Data Model
    Review a relationship diagram of how our data is stored.
  • Why Core?
    A plain english explanation of what's going on here.
  • Contact Developer
    Not working like it should? Please let us know.

Apps Built On Core