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