| 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 | machines.id | |
| description | varchar | 255 | χ | χ | |||
| created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| updated_at | timestamp | 29,6 | √ | χ | utc_now() |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| id | Primary key | Asc | projects_pkey |
|
