shop
Tables (4)
order (주문목록)
- order_id (주문번호) — BIGINT — Primary key — NOT NULL
- member_id (회원번호) — BIGINT — Foreign key → user.member_id — NOT NULL
- order_time (주문시각) — datetime — NOT NULL
- order_status (주문 상태) — CHAR(255) — NOT NULL
- order_price (주문 총 금액) — BIGINT — NOT NULL
order_detail (주문 상세)
- id (주문상세번호) — BIGINT — Primary key — NOT NULL
- order_id (주문번호) — BIGINT — Foreign key → order.order_id — NOT NULL
- product_id (상품번호) — BIGINT — Foreign key → product.product_id — NOT NULL
- order_quentity (주문수량) — BIGINT — NOT NULL
product (상품목록)
- product_id (상품번호) — BIGINT — Primary key — NOT NULL
- member_id (회원번호) — BIGINT — Foreign key → user.member_id — NOT NULL
- product_name (상품명) — CHAR(255) — NOT NULL
- stock (재고수량) — BIGINT — NOT NULL
- price (개당 가격) — BIGINT — NOT NULL
user (회원목록)
- member_id (회원번호) — BIGINT — Primary key — NOT NULL
- name (회원이름) — CHAR(255) — NOT NULL
- telNo (전화번호) — CHAR(255) — NOT NULL
- address (주소) — CHAR(255) — NOT NULL
- role (역할) — CHAR(255) — NOT NULL