Table: History_Of_Engagement
Columns
NameTypeConstraintsDescription
create__changeset_KEYintNOT NULL
update__changeset_KEYintNOT NULL
revise__changeset_KEYintNOT NULL
history_action_KEYtinyint (3)NOT NULL
engagement_KEYintNOT NULL
client_KEYint
engagement_template_KEYintNOT NULL
descriptionnvarchar (250)NOT NULL
long_descriptionnvarchar (-1)NOT NULL
engagement_type_KEYint
engagement_status_KEYintNOT NULL
office_KEYint
biller__staff_KEYint
reviewer__staff_KEYint
manager__staff_KEYint
rate_type_KEYintNOT NULL
billing_rate_type_KEYint
fixed_ratedecimal (9, 2)NOT NULL
markup_factordecimal (6, 4)NOT NULL
tax_area_KEYint
recurring_bill_KEYint
recurring_bill_method_KEYint
recurring_bill_amountdecimal (9, 2)NOT NULL
recurring_bill__staff_KEYint
recurring_bill__activity_KEYint
gl_accountnvarchar (60)NOT NULL
engagement_surcharge_method_KEYintNOT NULL
surcharge_amountdecimal (9, 2)NOT NULL
Primary key
NameColumnsDescription
PK_History_Of_Engagement$engagement_KEY$create__changeset_KEY$revise__changeset_KEYengagement_KEY, create__changeset_KEY, revise__changeset_KEYCLUSTERED

Schema diagram