ㄴㅇㄴ
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)