deps erd(modified)
Tables (24)
account
- account_seq — INT — Primary key — NOT NULL
- id — VARCHAR(20) — NOT NULL
- password — VARCHAR(20) — NOT NULL
- name — VARCHAR(10) — NOT NULL
- account_department — VARCHAR(20)
- account_rank — VARCHAR(20)
- account_email — VARCHAR(100)
- accout_phone_number — INT
- use_yn — VARCHAR(1)
- del_yn — VARCHAR(1)
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
auth_menu
- authrt_menu_seq — INT — Primary key — NOT NULL
- authrt_seq — INT — NOT NULL
- menu_seq2 — INT — NOT NULL
- active_yn — VARCHAR(1)
- use_yn — VARCHAR(1)
- created_by — VARCHAR(20)
- creation_date — TIMESTAMP
- updated_by — VARCHAR(20)
- update_date — TIMESTAMP
authority
- authrt_seq — INT — Primary key — NOT NULL
- authrt_cd — VARCHAR(100) — NOT NULL
- authrt_nm — VARCHAR(100) — NOT NULL
- authrt_expln — VARCHAR(255)
- sort_no — INT
- use_yn — VARCHAR(1)
- creation_date — TIMESTAMP — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
code
- code_seq — INT — Primary key — NOT NULL
- lookup_type — VARCHAR(150) — NOT NULL
- lookup_name — VARCHAR(250) — NOT NULL
- lookup_code — VARCHAR(10) — NOT NULL
- meaning — VARCHAR(20) — NOT NULL
- attribute1 — VARCHAR(100)
- attribute2 — VARCHAR(100)
- attribute3 — VARCHAR(100)
- attribute4 — VARCHAR(100)
- attribute5 — VARCHAR(100)
- attribute6 — VARCHAR(100)
- attribute7 — VARCHAR(100)
- attribute8 — VARCHAR(100)
- attribute9 — VARCHAR(100)
- attribute10 — VARCHAR(100)
- description — VARCHAR(4000)
- del_yn — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
company
- company_seq — INT — Primary key — NOT NULL
- company_type — ENUM("매출처","매입처) — NOT NULL
- company_registration_number — INT — NOT NULL
- company_name — VARCHAR(250) — NOT NULL
- ceo_name — VARCHAR(10)
- ceo_phone_number — INT
- company_address — VARCHAR(250)
- address_detail — VARCHAR(250)
- description — VARCHAR(4000)
- is_active — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
inspection_certificate
- certificate_seq — INT — Primary key — NOT NULL
- order_items_incoming_seq — INT — NOT NULL
- paint_method — ENUM("분체","액체") — NOT NULL
- thickness_layer1 — FLOAT — NOT NULL
- thickness_layer2 — FLOAT — NOT NULL
- thickness_layer3 — FLOAT — NOT NULL
- thickness_layer4 — FLOAT — NOT NULL
- routing_standard — VARCHAR(255)
- paint_used_1 — VARCHAR(255)
- paint_used_2 — VARCHAR(255)
- drying_time — VARCHAR(255)
- standard_thickness_layer_1 — VARCHAR(255)
- standard_thickness_layer_2 — VARCHAR(255)
- created_by — VARCHAR(255) — NOT NULL
- creation_date — VARCHAR(255) — NOT NULL
- updated_by — VARCHAR(255) — NOT NULL
- update_date — VARCHAR(255) — NOT NULL
internal_information
- internal_information_seq — INT — Primary key — NOT NULL
- internal_brn — VARCHAR(255)
- internal_company_name — VARCHAR(255)
- internal_ceo_name — VARCHAR(255)
- internal_ceo_phone_number — VARCHAR(255)
- internal_phone_number — VARCHAR(255)
- internal_fax_number — VARCHAR(255)
- internal_email — VARCHAR(255)
- inspector — VARCHAR(255)
- verifier — VARCHAR(255)
- internal_company_address — VARCHAR(255)
- internal_address_detail — VARCHAR(255)
- description — VARCHAR(255)
- created_by — VARCHAR(255)
- creation_date — VARCHAR(255)
- updated_by — VARCHAR(255)
- update_date — VARCHAR(255)
manager
- manager_seq — INT — Primary key — NOT NULL
- company_seq — INT — NOT NULL
- manager_name — VARCHAR(20) — NOT NULL
- manager_email — VARCHAR(100)
- manager_phone_number — INT
- manager_department — VARCHAR(20)
- manager_rank — VARCHAR(20)
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
menu
- menu_seq — INT — Primary key — NOT NULL
- up_menu_seq — INT
- srvc_seq — INT
- sort_no — INT
- menu_nm — VARCHAR(100)
- menu_url — VARCHAR(255)
- menu_type_enu — VARCHAR(20)
- main_display_yn — VARCHAR(1)
- display_yn — VARCHAR(1)
- use_yn — VARCHAR(1)
- remark — VARCHAR(255)
- created_by — VARCHAR(20)
- creation_date — TIMESTAMP
- updated_by — VARCHAR(20)
- update_date — TIMESTAMP
orderItems_incoming
- incoming_seq — INT — Primary key — NOT NULL
- order_items_seq — INT — NOT NULL
- item_order — INT
- lot_no — VARCHAR(150) — NOT NULL — 예) LOT-yyyymmdd-001
- barcode_no — VARCHAR(150) — NOT NULL — 예) LOT-yyyymmdd-001-01
- incoming_quantity — FLOAT
- incoming_date — TIMESTAMP — NOT NULL
- process_status — VARCHAR(20)
- del_yn — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- Fieldcreation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
orderItems_outgoing
- outgoing_seq — INT — Primary key — NOT NULL
- order_items_incoming_seq — INT — NOT NULL
- outgoing_no — VARCHAR(150) — NOT NULL — 예) OUT-yyyymmdd-001
- outgoing_quantity — INT — NOT NULL
- outgoing_date — TIMESTAMP — NOT NULL
- is_active — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
order_item_routing
- routing_seq — INT — Primary key — NOT NULL
- order_items_seq — INT — NOT NULL
- code_seq — INT — NOT NULL
- process_details — VARCHAR(100)
- routing_standard — VARCHAR(100)
- paint_used — VARCHAR(100)
- mixing_ratio — VARCHAR(50)
- drying_time — VARCHAR(50)
- drying_temperature — VARCHAR(50)
- coating_thickness — VARCHAR(50)
- description — VARCHAR(4000)
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
order_items
- item_seq — INT — Primary key — NOT NULL
- company_seq — INT — NOT NULL
- item_name — VARCHAR(250) — NOT NULL
- origin_item_code — VARCHAR(150)
- origin_item_name — VARCHAR(250)
- paint_color — VARCHAR(250)
- painting_method — ENUM("분체","액체") — NOT NULL
- is_defense — ENUM("일반","방산","자동차","조선") — NOT NULL
- item_price — FLOAT
- description — VARCHAR(4000)
- revision — INT — NOT NULL
- is_active — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
order_items_image
- file_seq — INT — Primary key — NOT NULL
- order_items_seq — INT — NOT NULL
- internal_information_seq — INT — NOT NULL
- cli_file_nm — VARCHAR(255)
- file_ext — VARCHAR(10)
- file_size — INT
- svr_file_nm — VARCHAR(255)
- svr_file_path — VARCHAR(255)
- is_main_image — TINYINT(1)
- created_by — VARCHAR(20) — NOT NULL — default:0
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
order_items_inout_history
- inout_history_seq — INT — Primary key — NOT NULL
- order_items_incoming_seq — INT
- order_items_outgoing_seq — INT
- before_amount — FLOAT
- after_amount — FLOAT
- modify_description — VARCHAR(4000)
- before_date — TIMESTAMP
- after_date — TIMESTAMP
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
order_items_process_progress
- progress_seq — INT — Primary key — NOT NULL
- order_items_incoming_seq — INT — NOT NULL
- routing_seq — INT — NOT NULL
- start_date — TIMESTAMP
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
raw_materials
- raw_material_seq — INT — Primary key — NOT NULL
- raw_material_category_seq — INT — NOT NULL
- raw_material_unit_seq — INT — NOT NULL
- company_seq — INT — NOT NULL
- raw_material_code — VARCHAR(150)
- raw_material_name — VARCHAR(250) — NOT NULL
- raw_material_standard — FLOAT — NOT NULL
- expiration_date — TIMESTAMP
- manufacturing_company — VARCHAR(250)
- is_active — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
- Field — VARCHAR(255)
raw_materials_incoming
- incoming_seq — INT — Primary key — NOT NULL
- raw_materials_seq — INT — NOT NULL
- storage_seq — INT — NOT NULL
- incoming_no — VARCHAR(150) — NOT NULL — 예) MINC-yyyymmdd-001
- incoming_material_standard — FLOAT — NOT NULL
- amount — FLOAT — NOT NULL
- incoming_date — TIMESTAMP — NOT NULL
- MFD — TIMESTAMP
- del_yn — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
raw_materials_inout_history
- inout_history_seq — INT — Primary key — NOT NULL
- raw_materials_incoming_seq — INT
- raw_materials_outgoing_seq — INT
- before_amount — FLOAT
- after_amount — FLOAT
- before_date — TIMESTAMP
- after_date — TIMESTAMP
- modify_description — VARCHAR(4000)
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
raw_materials_outgoing
- outgoing_seq — INT — Primary key — NOT NULL
- raw_materials_stock_seq — VARCHAR(255) — NOT NULL
- outgoing_amount — FLOAT — NOT NULL
- outgoing_date — TIMESTAMP — NOT NULL
- outgoing_no — VARCHAR(150) — NOT NULL
- del_yn — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
raw_materials_stock
- stock_seq — INT — Primary key — NOT NULL
- raw_material_seq — INT — NOT NULL
- storage_seq — INT — NOT NULL
- raw_material_stock_quantity — FLOAT — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
role_Resource
- role_resource_seq — INT — Primary key — NOT NULL
- user_seq — INT — NOT NULL
- authrt_seq — INT — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL
srvc
- srvc_seq — INT — Primary key — NOT NULL
- srvc_nm — VARCHAR(50)
- srvc_expln — VARCHAR(255)
- srvc_path — VARCHAR(100)
- srvc_type_enu — VARCHAR(20)
- use_yn — VARCHAR(1)
- created_by — VARCHAR(20)
- creation_date — TIMESTAMP
- updated_by — VARCHAR(20)
- update_date — TIMESTAMP
storage
- storage_seq — INT — Primary key — NOT NULL
- storage_code — VARCHAR(150) — NOT NULL
- storage_name — VARCHAR(250) — NOT NULL
- description — varchar(4000)
- del_yn — VARCHAR(1) — NOT NULL
- created_by — VARCHAR(20) — NOT NULL
- creation_date — TIMESTAMP — NOT NULL
- updated_by — VARCHAR(20) — NOT NULL
- update_date — TIMESTAMP — NOT NULL