Table: dbo.Processing_Note_Category
The category of a processing note. Users can add to this list.
Columns
NameTypeConstraintsDescription
processing_note_category_KEYint (4)NOT NULLThe primary key, assigned by ACS.
descriptionnvarchar (50)NOT NULLThe description of the note type.
processing_note_type_KEYint (4)NOT NULLThe type of note this category can apply to
Primary key
NameColumnsDescription
PK_Processing_Note_Categoryprocessing_note_category_KEY
Unique constraints
NameColumnsDescription
UK_Processing_Note_Category$description$processing_note_type_KEYdescription, processing_note_type_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Processing_Note_Category__Processing_Note_Type__processing_note_type_KEYprocessing_note_type_KEYProcessing_Note_Type (processing_note_type_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Processing_Note__Processing_Note_Category__processing_note_category_KEYprocessing_note_category_KEYProcessing_Note

Schema diagram