[Dev-team4] - ecommerce_system
Tables (8)
Deliver_Address (배송 주소)
- Key (delivery_address_id) — BIGINT — Primary key — NOT NULL — 배송주소ID
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL — 회원ID
- Field (address) — VARCHAR(50) — NOT NULL — 주소
- Field (is_configured) — Boolean — NOT NULL — 상태
- Field (coordinate) — POINT — NOT NULL — 좌표
Basket_Product (장바구니 상품)
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL — 회원ID
- product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — 상품ID
- Field (quantity) — INT — NOT NULL — 수량
Delivery (배송)
- Key (delivery_id) — BIGINT — Primary key — NOT NULL — 배송ID
- Key (delivery_address_id) — BIGINT — Foreign key → Deliver_Address.Key — NOT NULL — 배송주소ID
- order_id — BIGINT — Foreign key → Orders.order_id — NOT NULL — 주문ID
Orders (주문)
- order_id — BIGINT — Primary key — NOT NULL — 주문ID
- user_id — BIGINT — Foreign key → Users.user_id — NOT NULL — 회원ID
- order_detail — VARCHAR(100) — NOT NULL — 주문 요청사항
- total_price — INT — NOT NULL — 총 합계
- order_status — ENUM — NOT NULL — 주문 상태(주문중..)
- created_at — DATETIME — NOT NULL — 생성 날짜
Products (상품)
- product_id — BIGINT — Primary key — NOT NULL — 상품ID
- name — varchar(20) — NOT NULL — 상품 이름
- price — INT — NOT NULL — 상품 가격
- quantity — INT — NOT NULL — 재고
- created_at — DATETIME — NOT NULL — 생성 날짜
Refund (환불)
- Key (refund_id) — BIGINT — Primary key — NOT NULL — 환불ID
- order_id — BIGINT — Foreign key → Orders.order_id — NOT NULL — 주문ID
- Field (refund_reason) — VARCHAR(100) — NOT NULL — 환불사유
Users (회원)
- user_id — BIGINT — Primary key — NOT NULL — 회원ID
- name — VARCHAR(20) — NOT NULL — 이름
- email — VARCHAR(20) — NOT NULL — 이메일
- password — VARCHAR(20) — NOT NULL — 비밀번호
- phone_num — VARCHAR(20) — NOT NULL — 휴대폰 번호
- created_at — DATETIME — NOT NULL — 생성 날짜
- Field (is_admin) — BOOLEAN — NOT NULL — 관리자
order_item (주문 상품)
- order_id — BIGINT — Foreign key → Orders.order_id — NOT NULL — 주문ID
- product_id — BIGINT — Foreign key → Products.product_id — NOT NULL — 상품ID
- Field (quantity) — INT — NOT NULL — 주문 수량