Table: projects
Legend: Primary key columns Indexed columns
Column Type Size Nulls Auto Default References Comments
id bigserial 19  χ   √  nextval('projects_id_seq'::regclass) Defines the directory under which a set of analyses is done. Will allow migration of content from PEcAn settings.xml files that are not specific to a particular workflow instance but rather are shared across a set of analyses out of the settings file and into the database. There might be multiple 'workflows' or analyses within a single project, but each of their workflows.outdir should be within the larger projects.outdir.
name varchar 255  χ   χ 
outdir varchar 255  χ   χ 
machine_id int8 19  √   χ  null
description varchar 255  χ   χ 
created_at timestamp 29,6  √   χ  utc_now()
updated_at timestamp 29,6  √   χ  utc_now()
Column(s) Type Sort Constraint Name
id Primary key Asc projects_pkey