Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('gobs.protocol_id_seq'::regclass) |
|
|
ID |
||||
| pr_code | text | 2147483647 | null |
|
|
Code |
|||||
| pr_label | text | 2147483647 | null |
|
|
Name of the indicator |
|||||
| pr_description | text | 2147483647 | null |
|
|
Description, including URLs to references and authors. |
|||||
| pr_days_editable | int4 | 10 | 30 |
|
|
Number of days the observations from series related to the protocol are editable (delete & update) after creation. Use a very long value such as 10000 if the editing can occur at any time. The control is made based on the observation created_at column |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| protocol_pkey | Primary key | Asc | id |
| protocol_pr_code_idx | Performance | Asc | pr_code |
Relationships
Close relationships within degrees of separation
