program_log


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
version BIGINT 19 null
message VARCHAR 1000 √ null
program_id BIGINT 19 null
program.id FK_pnhc1jj16a48cn72yr2pnunbr R
proxy_user_id INT 10 √ null
sys_users.user_id FK_s7i7bf30hqs2tj7varkf1xfc6 R
subject VARCHAR 50 √ null
timestamp DATETIME 23 null
user_id INT 10 null
sys_users.user_id FK_1yrrxwie3f2ll8sekhjiq9r8i R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_1yrrxwie3f2ll8sekhjiq9r8i Performance Asc user_id
FK_pnhc1jj16a48cn72yr2pnunbr Performance Asc program_id
FK_s7i7bf30hqs2tj7varkf1xfc6 Performance Asc proxy_user_id

Relationships

Close relationships within degrees of separation