StaffComments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CommentSeq int identity 4 null
ID int 4 ((0))
Staff.ID FK_StaffComments_Staff R
CommentCreatedDate datetime 16,3 null
CommentCreatedBy varchar 50 ('')
CommentDate datetime 16,3 null
CommentBy varchar 80 ('')
Subject varchar 80 ('')
Comment nvarchar 1073741823 null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_StaffComments Primary key Asc CommentSeq
AK_StaffComments_ID Performance Asc ID

Relationships