shop
Tables (7)
Address (주소)
- id (주소아이디) — BIGINT — Primary key — NOT NULL
- member_id (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
- address_name (주소명) — VARCHAR
- zipcode (우편번호) — VARCHAR
- address (주소) — VARCHAR
- detail_address (상세주소) — VARCHAR
- phone_number (전화번호) — VARCHAR
- created_at (등록일) — DATETIME
- updated_at (수정일) — DATETIIME
Cart (장바구니)
- id (장바구니아이디) — BIGINT — Primary key — NOT NULL
- member_id (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
- created_at (생성일) — DATETIME
- updated_at (수정일) — DATETIME
CartItem (장바구니상품)
- id (장바구니상품아이디) — BIGINT — Primary key — NOT NULL
- cart_id (장바구니아이디) — BIGINT — Foreign key → Cart.id — NOT NULL
- product_id (상품아이디) — BIGINT — Foreign key → Product.id — NOT NULL
- quantity (수량) — INT
- created_at (추가일) — DATETIME
- updated_at (수정일) — DATETIME
Member (회원)
- id (회원아이디) — BIGINT — Primary key — NOT NULL
- email (이메일) — VARCHAR
- passowrd (비밀번호) — VARCHAR
- name (이름) — VARCHAR
- role (권한) — VARCHAR
- created_at (가입일) — DATETIME
- updated_at (수정일) — DATETIME
OrderItem (주문상품)
- id (주문상품아이디) — BIGINT — Primary key — NOT NULL
- product_id (상품아이디) — BIGINT — Foreign key → Product.id — NOT NULL
- orders_id (주문아이디) — BIGINT — Foreign key → Orders.id — NOT NULL
- quantity (수량) — INT
- order_price (주문시가격) — INT
- product_name (주문시상품이름) — String
Orders (주문)
- id (주문아이디) — BIGINT — Primary key — NOT NULL
- member_id (회원아이디) — BIGINT — Foreign key → Member.id — NOT NULL
- address_id (주소아이디) — BIGINT — Foreign key → Address.id — NOT NULL
- total_price (총주문금액) — INT
- status (주문상태) — VARCHAR
- ordered_at (주문일) — DATETIME
Product (상품)
- id (상품아이디) — BIGINT — Primary key — NOT NULL
- name (상품명) — VARCHAR
- price (상품가격) — INT
- stock_quantity (상품재고) — INT
- description (상품설명) — TEXT
- status (상품판매상태) — VARCHAR
- created_at (등록일) — DATETIME
- updated_at (수정일) — DATETIME