Dp Plan History Table Schema (dp_plan_history)


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