indicator


Description

Abstract entity for pictoric representations of business metrics such as speed,idling time, etc

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('indicator_id_seq'::regclass)
idclient int4 10 null
client.idclient fk_indicator_idclient R
idindicator_type int4 10 null
indicator_type.id fk_indicator_indicator_type R
idindicator_icon int4 10 null
indicator_icon.id fk_indicator_indicator_icon R
lower_limit float8 17,17 √ null
upper_limit float8 17,17 √ 0
lastmodifiedbyuser int4 10 0
lastmodificationdate timestamptz 35,6 √ now()

Indexes

Constraint Name Type Sort Column(s)
indicator_pkey Primary key Asc id
idx_indicator_client Performance Asc idclient

Relationships

Close relationships within degrees of separation