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