erd final
Tables (19)
b_bizarea
- id — int(11) — Primary key — NOT NULL
- co_cd — int(11) — Foreign key → b_co.id — NOT NULL
- bizarea_cd — varchar(50)
- co_id — int(11)
- bizarea_nm — varchar(50)
- bizarea_shnm — varchar(20)
- biz_no — varchar(50)
- biz_rpr — varchar(50)
- str_dt — timestamp
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- unitcur_id — int(11) — cur, cn
- unitcn_id — int(11) — cur, cn
- insrt_id — int(11)
- updt_id — int(11)
b_bizpartner
- id — int(11) — Primary key — NOT NULL
- co_cd — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
- unitcn_id — int(11) — Foreign key → b_bizunit.id — NOT NULL
- bizpartner_cd — varchar(50)
- bizpartner_type — varchar(20)
- biz_nm — varchar(50)
- bizpartner_nm — varchar(50)
- unitcur_id — int(11)
- bizpartner_stat — varchar(20)
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- unit_id — int(11)
- insrt_id — int(11)
- updt_id — int(11)
b_bizunit
- id — int(11) — Primary key — NOT NULL
- bizunit_cd — varchar(50) — NOT NULL
- bizunit_nm — varchar(50)
- bizunit_rmrk — varchar(50)
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- insrt_id — int(11)
- updt_id — int(11)
b_bom
- id — int(11) — Primary key — NOT NULL
- item_cd — int(11) — Foreign key → b_item.id — NOT NULL
- factory_cd (factory_cd2) — varchar(20) — Foreign key → b_item.factory_cd — NOT NULL
- item_id — int(11)
- bom_type — varchar(20)
- top_id — int(11)
- parent_id — int(11)
- bom_order — int(11)
- bom_level — int(11)
- leaf_fg — varchar(10)
- moitem_base — float
- jaitem_base — float
- unit_product — varchar(20)
- free_fg — varchar(10)
- loss_product — float
- demand_amt — float
- start_dt — varchar(8)
- end_dt — varchar(8)
- register_dt — datetime
- usage_fg — char(1)
- updt_id — int(11)
- insrt_id — int(11)
b_co
- id — int(11) — Primary key — NOT NULL
- co_cd — varchar(50) — Primary key — NOT NULL
- co_nm — varchar(50)
- co_shnm — varchar(50)
- co_rpr — varchar(20)
- co_type — varchar(20)
- co_div — varchar(20)
- co_estdt — timestamp
- co_strdt — timestamp
- unitcn_id — int(11)
- unitcur_id — int(11)
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- insrt_id — int(11)
- updt_id — int(11)
b_costeleaccnt
- id — int(11) — Primary key — NOT NULL
- placcnt_cd — varchar(50) — Primary key — NOT NULL — 손익원가코드
- accnt_cd — varchar(50) — Primary key — NOT NULL
- placcnt_nm — varchar(50) — 손익원가명
- fv_div — varchar(1) — 고정변동유무
- accnt_nm — varchar(50) — 계정이름
- costeleaccnt_rmrk — varchar(255) — 비고
- usage_fg — char(1)
b_factory
- id — int(11) — Primary key — NOT NULL
- factory_cd — varchar(20) — Primary key — NOT NULL
- factory_nm — varchar(50)
- factory_rmrk — varchar(50)
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- insrt_id — int(11)
- updt_id — int(11)
b_item
- id — int(11) — Primary key — NOT NULL
- item_cd — varchar(50) — Primary key — NOT NULL
- factory_cd (factory_cd2) — varchar(20) — Foreign key → b_factory.factory_cd — NOT NULL
- itemaccnt_id — int(11) — Foreign key → b_itemaccnt.id — NOT NULL
- itemgrp_id (id2itemgrp_id) — int(11) — Foreign key → b_itemgrp.id — NOT NULL
- unit_id — int(11)
- item_nm — varchar(50)
- item_spec — varchar(50)
- phantom_div — char(1) — 1 or 0 활성화
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- bom_fg — varchar(8)
- insrt_id — int(11)
- updt_id — int(11)
b_itemaccnt
- id — int(11) — Primary key — NOT NULL
- itemaccnt_cd — varchar(50) — NOT NULL
- itemaccnt_nm — varchar(50)
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- insrt_id — int(11)
- updt_id — int(11)
b_itemgrp
- id — int(11) — Primary key — NOT NULL
- itemgrp_cd — varchar(50)
- itemgrp_nm — varchar(50)
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- insrt_id — int(11)
- updt_id — int(11)
b_version
- id — int(11) — Primary key — NOT NULL
- version_cd — varchar(50) — Primary key — NOT NULL
- version_dt — varchar(8)
- insrt_id — int(11)
b_workcenter
- id — int(11) — Primary key — NOT NULL
- workcenter_cd — varchar(50) — Primary key — NOT NULL
- cstctr_id — int(11) — Foreign key → cb_cost_center.id — NOT NULL
- workcenter_nm — varchar(50)
- insrt_dt — timestamp
- updt_dt — timestamp
- usage_fg — char(1)
- insrt_id — int(11)
- updt_id — int(11)
ca_prediction
- id — int(11) — Primary key — NOT NULL — 모델생성시 자동생성
- costbill_id — int(11) — Foreign key → cc_costbill.id — NOT NULL
- id (id2) — int(11) — Foreign key → cc_costbill.ipm_id — NOT NULL — ID (입력x)
- id (id22) — int(11) — Foreign key → cc_costbill.mc_id — NOT NULL — ID (입력x)
- id (id23) — int(11) — Foreign key → cc_costbill.materialcost_id — NOT NULL — ID (입력x)
- id (id24) — int(11) — Foreign key → cc_costbill.pcp_id — NOT NULL — ID (입력x)
- prediction1_cost — int(255) — 첫째 달 예측 매출액
- prediction2_cost — int(255) — 둘째 달 예측 매출액
- prediction3_cost — int(255) — 셋째 달 예측 매출액
- prediction4_cost — int(255)
- periodym1_cd — int(6) — 첫째달
- periodym2_cd — int(6) — 둘째달
- periodym3_cd — int(6) — 셋째달
- periodym4_cd — int(6)
- variableperc_cost — float — 변동비%
- fixedperc_cost — float — 고정비%
- materialperc_cost — float — 재료비%
- prediction1_max — int(255)
- prediction2_max — int(255)
- prediction3_max — int(255)
- prediction4_max — int(255)
- prediction1_min — int(255)
- prediction2_min — int(255)
- prediction3_min — int(255)
- prediction4_min — int(255)
cb_cost_center
- id — int(11) — Primary key — NOT NULL
- cstctr_cd — varchar(50) — Primary key — NOT NULL
- bizunit_id — int(11) — Foreign key → b_bizunit.id — NOT NULL
- bizarea_id — int(11) — Foreign key → b_bizarea.id — NOT NULL
- co_cd — int(11) — Foreign key → b_bizarea.co_cd — NOT NULL
- factory_cd — varchar(20) — Foreign key → b_factory.factory_cd — NOT NULL
- cstctr_nm — varchar(50)
- cstctr_type — varchar(50)
- cstctr_dir_div — varchar(50)
- updt_dt — timestamp
- insrt_dt — datetime
- usage_fg — char(1)
- insrt_id — int(11)
- updt_id — int(11)
cc_costbill
- id — int(11) — Primary key — NOT NULL
- ipm_id — int(11) — Foreign key → cc_itempermanucost_if.id — NOT NULL — ID (입력x)
- mc_id — int(11) — Foreign key → cc_manucost_if.id — NOT NULL — ID (입력x)
- materialcost_id — int(11) — Foreign key → cc_materialcost_if.id — NOT NULL — ID (입력x)
- pcp_id — int(11) — Foreign key → cc_productcostpayment_if.id — NOT NULL — ID (입력x)
- bi_brm — int(255)
- ra_rm — int(255)
- ei_erm — int(255)
- ei_elc — int(255)
- ei_eoh — int(255)
- ic_dlfc — int(255)
- ic_ohdfe — int(255)
- ic_ohdfd — int(255)
- ic_dlvc — int(255)
- ic_ohdvc — int(255)
- ic_idlc — int(255)
- ic_idohc — int(255)
- proq — int(255)
- proamt_unit — int(255)
- ic_arm — int(255)
- uc_srw — int(255)
- uc_dlc — int(255)
- uc_idlc — int(255)
- uc_idohc — int(255)
- uc_dohc — int(255)
- currency_usd — float
- interest_rate — float
cc_itempermanucost_if
- id — int(11) — Primary key — NOT NULL — ID (입력x)
- version_cd (version_cd2) — varchar(50) — Foreign key → b_version.version_cd — NOT NULL
- accnt_cd (accnt_cd2) — varchar(50) — Foreign key → b_costeleaccnt.accnt_cd — NOT NULL
- bom_cd — int(11) — Foreign key → b_bom.id — NOT NULL
- co_cd (co_cd2) — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
- ipmc_ym — int(6) — 년월 ex) 200001
- ipmc_cost — int(255) — 금액
cc_manucost_if
- id — int(11) — Primary key — NOT NULL — ID (입력x)
- version_cd (version_cd2) — varchar(50) — Foreign key → b_version.version_cd — NOT NULL
- accnt_cd (accnt_cd2) — varchar(50) — Foreign key → b_costeleaccnt.accnt_cd — NOT NULL
- co_cd (co_cd2) — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
- cstctr_cd (cstctr_cd2) — varchar(50) — Foreign key → cb_cost_center.cstctr_cd — NOT NULL
- periodym_cd — varchar(6) — NOT NULL — 년월 ex) 200001
- manucost_price — int(255) — NOT NULL — 금액
- mngmt_1 — varchar(50) — NOT NULL — 관리항목
cc_materialcost_if
- id — int(11) — Primary key — NOT NULL — ID (입력x)
- version_cd (version_cd2) — varchar(50) — Foreign key → b_version.version_cd — NOT NULL
- accnt_cd (accnt_cd2) — varchar(50) — Foreign key → b_costeleaccnt.accnt_cd — NOT NULL
- co_cd (co_cd2) — varchar(50) — Foreign key → b_co.co_cd — NOT NULL
- factory_cd (factory_cd2) — varchar(20) — Foreign key → b_factory.factory_cd — NOT NULL
- bom_cd — int(11) — Foreign key → b_bom.id — NOT NULL
- workcenter_cd (workcenter_cd2) — varchar(50) — Foreign key → b_workcenter.workcenter_cd — NOT NULL
- periodym_cd — varchar(6) — 년월 ex) 200001
- mc_amount — int(255) — 수량
- mc_price — int(255) — 금액
cc_productcostpayment_if
- id — int(11) — Primary key — NOT NULL — ID (입력x)
- bom_cd — int(11) — Foreign key → b_version.id — NOT NULL
- version_cd (version_cd2) — varchar(50) — Foreign key → b_version.version_cd — NOT NULL
- item_cd — int(11) — Foreign key → b_bom.item_cd — NOT NULL
- factory_cd (factory_cd2) — varchar(20) — Foreign key → b_bom.factory_cd — NOT NULL
- accnt_cd (accnt_cd2) — varchar(50) — Foreign key → b_costeleaccnt.accnt_cd — NOT NULL
- basisicstoc_amt — int(255) — 기초재고수량
- basisicstoc_price — int(255) — 기초재고금액
- productionreceipt_amt — int(255) — 생산입고수량
- productionreceipt_price — int(255) — 생산입고금액
- sell_amt — int(255) — 판매출고수량
- sell_cost — int(255) — 판매출고금액
- loss_amt — int(255) — LOSS출고수량
- loss_cost — int(255) — LOSS출고금액
- development_amt — int(255) — 개발출고수량
- development_cost — int(255) — 개발출고금액
- endingstock_amt — int(255) — 기말재고수량
- endingstock_cost — int(255) — 기말재고금액
- pcp_dt — varchar(6) — 년월 ex) 200001