This is an associate table between Tst and Ctgry that is used to document the score reporting categories related to a specific offering of a test.

use StudentCentered
go

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

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

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

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

/*==============================================================*/
/* Table: TstCtgry */
/*==============================================================*/
create table dbo.TstCtgry (
ID int not null,
Tst_ID int not null,
Ctgry_ID int not null,
EffDt datetime not null default getdate(),
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(),
EndDt datetime null,
constraint TstCtgry_PK primary key nonclustered (ID)
on SmallIDX
)
on SmallTBL
go

/*==============================================================*/
/* Index: Tst_FK */
/*==============================================================*/
create index Tst_FK on dbo.TstCtgry (
Tst_ID
)
on SmallIDX
go

/*==============================================================*/
/* Index: Ctgry_FK */
/*==============================================================*/
create index Ctgry_FK on dbo.TstCtgry (
Ctgry_ID
)
on SmallIDX
go

/*==============================================================*/
/* Index: UnqTstCtgry_IDX */
/*==============================================================*/
create index UnqTstCtgry_IDX on dbo.TstCtgry (
Tst_ID,
Ctgry_ID
)
on SmallIDX
go

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

Foreign key to the Tst table.

Foreign key to the Ctgry table.

The date that this row of data becomes effective.

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 ceases to be effective.