Table: Recurring_Bill_Method
Tags: read-only

Content:
1Progress
2WIP at Standard
3Fixed Time & Expenses
4Fixed Time + Expenses at Standard
5Fixed Expenses + Time at Standard
6Adjustment
Columns
NameTypeConstraintsDescription
recurring_bill_method_KEYintNOT NULLDatabase assigned primary key for this table
descriptionnvarchar (50)NOT NULLUser defined description (unique).
Primary key
NameColumnsDescription
PK_Recurring_Bill_Method$recurring_bill_method_KEYrecurring_bill_method_KEYCLUSTERED
Unique constraints
NameColumnsDescription
UK_Recurring_Bill_Method__descriptiondescriptionEach description must be unique.
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Engagement__Recurring_Bill_Method__recurring_bill_method_KEYrecurring_bill_method_KEYEngagement

Schema diagram