| Table: projectfile | |||
| Represents a file within a project that has been selected for review | |||
| Columns | |||
| Name | Type | Constraints | Description |
| systemid | INTEGER | NOT NULL | System-generated primary key |
| project | INTEGER | NOT NULL | The project this file belongs to |
| path | VARCHAR (500) | NOT NULL | Relative path to the file within the file set for the project |
| originalpath | VARCHAR (500) | Optional relative path to the original version of the file within the original file set for the project. Used when the file has been renamed or moved | |
| changetype | CHAR (1) | NOT NULL | Type of change made to this file between original and new versions. Values are: C: Changed A: Added R: Removed |
| notes | TEXT | Free-form notes to assist reviewers | |
| reviewpriority | SMALLINT | Priority of this file (1-3, 3 is highest) for reviewing | |
| Primary key | |||
| Name | Columns | Description | |
| pk_projectfile | systemid | ||
| Foreign keys | |||
| Name | Columns | Referenced table | Description |
| fk_projectfile_project | project | project | |
| Incoming foreign keys | |||
| Name | Columns | Referencing table | Description |
| fk_filecomment_projectfile | projectfile | filecomment | |
| Indexes | |||
| Name | Columns | Description | |
| in_projectfile_project_path | project, path | NOTE: This index should be used on all DB's but MySQL (which requires that a length be specified for the text column) | |