mark project
Tables (6)
Address (배송지)
- Address_id (배송지 고유번호) — Primary key — NOT NULL
- user_id (회원고유번호) — Foreign key → User.user_id — NOT NULL
- address (배송지)
- createAt (생성날짜)
- updateAt (수정날짜)
Cart (장바구니)
- cart_id (장바구니고유번호) — Primary key — NOT NULL
- createAt (생성날짜)
- updateAt (수정날짜)
- quanitiy (수량??)
Order (주문)
- order_id (주문번호) — Primary key — NOT NULL
- user_id (회원고유번호) — Foreign key → User.user_id — NOT NULL
- total_price (주문 총 금액) — 고려해봐야할 것
- delivery_status (배송상태)
- req (배송요청사항)
- createAt (주문날짜)
- Field
Order_Product (주문상품)
- order_id (주문번호) — Foreign key → Order.order_id — NOT NULL
- product_id (상품고유번호) — Foreign key → Product.product_id — NOT NULL
- price (주문 가격)
- item_quantity (수량)
Product (상품)
- product_id (상품고유번호) — Primary key — NOT NULL
- image (상품이미지)
- product_name (상품명)
- product_price (상품가격)
- product_stock (상품수량)
- product_info (상품설명)
- product_cataegory (상품카테고리)
- createAt (생성날짜)
- createBy (생성자)
- updateAt (수정날짜)
User (사용자)
- user_id (회원고유번호) — Primary key — NOT NULL
- password (비밀번호)
- name (이름)
- phone (전화번호)
- role (역할)
- createAt (생성날짜)
- updateAt (수정날짜)