agd_appointment_participant

345 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
version int4 10 null
created_by varchar 255 √ null
created_date timestamp 29,6 √ null
last_modified_by varchar 255 √ null
last_modified_date timestamp 29,6 √ null
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ null
appointment_id uuid 2147483647 null
agd_base_appointment.id fk_agd_appointment_participant_on_appointment R
user_id uuid 2147483647 null
com_user.id fk_agd_appointment_participant_on_user R

Indexes

Constraint Name Type Sort Column(s)
pk_agd_appointment_participant Primary key Asc id
idx_agd_app_part_unq Must be unique Asc/Asc appointment_id + user_id
idx_agd_appointment_appointment Performance Asc appointment_id
idx_agd_appointment_user Performance Asc user_id

Relationships

Close relationships within degrees of separation