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