Boxoffice Project
Tables (4)
FAVORITE_BOXOFFICE
- Key (bNo) — int — Foreign key → WEEKLY_BOXDFFICE.Key — NOT NULL
- UNO (UNO2) — INT — Foreign key → USERS.UNO
- CREATE_DATE — DATETIME
REVIEW_BOXOFFICE
- RNO — INT — Primary key
- Key (bNo) — int — Foreign key → WEEKLY_BOXDFFICE.Key — NOT NULL
- UNO — INT — Foreign key → USERS.UNO
- TITLE — VARCHAR(200)
- CONTENT — TEXT
- SCORE — INT
- CREATE_DATE — DATETIME
USERS
- UNO — INT — Primary key
- ID — VARCHAR(30) — NOT NULL
- PASSWORD — VARCHAR(30) — NOT NULL
- NAME — VARCHAR(30) — NOT NULL
WEEKLY_BOXDFFICE
- Key (bNo) — int — Primary key — NOT NULL
- 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 — bigint
- audiAcc — bigint
- scrnCnt — bigint
- showCnt — bigint