notes

35 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
note_id BIGINT 19 √ null
assoc_type BIGINT 19 null
assoc_id BIGINT 19 null
user_id BIGINT 19 null
users.user_id Implied Constraint R
date_created DATETIME 19 null
date_modified DATETIME 19 √ NULL
title VARCHAR 255 √ NULL
contents TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc note_id
notes_assoc Performance Asc/Asc assoc_type + assoc_id

Relationships

Close relationships within degrees of separation