Shopping
Tables (6)
Member (회원)
- ID (회원ID) — BIGINT — Primary key — NOT NULL
- name (회원 이름) — VARCHAR(255) — NOT NULL
- roll (회원 역할) — ENUM(seller, user) — NOT NULL
- email (회원 이메일) — VARCHAR(255) — NOT NULL
- address (회원 주소) — VARCHAR(255) — NOT NULL
Order (주문)
- ID (주문 ID) — BIGINT — Primary key — NOT NULL
- member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
- date (주문 날짜) — DATE — NOT NULL
- total_price (총 금액) — int — NOT NULL
Order_Detail (주문 상세)
- ID (주문 상세 ID) — BIGINT — Primary key — NOT NULL
- order_ID (주문 ID) — BIGINT — Foreign key → Order.ID — NOT NULL
- product_ID (제품 ID) — BIGINT — Foreign key → Product.ID — NOT NULL
- count (제품 개수) — int — NOT NULL
- price (금액) — int — NOT NULL
Product (제품)
- ID (제품 ID) — BIGINT — Primary key — NOT NULL
- member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
- name (제품 이름) — VARCHAR(255) — NOT NULL
- price (제품 가격) — int — NOT NULL
- stock (제품 재고) — int — NOT NULL
- detail (제품 설명) — VARCHAR(255)
SellerRank (판매자 랭크)
- ID (판매자 랭크 ID) — BIGINT — Primary key — NOT NULL
- member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
- rank (판매자 랭크) — VARCHAR(255) — NOT NULL
- total_trade (총 판매량) — int — NOT NULL
UserRank (구매자 랭크)
- ID (판매자 랭크 ID) — BIGINT — Primary key — NOT NULL
- member_ID (회원ID) — BIGINT — Foreign key → Member.ID — NOT NULL
- rank (판매자 랭크) — VARCHAR(255) — NOT NULL
- total_trade (총 판매량) — int — NOT NULL