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