Appraisal Grp Org Table Schema (appraisal_grp_org)


Description

Organisations assigned to appraisal

appraisal_grp_org table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
appraisalid BIGINT 19 null
appraisal.id apprgrporg_app2_fk R
orgid BIGINT 19 null
org.id apprgrporg_org2_fk R
includechildren BIT 1 √ null

Table contained -1 rows

appraisal_grp_org table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprgrporg_app_ix Performance Asc appraisalid
apprgrporg_org_ix Performance Asc orgid

appraisal_grp_org table relationships

Close relationships within degrees of separation