schema_migrations


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
catalog_item_location_pricing.legacy_practice_location_id Implied Constraint R
catalog_item_location_pricing.practice_location_id Implied Constraint R
catalog_item_lots.legacy_item_lot_id Implied Constraint R
catalog_item_lots.practice_location_id Implied Constraint R
catalog_item_provider_mappings.legacy_provider_id Implied Constraint R
catalog_item_provider_mappings.practice_location_id Implied Constraint R
catalog_item_provider_mappings.provider_id Implied Constraint R
catalog_items.legacy_fee_id Implied Constraint R
catalog_items.legacy_item_id Implied Constraint R
catalog_items.legacy_practice_service_type_id Implied Constraint R
catalog_items.legacy_service_id Implied Constraint R
catalog_items.manufacturer_id Implied Constraint R
catalog_items.practice_id Implied Constraint R
gift_card_definition_locations.practice_location_id Implied Constraint R
gift_card_definitions.practice_id Implied Constraint R
gift_card_ledger_entries.actor_user_id Implied Constraint R
gift_card_ledger_entries.source_id Implied Constraint R
gift_cards.location_id Implied Constraint R
gift_cards.patient_id Implied Constraint R
gift_cards.practice_id Implied Constraint R
loyalty_point_adjustments.actor_user_id Implied Constraint R
loyalty_point_adjustments.source_id Implied Constraint R
loyalty_profiles.patient_id Implied Constraint R
loyalty_profiles.practice_id Implied Constraint R
native_payment_transactions.checkout_id Implied Constraint R
native_payment_transactions.gateway_transaction_id Implied Constraint R
native_payment_transactions.invoice_id Implied Constraint R
native_payment_transactions.location_id Implied Constraint R
native_payment_transactions.patient_id Implied Constraint R
native_payment_transactions.practice_id Implied Constraint R
native_payment_transactions.processor_id Implied Constraint R
notification_user_states.user_id Implied Constraint R
notifications.location_id Implied Constraint R
notifications.practice_id Implied Constraint R
notifications.source_entity_id Implied Constraint R
package_definition_location_prices.practice_location_id Implied Constraint R
package_definitions.practice_id Implied Constraint R
package_items.catalog_item_id Implied Constraint R
package_ledger_entries.actor_user_id Implied Constraint R
package_ledger_entries.source_id Implied Constraint R
patient_files.created_by_user_id Implied Constraint R
patient_files.deleted_by_user_id Implied Constraint R
patient_files.patient_id Implied Constraint R
patient_files.practice_id Implied Constraint R
patient_package_instances.location_id Implied Constraint R
patient_package_instances.patient_id Implied Constraint R
patient_package_instances.practice_id Implied Constraint R
patient_package_instances.source_checkout_id Implied Constraint R
patient_package_instances.source_invoice_id Implied Constraint R
patient_package_instances.source_payment_id Implied Constraint R
patient_package_item_balances.catalog_item_id Implied Constraint R
patient_portal_accounts.legacy_patient_id Implied Constraint R
patient_portal_accounts.legacy_user_id Implied Constraint R
patient_portal_provider_links.legacy_provider_id Implied Constraint R
payment_gateway_configs.location_id Implied Constraint R
payment_gateway_configs.practice_id Implied Constraint R
payment_gateway_configs.private_api_key_secret_id Implied Constraint R
payment_gateway_configs.processor_id Implied Constraint R
promotion_applications.actor_user_id Implied Constraint R
promotion_applications.catalog_item_id Implied Constraint R
promotion_applications.line_id Implied Constraint R
promotion_applications.location_id Implied Constraint R
promotion_applications.patient_id Implied Constraint R
promotion_applications.practice_id Implied Constraint R
promotion_applications.source_checkout_id Implied Constraint R
promotion_applications.source_id Implied Constraint R
promotion_applications.source_invoice_id Implied Constraint R
promotion_definitions.practice_id Implied Constraint R
promotion_linked_items.catalog_item_id Implied Constraint R
rbac_audit_events.actor_user_id Implied Constraint R
rbac_audit_events.practice_id Implied Constraint R
rbac_audit_events.target_id Implied Constraint R
rbac_role_emulation_grants.granted_by_user_id Implied Constraint R
rbac_role_emulation_grants.practice_id Implied Constraint R
rbac_roles.practice_id Implied Constraint R
rbac_users.legacy_user_id Implied Constraint R
rbac_users.practice_id Implied Constraint R
name text 2147483647 null
applied_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
schema_migrations_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation