spexportschema

Table info.

Title Sp Export Schema
Description Sp Export Schema

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpExportSchemaID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Description varchar(255) Description description
SchemaName varchar(80) Schema Name schemaName
SchemaVersion varchar(80) Schema Version schemaVersion
DisciplineID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKD2861D324CE675DE DisciplineID
FKD2861D325327F942 ModifiedByAgentID
FKD2861D327699B003 CreatedByAgentID
PRIMARY SpExportSchemaID

One-to-many relationships

Name Field Related table Related field
FKC5EDFE525722A7A2 SpExportSchemaID sp_schema_mapping SpExportSchemaID
FKBB21AF455722A7A2 SpExportSchemaID spexportschemaitem SpExportSchemaID

Many-to-one relationships

Name Field Related table Related field
FKD2861D324CE675DE DisciplineID discipline UserGroupScopeId
FKD2861D325327F942 ModifiedByAgentID agent AgentID
FKD2861D327699B003 CreatedByAgentID agent AgentID