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 | ||
provisioning_target_id | integer, foreign key | Provisioning Target ID | provisioning_targets:id | ||
subject_model | varchar(80) | Model that was provisioned | Any model can be provisioned, but only models of interest get proper foreign keys | ||
subjectid | integer | Primary Key of entity that was provisioned | This is really a foreign key | ||
person_id | integer, foreign key | Person ID change applied to | people:id | Unlike HistoryRecord and JobHistoryRecord, no more than one foreign key should be set | |
group_id | integer, foreign key | Group ID change applied to | groups:id | Unlike HistoryRecord and JobHistoryRecord, no more than one foreign key should be set | |
status | varchar(2) | Machine readable transaction code |
| ||
comment | varchar(256) | Human readable transaction description |