Table: projectthread | |||
Groups together project-level comments with a common title, like an email thread | |||
Columns | |||
Name | Type | Constraints | Description |
systemid | INTEGER | NOT NULL | System-generated primary key |
project | INTEGER | NOT NULL | The project this thread is against |
owner | INTEGER | NOT NULL | Foreign key to the user who started this thread |
threadtitle | VARCHAR (100) | NOT NULL | Title of the thread |
Primary key | |||
Name | Columns | Description | |
pk_projectthread | systemid | ||
Foreign keys | |||
Name | Columns | Referenced table | Description |
fk_projectthread_project | project | project | |
fk_projectthread_systemuser | owner | systemuser | |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
fk_projectcomment_projectthread | projectthread | projectcomment | |
Indexes | |||
Name | Columns | Description | |
in_projectthread_project | project | ||
in_projectthread_owner | owner |