This table holds the data for the projects that each file or filegroup belongs to. The related authors table refers to this one.
The proprietary_expiration, last_addition, and proprietary_duration fields in this table are related: given any 2, you can easily calculate the third as:
proprietary_expiration = last_addition + proprietary_duration
It was decided that all three should be included, regardless of the potential for conflicting data.
Description:
Column | Type | Collation | Nullable | Default
------------------------+-----------------------------+-----------+----------+---------
project_code | character varying | | not null |
legacy_id | character varying | | |
total_observation_time | double precision | | |
opt_project_id | integer | | |
title | character varying | | |
abstract | text | | |
proprietary_expiration | timestamp without time zone | | |
last_addition | date | | |
starttime | double precision | | |
endtime | double precision | | |
proprietary_duration | double precision | | |
Indexes:
"projects_project_code_pkey" PRIMARY KEY, btree (project_code)
Referenced by:
TABLE "image_products" CONSTRAINT "image_products_project_code_fkey" FOREIGN KEY (project_code) REFERENCES projects(project_code)
TABLE "authors" CONSTRAINT "projects_authors_fk" FOREIGN KEY (project_code) REFERENCES projects(project_code) ON UPDATE CASCADE ON DELETE CASCADE
TABLE "execution_blocks" CONSTRAINT "projects_execution_blocks_fk" FOREIGN KEY (project_code) REFERENCES projects(project_code) ON UPDATE CASCADE ON DELETE CASCADE
TABLE "filegroups" CONSTRAINT "projects_filegroups_fk" FOREIGN KEY (project_code) REFERENCES projects(project_code) ON UPDATE CASCADE ON DELETE CASCADE
Columns:
project_code: the unique id for a project. Primarily taken from the Proposal Submission Tool, these codes are usually of the format 14A-336 for the VLA and BM0187 for the VLBA, though exceptions exist.
legacy_id: an alternate project code, used by some older pieces of NRAO software. This does not always exist.
total_observation_time: the total amount of time that the project has observed, in hours. this is calculated from the science data of the files attached to the project.
opt_project_id: the id of the project in the Observation Preparation Tool, if such and id exists and can be found.
title: the title attached to the project when it was submitted.
abstract: the abstract attached to the project when it was submitted.
proprietary_expiration: the date and time that the data attached to this project becomes publicly accessible. This is usually 6 months after the last observation.
last_addition: the date that data was last added to this project.
starttime: the start time of the earliest observation attached to this project.
endtime: the end time of the latest observation attached to this project.
proprietary_duration: the length of time that data attached to this project will remain proprietary after the last observation.