2

Tables (33)

category

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • name — VARCHAR(64) — NOT NULL
  • level — VARCHAR(16) — NOT NULL
  • parent_id — BIGINT
  • status — VARCHAR(16) — NOT NULL
  • sort_order — INT — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

circular_buyer

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • company_name — VARCHAR(128) — NOT NULL
  • industry_group — VARCHAR(64) — NOT NULL
  • product_types — JSON
  • product_note — TEXT
  • description — TEXT
  • primary_material_fit — VARCHAR(32) — NOT NULL
  • manager_name — VARCHAR(64) — NOT NULL
  • phone — VARCHAR(32) — NOT NULL
  • partner_type — VARCHAR(32) — NOT NULL
  • embedding — JSON
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

circular_material_price_policy

  • material_code — VARCHAR(32) — Primary key — NOT NULL
  • material_name_ko — VARCHAR(32) — NOT NULL
  • material_group — VARCHAR(32) — NOT NULL
  • price_per_kg — INT — NOT NULL
  • active — TINYINT(1) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

infrastructure

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • location_type — VARCHAR(16) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • region — VARCHAR(32) — NOT NULL
  • manager_name — VARCHAR(64) — NOT NULL
  • contact — VARCHAR(32) — NOT NULL
  • address — VARCHAR(256) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

inventory

  • id — BIGINT — Primary key — NOT NULL
  • sku_id — BIGINT — Foreign key → product_sku.id — NOT NULL
  • location_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • inventory_status — VARCHAR(32) — NOT NULL
  • quantity — INT — NOT NULL
  • reserved_quantity — INT — NOT NULL
  • in_transit_quantity — INT — NOT NULL
  • available_quantity — INT — NOT NULL
  • status_changed_at — DATETIME — NOT NULL
  • last_movement_at — DATETIME — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

inventory_candidate_condition

  • id — BIGINT — Primary key — NOT NULL
  • inventory_id — BIGINT — Foreign key → inventory.id — NOT NULL
  • condition_code — INT — NOT NULL
  • condition_label — VARCHAR(128) — NOT NULL
  • matched_at — DATETIME — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

material

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • name_ko — VARCHAR(32) — NOT NULL
  • material_group — VARCHAR(32) — NOT NULL
  • active — TINYINT(1) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

product_master

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • category_code — VARCHAR(32) — NOT NULL
  • base_price — BIGINT — NOT NULL
  • lead_time_days — INT — NOT NULL
  • warehouse_safety_stock — INT — NOT NULL
  • store_safety_stock — INT — NOT NULL
  • main_vendor_code — VARCHAR(32) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

product_material_composition

  • id — BIGINT — Primary key — NOT NULL
  • product_id — BIGINT — Foreign key → product_master.id — NOT NULL
  • material_id — BIGINT — Foreign key → material.id — NOT NULL
  • ratio — INT — NOT NULL
  • composition_order — INT — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

product_sku

  • id — BIGINT — Primary key — NOT NULL
  • sku_code — VARCHAR(32) — NOT NULL
  • product_code — VARCHAR(32) — NOT NULL
  • color — VARCHAR(32) — NOT NULL
  • size — VARCHAR(16) — NOT NULL
  • unit_price — BIGINT — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

purchase_order

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • vendor_id — BIGINT — Foreign key → vendor.id — NOT NULL
  • vendor_name — VARCHAR(128) — NOT NULL
  • vendor_contact_name — VARCHAR(64) — NOT NULL
  • warehouse_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • warehouse_name — VARCHAR(128) — NOT NULL
  • member_id — VARCHAR(32)
  • member_name — VARCHAR(64)
  • status — VARCHAR(16) — NOT NULL
  • total_amount — BIGINT — NOT NULL
  • cancel_reason — VARCHAR(256)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

purchase_order_item

  • id — BIGINT — Primary key — NOT NULL
  • purchase_order_id — BIGINT — Foreign key → purchase_order.id — NOT NULL
  • vendor_product_id — BIGINT — Foreign key → vendor_product.id — NOT NULL
  • product_code — VARCHAR(64) — NOT NULL
  • product_name — VARCHAR(256) — NOT NULL
  • sku_code — VARCHAR(32) — NOT NULL
  • color — VARCHAR(32) — NOT NULL
  • size — VARCHAR(16) — NOT NULL
  • unit_price — BIGINT — NOT NULL
  • quantity — INT — NOT NULL
  • subtotal — BIGINT — NOT NULL

purchase_order_status_history

  • id — BIGINT — Primary key — NOT NULL
  • purchase_order_id — BIGINT — Foreign key → purchase_order.id — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • changed_at — DATETIME — NOT NULL
  • changed_by_name — VARCHAR(64)
  • note — VARCHAR(256)

refresh_token

  • id — BIGINT — Primary key — NOT NULL
  • employee_code — VARCHAR(50) — NOT NULL
  • token — VARCHAR(512) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL

store_inbound_header

  • id — BIGINT — Primary key — NOT NULL
  • inbound_no — VARCHAR(50) — NOT NULL
  • source_ref_no — VARCHAR(50) — NOT NULL
  • source_ref_id — BIGINT
  • outbound_no — VARCHAR(50) — NOT NULL
  • store_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • from_warehouse_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • total_sku_count — INT — NOT NULL
  • total_expected_quantity — INT — NOT NULL
  • expected_arrival_at — DATETIME — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • received_at — DATETIME
  • requested_by_member_id — VARCHAR(50)
  • requested_by_name — VARCHAR(100)
  • received_by_member_id — VARCHAR(50)
  • received_by_name — VARCHAR(100)
  • memo — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

store_inbound_item

  • id — BIGINT — Primary key — NOT NULL
  • inbound_header_id — BIGINT — Foreign key → store_inbound_header.id — NOT NULL
  • outbound_item_id — BIGINT
  • source_line_ref_id — BIGINT
  • sku_id — BIGINT — Foreign key → product_sku.id — NOT NULL
  • sku_code — VARCHAR(50) — NOT NULL
  • product_code — VARCHAR(50) — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • main_category — VARCHAR(100)
  • sub_category — VARCHAR(100)
  • color — VARCHAR(50)
  • size — VARCHAR(50)
  • unit_price — BIGINT
  • expected_quantity — INT — NOT NULL
  • memo — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

store_inbound_status_history

  • id — BIGINT — Primary key — NOT NULL
  • inbound_header_id — BIGINT — Foreign key → store_inbound_header.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • changed_at — DATETIME — NOT NULL
  • changed_by_member_id — VARCHAR(50)
  • changed_by_name — VARCHAR(100)
  • reason — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

store_order_header

  • id — BIGINT — Primary key — NOT NULL
  • order_no — VARCHAR(50) — NOT NULL
  • store_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • warehouse_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • requested_by_member_id — VARCHAR(50) — NOT NULL
  • requested_by_name — VARCHAR(100) — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • total_sku_count — INT — NOT NULL
  • total_requested_quantity — INT — NOT NULL
  • memo — VARCHAR(500)
  • cancel_reason — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

store_order_item

  • id — BIGINT — Primary key — NOT NULL
  • order_header_id — BIGINT — Foreign key → store_order_header.id — NOT NULL
  • sku_id — BIGINT — Foreign key → product_sku.id — NOT NULL
  • sku_code — VARCHAR(32) — NOT NULL
  • product_code — VARCHAR(32) — NOT NULL
  • product_name — VARCHAR(128) — NOT NULL
  • main_category — VARCHAR(64) — NOT NULL
  • sub_category — VARCHAR(64) — NOT NULL
  • color — VARCHAR(32) — NOT NULL
  • size — VARCHAR(16) — NOT NULL
  • unit_price — BIGINT — NOT NULL
  • requested_quantity — INT — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

store_order_status_history

  • id — BIGINT — Primary key — NOT NULL
  • order_header_id — BIGINT — Foreign key → store_order_header.id — NOT NULL
  • history_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • changed_at — DATETIME — NOT NULL
  • changed_by_member_id — VARCHAR(50)
  • changed_by_name — VARCHAR(100)
  • reason — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

store_sale_header

  • id — BIGINT — Primary key — NOT NULL
  • sale_no — VARCHAR(50) — NOT NULL
  • store_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • sold_at — DATETIME — NOT NULL
  • total_quantity — INT — NOT NULL
  • total_amount — BIGINT — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

store_sale_item

  • id — BIGINT — Primary key — NOT NULL
  • sale_header_id — BIGINT — Foreign key → store_sale_header.id — NOT NULL
  • sku_id — BIGINT — Foreign key → product_sku.id — NOT NULL
  • sku_code — VARCHAR(32) — NOT NULL
  • product_code — VARCHAR(32) — NOT NULL
  • product_name — VARCHAR(128) — NOT NULL
  • main_category — VARCHAR(64) — NOT NULL
  • sub_category — VARCHAR(64) — NOT NULL
  • color — VARCHAR(32) — NOT NULL
  • size — VARCHAR(16) — NOT NULL
  • quantity — INT — NOT NULL
  • unit_price — BIGINT — NOT NULL
  • line_amount — BIGINT — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

store_warehouse_map

  • id — BIGINT — Primary key — NOT NULL
  • store_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • warehouse_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • role — VARCHAR(16) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

user

  • id — BIGINT — Primary key — NOT NULL
  • employee_code — VARCHAR(50)
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(64) — NOT NULL
  • email — VARCHAR(128) — NOT NULL
  • phone_number — VARCHAR(32) — NOT NULL
  • location_code — VARCHAR(32) — NOT NULL
  • location_name — VARCHAR(128) — NOT NULL
  • application_reason — TEXT
  • role — VARCHAR(20)
  • status — VARCHAR(20)
  • applied_at — DATETIME
  • processed_at — DATETIME

vendor

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(32) — NOT NULL
  • name — VARCHAR(128) — NOT NULL
  • contact_name — VARCHAR(64)
  • contact_phone — VARCHAR(32)
  • contact_email — VARCHAR(128)
  • status — VARCHAR(16) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

vendor_product

  • id — BIGINT — Primary key — NOT NULL
  • code — VARCHAR(64) — NOT NULL
  • vendor_id — BIGINT — Foreign key → vendor.id — NOT NULL
  • product_code — VARCHAR(64) — NOT NULL
  • product_name — VARCHAR(256) — NOT NULL
  • unit_price — BIGINT — NOT NULL
  • moq — INT
  • lead_time_days — INT
  • contract_start — DATE
  • contract_end — DATE
  • status — VARCHAR(16) — NOT NULL
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

warehouse_transfer_header

  • id — BIGINT — Primary key — NOT NULL
  • transfer_no — VARCHAR(50) — NOT NULL
  • from_warehouse_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • to_warehouse_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • requested_by — VARCHAR(100)
  • requested_at — DATETIME — NOT NULL
  • reason_summary — VARCHAR(500)
  • memo_summary — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

warehouse_transfer_item

  • id — BIGINT — Primary key — NOT NULL
  • header_id — BIGINT — Foreign key → warehouse_transfer_header.id — NOT NULL
  • sku_id — BIGINT — Foreign key → product_sku.id — NOT NULL
  • quantity — INT — NOT NULL
  • reason — VARCHAR(500)
  • memo — VARCHAR(500)
  • from_available_before — INT — NOT NULL
  • to_available_before — INT — NOT NULL
  • from_available_after — INT
  • to_available_after — INT
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

wh_inbound_header

  • id — BIGINT — Primary key — NOT NULL
  • inbound_code — VARCHAR(50) — NOT NULL
  • inbound_type — VARCHAR(30) — NOT NULL
  • source_ref_no — VARCHAR(50) — NOT NULL
  • source_ref_id — BIGINT
  • warehouse_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • warehouse_name — VARCHAR(128) — NOT NULL
  • source_name — VARCHAR(200) — NOT NULL
  • total_quantity — BIGINT — NOT NULL
  • total_amount — BIGINT
  • completed_at — DATETIME
  • confirmed_by_member_id — VARCHAR(50)
  • confirmed_by_name — VARCHAR(128)
  • memo — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

wh_inbound_item

  • id — BIGINT — Primary key — NOT NULL
  • inbound_header_id — BIGINT — Foreign key → wh_inbound_header.id — NOT NULL
  • product_code — VARCHAR(64) — NOT NULL
  • product_name — VARCHAR(256) — NOT NULL
  • sku_code — VARCHAR(32) — NOT NULL
  • color — VARCHAR(32)
  • size — VARCHAR(16)
  • quantity — INT — NOT NULL
  • unit_price — BIGINT
  • subtotal — BIGINT
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

wh_outbound_header

  • id — BIGINT — Primary key — NOT NULL
  • outbound_no — VARCHAR(50) — NOT NULL
  • source_type — VARCHAR(30) — NOT NULL
  • source_ref_no — VARCHAR(50) — NOT NULL
  • source_ref_id — BIGINT
  • warehouse_id — BIGINT — Foreign key → infrastructure.id — NOT NULL
  • destination_type — VARCHAR(30) — NOT NULL
  • destination_id — BIGINT — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • total_requested_quantity — INT — NOT NULL
  • requested_at — DATETIME — NOT NULL
  • confirmed_at — DATETIME
  • departed_at — DATETIME
  • arrived_at — DATETIME
  • requested_by_member_id — VARCHAR(50)
  • requested_by_name — VARCHAR(100)
  • memo — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

wh_outbound_item

  • id — BIGINT — Primary key — NOT NULL
  • outbound_header_id — BIGINT — Foreign key → wh_outbound_header.id — NOT NULL
  • source_line_ref_id — BIGINT
  • sku_id — BIGINT — Foreign key → product_sku.id — NOT NULL
  • sku_code — VARCHAR(50) — NOT NULL
  • product_code — VARCHAR(50) — NOT NULL
  • product_name — VARCHAR(200) — NOT NULL
  • main_category — VARCHAR(100)
  • sub_category — VARCHAR(100)
  • color — VARCHAR(50)
  • size — VARCHAR(50)
  • unit_price — BIGINT
  • requested_quantity — INT — NOT NULL
  • memo — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL

wh_outbound_status_history

  • id — BIGINT — Primary key — NOT NULL
  • outbound_header_id — BIGINT — Foreign key → wh_outbound_header.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • changed_at — DATETIME — NOT NULL
  • changed_by_member_id — VARCHAR(50)
  • changed_by_name — VARCHAR(100)
  • reason — VARCHAR(500)
  • create_date — DATETIME — NOT NULL
  • update_date — DATETIME — NOT NULL