MB
Tables (9)
Book (책)
- isbn (Key) — Long — Primary key — NOT NULL
- book_name (Field) — String
- publisher (Field2) — String
- author (Field3) — String
- description (Field4) — String
- image (Field5) — String
- pub_date (Field6) — String
friend (Untitled3)
- number (Key) — Long — Primary key — NOT NULL
- user1 (유저 고유 번호) — Long — Foreign key → user.user_number — NOT NULL
- user2 (유저 고유 번호2) — Long — Foreign key → user.user_number — NOT NULL
genre (Untitled)
- number (Key) — Long — Primary key — NOT NULL
- name (Field) — String
movie (영화)
- movie_id (Key) — Long — Primary key — NOT NULL
- movie_name (Field) — String
- genre (Field2) — String
- description (Field3) — String
- poster (Field4) — String
user (유저)
- user_number (유저 고유 번호) — Long — Primary key — NOT NULL
- user_name (Field) — String
- id (Field2) — String
- password (Field3) — String
- email (Field4) — String
user_book (유저 추천 책)
- user_book_number (Key) — Long — Primary key — NOT NULL
- rating (Field) — Double
- review (Field2) — String
- isbn (Key3) — Long — Foreign key → Book.isbn — NOT NULL
- user_number (유저 고유 번호2) — Long — Foreign key → user.user_number — NOT NULL
user_dislike_genre (Untitled2)
- number (Key) — Long — Primary key — NOT NULL
- number (Key2) — Long — Foreign key → genre.number — NOT NULL
- user_number (유저 고유 번호) — Long — Foreign key → user.user_number — NOT NULL
user_like_genre (유저 선호 장르)
- number (Key) — Long — Primary key — NOT NULL
- user_number (유저 고유 번호) — Long — Foreign key → user.user_number — NOT NULL
- number (Key2) — Long — Foreign key → genre.number — NOT NULL
user_movie (유저 취향 영화)
- user_movie_number (Key) — Long — Primary key — NOT NULL
- rating (Field) — Double
- user_number (유저 고유 번호2) — Long — Foreign key → user.user_number — NOT NULL
- movie_id (Key3) — Long — Foreign key → movie.movie_id — NOT NULL