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