중앙 시스템 ERD
테이블 (24)
TB_BIZMST (사업장)
- business_key — INT — 기본 키
- business_common_code (common_code) — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- business_code — VARCHAR(13) — NOT NULL
- business_name — VARCHAR(30) — NOT NULL
- business_rep — VARCHAR(5) — NOT NULL
- business_no — VARCHAR(13) — NOT NULL
- business_tel — VARCHAR(13) — NOT NULL
- business_fax — VARCHAR(13)
- business_address — VARCHAR(50) — NOT NULL
TB_BUYIN
- input_key — INT — 기본 키
- input_common_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- business_employee_no — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- input_no — varchar(6) — NOT NULL
- input_consent — tinyint(1)
- input_note — varchar(50)
TB_CUSTMST
- customer_key — INT — 기본 키
- customer_code — VARCHAR(6) — 기본 키 — NOT NULL
- item_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- customer_name — VARCHAR(30) — NOT NULL
- customer_rep — VARCHAR(5) — NOT NULL
- industry — VARCHAR(30) — NOT NULL
- corporate_no — VARCHAR(14) — NOT NULL
- customer_no — VARCHAR(12) — NOT NULL
- customer_tel — VARCHAR(13) — NOT NULL
- customer_fax — VARCHAR(15)
- customer_address — VARCHAR(50) — NOT NULL
- customer_address_details — VARCHAR(50)
- customer_post — VARCHAR(10) — NOT NULL
- customer_active — BOOLEAN
- customer_note — VARCHAR(50)
TB_DEPARTMST (부서)
- department_key — INT — 기본 키
- department_common_code (common_code) — VARCHAR(5) — 외래 키 → TB_BIZMST.business_common_code — NOT NULL
- department_code — VARCHAR(6) — NOT NULL
- department_name — VARCHAR(10) — NOT NULL
- department_tel — VARCHAR(13) — NOT NULL
- department_fax — VARCHAR(13)
- department_active — BOOLEAN — NOT NULL
- department_note — VARCHAR(50)
TB_DISPR (반려)
- disapprove_key — INT — 기본 키
- state_common_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- state_request_key — INT — NOT NULL
- disapprove_employee_no — VARCHAR(9) — NOT NULL
- disapprove_date — DATETIME
- disapprove_note — VARCHAR(50)
TB_EMPMST
- employee_key — INT — 기본 키
- employee_no — VARCHAR(9) — 기본 키 — NOT NULL
- employee_common_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- employee_workplace_code — VARCHAR(6) — NOT NULL
- employee_password — VARCHAR(20)
- employee_name — VARCHAR(5) — NOT NULL
- employee_tel — VARCHAR(13) — NOT NULL
- employee_active — BOOLEAN
- employee_note — VARCHAR(50)
TB_FRNCHSMST
- franchise_key — INT — 기본 키
- franchise_code — VARCHAR(6) — 기본 키 — NOT NULL
- franchise_name — VARCHAR(30) — NOT NULL
- franchise_rep — VARCHAR(5) — NOT NULL
- franchise_no — VARCHAR(12) — NOT NULL
- franchise_tel — VARCHAR(13) — NOT NULL
- franchise_address — VARCHAR(50) — NOT NULL
- franchise_address_detail — VARCHAR(20)
- franchise_post — VARCHAR(10) — NOT NULL
- franchise_state — VARCHAR(10) — NOT NULL
- franchise_city — VARCHAR(10) — NOT NULL
- franchise_active — BOOLEAN
- franchise_note — VARCHAR(50)
TB_INOUT_HIS (물품입출내역)
- inout_history_key — INT — 기본 키
- serial_no — VARCHAR(6) — 외래 키 → TB_ITEMSUB.serial_no — NOT NULL
- warehouse_code — VARCHAR(6) — 외래 키 → TB_WHMST.warehouse_code — NOT NULL
- inout_common_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- customer_employee_no — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- franchise_code — VARCHAR(6) — 외래 키 → TB_FRNCHSMST.franchise_code — NOT NULL
- location_key — INT — 외래 키 → TB_LOCMST.location_key
- business_employee_no — VARCHAR(9) — NOT NULL
- inout_history_date — DATETIME
- inout_history_note — VARCHAR(50)
- inout_no — VARCHAR(6)
TB_INSTK
- input_stock_key — int — 기본 키
- input_key — INT — 외래 키 → TB_BUYIN.input_key
- customer_employee_no — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- input_stock_date — DATE
- input_stock_note — VARCHAR(50)
TB_INSTK_SUB
- input_stock_sub_key — INT — 기본 키
- input_key — INT — 외래 키 → TB_BUYIN.input_key
- location_key — INT — 외래 키 → TB_LOCMST.location_key
- serial_no — VARCHAR(6) — NOT NULL
TB_INSTL_APPR
- install_approve_key — INT — 기본 키
- install_request_key (install_request_key2) — INT — 외래 키 → TB_INSTL_REQ.install_request_key
- customer_employee_no — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- customer_installer_no — VARCHAR(9) — NOT NULL
- output_no — VARCHAR(6) — NOT NULL
- install_schedule_date — DATE
- install_approve_date — DATETIME
- install_approve_note — VARCHAR(50)
- install_approve_consent — BOOLEAN
TB_INSTL_REQ
- install_request_key — INT — 기본 키
- item_common_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- franchise_code — VARCHAR(6) — 외래 키 → TB_FRNCHSMST.franchise_code — NOT NULL
- business_employee_no — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- customer_code — VARCHAR(6) — 외래 키 → TB_CUSTMST.customer_code — NOT NULL
- install_request_amount — INT — NOT NULL
- install_request_date — DATETIME
- install_request_consent — BOOLEAN
- install_request_note — VARCHAR(50)
TB_INSTL_SUB
- install_sub_key — INT — 기본 키
- serial_no — VARCHAR(6) — 외래 키 → TB_ITEMSUB.serial_no — NOT NULL
- output_no — VARCHAR(6) — NOT NULL
TB_ITEMMST
- item_key — INT — 기본 키
- employee_workplace_code — VARCHAR(6) — 외래 키 → TB_CUSTMST.customer_code — NOT NULL
- input_price — INT — NOT NULL
- output_price — INT — NOT NULL
- size — VARCHAR(20)
- unit — VARCHAR(10)
- item_active — BOOLEAN
- item_note — VARCHAR(50)
TB_ITEMSUB
- item_sub_key — INT — 기본 키
- serial_no — VARCHAR(6) — 기본 키 — NOT NULL
- item_common_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- item_sub_note — VARCHAR(50)
- current_common_code — VARCHAR(5) — NOT NULL
TB_LOCMST
- location_key — INT — 기본 키
- warehouse_code (warehouse_code2) — VARCHAR(6) — 외래 키 → TB_WHMST.warehouse_code — NOT NULL
- warehouse_code — VARCHAR(6) — NOT NULL
- row — VARCHAR(2) — NOT NULL
- col — VARCHAR(2) — NOT NULL
- shelf — INT — NOT NULL
- located — BOOLEAN
- location_active — BOOLEAN
- location_note — VARCHAR(50)
TB_PURCH_APPR
- purchase_approve_key — INT — 기본 키
- purchase_request_key — INT — 외래 키 → TB_PURCH_REQ.purchase_request_key
- customer_employee_no — VARCHAR(9) — 외래 키 → TB_PURCH_REQ.employee_no — NOT NULL
- warehouse_code — VARCHAR(6) — 외래 키 → TB_WHMST.warehouse_code — NOT NULL
- purchase_no — VARCHAR(6) — NOT NULL
- purchase_approve_date — TIMESTAMP
- purchase_approve_note — VARCHAR(50)
TB_PURCH_REQ
- purchase_request_key — INT — 기본 키
- employee_no — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- item_common_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- customer_code — VARCHAR(6) — 외래 키 → TB_CUSTMST.customer_code — NOT NULL
- amount — INT — NOT NULL
- purchase_request_date — TIMESTAMP
- purchase_consent — BOOLEAN
- purchase_request_note — VARCHAR(50)
TB_RTN_APPR
- return_approve_key — INT — 기본 키
- return_request_key — INT — 외래 키 → TB_RTN_REQ.return_request_key
- business_employee_no — VARCHAR(9) — 외래 키 → TB_RTN_REQ.business_employee_no — NOT NULL
- employee_no (employee_no2) — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- customer_configurer_no — VARCHAR(9) — NOT NULL
- customer_employee_no — VARCHAR(9) — NOT NULL
- return_no — VARCHAR(6) — NOT NULL
- return_approve_date — DATETIME
- return_date — DATE
- return_approve_note — VARCHAR(50)
TB_RTN_REQ
- return_request_key — INT — 기본 키
- serial_no — VARCHAR(6) — 외래 키 → TB_ITEMSUB.serial_no — NOT NULL
- franchise_code — VARCHAR(6) — 외래 키 → TB_FRNCHSMST.franchise_code — NOT NULL
- business_employee_no — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- customer_code — VARCHAR(6) — 외래 키 → TB_CUSTMST.customer_code — NOT NULL
- return_request_date — DATETIME
- return_consent — BOOLEAN
- return_request_note — VARCHAR(50)
TB_STKTK (실사)
- stocktaking_key — INT — 기본 키
- item_code — VARCHAR(5) — 외래 키 → TB_SYSCOMM.common_code — NOT NULL
- warehouse_code — VARCHAR(6) — 외래 키 → TB_WHMST.warehouse_code — NOT NULL
- customer_employee_no — VARCHAR(9) — 외래 키 → TB_EMPMST.employee_no — NOT NULL
- count_current — INT
- count_configuration — INT
- count_difference — INT
- stocktaking_type — BOOLEAN — NOT NULL
- stocktaking_date — DATETIME
TB_SYSCOMM (공통코드)
- common_code_key — INT — 기본 키
- common_code — VARCHAR(5) — 기본 키 — NOT NULL
- common_code_type — VARCHAR(10) — NOT NULL
- common_code_name — VARCHAR(20) — NOT NULL
- common_code_active — BOOLEAN — NOT NULL
- common_code_note — VARCHAR(50)
TB_WHMST
- warehouse_key — INT — 기본 키
- warehouse_code — VARCHAR(6) — 기본 키 — NOT NULL
- customer_code (customer_code2) — VARCHAR(6) — 외래 키 → TB_CUSTMST.customer_code — NOT NULL
- customer_employee_no — VARCHAR(9) — NOT NULL
- warehouse_name — VARCHAR(30) — NOT NULL
- warehouse_tel — VARCHAR(13) — NOT NULL
- warehouse_address — VARCHAR(50) — NOT NULL
- warehouse_address_detail — VARCHAR(20)
- warehouse_post — VARCHAR(10) — NOT NULL
- warehouse_state — VARCHAR(10) — NOT NULL
- warehouse_city — VARCHAR(10) — NOT NULL
- warehouse_active — BOOLEAN
- warehouse_note — VARCHAR(50)
V_ITEM_CRNT (재고현황)
- common_code — VARCHAR(5)
- warehouse_code (Field2)
- common_code_name (Field3)
- warehouse_name (Field4)
- warehouse_city (Field5)
- warehouse_address (Field6)
- warehouse_address_detail (Field7)
- customer_name (Field8)
- inout_history_date (Field9)
- count (Field10)