Appraisal History Table Schema (appraisal_history)


Description

Appraisal access history

appraisal_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
userid BIGINT 19 null
user.id apprhist_use2_fk R
appraisalid BIGINT 19 null
appraisal.id apprhist_app2_fk R
timecreated BIGINT 19 null

Table contained -1 rows

appraisal_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
apprhist_app_ix Performance Asc appraisalid
apprhist_use_ix Performance Asc userid

appraisal_history table relationships

Close relationships within degrees of separation