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