hyun-book-shop

Tables (7)

Book (book)

  • book_id (Key) — type — Primary key — NOT NULL
  • title (Field) — type
  • publisher (Field2) — type
  • author (Field3) — type
  • price (Field4) — type

Cart (장바구니)

  • user_id (Key) — type — Foreign key → User.user_id — NOT NULL
  • book_id (Key2) — type — Foreign key → Book.book_id — NOT NULL
  • amount (user_id) — type

Order

  • order_id — type — Primary key — NOT NULL
  • user_id (Key) — type — Foreign key → User.user_id — NOT NULL
  • created_at (Field) — type

OrderInfo (Untitled)

  • order_id — type — Foreign key → Order.order_id — NOT NULL
  • book_id (Key) — type — Foreign key → Book.book_id — NOT NULL
  • amount (Field) — type
  • price (Field2) — type

Review

  • review_id — type — Primary key — NOT NULL
  • book_id (Key2) — type — Foreign key → Book.book_id — NOT NULL
  • user_id (Key) — type — Foreign key → User.user_id — NOT NULL
  • content (user_id) — type
  • rating (book_id) — type

User

  • user_id (Key) — type — Primary key — NOT NULL
  • enail (Field)

UserInfo

  • user_info_id (Key) — type — Primary key — NOT NULL
  • password (Field) — type
  • user_id (Key3) — type — Foreign key → User.user_id — NOT NULL