app_user

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int8 19 √ null
payment.created_by payment_created_by_fkey R
session_app.user_id session_app_user_id_fkey C
staff.id staff_id_fkey C
public_id varchar 10 null
appointment.created_by appointment_created_by_fkey R
name varchar 2147483647 null
email varchar 2147483647 null
password_hash varchar 2147483647 null
clinic_id int8 19 null
clinic.id app_user_clinic_id_fkey R
role role_in_app 2147483647 null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
app_user_pkey Primary key Asc id
app_user_email_key Must be unique Asc email
app_user_public_id_key Must be unique Asc public_id
idx_user_clinic_id Performance Asc clinic_id

Relationships

Close relationships within degrees of separation