종프_상품
테이블 (11)
campaign_target_lot
- campaign_target_lot_id — bigint — 기본 키 — NOT NULL
- target_date — date — NOT NULL
- stock_lot_id — bigint — 외래 키 → stock_lot.stock_lot_id — 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 — 외래 키 → category.category_id
- 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 — 외래 키 → product_option.product_option_id — 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 — 외래 키 → product_option.product_option_id — 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 — 외래 키 → category.category_id — NOT NULL
- supplier_id — bigint — 외래 키 → supplier.supplier_id — 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 — 외래 키 → product.product_id — 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 — 외래 키 → product.product_id — 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 — 외래 키 → stock_lot.stock_lot_id — 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 — 외래 키 → product_option.product_option_id — 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 — 외래 키 → stock_lot.stock_lot_id — 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