자산관리수정중

테이블 (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)