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