intake_note


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
version BIGINT 19 null
intake_id BIGINT 19 null
intake.id FK_34alba0toa7g119ruo69628sx R
note_type VARCHAR 255 null
notes LONGTEXT 2147483647 √ null
proxy_user_id INT 10 √ null
sys_users.user_id FK_ko46nkcjuprpckpupa1b552q R
timestamp DATETIME 19 √ null
user_id INT 10 √ null
sys_users.user_id FK_9fsjxba23fpkoe7ksr6p73p37 R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_34alba0toa7g119ruo69628sx Performance Asc intake_id
FK_9fsjxba23fpkoe7ksr6p73p37 Performance Asc user_id
FK_ko46nkcjuprpckpupa1b552q Performance Asc proxy_user_id

Relationships

Close relationships within degrees of separation