coverage


Description

Entrance entity for the definition of what kind of tasks over what objects the client wishes to grant access

Columns

Column Type Size Nulls Auto Default Children Parents Comments
idcoverage int4 10 null
coverage_command.idcoverage FK_coverage_command_coverage R
coverage_macros.idcoverage FK_coverage_macros_coverage R
coverage_unitgroup.idcoverage FK_coverage_unitgroup_coverage C
coverage_usergroup.idcoverage FK_coverage_usergroup_coverage C
vw_unit_coverage.idcoverage Implied Constraint R
idclient int4 10 null
client.idclient FK_coverage_client R
alias varchar 50 null
description varchar 100 √ null
mgssendreceive bpchar 4 null
createdbyuser int4 10 null
creationdate timestamp 29,6 null
lastmodifiedbyuser int4 10 null
lastmodificationdate timestamp 29,6 null
originatingsystem varchar 50 null
enabled bool 1 true
aef_id int4 10 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_coverage Primary key Asc idcoverage
UQ_coverage_idcoverage Must be unique Asc idcoverage

Relationships

Close relationships within degrees of separation