ㅇ
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