| 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 | ||