비긴어게인

테이블 (15)

bom

  • bomno — VARCHAR2(20) — 기본 키 — NOT NULL
  • parent_itemcode — VARCHAR2(20) — 외래 키 → item.itemcode — NOT NULL
  • child_itemcode — VARCHAR2(20) — 외래 키 → item.itemcode — NOT NULL
  • qty — NUMBER(12,2) — NOT NULL
  • unit — VARCHAR2(20)
  • useyn — CHAR(1) — NOT NULL

defect

  • defectcode — VARCHAR2(20) — 기본 키 — NOT NULL
  • defectname — VARCHAR2(100) — NOT NULL
  • defectdesc — VARCHAR2(200)
  • useyn — CHAR(1) — NOT NULL

dept

  • deptno — VARCHAR2(2) — 기본 키 — NOT NULL
  • dname — VARCHAR2(50) — NOT NULL
  • loc — VARCHAR2(100)
  • useyn — CHAR(1) — NOT NULL

emp

  • empno — VARCHAR2(6) — 기본 키 — NOT NULL
  • ename — VARCHAR2(50) — NOT NULL
  • job — VARCHAR2(30)
  • mgr — VARCHAR2(6) — 외래 키 → emp.empno
  • hiredate — DATE
  • phone — VARCHAR2(20)
  • deptno — VARCHAR2(2) — 외래 키 → dept.deptno — NOT NULL
  • status — VARCHAR2(20) — NOT NULL

equipment

  • equipmentcode — VARCHAR2(20) — 기본 키 — NOT NULL
  • equipmentname — VARCHAR2(100) — NOT NULL
  • processcode — VARCHAR2(20) — 외래 키 → process.processcode — NOT NULL
  • deptno — VARCHAR2(2) — 외래 키 → dept.deptno — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • installdate — DATE
  • useyn — CHAR(1) — NOT NULL

inbound

  • inboundno — VARCHAR2(20) — 기본 키 — NOT NULL
  • itemcode — VARCHAR2(20) — 외래 키 → item.itemcode — NOT NULL
  • suppliercode — VARCHAR2(20) — 외래 키 → supplier.suppliercode — NOT NULL
  • lotno — VARCHAR2(20) — NOT NULL
  • inbounddate — DATE — NOT NULL
  • qty — NUMBER(12,2) — NOT NULL
  • unit — VARCHAR2(20)
  • status — VARCHAR2(20) — NOT NULL
  • created_by_empno — VARCHAR2(6) — 외래 키 → emp.empno — NOT NULL
  • created_by_deptno — VARCHAR2(2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

inventory

  • inventoryno — VARCHAR2(20) — 기본 키 — NOT NULL
  • itemcode — VARCHAR2(20) — 외래 키 → item.itemcode — NOT NULL
  • lotno — VARCHAR2(20) — NOT NULL
  • qty — NUMBER(12,2) — NOT NULL
  • unit — VARCHAR2(20)
  • location — VARCHAR2(100)
  • status — VARCHAR2(20) — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

item

  • itemcode — VARCHAR2(20) — 기본 키 — NOT NULL
  • itemname — VARCHAR2(100) — NOT NULL
  • itemtype — VARCHAR2(2) — NOT NULL
  • itemgroup — VARCHAR2(10)
  • spec — VARCHAR2(100)
  • unit — VARCHAR2(20)
  • safestock — NUMBER(12,2)
  • useyn — CHAR(1) — NOT NULL

process

  • processcode — VARCHAR2(20) — 기본 키 — NOT NULL
  • processname — VARCHAR2(100) — NOT NULL
  • processorder — NUMBER(3) — NOT NULL
  • processdesc — VARCHAR2(200)
  • useyn — CHAR(1) — NOT NULL

production_plan

  • planno — VARCHAR2(20) — 기본 키 — NOT NULL
  • itemcode — VARCHAR2(20) — 외래 키 → item.itemcode — NOT NULL
  • plandate — DATE — NOT NULL
  • planqty — NUMBER(12,2) — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • created_by_empno — VARCHAR2(6) — 외래 키 → emp.empno — NOT NULL
  • created_by_deptno — VARCHAR2(2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

production_result

  • resultno — VARCHAR2(20) — 기본 키 — NOT NULL
  • workorderno — VARCHAR2(20) — 외래 키 → work_order.workorderno — NOT NULL
  • lotno — VARCHAR2(20) — NOT NULL
  • goodqty — NUMBER(12,2) — NOT NULL
  • defectqty — NUMBER(12,2) — NOT NULL
  • resultdate — DATE — NOT NULL
  • status — VARCHAR2(20) — NOT NULL
  • created_by_empno — VARCHAR2(6) — 외래 키 → emp.empno — NOT NULL
  • created_by_deptno — VARCHAR2(2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

quality_inspection

  • inspectionno — VARCHAR2(20) — 기본 키 — NOT NULL
  • lotno — VARCHAR2(20) — NOT NULL
  • itemcode — VARCHAR2(20) — 외래 키 → item.itemcode — NOT NULL
  • inspectiondate — DATE — NOT NULL
  • inspectionresult — VARCHAR2(200)
  • judgment — VARCHAR2(20) — NOT NULL
  • inspector_empno — VARCHAR2(6) — 외래 키 → emp.empno — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

supplier

  • suppliercode — VARCHAR2(20) — 기본 키 — NOT NULL
  • suppliername — VARCHAR2(100) — NOT NULL
  • managername — VARCHAR2(50)
  • tel — VARCHAR2(20)
  • addr — VARCHAR2(200)
  • useyn — CHAR(1) — NOT NULL

user_account

  • empno — VARCHAR2(6) — 외래 키 → emp.empno — NOT NULL
  • loginpw — VARCHAR2(100) — NOT NULL
  • levelcode — VARCHAR2(3) — NOT NULL
  • firstloginyn — CHAR(1) — NOT NULL
  • temppwyn — CHAR(1) — NOT NULL
  • accountstatus — VARCHAR2(20) — NOT NULL
  • lastloginat — TIMESTAMP

work_order

  • workorderno — VARCHAR2(20) — 기본 키 — NOT NULL
  • planno — VARCHAR2(20) — 외래 키 → production_plan.planno — NOT NULL
  • processcode — VARCHAR2(20) — 외래 키 → process.processcode — NOT NULL
  • equipmentcode — VARCHAR2(20) — 외래 키 → equipment.equipmentcode — NOT NULL
  • lotno — VARCHAR2(20) — NOT NULL
  • workdate — DATE — NOT NULL
  • workqty — NUMBER(12,2) — NOT NULL
  • worker_empno — VARCHAR2(6) — 외래 키 → emp.empno
  • status — VARCHAR2(20) — NOT NULL
  • created_by_empno — VARCHAR2(6) — 외래 키 → emp.empno — NOT NULL
  • created_by_deptno — VARCHAR2(2) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL