First come

Tables (6)

order_items (Untitled5)

  • orderit_id (주문 항목 id) — Primary key — NOT NULL
  • product_id (제품id) — Foreign key → products.product_id — NOT NULL
  • order_id (주문id) — Foreign key → orders.order_id — NOT NULL
  • user_id (유저id) — Foreign key → orders.user_id — NOT NULL
  • Field

orders (Untitled4)

  • order_id (주문id) — Primary key — NOT NULL
  • user_id (유저id) — Foreign key → user.user_id — NOT NULL
  • order_date (주문날짜) — timestamp
  • status (주문상태)
  • total_amount (총 금액)

products (Untitled2)

  • product_id (제품id) — Primary key — NOT NULL
  • name (제품이름) — varchar
  • description (설명) — text
  • price (가격) — var
  • stock_quantity (재고량) — var
  • created_at (등록일자) — timestamp
  • updated_at (수정일자) — timestamp

returns (Untitled6)

  • returns_id (반품id) — Primary key — NOT NULL
  • orderit_id (주문 항목 id) — Foreign key → order_items.orderit_id — NOT NULL
  • return_date (반품시간)
  • status (반품상태)

user (Untitled)

  • user_id (유저id) — Primary key — NOT NULL
  • name (이름)
  • phone_number (핸드폰번호) — varchar(11)
  • address (주소) — text
  • email (이메일) — varchar(255_)
  • password (비밀번호)
  • created_at (등록일자) — timestamp
  • updated_at (수정일자) — timestamp

wishlist (Untitled3)

  • wishlsit_id (위시리스트id) — Primary key — NOT NULL
  • user_id — Foreign key → user.user_id — NOT NULL
  • product_id (제품id) — Foreign key → products.product_id — NOT NULL