book store

Tables (3)

Book (책)

  • id (Key) — bigint — Primary key — NOT NULL
  • ISBN (Field6) — varchar
  • title (Field) — varchar
  • description (Field2) — midText
  • like (Field3) — int
  • author (Field4) — varchar
  • genre (Field5) — varchar
  • review (Field7) — varchar
  • preference (Field8) — int
  • img (Field9) — varchar

User (유저)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar
  • password (Field2) — varchar
  • address (Field3) — varchar
  • zipCode (Field4) — varchar
  • grade (Field5) — varchar

UserBook (Untitled)

  • id (Key) — bigint — Foreign key → User.id — NOT NULL
  • id (Key2) — bigint — Foreign key → Book.id — NOT NULL