Table: dbo.Billing_Fee_Month
Columns
NameTypeConstraintsDescription
billing_fee_month_KEYint (4)NOT NULLPrimary key for this table; specifies the month of the billing
month_namenvarchar (20)NOT NULLMonth name, displayed
billing_fee_frequency_KEYint (4)NOT NULLForeign key; key of associated billing frequency
Primary key
NameColumnsDescription
PK_Billing_Fee_Monthbilling_fee_month_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Billing_Fee_Month__Billing_Fee_Frequency__billing_fee_frequency_KEYbilling_fee_frequency_KEYBilling_Fee_Frequency (billing_fee_frequency_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Billing_Item_Schedule__Billing_Fee_Month__billing_fee_month_KEYbilling_fee_month_KEYBilling_Item_Schedule
FK_Client_Billing_Item_Schedule__Billing_Fee_Month__billing_fee_month_KEYbilling_fee_month_KEYClient_Billing_Item_Schedule

Schema diagram