revique.public

TABLES 36

COLUMNS 416

Constraints 27

Anomalies 77

Routines 40

Database Type: PostgreSQL - 16.15 (Debian 16.15-1.pgdg13+2)

standard public schema

Table / View	Children	Parents	Columns	Type
catalog_item_lots	0	3	13	Table
native_payment_transactions	0	8	25	Table
patient_files	0	4	17	Table
promotion_linked_items	0	2	6	Table
promotion_definitions	2	1	13	Table
gift_card_definitions	2	1	12	Table
rbac_audit_events	0	3	9	Table
gift_card_ledger_entries	0	3	13	Table
payment_gateway_configs	1	4	14	Table
package_items	2	2	8	Table
patient_portal_provider_links	0	2	9	Table
loyalty_point_adjustments	0	3	11	Table
catalog_item_provider_mappings	0	4	9	Table
package_ledger_entries	0	6	16	Table
schema_migrations	77	0	3	Table
catalog_items	3	6	25	Table
notifications	1	3	16	Table
gift_cards	1	4	15	Table
loyalty_program_products	0	0	9	Table
loyalty_profiles	1	2	17	Table
package_definition_location_prices	0	2	7	Table
notification_user_states	0	2	8	Table
patient_package_item_balances	1	3	9	Table
package_definitions	4	1	11	Table
promotion_applications	0	10	21	Table
rbac_user_roles	0	2	3	Table
patient_package_instances	2	7	15	Table
rbac_role_emulation_grants	0	3	9	Table
patient_portal_accounts	1	2	8	Table
rbac_roles	3	1	9	Table
catalog_item_location_pricing	0	3	18	Table
rbac_users	2	2	13	Table
rbac_role_permissions	0	2	4	Table
gift_card_definition_locations	0	2	7	Table
rbac_user_locations	0	1	5	Table
rbac_feature_catalog	1	0	9	Table