DEMS

Tables (4)

dems_component_systems

  • id — bigint — Primary key — NOT NULL
  • component_name — character
  • component_description — character
  • rabbit_queue_name — character

dems_scenarios

  • id — bigint — Primary key — NOT NULL
  • scenario_name — character
  • scenario_description — character

dems_transaction_details

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • transactions_id — bigint — Foreign key → dems_transactions.id — NOT NULL
  • is_ack — boolean
  • message_payload — character
  • message_sequence — integer
  • from_system_id (id2) — bigint — Foreign key → dems_component_systems.id — NOT NULL
  • to_system_id (id3) — bigint — Foreign key → dems_component_systems.id — NOT NULL

dems_transactions

  • id — bigint — Primary key — NOT NULL
  • created_at — timestamp
  • updated_at — timestamp
  • transaction_uuid — character — NOT NULL
  • company_uuid — character — NOT NULL
  • now_sequence — integer
  • scenarios_id (id2) — bigint — Foreign key → dems_scenarios.id — NOT NULL