Table: projectthread
Groups together project-level comments with a common title, like an email thread
Columns
NameTypeConstraintsDescription
systemidINTEGERNOT NULLSystem-generated primary key
projectINTEGERNOT NULLThe project this thread is against
ownerINTEGERNOT NULLForeign key to the user who started this thread
threadtitleVARCHAR (100)NOT NULLTitle of the thread
Primary key
NameColumnsDescription
pk_projectthreadsystemid
Foreign keys
NameColumnsReferenced tableDescription
fk_projectthread_projectprojectproject
fk_projectthread_systemuserownersystemuser
Incoming foreign keys
NameColumnsReferencing tableDescription
fk_projectcomment_projectthreadprojectthreadprojectcomment
Indexes
NameColumnsDescription
in_projectthread_projectproject
in_projectthread_ownerowner

Schema diagram