starbucks

Tables (4)

Customer (Untitled)

  • id (Key) — Primary key — NOT NULL
  • gender (Key2) — Primary key — NOT NULL
  • age (Key3) — Primary key — NOT NULL
  • became_member_on (Key4) — Primary key — NOT NULL
  • income (Key5) — Primary key — NOT NULL

Offer (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • reward (Key2) — Primary key — NOT NULL
  • channels (Key3) — Primary key — NOT NULL
  • difficulty (Key4) — Primary key — NOT NULL
  • duration (Key5) — Primary key — NOT NULL
  • offer_type (Key6) — Primary key — NOT NULL

Transcript (Untitled3)

  • person (Key) — Primary key — NOT NULL
  • event (Key2) — Primary key — NOT NULL
  • value (Key3) — Primary key — NOT NULL
  • hours_since_start (Key4) — Primary key — NOT NULL

Transcript_final (Untitled4)

  • tr_id (Key) — Primary key — NOT NULL
  • person (Key2) — Primary key — NOT NULL
  • event (Key3) — Primary key — NOT NULL
  • value (Key4) — Primary key — NOT NULL
  • time (Key5) — Primary key — NOT NULL