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 — ...