Table: Recurring_Bill
Columns
NameTypeConstraintsDescription
recurring_bill_KEYintNOT NULLAUTO-INCREMENT: Database assigned primary key for this table
update__staff_KEYintNOT NULL
update_date_utcdatetimeNOT NULL
descriptionnvarchar (250)NOT NULLUser defined description (unique).
create_date_utcdatetimeNOT NULL
Primary key
NameColumnsDescription
PK_Recurring_Bill$recurring_bill_KEYrecurring_bill_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Recurring_Bill$descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Engagement__Recurring_Bill__recurring_bill_KEYrecurring_bill_KEYEngagement

Schema diagram