Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('ecapris_subproject_statuses_id_seq'::regclass) |
|
|
Primary key for the table |
|||
| ecapris_subproject_id | text | 2147483647 | null |
|
|
eCapris subproject ID number |
||||
| subproject_name | text | 2147483647 | null |
|
|
Name of eCapris subproject |
||||
| subproject_status_id | int4 | 10 | null |
|
|
Unique ID of subproject status from eCapris |
||||
| current_status_fl | bool | 1 | null |
|
|
Is this the current and most recent status? |
||||
| sub_project_status_desc | text | 2147483647 | √ | null |
|
|
Content of the subproject status |
|||
| review_timestamp | timestamptz | 35,6 | null |
|
|
Timestamp of the status update - MM/DD/YYYY HH:MM:SS format |
||||
| subproject_status_impacts | text | 2147483647 | √ | null |
|
|
Updates on project blockers |
|||
| summary_description | text | 2147483647 | √ | null |
|
|
More of a public-ready status could be used down the road; nullable in eCapris |
|||
| reviewed_by_name | text | 2147483647 | null |
|
|
First and last name of author; nullable in eCapris |
||||
| reviewed_by_email | text | 2147483647 | √ | null |
|
|
Email of author |
|||
| created_at | timestamptz | 35,6 | now() |
|
|
Timestamp when the record was created |
||||
| updated_at | timestamptz | 35,6 | now() |
|
|
Timestamp when the record was last updated |
||||
| created_by_user_id | int4 | 10 | √ | null |
|
|
ID of the user who created the record |
|||
| updated_by_user_id | int4 | 10 | √ | null |
|
|
ID of the user who updated the record |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ecapris_subproject_statuses_pkey | Primary key | Asc | id |
| ecapris_subproject_statuses_subproject_status_id_key | Must be unique | Asc | subproject_status_id |