order

Tables (4)

order (주문기록)

  • ID (주문번호) — BIGINT — Primary key — NOT NULL
  • user_id (사용자ID) — BIGINT — Foreign key → user.ID — NOT NULL
  • DATETIME (구매시각) — DATETIME — NOT NULL

particular (주문 상세기록)

  • ID (상세기록) — BIGINT — Primary key — NOT NULL
  • product_id (상품ID) — BIGINT — Foreign key → product.ID — NOT NULL
  • order_id (주문번호) — BIGINT — Foreign key → order.ID — NOT NULL
  • product_count (구매 수량) — 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
  • price (가격) — BIGINT — NOT NULL
  • stock (재고) — BIGINT — NOT NULL
  • seller (판매자) — VARCHAR(255) — NOT NULL

user (사용자)

  • ID (사용자ID) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR(255) — NOT NULL
  • email (이메일) — VARCHAR(255) — NOT NULL
  • password (비밀번호) — VARCHAR(255) — NOT NULL
  • role (유저구분) — VARCHAR(255) — NOT NULL