Dp Plan History Table Schema (dp_plan_history)


Description

A table for tracking and recording modifications to a related dp_plan

dp_plan_history table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
planid BIGINT 19 null
dp_plan.id dpplanhist_pla2_fk R

The related plan's id
status TINYINT 3 null

The plan's status
reason TINYINT 3 null

The reason for the status change
reasonfordecision LONGTEXT 2147483647 √ null

The reason for approving/declining the request
timemodified BIGINT 19 null

Modification time
usermodified BIGINT 19 null
user.id dpplanhist_use2_fk R

The id of the user who made the modification

Table contained -1 rows

dp_plan_history table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
dpplanhist_pla_ix Performance Asc planid
dpplanhist_use_ix Performance Asc usermodified

dp_plan_history table relationships

Close relationships within degrees of separation