target_area_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
message LONGTEXT 2147483647 √ null
proxy_user_id INT 10 √ null
sys_users.user_id FK_798fr6qghgtewex2b78c6ek1i R
subject VARCHAR 50 √ null
target_area_id INT 10 null
target_area.id FK_q051etq6wgik5319gnrfhhrjj R
timestamp DATETIME 23 null
user_id INT 10 null
sys_users.user_id FK_8ayryxth5wx1m0gg487ewu13r R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_798fr6qghgtewex2b78c6ek1i Performance Asc proxy_user_id
FK_8ayryxth5wx1m0gg487ewu13r Performance Asc user_id
FK_q051etq6wgik5319gnrfhhrjj Performance Asc target_area_id

Relationships

Close relationships within degrees of separation