sw전시회
테이블 (12)
box-office
- movies_movieCd — VARCHAR(20) — 외래 키 → movies.movieCd — NOT NULL
- rank — VARCHAR(15) — NOT NULL
- audiAcc — VARCHAR(10)
comments
- commnetID — INT — 기본 키 — NOT NULL
- users_id — VARCHAR(50) — 외래 키 → users.userId — NOT NULL
- movies_movieCd — VARCHAR(20) — 외래 키 → movies.movieCd — NOT NULL
- commnet — VARCHAR(1000) — NOT NULL
- like — INT — NOT NULL
genres
- genreID — INT — 기본 키 — NOT NULL
- genreAlt — VARCHAR(45) — NOT NULL
locations
- locationID — INT — 기본 키 — NOT NULL
- movies_movieCd — VARCHAR(20) — 외래 키 → movies.movieCd — NOT NULL
- do — VARCHAR(45) — NOT NULL
- si_gun_gu — VARCHAR(45) — NOT NULL
- dong_eup_myeon — VARCHAR(45) — NOT NULL
- detailed — VARCHAR(45)
- locationNm — VARCHAR(45) — NOT NULL
movies
- id — BIGINT — 기본 키 — NOT NULL
- movieCd — VARCHAR(20) — NOT NULL
- movieNm — VARCHAR(45) — NOT NULL
- poster — MEDIUMBLOB — NOT NULL
- openDtr — VARCHAR(45) — NOT NULL
- nationAlt — VARCHAR(45) — NOT NULL
- average_rating — FLOAT(2,1)
movies_has_genres
- movies_id — BIGINT — 외래 키 → movies.id — NOT NULL
- genres_genreID — INT — 외래 키 → genres.genreID — NOT NULL
movies_has_participants
- moviesParticipantsId — INT — 기본 키 — NOT NULL
- movies_movieCd — VARCHAR(20) — 외래 키 → movies.movieCd — NOT NULL
- participants_peopleCd — VARCHAR(45) — 외래 키 → participants.peopleCd — NOT NULL
participants
- peopleCd — VARCHAR(45) — 기본 키 — NOT NULL
- peopleNm — VARCHAR(45) — NOT NULL
- repRoleNm — VARCHAR(45) — NOT NULL
- like — INT — NOT NULL
ratings
- ratingID — INT — 기본 키 — NOT NULL
- users_id — VARCHAR(50) — 외래 키 → users.userId — NOT NULL
- movies_movieCd — VARCHAR(20) — 외래 키 → movies.movieCd — NOT NULL
- rating — FLOAT(2,1) — NOT NULL
- date — TIMESTAMP(2) — NOT NULL
sub-Commnets
- subCommnetID — INT — 기본 키 — NOT NULL
- comments_commnetID — INT — 외래 키 — NOT NULL
- users_id — VARCHAR(50) — 외래 키 — NOT NULL
- subCommnet — VARCHAR(1000) — NOT NULL
users
- id — BIGINT — 기본 키 — NOT NULL
- userId — VARCHAR(50) — NOT NULL
- password — VARCHAR(45)
- nickname — VARCHAR(45) — NOT NULL
wantings
- wantingID — INT — 기본 키 — NOT NULL
- users_id — VARCHAR(50) — 외래 키 → users.userId — NOT NULL
- movies_movieCd — VARCHAR(20) — 외래 키 → movies.movieCd — NOT NULL
- date — TIMESTAMP(2) — NOT NULL