warranty_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
new_value VARCHAR 100 √ null
old_value VARCHAR 100 √ null
proxy_user_id INT 10 √ null
sys_users.user_id FK_kcymmeo48e81utf648p0xyfre R
site_id INT 10 null
site.id FK_dx6xb8auqdcnx3x4h3e4td8bs R
subject VARCHAR 100 null
timestamp DATETIME 23 null
type_id BIGINT 19 √ null
asset_type.id FK_31snucjrlpnp5ajdtk97vrj88 R
user_id INT 10 null
sys_users.user_id FK_e2r7igtp6lkwl92pf38sd19k8 R
warranty_id BIGINT 19 √ null
asset_warranty.id FK_6n92j8m4nreo47fj2m10u69cs R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_31snucjrlpnp5ajdtk97vrj88 Performance Asc type_id
FK_6n92j8m4nreo47fj2m10u69cs Performance Asc warranty_id
FK_dx6xb8auqdcnx3x4h3e4td8bs Performance Asc site_id
FK_e2r7igtp6lkwl92pf38sd19k8 Performance Asc user_id
FK_kcymmeo48e81utf648p0xyfre Performance Asc proxy_user_id

Relationships

Close relationships within degrees of separation