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 — 생성일