notes


Description

Notes allow users to annotate associated entities, such as submissions.

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 notes_user_id_foreignC
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
notes_user_id Performance Asc user_id

Relationships

Close relationships within degrees of separation