Boxoffice demo
Tables (4)
WEEKLY_BOXOFFICE
- 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(1000)
- opendt — DATE
- salesamt — BIGINT
- salesshare — DOUBLE
- salesinten — BIGINT
- saleschange — DOUBLE
- salesacc — BIGINT
- audicnt — BIGINT
- audiinten — INT
- audichange — DOUBLE
- audiacc — BIGINT
- scrncnt — INT
- showcnt — INT
favorite_boxoffice
- mon — INT — Foreign key → member.mon — NOT NULL
- bno — INT — Foreign key → WEEKLY_BOXOFFICE.bno — NOT NULL
- create_date — DATETIME
member
- mon — INT — Primary key — NOT NULL
- id — VARCHAR(30) — NOT NULL
- password — VARCHAR(30) — NOT NULL
- name — VARCHAR(30) — NOT NULL
review_boxoffice
- mon — INT — Primary key — NOT NULL
- title — VARCHAR(200)
- content — TEXT
- score — INT
- create_date — DATETIME
- mon (mon2) — INT — Foreign key → member.mon — NOT NULL
- bno — INT — Foreign key → WEEKLY_BOXOFFICE.bno — NOT NULL