order

Tables (5)

order (주문 테이블)

  • id (주문 ID) — bigint — Primary key — NOT NULL
  • user_id (유저아이디) — bigint — Foreign key → user.id — NOT NULL
  • order_time (주문시간)

order_before (장바구니)

  • id (Key) — bigint — Primary key — NOT NULL
  • product_id (상품 아이디) — bigint — Foreign key → product.id — NOT NULL
  • user_id (유저아이디2) — bigint — Foreign key → user.id — NOT NULL
  • wbuy_count (구매수량) — int — NOT NULL

order_detail (주문 상세내역)

  • id (주문 상세내역아이디) — bigint — Primary key — NOT NULL
  • product_id (상품 아이디) — bigint — Foreign key → product.id — NOT NULL
  • order_id (주문 ID) — bigint — Foreign key → order.id — NOT NULL
  • buy_count (주문 수량) — int — NOT NULL

product (상품 테이블)

  • id (상품 아이디) — bigint — Primary key — NOT NULL
  • user_id (유저아이디(판매자)) — bigint — Foreign key → user.id — NOT NULL
  • p_name (상품이름) — varchar(255) — NOT NULL
  • stock (재고) — int — NOT NULL

user (유저테이블)

  • id (유저아이디) — bigint — Primary key — NOT NULL
  • name (이름) — varchar(255) — NOT NULL
  • role (역할군) — enum('user','seller') — NOT NULL
  • ph_num (번호) — varchar(255) — NOT NULL