payment_gateway_configs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
native_payment_transactions.payment_gateway_config_id native_payment_transactions_payment_gateway_config_id_fkey R
practice_id text 2147483647 null
schema_migrations.id Implied Constraint R
location_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
gateway text 2147483647 null
gateway_environment text 2147483647 'sandbox'::text
status text 2147483647 'active'::text
display_name text 2147483647 √ null
public_key text 2147483647 √ null
private_api_key_secret_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
processor_id text 2147483647 √ null
schema_migrations.id Implied Constraint R
api_base_url text 2147483647 √ null
metadata jsonb 2147483647 '{}'::jsonb
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
payment_gateway_configs_pkey Primary key Asc id
payment_gateway_configs_active_lookup_idx Performance Asc/Asc/Asc/Asc practice_id + location_id + gateway + status
payment_gateway_configs_global_unique Must be unique Asc/Asc/Asc practice_id + gateway + gateway_environment
payment_gateway_configs_location_unique Must be unique Asc/Asc/Asc/Asc practice_id + location_id + gateway + gateway_environment

Check Constraints

Constraint Name Constraint
payment_gateway_configs_practice_id_check ((practice_id <> ''::text))
payment_gateway_configs_public_key_check (((public_key IS NULL) OR (public_key ~~ 'pub_%'::text)))
payment_gateway_configs_gateway_check ((gateway = 'fluidpay'::text))
payment_gateway_configs_status_check ((status = ANY (ARRAY['active'::text, 'inactive'::text])))
payment_gateway_configs_gateway_environment_check ((gateway_environment = ANY (ARRAY['sandbox'::text, 'production'::text])))

Relationships

Close relationships within degrees of separation