members
-
member_sk PK integer


machines
-
machine_sk PK integer


tables
-
table_sk PK integer


hosts
-
host_sk PK integer


member_tier
-
member_tier_sk PK integer


gaming_transactions
-
member_sk integer FK >- members.member_sk
window_code varchar
snapshot_date date


# one_to_one with gaming_transactions on the composite key (member_sk, window_code, snapshot_date)
gaming_transactions_trend
-
member_sk integer FK - gaming_transactions.member_sk
window_code varchar FK - gaming_transactions.window_code
snapshot_date date FK - gaming_transactions.snapshot_date


gaming_transactions_detail
-
member_sk integer NULL FK >- members.member_sk
machine_sk integer NULL FK >- machines.machine_sk
table_sk integer NULL FK >- tables.table_sk


points_transactions
-
member_sk integer NULL FK >- members.member_sk


reservations
-
host_sk integer NULL FK >- hosts.host_sk
member_tier_sk integer NULL FK >- member_tier.member_tier_sk
