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