BookStore

Tables (12)

Book (책)

  • Key (book_id) — BIGINT — Primary key — NOT NULL
  • Field (title) — VARCHAR(255) — NOT NULL
  • Field2 (author) — VARCHAR(255) — NOT NULL
  • Field3 (isbn) — VARCHAR(13) — NOT NULL — Unique 13 characters for book
  • Field4 (unit_price) — DECIMAL(10, 2) — NOT NULL — 99999999.99
  • Field (publication_date) — DATE — NOT NULL
  • Field2 (publisher) — VARCHAR(255)
  • Field (description) — TEXT — 65,536 Characters
  • Field (stock_quantity) — BIGINT — NOT NULL — to check Stock Available
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL

CartItem (InterMediate Table, Junction(Join))

  • Key (cart_item_id) — BIGINT — Primary key — NOT NULL — PK (it's not composite key)
  • Key (cart_id) — BIGINT — Foreign key → cart.Key — NOT NULL — Join Table has FK
  • Key (book_id) — BIGINT — Foreign key → Book.Key — NOT NULL — Join Table has FK
  • Field (quantity) — BIGINT — NOT NULL — How many copies of a book are added to a cart

Customer (회원)

  • Key (customer_id) — BIGINT — Primary key — NOT NULL
  • Field (password) — VARCHAR(255) — NOT NULL
  • Field2 (name) — VARCHAR(255) — NOT NULL
  • Field5 (email) — VARCHAR(255) — NOT NULL
  • Field3 (phone) — VARCHAR(20) — NOT NULL
  • Field4 (address) — VARCHAR(255) — NOT NULL — TEXT 사용하면 - 65,535
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field2 (updated_at) — TIMESTAMP — NOT NULL

MyPage (마이페이지)

    Order (주문)

    • Key (order_id) — BIGINT — Primary key — NOT NULL
    • Field (order_date) — DATETIME — NOT NULL
    • Key (customer_id) — BIGINT — Foreign key → Customer.Key — NOT NULL
    • Key (cart_id) — BIGINT — Foreign key → cart.Key — NOT NULL

    OrderBook (InterMediate, Juntion(Join))

    • Key (order_book_id) — BIGINT — Primary key — NOT NULL — composite PK - order_id & book_id (@EmbeddedId)
    • Key (book_id) — BIGINT — Foreign key → Book.Key — NOT NULL — Join Table has FK
    • Key (order_id) — BIGINT — Foreign key → Order.Key — NOT NULL — Join Table has FK
    • Field2 (quantity) — BIGINT — NOT NULL — How many of each book are part of a particular order

    cart (장바구니)

    • Key (cart_id) — BIGINT — Primary key — NOT NULL
    • Key (customer_id) — BIGINT — Foreign key → Customer.Key — NOT NULL
    • title (created_at) — TIMESTAMP — NOT NULL
    • Field3 (updated_at) — TIMESTAMP — NOT NULL

    category (책 카테고리(for advancement))

      deliver (배송 (for advancement))

        delivery option (배송 옵션(for advancement))

          review, comment (리뷰 (댓글) for advancement)

            wishlist (찜 (for advancement))