ins_inspection_department_zip_code

8 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
department_id uuid 2147483647 √ null
ins_inspection_department.id fk_ins_inspection_department_zip_code_on_department R
zip_code_id uuid 2147483647 √ null
add_zip_code.id fk_ins_inspection_department_zip_code_on_zip_code R

Indexes

Constraint Name Type Sort Column(s)
pk_ins_inspection_department_zip_code Primary key Asc id
idx_ins_inspection_department_zip_code_service Performance Asc department_id
idx_ins_inspection_department_zip_code_zip_code Performance Asc zip_code_id

Relationships

Close relationships within degrees of separation