re_maintenance_event_wastewater_structure

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 uuid_generate_v4()

UUID generated with uuid_generate_v4 see https://www.postgresql.org/docs/16/uuid-ossp.html#UUID-OSSP-FUNCTIONS-SECT

fk_wastewater_structure varchar 16 null
wastewater_structure.obj_id rel_maintenance_event_wastewater_structure_wastewater_structure C
fk_maintenance_event varchar 16 null
maintenance_event.obj_id rel_maintenance_event_wastewater_structure_maintenance_event C

Indexes

Constraint Name Type Sort Column(s)
pkey_tww_od_re_maintenance_event_wastewater_structure_id Primary key Asc id
in_re_maintenance_event_wastewater_structure_fks Must be unique Asc/Asc fk_maintenance_event + fk_wastewater_structure

Relationships