DPP 프로토타입 ERD
테이블 (5)
barcode_history
- id — INT
- gtin — VARCHAR(255) — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- process_code — VARCHAR(10) — NOT NULL
- process_name — VARCHAR(255)
- batch_code — VARCHAR(50) — NOT NULL
- lot_code — VARCHAR(50) — NOT NULL
- production_date — VARCHAR(10) — NOT NULL
- barcode_data — TEXT — NOT NULL
- barcode_type — VARCHAR(20)
- created_by — VARCHAR(100)
- created_at — TIMESTAMP
carbon_emission_summary
- id — INT
- gtin — VARCHAR(20) — NOT NULL
- process_code — VARCHAR(10) — NOT NULL
- process_name — VARCHAR(50)
- scope1 — FLOAT
- scope2 — FLOAT
- total — FLOAT
- event_count — INT
- last_event_time — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
epcis_events
- id — INT
- event_id — VARCHAR(255) — NOT NULL
- event_type — VARCHAR(50) — NOT NULL
- event_action — VARCHAR(20) — NOT NULL
- event_time — DATETIME — NOT NULL
- gtin — VARCHAR(255) — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- process_code — VARCHAR(10) — NOT NULL
- process_name — VARCHAR(255)
- batch_code — VARCHAR(255) — NOT NULL
- lot_code — VARCHAR(255) — NOT NULL
- production_date — DATE — NOT NULL
- gs1_code — TEXT — NOT NULL
- epcis_data — JSON
- carbon_emission — FLOAT
- is_final_process — BOOLEAN
- status — VARCHAR(20)
- created_by — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
gtin_definitions
- id — INT
- gtin — VARCHAR(20) — NOT NULL
- product_name — VARCHAR(255)
- product_type — VARCHAR(100)
- width_mm — FLOAT
- thickness_um — FLOAT
- surface_type — VARCHAR(100)
- description — TEXT
- material_type — VARCHAR(100)
- material_grade — VARCHAR(100)
- tensile_strength — FLOAT
- elongation — FLOAT
- bath_composition — VARCHAR(255)
- current_density — FLOAT
- material_description — TEXT
- processes — TEXT
- certifications — TEXT
- product_image — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
unified_users
- id — INT
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- email — VARCHAR(100)
- role — VARCHAR(20)
- name — VARCHAR(100)
- phone — VARCHAR(20)
- zipcode — VARCHAR(10)
- address — VARCHAR(200)
- detail_address — VARCHAR(100)
- department — VARCHAR(100)
- position — VARCHAR(100)
- company_name — VARCHAR(200)
- company_address — VARCHAR(300)
- company_gln — VARCHAR(50)
- industry_type — VARCHAR(50)
- company_website — VARCHAR(200)
- company_image — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP