ins_inspection_agent

264 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 null
deleted_by varchar 255 √ null
deleted_date timestamp 29,6 √ 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
agent_id uuid 2147483647 null
com_user.id fk_ins_inspection_agent_on_agent R
inspection_id uuid 2147483647 null
ins_inspection.id fk_ins_inspection_agent_on_inspection R

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_agent Primary key Asc id
idx_ins_inspection_agent_agent Performance Asc agent_id
idx_ins_inspection_agent_parent_field_inspection Performance Asc inspection_id

Relationships

Close relationships within degrees of separation