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