Table

provisioning_history_records

Description

Provisioning Target-specific transaction history (human readable)


Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


provisioning_target_idinteger, foreign keyProvisioning Target IDprovisioning_targets:id(tick)
subject_modelvarchar(80)Model that was provisioned
(tick)Any model can be provisioned, but only models of interest get proper foreign keys
subjectidintegerPrimary Key of entity that was provisioned
(tick)This is really a foreign key
person_idinteger, foreign keyPerson ID change applied topeople:id
Unlike HistoryRecord and JobHistoryRecord, no more than one foreign key should be set
group_idinteger, foreign keyGroup ID change applied togroups:id
Unlike HistoryRecord and JobHistoryRecord, no more than one foreign key should be set

status

varchar(2)

Machine readable transaction code

  • N: Not Provisioned
  • P: Provisioned
  • Q: Queued
  • X: Unknown
(tick)


comment

varchar(256)

Human readable transaction description


(tick)


  • No labels