route_definition


Columns

Column Type Size Nulls Auto Default Children Parents Comments
idroute_definition int4 10 null
idclient int4 10 √ null
client.idclient route_definition_idclient_fkey R
idcreation_mayauser int4 10 √ null
mayauser.idmayauser route_definition_idcreation_mayauser_fkey R
idmodification_mayauser int4 10 √ null
mayauser.idmayauser route_definition_idmodification_mayauser_fkey R
creationdate timestamp 29,6 √ null
modificationdate timestamp 29,6 √ null
enable bool 1 √ null
name varchar 50 √ null
description varchar 280 √ null
datastore varchar 10000 √ null

Indexes

Constraint Name Type Sort Column(s)
route_definition_pkey Primary key Asc idroute_definition

Relationships

Close relationships within degrees of separation