LOK Test
Tables (5)
AdCampaign Dim (Untitled4)
- Key — char — Primary key — NOT NULL
- Field — char
- Field2 — date
- Field3 — date
- Field4 — ...
AdCampaign Fact (Untitled5)
- Key — char — Foreign key → AdCampaign Dim.Key — NOT NULL
- Field — int
- Field2 — int
- Field3 — int
- Field4 — int
- Field5 — int
- Field7 — date
- Field6 — ...
Customer Dim (Untitled)
- Key — char — Primary key — NOT NULL
- Field — char
- Field2 — char
- Field3 — date
- Field4 — ...
WebSession Dim (Untitled2)
- Key — char — Primary key — NOT NULL
- Key (Key3) — char — Foreign key → Customer Dim.Key — NOT NULL
- Key (Key2) — char — Foreign key → AdCampaign Dim.Key — NOT NULL
- Field — ...
WebSession Fact (Untitled3)
- Key — char — Foreign key → WebSession Dim.Key — NOT NULL
- Key (Key3) — char — Foreign key → WebSession Dim.Key — NOT NULL
- Key (Key2) — char — Foreign key → WebSession Dim.Key — NOT NULL
- Field — time
- Field2 — ...