Table: Accruable_Benefit
Columns
Name | Type | Constraints | Description
accruable_benefit_KEY | int | NOT NULL | Primary key for this table, same value as [benefit_KEY].
update__staff_KEY | int | NOT NULL |
update_date | datetime | NOT NULL |
create_date | datetime | NOT NULL |
benefit_KEY | int | NOT NULL | Key to a Benefit that the accruable benefit is for.
activity_KEY | int | NOT NULL | Key to an Activity that the accruable benefit is for.

Primary key
Name | Columns | Description
PK_Accruable_Benefit$accruable_benefit_KEY | accruable_benefit_KEY | CLUSTERED
Unique constraints
Name | Columns | Description
UK_Accruable_Benefit__activity_KEY | activity_KEY |
UK_Accruable_Benefit__benefit_KEY | benefit_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Accruable_Benefit__Activity__activity_KEY | activity_KEY | Activity |
FK_Accruable_Benefit__Benefit__benefit_KEY | benefit_KEY | Benefit |