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