erd
Tables (5)
FAVORITE_BOXOFFICE
- bNo — int — Foreign key → WEEKLY_BOXOFFICE.bNo
- Key (UNO2) — INT — Foreign key → Untitled.Key — NOT NULL
- BNO — INT
- UNO — INT
- CREATE_DATE — DATETIME
REVIEW_BOXOFFICE
- RNO — INT — Primary key
- BNO — INT
- UNO — INT
- TITLE — VARCHAR(200)
- CONTENT — TEXT
- SCORE — INT
- CREATE_DATE — DATETIME
- bNo — int — Foreign key → WEEKLY_BOXOFFICE.bNo
- bNo (bNo2) — int — Foreign key → WEEKLY_BOXOFFICE.bNo
- Key (UNO2) — INT — Foreign key → Untitled.Key — NOT NULL
Untitled (USERS)
- Key (UNO) — INT — Primary key — NOT NULL
- Field (ID) — VARCHAR(30)
- Field2 (PASSWORD) — VARCHAR(30)
- Field3 (NAME) — VARCHAR(30)
WEEKLY_BOXOFFICE
- bNo — int — Primary key
- boxofficeType — varchar(100)
- showRange — varchar(100)
- yearWeekTime — varchar(100)
- rnum — int
- rank — int
- rankInten — int
- rankOldAndNew — varchar(100)
- movieCd — varchar(100)
- movieNm — varchar(100)
- openDt — varchar(100)
- salesAmt — bigint
- salesShare — double
- salesInten — bigint
- salesChange — double
- salesAcc — bigint
- audiCnt — bigint
- audiInten — bigint
- audiChange — double
- audiAcc — bigint
- scrnCnt — bigint
- showCnt — bigint
weather (Untitled)
- Key — Primary key — NOT NULL
- Key2 — Primary key — NOT NULL