Kashi_TestResults

2458 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SourceFile varchar 100 null
PersonID varchar 50 null
KashiFacCode varchar 50 √ null
PersonType varchar 50 null
FirstName varchar 100 √ null
LastName varchar 100 √ null
LabID varchar 50 √ null
KitID varchar 50 null
VW_Kashi_TestResults.KitID Implied ConstraintR
DateCollected datetime2 16,3 √ null
DateReported datetime2 16,3 √ null
Outcome varchar 50 √ null
AVA_insdate datetime2 16,3 (getdate())
TimeCollected time 12,7 √ null
ReportComment nvarchar 2147483647 √ null
Panel varchar 1000 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_Kashi_TestResults Primary key Asc KitID

Relationships

Close relationships within degrees of separation