dkqnwl
Tables (19)
CUSTOMER
- CUSTOMER_ID — integer
- NAME — varchar(100) — NOT NULL
- CONTACT — varchar(100) — 연락처
- ADDRESS — varchar(200) — 주소
FINISHED_PRODUCT_LOT
- FINISHED_LOT_ID — integer
- PRODUCT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID
- QUANTITY — integer — 수량
- QC_STATUS — varchar(20) — 품질검사
- INSPECTOR — varchar(100) — 검사자
- STATUS — varchar(20) — 상태
- CREATED_AT — date — 생성일
KPI
- KPI_ID — integer
- PRODUCT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID
- KPI_NAME — varchar(100) — NOT NULL — KPI
- KPI_TYPE — varchar(20) — PRODUCTIVITY/QUALITY/EFFICIENCY
- TARGET_VALUE — integer — 목표값
- ACTUAL_VALUE — integer — 실제값
- MEASURE_DATE — date — 측정일
ORDERS
- ORDER_ID — integer
- CUSTOMER_ID — integer — Foreign key → CUSTOMER.CUSTOMER_ID
- PRODUCT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID — 제품
- FINISHED_LOT_ID — integer — Foreign key → FINISHED_PRODUCT_LOT.FINISHED_LOT_ID — 완제품
- QUANTITY — integer — 주문
- ORDER_DATE — date — 주문일
- STATUS — varchar(20) — 주문
PASSWORD_HISTORY
- HISTORY_ID — integer
- USER_ID — integer — Foreign key → USERS.USER_ID
- PASSWORD — varchar(100) — NOT NULL — 이전
- CHANGED_AT — date — 변경일
PRODUCT
- PRODUCT_ID — integer
- PRODUCT_NAME — varchar(100) — NOT NULL
- PRODUCT_TYPE — varchar(20) — NOT NULL
- UNIT — varchar(20) — kg
- DESCRIPTION — varchar(500) — 제품
PRODUCTION_HISTORY
- HISTORY_ID — integer
- RAW_LOT_ID — integer — Foreign key → RAW_MATERIAL_LOT.RAW_LOT_ID
- SEMI_LOT_ID — integer — Foreign key → SEMI_FINISHED_LOT.SEMI_LOT_ID — 반제품
- FINISHED_LOT_ID — integer — Foreign key → FINISHED_PRODUCT_LOT.FINISHED_LOT_ID — 완제품
- STEP_NAME — varchar(100) — 공정
- START_TIME — date — 시작
- END_TIME — date — 종료
- OPERATOR — varchar(100) — 작업자
- STATUS — varchar(20) — 상태
RAW_MATERIAL_LOT
- RAW_LOT_ID — integer
- PRODUCT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID
- QUANTITY — decimal(10,2) — 수량
- UNIT — varchar(10) — 단위
- SUPPLIER — varchar(100) — 공급업체
- EXPIRY_DATE — date — 유통기한
- STATUS — varchar(20) — 상태
- CREATED_AT — date — 생성일
RAW_SEMI_BOM_LOT
- RAW_SEMI_BOM_LOT_ID — integer
- RAW_SEMI_BOM_ID — integer — Foreign key → RAW_TO_SEMI_BOM.RAW_SEMI_BOM_ID
- RAW_LOT_ID — integer — Foreign key → RAW_MATERIAL_LOT.RAW_LOT_ID — 원자재
- SEMI_LOT_ID — integer — Foreign key → SEMI_FINISHED_LOT.SEMI_LOT_ID — 반제품
- PLANNED_QUANTITY — decimal(10,2) — 계획
- ACTUAL_QUANTITY — decimal(10,2) — 실제
- VARIANCE — decimal(10,2) — 차이
- CREATED_AT — date — 생성일
RAW_TO_SEMI_BOM
- RAW_SEMI_BOM_ID — integer
- PARENT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID
- CHILD_ID — integer — Foreign key → PRODUCT.PRODUCT_ID — 원자재
- QUANTITY — decimal(10,2) — NOT NULL — 필요
- PROCESS_TEMP — decimal(5,2) — 공정
- PROCESS_TIME — decimal(5,2) — 공정
- EQUIPMENT — varchar(50) — 사용
- CREATED_AT — date — 생성일
SEMI_FINISHED_BOM_LOT
- SEMI_FINISHED_BOM_LOT_ID — integer
- SEMI_FINISHED_BOM_ID — integer — Foreign key → RAW_TO_SEMI_BOM.RAW_SEMI_BOM_ID
- SEMI_LOT_ID — integer — Foreign key → SEMI_FINISHED_LOT.SEMI_LOT_ID — 반제품
- FINISHED_LOT_ID — integer — Foreign key → FINISHED_PRODUCT_LOT.FINISHED_LOT_ID — 완제품
- PLANNED_QUANTITY — decimal(10,2) — 계획
- ACTUAL_QUANTITY — decimal(10,2) — 실제
- VARIANCE — decimal(10,2) — 차이
- CREATED_AT — date — 생성일
SEMI_FINISHED_LOT
- SEMI_LOT_ID — integer
- PRODUCT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID
- QUANTITY — decimal(10,2) — 수량
- UNIT — varchar(10) — 단위
- PROCESS_STEP — varchar(50) — 공정
- STATUS — varchar(20) — 상태
- CREATED_AT — date — 생성일
SEMI_TO_FINISHED_BOM
- SEMI_FINISHED_BOM_ID — integer
- PARENT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID
- CHILD_ID — integer — Foreign key → PRODUCT.PRODUCT_ID — 반제품
- QUANTITY — decimal(10,2) — NOT NULL — 필요
- MIXING_RATIO — decimal(5,2) — 배합
- CURING_TIME — decimal(5,2) — 숙성
- PACKAGING_TYPE — varchar(50) — 포장
- CREATED_AT — date — 생성일
USERS
- USER_ID — integer
- EMPLOYEE_NUMBER — varchar(20) — NOT NULL
- USERNAME — varchar(50) — NOT NULL — 사용자명
- PASSWORD — varchar(100) — NOT NULL — 비밀번호
- ROLE — varchar(20) — ADMIN/EMPLOYEE
- IS_FIRST_LOGIN — integer — 최초
- IS_ACTIVE — integer — 계정
- CREATED_AT — date — 생성일
WORKERS
- WORKER_ID — integer
- USER_ID — integer — Foreign key → USERS.USER_ID
- WORKER_NAME — varchar(100) — NOT NULL — 작업자명
- CURRENT_PROCESS — varchar(100) — 현재
- SKILL_LEVEL — varchar(20) — BEGINNER/INTERMEDIATE/EXPERT
- WORK_SHIFT — varchar(20) — DAY/NIGHT
- CREATED_AT — date — 생성일
WORK_ORDER
- WORK_ORDER_ID — integer
- ORDER_ID — integer — Foreign key → ORDERS.ORDER_ID
- PRODUCT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID — 제품
- WORK_ORDER_NO — varchar(50) — NOT NULL — 작업지시
- WORK_ORDER_TYPE — varchar(20) — NOT NULL — PRODUCTION/REPAIR/MAINTENANCE
- PLANNED_QUANTITY — decimal(10,2) — NOT NULL — 계획
- ACTUAL_QUANTITY — decimal(10,2) — 실제
- PRIORITY — varchar(20) — HIGH/NORMAL/LOW
- STATUS — varchar(20) — PLANNED/IN_PROGRESS/COMPLETED/CANCELLED
- PLANNED_START_DATE — date — 계획
- PLANNED_END_DATE — date — 계획
- ACTUAL_START_DATE — date — 실제
- ACTUAL_END_DATE — date — 실제
- CREATED_BY — integer — Foreign key → USERS.USER_ID — 생성자
- CREATED_AT — date — 생성일
- UPDATED_AT — date — 수정일
WORK_ORDER_MATERIAL
- WORK_ORDER_MATERIAL_ID — integer
- WORK_ORDER_ID — integer — Foreign key → WORK_ORDER.WORK_ORDER_ID
- WORK_ORDER_PROCESS_ID — integer — Foreign key → WORK_ORDER_PROCESS.WORK_ORDER_PROCESS_ID — 공정
- PRODUCT_ID — integer — Foreign key → PRODUCT.PRODUCT_ID — 자재
- MATERIAL_TYPE — varchar(20) — NOT NULL — RAW/SEMI_FINISHED
- LOT_ID — integer — LOT
- PLANNED_QUANTITY — decimal(10,2) — NOT NULL — 계획
- ACTUAL_QUANTITY — decimal(10,2) — 실제
- UNIT — varchar(20) — 단위
- STATUS — varchar(20) — PLANNED/ISSUED/USED/RETURNED
- ISSUE_DATE — date — 자재
- CREATED_AT — date — 생성일
WORK_ORDER_PROCESS
- WORK_ORDER_PROCESS_ID — integer
- WORK_ORDER_ID — integer — Foreign key → WORK_ORDER.WORK_ORDER_ID
- PROCESS_SEQUENCE — integer — NOT NULL — 공정
- PROCESS_NAME — varchar(100) — NOT NULL — 공정명
- PROCESS_CODE — varchar(50) — 공정
- PLANNED_QUANTITY — decimal(10,2) — NOT NULL — 공정별
- ACTUAL_QUANTITY — decimal(10,2) — 공정별
- STANDARD_TIME — decimal(5,2) — 표준
- ACTUAL_TIME — decimal(5,2) — 실제
- EQUIPMENT_ID — varchar(50) — 사용
- EQUIPMENT_NAME — varchar(100) — 사용
- PROCESS_PARAMETERS — text — 공정
- STATUS — varchar(20) — PLANNED/IN_PROGRESS/COMPLETED/ON_HOLD
- START_TIME — date — 공정
- END_TIME — date — 공정
- CREATED_AT — date — 생성일
WORK_ORDER_WORKER
- WORK_ORDER_WORKER_ID — integer
- WORK_ORDER_ID — integer — Foreign key → WORK_ORDER.WORK_ORDER_ID
- WORK_ORDER_PROCESS_ID — integer — Foreign key → WORK_ORDER_PROCESS.WORK_ORDER_PROCESS_ID — 공정
- WORKER_ID — integer — Foreign key → WORKERS.WORKER_ID — 작업자
- ROLE — varchar(50) — OPERATOR/SUPERVISOR/INSPECTOR
- ASSIGNED_DATE — date — 할당일
- START_TIME — date — 작업
- END_TIME — date — 작업
- STATUS — varchar(20) — ASSIGNED/IN_PROGRESS/COMPLETED
- CREATED_AT — date — 생성일