DPP 상품 유형 다변화 예시(연결선추가본)

테이블 (11)

Company_MES_table

  • GLN — VARCHAR(14) — 기본 키 — NOT NULL
  • company_name — VARCHAR(255) — NOT NULL
  • Field — MES 수집 가능 데이터들
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7

EPCIS_Company_user (CopyOfEPCIS_company)

  • GLN — VARCHAR(14) — 외래 키 → Company_MES_table.GLN — NOT NULL
  • id — VARCHAR(14)
  • pw — VARCHAR(255)
  • cell — VARCHAR(14)
  • name — VARCHAR(14)
  • email — VARCHAR(14)
  • Field

EPCIS_company

  • gtin — VARCHAR(14) — 기본 키
  • GLN — VARCHAR(14) — 외래 키 → Company_MES_table.GLN — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

barcode_history

  • gtin — VARCHAR(14) — 외래 키 → products.gtin
  • event_id — VARCHAR(255)
  • created_by — VARCHAR(255)
  • created_at — DATETIME

carbon_emission_summary

  • gtin — VARCHAR(14) — 기본 키 — NOT NULL
  • process_code — VARCHAR(50) — 기본 키 — NOT NULL
  • process_name — VARCHAR(255)
  • total_emission — FLOAT
  • event_count — INT
  • last_event_time — DATETIME
  • created_at — DATETIME

dpp_documents

  • gtin — VARCHAR(14) — 기본 키 — NOT NULL
  • doc_type — VARCHAR(100) — 기본 키 — NOT NULL
  • doc_name — VARCHAR(255) — NOT NULL
  • doc_uri — VARCHAR(255) — NOT NULL
  • access_level — ENUM('public','restricted','confidential')
  • issued_by — VARCHAR(255)
  • issued_at — DATETIME
  • valid_until — DATETIME
  • created_at — DATETIME

epcis_events

  • gtin — VARCHAR(14) — 외래 키 → products.gtin
  • event_type — ENUM('ObjectEvent','AggregationEvent','TransactionEvent','TransformationEvent') — NOT NULL
  • action — ENUM('ADD','OBSERVE','DELETE') — NOT NULL
  • event_time — DATETIME — NOT NULL
  • record_time — DATETIME
  • epc_list — JSON
  • parent_id — VARCHAR(255)
  • child_epc_list — JSON
  • biz_step — VARCHAR(100)
  • disposition — VARCHAR(100)
  • read_point — VARCHAR(255)
  • biz_location — VARCHAR(255)
  • ilmd — JSON
  • event_data — JSON
  • cert_list — JSON
  • created_by — VARCHAR(255)
  • updated_at — TIMESTAMP
  • event_id — VARCHAR(255) — NOT NULL

product_attributes

  • product_id — VARCHAR(14) — 기본 키 — NOT NULL
  • attr_code — VARCHAR(50) — 기본 키 — NOT NULL
  • attr_name — VARCHAR(100) — NOT NULL
  • attr_value — VARCHAR(255) — NOT NULL
  • attr_unit — VARCHAR(50)
  • created_at — DATETIME

product_components

  • product_id — VARCHAR(14) — 기본 키 — NOT NULL
  • component_type — VARCHAR(100)
  • component_name — VARCHAR(255)
  • component_gtin — VARCHAR(14)
  • quantity — DECIMAL(10,2)
  • unit — VARCHAR(20)
  • supplier — VARCHAR(255)

product_lifecycle

  • product_id — VARCHAR(14) — 기본 키 — NOT NULL
  • expected_lifetime — INT
  • recycling_info — TEXT
  • disposal_info — TEXT

products

  • gtin — VARCHAR(14) — 외래 키 → EPCIS_company.gtin
  • updated_at — TIMESTAMP — 갱신일자
  • product_name — VARCHAR(255) — NOT NULL — 제품명
  • brand — VARCHAR(100) — 기업명
  • manufacturer — VARCHAR(255) — 제품생산번호
  • serial_number — VARCHAR(100) — 제품고유번호
  • description — TEXT
  • dpp_uri — VARCHAR(255) — 디지털링크 주소
  • product_type_id — INT — 제품분류코드
  • created_at — DATETIME — 등록일자