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 — 등록일자