refresh-bookstore

Tables (5)

Category (카테고리)

  • category_id (FK) — Long — Primary key — NOT NULL
  • name (Field) — varchar(100)

Order (주문)

  • order_id (PK) — Long — Primary key — NOT NULL
  • orderList_id (Fk) — Long — Foreign key → orderList.orderList_id — NOT NULL
  • email (Field) — varchar(100)
  • shippingStatus (Field2) — varchar(100)
  • deliveryFee (Field3) — varchar(100)
  • uerName (Field4) — varchar(100)
  • postalCode (Field5) — varchar(100)
  • address (Field6) — varchar(100)
  • detailAddress (Field7) — varchar(100)
  • userPhone (Field8) — varchar(100)
  • orderRequest (Field9) — varchar(100)
  • totalPrice (Field11) — varchar(100)
  • create_at (Field12) — date

Product (상품)

  • book_id (PK) — Long — Primary key — NOT NULL
  • category_id (FK) — varchar(100) — Foreign key → Category.category_id — NOT NULL
  • title (Field1) — varchar(100)
  • author (Field2) — varchar(100)
  • publisher (Field3) — varchar(100)
  • publication_date (Field4) — date
  • isbn (Field5) — varchar(100)
  • description (Field6) — LONG
  • price (Field7) — varchar(100)
  • image_path (Field8) — varchar(100)
  • category (Field9) — varchar(100)
  • create_at (Field11) — date

orderList (주문리스트)

  • orderList_id (Pk) — Long — Primary key — NOT NULL
  • book_id (FK) — Long — Foreign key → Product.book_id — NOT NULL
  • amount (수량)

user (유저)

  • uer_id (PK) — Long — Primary key — NOT NULL
  • name (Field) — varchar(100)
  • email (Field7) — varchar(100)
  • password (Field2) — varchar(100)
  • address (Field3) — varchar(100)
  • phone (Field4) — varchar(100)
  • isAdmin (Field6) — varchar(100)
  • create_at (Field5) — date