notes

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
note_id bigserial 19 nextval('notes_note_id_seq'::regclass)
assoc_type int8 19 null
assoc_id int8 19 null
user_id int8 19 null
users.user_id notes_user_id_foreignC
date_created timestamp 22 null
date_modified timestamp 22 null
title varchar 255 null
contents text 2147483647 null

Indexes

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

Relationships