order_system

Tables (5)

DELIVER_STATUS (배송상태)

  • id (배송상태ID) — BIGINT — Primary key — NOT NULL
  • order_id (주문ID) — BIGINT — Foreign key → ORDER.id — NOT NULL
  • status (배송상태) — ENUM('배송 전', '배송시작', '배송중','배송완료')
  • current_location (현재위치) — VARCHAR(255)
  • tracking_number (운송장번호) — VARCHAR(255) — NOT NULL

ORDER (주문내역)

  • id (주문ID) — BIGINT — Primary key — NOT NULL
  • customer_id (구매자ID) — BIGINT — Foreign key → USER.id — NOT NULL
  • date (구매일자) — DATE_FORMAT

ORDER_ITEM (주문상세)

  • id (주문상세ID) — BIGINT — Primary key — NOT NULL
  • order_id (주문ID) — BIGINT — Foreign key → ORDER.id — NOT NULL
  • product_id (상품ID) — BIGINT — Foreign key → PRODUCT.seller_id — NOT NULL
  • amount (주문량) — BIGINT — NOT NULL
  • purchased_price (구매가격) — BIGINT — NOT NULL

PRODUCT (상품)

  • id (상품ID) — BIGINT — Primary key — NOT NULL
  • seller_id (판매자ID) — BIGINT — Foreign key → USER.id — NOT NULL
  • name (상품이름) — VARCHAR(255) — NOT NULL
  • quantity (재고) — BIGINT — NOT NULL
  • price (가격) — BIGINT — NOT NULL

USER (회원정보)

  • id (회원ID) — BIGINT — Primary key — NOT NULL
  • name (회원이름) — VARCHAR(255) — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • role (역할) — ENUM(seller, customer)
  • address (주소) — VARCHAR(255) — NOT NULL