ㅇ

Tables (8)

Untitled

  • show — ID` — Primary key — NOT NULL
  • show — name` — NOT NULL
  • show — genre` — NOT NULL
  • show — date` — NOT NULL
  • production — company
  • breakeven — INT — NOT NULL

Untitled2

  • PR — ID` — Primary key — NOT NULL
  • channel — VARCHAR(10) — NOT NULL
  • PR — price` — NOT NULL
  • PR — starting — NOT NULL
  • PR — end — NOT NULL
  • show — ID` — NOT NULL

Untitled3

  • SNS — ID` — Primary key — NOT NULL
  • PR — ID` — NOT NULL
  • SNS — date` — NOT NULL
  • PR — ID2` — NOT NULL

Untitled4

  • reaction — ID` — Primary key — NOT NULL
  • share — INT
  • like — INT
  • view — INT
  • GPA — INT
  • SNS — ID` — NOT NULL

Untitled5

  • ticket — ID` — Primary key — NOT NULL
  • show — ID` — NOT NULL
  • ticket — class` — NOT NULL
  • Regular — price` — NOT NULL
  • discount — rate` — NOT NULL
  • discount — type` — NOT NULL

Untitled6

  • visitor — ID` — Primary key — NOT NULL
  • age — INT
  • gender — VARCHAR(35)
  • route — VARCHAR(35)

Untitled7

  • trans_ID — INT — Primary key — NOT NULL
  • reaction — ID` — NOT NULL
  • quantity — INT — NOT NULL
  • amount — INT — NOT NULL
  • total_price — INT — NOT NULL
  • show — ID` — NOT NULL
  • visitor — ID` — NOT NULL
  • ticket — ID` — NOT NULL
  • transaction_date — DATE — Foreign key → Untitled8.date — NOT NULL

Untitled8

  • date — DATE — Primary key — NOT NULL
  • day_of_week — VARCHAR(10)
  • weekend_flag — BOOLEAN
  • holiday_flag — BOOLEAN
  • temperature — INT — NOT NULL
  • precipitation — INT — NOT NULL