Table: dbo.Vendor_Type
Table used to store the types of vendors.
Columns
NameTypeConstraintsDescription
vendor_type_KEYint (4)NOT NULLPrimary key for this table.
descriptionnvarchar (28)NOT NULLDescription of the vendor type.
Primary key
NameColumnsDescription
PK_Vendor_Typevendor_type_KEY
Unique constraints
NameColumnsDescription
UK_Vendor_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Vendor__Vendor_Type__current__vendor_type_KEYcurrent__vendor_type_KEYVendor
FK_Manage_AP_Payment_Processable_Transaction__Vendor_Type__vendor_type_KEYvendor_type_KEYManage_AP_Payment_Processable_Transaction

Schema diagram