order
Tables (5)
address (주소)
- id (주소id) — BIGINT — Primary key — NOT NULL
- user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
- addr (주소) — varchar(255) — NOT NULL
order_detail (주문정보)
- id (테이블id) — BIGINT — Primary key — NOT NULL
- pro_id (상품ID) — BIGINT — Foreign key → products.id — NOT NULL
- orderr_id (주문번호) — BIGINT — Foreign key → order_sheet.id — NOT NULL
- qty (수량) — BIGINT — NOT NULL
order_sheet (주문지)
- id — BIGINT — Primary key — NOT NULL
- user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
- order_time (주문시각) — datetime — NOT NULL
products (상품)
- id (상품ID) — BIGINT — Primary key — NOT NULL
- user_id (회원id) — BIGINT — Foreign key → user.id — NOT NULL
- name (상품이름) — varchar(255) — NOT NULL
- detail (상품설명) — varchar(3000)
- price (가격) — BIGINT — NOT NULL
- stock (재고) — BIGINT — NOT NULL
user (회원)
- id (회원id) — BIGINT — Primary key — NOT NULL
- name (이름) — varchar(255) — NOT NULL
- phone (전화번호) — varchar(255) — NOT NULL
- role (판매자구분) — enum — NOT NULL