종프_상품 - 2026-08-31 11:44:07

테이블 (11)

campaign_target_lot

  • campaign_target_lot_id — bigint — 기본 키 — NOT NULL
  • target_date — date — NOT NULL
  • stock_lot_id — bigint — 외래 키 — NOT NULL
  • turnover_rate — decimal(5,4) — NOT NULL
  • issuable_qty — int — NOT NULL
  • target_rank — int — NOT NULL
  • created_at — datetime(6) — NOT NULL

category

  • category_id — bigint — 기본 키 — NOT NULL
  • parent_id — bigint — 외래 키
  • parent_key — bigint
  • name — varchar(50) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

daily_sales

  • daily_sales_id — bigint — 기본 키 — NOT NULL
  • product_option_id — bigint — 외래 키 — NOT NULL
  • stat_date — date — NOT NULL
  • opening_stock — int — NOT NULL
  • inbound_qty — int — NOT NULL
  • restocked_qty — int — NOT NULL
  • sold_qty — int — NOT NULL
  • sold_amount — bigint — NOT NULL
  • disposed_qty — int — NOT NULL
  • expired_qty — int — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

option_availability_sync_failure

  • option_availability_sync_failure_id — bigint — 기본 키 — NOT NULL
  • product_option_id — bigint — 외래 키 — NOT NULL
  • sold_out — tinyint(1) — NOT NULL
  • occurred_at — datetime(6) — NOT NULL
  • attempt_count — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

product

  • product_id — bigint — 기본 키 — NOT NULL
  • product_code — varchar(50) — NOT NULL
  • request_id — varchar(100) — NOT NULL
  • name — varchar(255) — NOT NULL
  • category_id — bigint — 외래 키 — NOT NULL
  • supplier_id — bigint — 외래 키 — NOT NULL
  • sale_status — varchar(30) — NOT NULL
  • storage_type — varchar(30) — NOT NULL
  • sale_available_days_from_expiry — int — NOT NULL
  • description — text
  • deleted_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

product_image

  • product_image_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 — NOT NULL
  • request_id — varchar(100) — NOT NULL
  • upload_id — binary(16) — NOT NULL
  • object_key — varchar(255) — NOT NULL
  • upload_status — varchar(20) — NOT NULL
  • sort_order — int — NOT NULL
  • is_main — tinyint(1) — NOT NULL
  • is_main_key — bigint
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

product_option

  • product_option_id — bigint — 기본 키 — NOT NULL
  • product_id — bigint — 외래 키 — NOT NULL
  • name — varchar(100) — NOT NULL
  • price — int — NOT NULL
  • sale_status — varchar(30) — NOT NULL
  • sold_out — tinyint(1) — NOT NULL
  • sold_out_synced_at — datetime(6)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

stock_allocation

  • stock_allocation_id — bigint — 기본 키 — NOT NULL
  • order_item_id — bigint — NOT NULL
  • stock_lot_id — bigint — 외래 키 — NOT NULL
  • qty — int — NOT NULL
  • status — varchar(30) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

stock_lot

  • stock_lot_id — bigint — 기본 키 — NOT NULL
  • product_option_id — bigint — 외래 키 — NOT NULL
  • request_id — varchar(100) — NOT NULL
  • received_date — date — NOT NULL
  • expiry_date — date — NOT NULL
  • initial_qty — int — NOT NULL
  • available_qty — int — NOT NULL
  • status — varchar(30) — NOT NULL
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

stock_movement

  • stock_movement_id — bigint — 기본 키 — NOT NULL
  • stock_lot_id — bigint — 외래 키 — NOT NULL
  • request_id — varchar(100)
  • movement_type — varchar(30) — NOT NULL
  • quantity — int — NOT NULL
  • qty_before — int — NOT NULL
  • qty_after — int — NOT NULL
  • order_id — bigint
  • admin_id — bigint
  • disposal_reason — varchar(30)
  • reason — varchar(200)
  • created_at — datetime(6) — NOT NULL

supplier

  • supplier_id — bigint — 기본 키 — NOT NULL
  • name — varchar(100) — NOT NULL
  • contact — varchar(100)
  • created_at — datetime(6) — NOT NULL
  • updated_at — datetime(6) — NOT NULL