payment

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
payment_gym.id payment_gym_id_fkey C
session.payment_id session_payment_id_fkey N
public_id varchar 10 null
clinic_id int8 19 null
clinic.id payment_clinic_id_fkey R
created_by int8 19 null
app_user.id payment_created_by_fkey R
amount numeric 12,2 null
date date 13 null
payment_method payment_method 2147483647 null
request_id varchar 2147483647 √ null
payer_public_id varchar 10 null
voided_at timestamptz 35,6 √ null
void_reason text 2147483647 √ null
created_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
payment_pkey Primary key Asc id
idx_payment_clinic_date Performance Asc/Asc clinic_id + date
idx_payment_patient_id Performance Asc payer_public_id
payment_public_id_key Must be unique Asc public_id
payment_request_id_key Must be unique Asc request_id

Check Constraints

Constraint Name Constraint
payment_amount_check ((amount > (0)::numeric))

Relationships

Close relationships within degrees of separation