OrdetSystem
Tables (4)
member (회원)
- id (ID) — Not Null — Primary key — NOT NULL
- email (이메일) — Not Null
- password (패스워드) — Not Null
- name (이름) — NULL
- role (역할) — NULL
- created_time (가입일자) — NULL
ordering (주문)
- id (ID) — NOT NULL — Primary key — NOT NULL
- member_id (주문자ID) — NOT NULL
- order_status (주문상태) — NULL
- created_time (주문일자) — NULL
ordering_details (Untitled)
- id (Key) — NOT NULL — Primary key — NOT NULL
- order_id (Field) — NOT NULL
- product_id (Field2) — NOT NULL
- quantity (Field3) — NOT NULL
- created_time (Field4) — NULL
product (상품)
- id (ID) — NOT NULL — Primary key — NOT NULL
- member_id (생산자ID) — NOT NULL
- name (상품명) — NOT NULL
- price (상품가격) — NOT NULL
- category (카테고리) — NULL
- stockQuantity (상품재고) — NOT NULL
- image_path (이미지url) — NULL
- created_time (생성일자) — NULL