라자다쇼핑몰

테이블 (8)

결제 (Untitled4)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

교환 및 환불 (Untitled7)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8

리뷰 (Untitled)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

배송 (Untitled5)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

상품 (products)

  • product_id (key) — bigint
  • seller_id (Field2) — bigint
  • category_id (Field3) — bigint
  • brand (Field4) — varchar(100)
  • title (Field5) — varchar(255)
  • url (Field6) — varchar(500)
  • description (Field7) — text
  • initial_price (Field8) — decimal(12,2)
  • final_price (Field9) — decimal(12,2)
  • currency (Field10) — varchar(10)
  • returns_and_warranty (Field11) — text
  • is_lazmall (Field) — boolean
  • created_at (Field12) — timestamp
  • updated_at (Field13) — timestamp

주문 (orders)

  • oreder_id (Key) — bigint — 기본 키 — NOT NULL
  • order_number (Field3) — varchar(50)
  • order_status (Field4) — varchar(30)
  • total_amount (Field5) — decimal(12,2)
  • ordered_at (Field6) — timestamp
  • created_at (Field7) — timestamp
  • updated_at (Field) — timestamp
  • user_id (Key2) — bigint — 외래 키 → 회원.user_id — NOT NULL

주문상세 (order_items)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • product_id (Field5) — bigint
  • product_variant_id (Field6) — bigint
  • seller_id (Field7) — bigint
  • quantity (Field8) — int
  • unit_price (Field9) — decimal(12,2)
  • discount_amount (Field10) — decimal(12,2)
  • final_amount (Field11) — decimal(12,2)
  • item_status (Field12) — varchar(30)
  • created_at (Field) — timestamp
  • updated_at (Field2) — timestamp
  • oreder_id (Key2) — bigint — 외래 키 → 주문.oreder_id — NOT NULL

회원 (users)

  • user_id (Key) — bigint — 기본 키 — NOT NULL
  • email (Field2) — varchar(100)
  • password (Field3) — varchar(255)
  • name (Field4) — varchar(50)
  • phone (Field5) — varchar(30)
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp