order_system
Tables (4)
member (회원)
- id (ID) — Primary key — NOT NULL
- email (이메일) — NOT NULL
- password (패스워드) — NOT NULL
- name (이름)
- role (역할) — enum('user', 'admin')
- created_time (가입일자)
order_details (주문상세)
- id (ID) — Primary key — NOT NULL
- quantity (주문수량) — NOT NULL
- created_time (주문일시)
- orering_id (주문ID) — Foreign key → ordering.id — NOT NULL
- 상품ID (ID3) — Foreign key → product.id — NOT NULL
ordering (주문)
- id (ID) — Primary key — NOT NULL
- del_yn (삭제여부)
- member_id (회원ID) — Foreign key → member.id — NOT NULL
- created_time (생성시각)
product (상품)
- id (ID) — Primary key — NOT NULL
- name (상품명) — NOT NULL
- price (상품가격) — NOT NULL
- category (카테고리)
- stockQuantity (상품재고) — NOT NULL
- image_path (이미지url)
- created_time (생성일자)
- member_id (회원ID) — Foreign key → member.id — NOT NULL