order
Tables (4)
order (주문기록)
- ID (주문번호) — BIGINT — Primary key — NOT NULL
- user_id (사용자ID) — BIGINT — Foreign key → user.ID — NOT NULL
- DATETIME (구매시각) — DATETIME — NOT NULL
particular (주문 상세기록)
- ID (상세기록) — BIGINT — Primary key — NOT NULL
- product_id (상품ID) — BIGINT — Foreign key → product.ID — NOT NULL
- order_id (주문번호) — BIGINT — Foreign key → order.ID — NOT NULL
- product_count (구매 수량) — BIGINT — NOT NULL
product (상품)
- ID (상품ID) — BIGINT — Primary key — NOT NULL
- seller_id (판매자ID) — BIGINT — Foreign key → user.ID — NOT NULL
- name (상품명) — VARCHAR(255) — NOT NULL
- price (가격) — BIGINT — NOT NULL
- stock (재고) — BIGINT — NOT NULL
- seller (판매자) — VARCHAR(255) — NOT NULL
user (사용자)
- ID (사용자ID) — BIGINT — Primary key — NOT NULL
- name (이름) — VARCHAR(255) — NOT NULL
- email (이메일) — VARCHAR(255) — NOT NULL
- password (비밀번호) — VARCHAR(255) — NOT NULL
- role (유저구분) — VARCHAR(255) — NOT NULL