asset_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version INT 10 √ 0
new_value VARCHAR 100 √ null
old_value VARCHAR 100 √ null
schedule_id BIGINT 19 null
asset_schedule.id FK4E6AC5752BBA482A R
subject VARCHAR 255 null
timestamp DATETIME 19 null
type_id BIGINT 19 √ null
asset_type.id FK4E6AC57545D4494A R
user_id INT 10 null
sys_users.user_id FK4E6AC57528C762A3 R
proxy_user_id INT 10 √ null
sys_users.user_id FK4E6AC575A1B485D2 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK4E6AC57528C762A3 Performance Asc user_id
FK4E6AC5752BBA482A Performance Asc schedule_id
FK4E6AC57545D4494A Performance Asc type_id
FK4E6AC575A1B485D2 Performance Asc proxy_user_id
IX_assetLog_timestamp Performance Asc timestamp

Relationships

Close relationships within degrees of separation