MES

Tables (46)

attachment

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • attachment_type — varchar(255) — 엔티티 타입
  • file_name — varchar(255) — 파일명
  • file_path — varchar(255) — 파일 경로
  • file_size — bigint(20) — NOT NULL — 파일 사이즈
  • file_type — varchar(255) — 파일 타입
  • base_entity_id — bigint(20)

authority

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • authority_code_category_type — varchar(255)
  • authority_code_type — varchar(255)

company

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 회사코드
  • title — varchar(255) — 회사명

cooperator

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 협력사코드
  • title — varchar(255) — 협력사명

customer

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 고객사코드
  • title — varchar(255) — 고객명

defect_code

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 결함 코드
  • title — varchar(255) — 결함명
  • defect_code_category_id — bigint(20) — Foreign key → defect_code_category.id

defect_code_category

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 카테고리 이름

department

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 부서 코드
  • title — varchar(255) — 부서명
  • company_id — bigint(20) — Foreign key → company.id
  • parent_id — bigint(20) — Foreign key → department.id

employee

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 사번
  • email — varchar(255) — 이메일
  • phone — varchar(255) — 전화번호
  • position — varchar(255) — 직급
  • title — varchar(255) — 직원명
  • department_id — bigint(20) — Foreign key → department.id

employee_production_plan_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • employee_id — bigint(20) — Foreign key → employee.id
  • production_order_id — bigint(20) — Foreign key → production_order.id

employee_role_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • employee_id — bigint(20) — Foreign key → employee.id
  • role_id — bigint(20) — Foreign key → role.id

equipment

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 장비 코드
  • title — varchar(255) — 장비명

equipment_record

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • equipment_id — bigint(20) — Foreign key → equipment.id
  • off_code_id — bigint(20) — Foreign key → off_code.id

hibernate_sequence

  • next_val — bigint(20)

inventory

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • last — bit(1) — 마지막 순서 확인
  • quantity — int(11) — 수량
  • routing_number — int(11) — 순서
  • part_template_id — bigint(20) — Foreign key → part_template.id

inventory_record

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • arrival — varchar(255) — 도착지
  • departure — varchar(255) — 출발지
  • progress_result_type — varchar(255)
  • quantity — int(11) — 수량
  • inventory_storage_link_id — bigint(20) — Foreign key → inventory_storage_link.id
  • progress_result_id — bigint(20)

inventory_storage_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • quantity — int(11) — 수량
  • inventory_id — bigint(20) — Foreign key → inventory.id
  • storage_id — bigint(20) — Foreign key → storage.id

item_category

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 카테고리 코드
  • title — varchar(255) — 카테고리 이름

item_part_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • quantity — int(11) — 수량
  • item_template_id — bigint(20) — Foreign key → item_template.id
  • part_template_id — bigint(20) — Foreign key → part_template.id

item_template

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 템플릿 코드
  • title — varchar(255) — 템플릿명
  • item_category_id — bigint(20) — Foreign key → item_category.id

note

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • note — varchar(255) — 비고
  • base_entity_id — bigint(20)

off_code

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 결함 코드
  • title — varchar(255) — 결함명
  • off_code_category_id — bigint(20) — Foreign key → off_code_category.id

off_code_category

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 카테고리 이름

outsourcing_order

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • completed_quantity — int(11) — 성공 수량
  • production_order_status_type — varchar(255) — 작업 상태
  • total_quantity — int(11) — 목표 수량
  • work_order — int(11) — 작업 순번
  • routing_id — bigint(20) — Foreign key → routing.id

outsourcing_result

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • quantity — int(11)
  • production_result_type — varchar(255) — 생산 상태
  • defect_code_id — bigint(20) — Foreign key → defect_code.id
  • outsourcing_order_id — bigint(20) — Foreign key → outsourcing_order.id

part_template

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 템플릿 코드
  • part_template_type — varchar(255) — 파트 타입
  • title — varchar(255) — 템플릿명
  • process_template_id — bigint(20) — Foreign key → process_template.id

part_template_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • quantity — int(11) — 수량
  • child_template_id — bigint(20) — Foreign key → part_template.id
  • parent_template_id — bigint(20) — Foreign key → part_template.id

part_template_purchase_order_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • part_template_id — bigint(20) — Foreign key → part_template.id
  • purchase_order_id — bigint(20) — Foreign key → purchase_order.id

plant

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 작업장코드
  • title — varchar(255) — 작업장명
  • company_id — bigint(20) — Foreign key → company.id

process

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 공정 코드
  • title — varchar(255) — 공정명
  • plant_id — bigint(20) — Foreign key → plant.id

process_equipment_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • equipment_id — bigint(20) — Foreign key → equipment.id
  • process_id — bigint(20) — Foreign key → process.id

process_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • routing_number — int(11)
  • process_id — bigint(20) — Foreign key → process.id
  • process_template_id — bigint(20) — Foreign key → process_template.id

process_template

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 템플릿 코드
  • title — varchar(255) — 템플릿 명

production_order

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • completed_quantity — int(11) — 성공 수량
  • production_order_status_type — varchar(255) — 작업 상태
  • total_quantity — int(11) — 목표 수량
  • work_order — int(11) — 작업 순번
  • routing_id — bigint(20) — Foreign key → routing.id

production_result

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • quantity — int(11)
  • production_result_type — varchar(255) — 생산 상태
  • defect_code_id — bigint(20) — Foreign key → defect_code.id
  • production_order_id — bigint(20) — Foreign key → production_order.id

project

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 프로젝트명
  • company_id — bigint(20) — Foreign key → company.id

project_item_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • quantity — int(11) — 수량
  • item_template_id — bigint(20) — Foreign key → item_template.id
  • project_id — bigint(20) — Foreign key → project.id

property

  • id — bigint(20) — Primary key — NOT NULL
  • value — varchar(255)
  • entity_id — bigint(20)
  • property_def_id — bigint(20) — Foreign key → property_def.id

property_def

  • id — bigint(20) — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • data_type — varchar(255)
  • description — varchar(255)
  • entity_type — varchar(255)
  • options — varchar(255)
  • title — varchar(255)

purchase

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • quantity — int(11) — 수량
  • item_template_id — bigint(20) — Foreign key → item_template.id
  • part_template_id — bigint(20) — Foreign key → part_template.id
  • project_id — bigint(20) — Foreign key → project.id

purchase_order

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • completed_quantity — int(11) — 성공 수량
  • purchase_type — varchar(255) — 구매 타입
  • total_quantity — int(11) — 목표 수량

purchase_result

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • quantity — int(11)
  • purchase_type — varchar(255) — 구매 상태
  • purchase_order_id — bigint(20) — Foreign key → purchase_order.id

role

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 권한명

role_authority_link

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • authority_id — bigint(20) — Foreign key → authority.id
  • role_id — bigint(20) — Foreign key → role.id

routing

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • completed_quantity — int(11) — 완료 수량
  • defect_quantity — int(11) — 불량 수량
  • routing_number — int(11) — 공정 순서
  • total_quantity — int(11) — 목표 수량
  • item_template_id — bigint(20) — Foreign key → item_template.id
  • parent_id — bigint(20) — Foreign key → routing.id
  • part_template_id — bigint(20) — Foreign key → part_template.id
  • prev_id — bigint(20) — Foreign key → routing.id
  • process_id — bigint(20) — Foreign key → process.id
  • project_id — bigint(20) — Foreign key → project.id

storage

  • id — bigint(20) — Primary key — NOT NULL
  • date_of_creation — datetime(6)
  • date_of_modification — datetime(6)
  • active — bit(1) — NOT NULL
  • code — varchar(255) — 창고 코드
  • title — varchar(255) — 창고명