Boxoffice demo
Tables (4)
favorite_boxoffice
- bno — BIGINT — Primary key — NOT NULL
- mno (mno2) — BIGINT — Foreign key → member.mno — NOT NULL
- mno — INT
- create_date — DATETIME
member
- mno — BIGINT — Primary key — NOT NULL
- id — VARCHAR(30) — NOT NULL
- password — VARCHAR(30) — NOT NULL
- name — VARCHAR(30) — NOT NULL
review_boxoffice
- rno — BIGINT — Primary key — NOT NULL
- bno — INT
- mno — INT
- title — VARCHAR(200)
- content — TEXT
- score — INT
- create_date — DATETIME
- Key (Key2) — Foreign key → member.mno — NOT NULL
weekly_boxoffice
- bno — BIGINT — Primary key — NOT NULL
- bno (bno2) — BIGINT — Foreign key → favorite_boxoffice.bno — NOT NULL
- mno (mno2) — BIGINT — Foreign key → favorite_boxoffice.mno — NOT NULL
- rnum — INT
- boxoffice_rank — INT
- rankinten — INT
- rankoldandnew — VARCHAR(30)
- moviecd — VARCHAR(30)
- movienm — VARCHAR(300)
- opendt — DATE
- salesamt — BIGINT
- salesshare — DOUBLE
- salesinten — BIGINT
- saleschange — DOUBLE
- salesacc — BIGINT
- audicnt — BIGINT
- audiinten — BIGINT
- audichange — DOUBLE
- audiacc — BIGINT
- scrncnt — BIGINT
- showcnt — BIGINT
- boxofficetype — VARCHAR(100)
- showrange — VARCHAR(100)
- yearweektime — VARCHAR(100)
- rno — BIGINT — Foreign key → review_boxoffice.rno — NOT NULL