This table contains names and descriptions for each of the rows used to describe a particular data element. For instance, if there was a table of table entry for Gender, this table may contain a row for Male and a row for Female related to the table of table for Gender.

use StudentCentered
go

if exists (select 1
from sysindexes
where id = object_id('dbo.MstrCd')
and name = 'TblOfTbl_FK'
and indid > 0
and indid < 255)
drop index dbo.MstrCd.TblOfTbl_FK
go

if exists (select 1
from sysobjects
where id = object_id('dbo.MstrCd')
and type = 'U')
drop table dbo.MstrCd
go

/*==============================================================*/
/* Table: MstrCd */
/*==============================================================*/
create table dbo.MstrCd (
ID int not null,
TblOfTbl_ID int not null,
Nm varchar(100) not null,
Descr varchar(255) not null,
Cd varchar(10) null,
SortOrder int null,
CrtrID varchar(18) not null default suser_sname(),
CrtDt datetime not null default getdate(),
UpdtID varchar(18) not null default suser_sname(),
UpdtDt datetime not null default getdate(),
EffDt datetime not null default getdate(),
EndDt datetime null,
constraint MstrCd_PK primary key nonclustered (ID)
on SmallIDX
)
on SmallTBL
go

/*==============================================================*/
/* Index: TblOfTbl_FK */
/*==============================================================*/
create index TblOfTbl_FK on dbo.MstrCd (
TblOfTbl_ID
)
on SmallIDX
go

Unique ID assigned and maintained by the database for the MstrCd table.

Foreign key to the TblOfTbl table.

Name of an attribute within a virtual table.

Description for an attribute within a virtual table.

Coded value for an attribute within a virtual table.

Used when a non-natural sort order is required for the list of attributes.

The user identification of the person or process that created the record.

The date the source row of data was created.

The user identification of the person or process that last updated the record.

The date of the last update.

The date that this row of data becomes effective.

The date that this row of data ceases to be effective.