mybatis-movie1

Tables (4)

DIRECTOR (감독)

  • DIR_ID (감독아이디) — Primary key — NOT NULL
  • NAME (감독명)
  • ADDRESS (감독주소)
  • INTRODUCE (소개)

GENRE (장르)

  • GENRE_NUM (장르번호) — Primary key — NOT NULL
  • GENRE_NAME (장르명)

MOVIE (영화)

  • ID (영화아이디) — Primary key — NOT NULL
  • DIR_ID (감독아이디) — Foreign key → DIRECTOR.DIR_ID — NOT NULL
  • TITLE (영화타이틀)
  • PEOPLE (관객수)

MOVIE_GENRE (영화장르)

  • GENRE_NUM (장르번호) — Foreign key → GENRE.GENRE_NUM — NOT NULL
  • ID (영화아이디) — Foreign key → MOVIE.ID — NOT NULL