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