mes

Tables (29)

attachment

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

company

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 회사명

department

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 부서명
  • company_id — bigint — Foreign key → company.id
  • parent_id — bigint — Foreign key → department.id

employee

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • date_of_birth — varchar(255) — 생년월일
  • email — varchar(255) — 이메일
  • phone — varchar(255) — 전화번호
  • position — varchar(255) — 직급
  • title — varchar(255) — 직원명
  • department_id — bigint — Foreign key → department.id

employee_production_plan_link

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

employee_role_link

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

equipment

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

equipment_link

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

hibernate_sequence

  • next_val — bigint

inventory

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

inventory_record

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • quantity — int — 수량
  • inventory_id — bigint — Foreign key → inventory.id

item_category

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

item_part_link

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

item_template

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 템플릿 명
  • item_category_id — bigint — Foreign key → item_category.id

note

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • note — varchar(255) — 비고

part_template

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 템플릿 명
  • process_template_id — bigint — Foreign key → process_template.id

part_template_link

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • quantity — int — 수량
  • child_template_id — bigint — Foreign key → part_template.id
  • parent_template_id — bigint — Foreign key → part_template.id

plant

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 공장명
  • company_id — bigint — Foreign key → company.id

process

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 공정명
  • plant_id — bigint — Foreign key → plant.id

process_link

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • routing_number — int
  • process_id — bigint — Foreign key → process.id
  • process_template_id — bigint — Foreign key → process_template.id

process_template

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • title — varchar(255) — 템플릿 명
  • part_template_id — bigint — Foreign key → part_template.id

production_order

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • completed_quantity — int — 성공 수량
  • status_enum — varchar(255) — 작업 여부
  • total_quantity — int — 목표 수량
  • work_order — int — 주문 수량
  • routing_id — bigint — Foreign key → routing.id

production_result

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • production_status — varchar(255) — 생산 상태
  • quantity — int — 수량
  • production_order_id — bigint — Foreign key → production_order.id

project

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

project_item_link

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

property

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

property_def

  • id — bigint — 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)

role

  • id — bigint — Primary key — NOT NULL
  • active — bit(1) — NOT NULL
  • role — varchar(255) — 권한

routing

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