비긴어게인
테이블 (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