agd_base_appointment

345 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
agd_appointment_participant.appointment_id fk_agd_appointment_participant_on_appointment R
agd_simple_appointment.id fk_agd_simple_appointment_on_id R
ins_inspection_appointment.id fk_ins_inspection_appointment_on_id R
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
start_date timestamp 29,6 null
end_date timestamp 29,6 null
status_id uuid 2147483647 null
agd_appointment_status.id fk_agd_base_appointment_on_status R
type_id uuid 2147483647 null
agd_appointment_type.id fk_agd_base_appointment_on_type R
appointment_comment varchar 2048 √ null
cancelled_appointment_comment varchar 2048 √ null
appointment_type varchar 31 √ null

Indexes

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

Relationships

Close relationships within degrees of separation