DPP

Tables (5)

epc_normalized

  • epc_raw — text
  • epc_canonical — text — NOT NULL
  • last_seen — timestamptz — NOT NULL

event_ilmd

  • event_id — bigint — Primary key — NOT NULL
  • attr_key — text — Primary key — NOT NULL
  • attr_val — jsonb

event_raw

  • event_id — bigint
  • epcis_json — jsonb — NOT NULL

tenants

  • tenant_id — uuid
  • company_name — text — NOT NULL
  • status — text — NOT NULL
  • created_at — timestamptz — NOT NULL

users

  • user_id — uuid
  • email — text — NOT NULL
  • password_hash — text — NOT NULL
  • display_name — text
  • global_role — iam.user_role — NOT NULL
  • status — text — NOT NULL
  • created_at — timestamptz — NOT NULL
  • last_login_at — timestamptz