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