ㄴㅇㄴ

Tables (34)

approval_history

  • approval_id — VARCHAR2(36)
  • entity — VARCHAR2(100) — NOT NULL
  • entity_id — VARCHAR2(100) — NOT NULL
  • step_no — NUMBER(3) — NOT NULL
  • action — VARCHAR2(20) — NOT NULL
  • actor_user_id — VARCHAR2(36) — NOT NULL
  • acted_at — TIMESTAMP — NOT NULL
  • comment — VARCHAR2(1000) — ARCHAR2(1000
  • esign_id — VARCHAR2(36)

audit_log

  • audit_id — VARCHAR2(36)
  • entity — VARCHAR2(100) — NOT NULL
  • entity_id — VARCHAR2(100) — NOT NULL
  • action — VARCHAR2(20) — NOT NULL
  • user_id — VARCHAR2(36)
  • ts_utc — TIMESTAMP — NOT NULL
  • old_json — CLOB
  • new_json — CLOB
  • esign_reason — VARCHAR2(200)
  • esign_user_id — VARCHAR2(36)
  • esign_ts — TIMESTAMP

consumption

  • consume_id — VARCHAR2(36)
  • order_id — VARCHAR2(36) — NOT NULL
  • op_id — VARCHAR2(36) — NOT NULL
  • unit_id — VARCHAR2(36)
  • mat_lot_id — VARCHAR2(36) — NOT NULL
  • qty — NUMBER(14,4) — NOT NULL
  • ts_utc — TIMESTAMP — NOT NULL

containers

  • container_id — VARCHAR2(36)
  • container_type — VARCHAR2(30) — NOT NULL
  • status — VARCHAR2(20)
  • loc_id — VARCHAR2(36)
  • capacity_qty — NUMBER(12)
  • uom — VARCHAR2(20)
  • created_at — TIMESTAMP

env_readings

  • reading_id — VARCHAR2(36)
  • sensor_id — VARCHAR2(36) — NOT NULL
  • value_num — NUMBER(18,6)
  • value_text — VARCHAR2(200)
  • ts_utc — TIMESTAMP — NOT NULL

env_sensors

  • sensor_id — VARCHAR2(36)
  • loc_id — VARCHAR2(36) — NOT NULL
  • sensor_type — VARCHAR2(30) — NOT NULL
  • model — VARCHAR2(50)
  • serial_no — VARCHAR2(50)
  • installed_at — TIMESTAMP

equip_state_log

  • state_log_id — VARCHAR2(36)
  • equipment_id — VARCHAR2(36) — NOT NULL
  • from_state — VARCHAR2(20)
  • to_state — VARCHAR2(20) — NOT NULL
  • reason_code — VARCHAR2(30)
  • ts_start — TIMESTAMP — NOT NULL
  • ts_end — TIMESTAMP
  • duration_sec — NUMBER(14,3)
  • comment — VARCHAR2(1000) — ARCHAR2(1000
  • operator_id — VARCHAR2(36)

equipment

  • equipment_id — VARCHAR2(36)
  • parent_equipment_id — VARCHAR2(36)
  • type — VARCHAR2(50)
  • maker — VARCHAR2(50)
  • model — VARCHAR2(50)
  • serial_no — VARCHAR2(50)

esignatures

  • esign_id — VARCHAR2(36)
  • user_id — VARCHAR2(36) — NOT NULL
  • reason — VARCHAR2(200) — NOT NULL
  • signed_at — TIMESTAMP — NOT NULL
  • method — VARCHAR2(20) — NOT NULL
  • signature_hash — VARCHAR2(256)

event_bus

  • event_id — VARCHAR2(36)
  • event_type — VARCHAR2(80) — NOT NULL
  • occurred_at_utc — TIMESTAMP — NOT NULL
  • site — VARCHAR2(40)
  • line — VARCHAR2(40)
  • workcenter_id — VARCHAR2(36)
  • op_id — VARCHAR2(36)
  • source_system — VARCHAR2(40)
  • payload_json — CLOB
  • processed_flag — CHAR(1)

genealogy

  • parent_unit_id — VARCHAR2(36) — Primary key — NOT NULL
  • child_unit_id — VARCHAR2(36) — Primary key — NOT NULL
  • op_id — VARCHAR2(36)
  • ts_utc — TIMESTAMP
  • relation — VARCHAR2(20)

hold_release_history

  • hr_id — VARCHAR2(36)
  • entity — VARCHAR2(100) — NOT NULL
  • entity_id — VARCHAR2(100) — NOT NULL
  • action — VARCHAR2(10) — NOT NULL
  • reason_code — VARCHAR2(50)
  • comment — VARCHAR2(1000) — ARCHAR2(1000
  • actor_user_id — VARCHAR2(36) — NOT NULL
  • acted_at — TIMESTAMP — NOT NULL

inspection_plan

  • insp_plan_id — VARCHAR2(36)
  • op_id — VARCHAR2(36)
  • item_id — VARCHAR2(36)
  • param_code — VARCHAR2(50) — NOT NULL
  • sampling_rule — VARCHAR2(100)
  • lcl — NUMBER(15,5)
  • ucl — NUMBER(15,5)
  • uom — VARCHAR2(20)
  • effective_from — TIMESTAMP
  • effective_to — TIMESTAMP

inventory_transactions

  • txn_id — VARCHAR2(36)
  • txn_type — VARCHAR2(20) — NOT NULL
  • mat_lot_id — VARCHAR2(36)
  • unit_id — VARCHAR2(36)
  • container_id — VARCHAR2(36)
  • from_loc_id — VARCHAR2(36)
  • to_loc_id — VARCHAR2(36)
  • qty — NUMBER(14,4)
  • uom — VARCHAR2(20)
  • ts_utc — TIMESTAMP — NOT NULL
  • ref_entity — VARCHAR2(50)
  • ref_id — VARCHAR2(64)
  • operator_id — VARCHAR2(36)
  • note — VARCHAR2(4000)

items

  • item_id — VARCHAR2(36)
  • rev — VARCHAR2(20)
  • spec_thickness — NUMBER(10,3)
  • spec_size — VARCHAR2(50)

labels

  • label_id — VARCHAR2(36)
  • label_type — VARCHAR2(20)
  • code_value — VARCHAR2(200) — NOT NULL
  • template_id — VARCHAR2(50)
  • printed_at — TIMESTAMP
  • operator_id — VARCHAR2(36)
  • unit_id — VARCHAR2(36)
  • mat_lot_id — VARCHAR2(36)
  • container_id — VARCHAR2(36)

material_lots

  • mat_lot_id — VARCHAR2(36)
  • item_id — VARCHAR2(36)
  • mfg_date — DATE
  • expiry_date — DATE
  • qty_on_hand — NUMBER(12)
  • uom — VARCHAR2(20)

nonconformance

  • nc_id — VARCHAR2(36)
  • op_id — VARCHAR2(36)
  • unit_id — VARCHAR2(36)
  • mat_lot_id — VARCHAR2(36)
  • defect_code — VARCHAR2(50)
  • severity — VARCHAR2(20)
  • qty — NUMBER(12)
  • detected_ts — TIMESTAMP
  • disposition — VARCHAR2(20)

operation_executions

  • exec_id — VARCHAR2(36)
  • order_id — VARCHAR2(36) — NOT NULL
  • op_id — VARCHAR2(36) — NOT NULL
  • equipment_id — VARCHAR2(36)
  • unit_id — VARCHAR2(36)
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • result — VARCHAR2(20)

order_schedules

  • sched_id — VARCHAR2(36)
  • order_id — VARCHAR2(36) — NOT NULL
  • op_id — VARCHAR2(36)
  • equipment_id — VARCHAR2(36)
  • start_plan — TIMESTAMP
  • end_plan — TIMESTAMP
  • lock_flag — CHAR(1)

production_orders

  • order_id — VARCHAR2(36)
  • item_id — VARCHAR2(36) — NOT NULL
  • qty — NUMBER(12) — NOT NULL
  • routing_id — VARCHAR2(36)
  • due_date — DATE
  • status — VARCHAR2(20)
  • priority — NUMBER(3)

purchase_orders

  • po_id — VARCHAR2(36)
  • supplier_id — VARCHAR2(36)
  • eta — DATE
  • status — VARCHAR2(20)

receiving

  • rcv_id — VARCHAR2(36)
  • po_id — VARCHAR2(36)
  • mat_lot_id — VARCHAR2(36)
  • qty — NUMBER(12)
  • ts_utc — TIMESTAMP
  • inspected_flag — CHAR(1)
  • created_by — VARCHAR2(36)
  • created_at — TIMESTAMP
  • updated_by — VARCHAR2(36)
  • updated_at — TIMESTAMP
  • approved_by — VARCHAR2(36)
  • approved_at — TIMESTAMP
  • status — VARCHAR2(20)

roles

  • role_id — VARCHAR2(36)
  • name — VARCHAR2(50) — NOT NULL

routing_operations

  • op_id — VARCHAR2(36)
  • routing_id — VARCHAR2(36) — NOT NULL
  • seq — NUMBER(5) — NOT NULL
  • workcenter_id — VARCHAR2(36)
  • recipe_id — VARCHAR2(36)
  • std_ct_sec — NUMBER(10,2)

routings

  • routing_id — VARCHAR2(36)
  • name — VARCHAR2(100) — NOT NULL
  • version — NUMBER(5) — NOT NULL

spcsamples

  • sample_id — VARCHAR2(36)
  • op_id — VARCHAR2(36)
  • equipment_id — VARCHAR2(36)
  • unit_id — VARCHAR2(36)
  • param_code — VARCHAR2(50)
  • value — NUMBER(15,5)
  • measured_ts — TIMESTAMP
  • uom — VARCHAR2(20)

suppliers

  • supplier_id — VARCHAR2(36)
  • name — VARCHAR2(120) — NOT NULL
  • email — VARCHAR2(150)
  • phone — VARCHAR2(50)

user_roles

  • user_id — VARCHAR2(36) — Primary key — NOT NULL
  • role_id — VARCHAR2(36) — Primary key — NOT NULL

users

  • user_id — VARCHAR2(36)
  • name — VARCHAR2(100) — NOT NULL
  • email — VARCHAR2(150) — NOT NULL
  • created_at — TIMESTAMP

warehouse_locations

  • loc_id — VARCHAR2(36)
  • warehouse — VARCHAR2(50) — NOT NULL
  • area — VARCHAR2(50)
  • aisle — VARCHAR2(20)
  • rack — VARCHAR2(20)
  • shelf — VARCHAR2(20)
  • bin — VARCHAR2(20)
  • parent_loc_id — VARCHAR2(36)
  • width_mm — NUMBER(10,2)
  • depth_mm — NUMBER(10,2)
  • height_mm — NUMBER(10,2)
  • temp_min_c — NUMBER(6,2)
  • temp_max_c — NUMBER(6,2)
  • humid_min_pct — NUMBER(6,2)
  • humid_max_pct — NUMBER(6,2)
  • is_line_side — CHAR(1)
  • created_at — TIMESTAMP

wip_units

  • unit_id — VARCHAR2(36)
  • order_id — VARCHAR2(36)
  • current_op_id — VARCHAR2(36)
  • unit_type — VARCHAR2(20)
  • qty — NUMBER(12)
  • status — VARCHAR2(20)

workcenter_equipment

  • workcenter_id — VARCHAR2(36) — Primary key — NOT NULL
  • equipment_id — VARCHAR2(36) — Primary key — NOT NULL
  • effective_from — TIMESTAMP
  • effective_to — TIMESTAMP

workcenters

  • workcenter_id — VARCHAR2(36)
  • name — VARCHAR2(100) — NOT NULL
  • line — VARCHAR2(50)