Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| proxy_id | serial | 10 | √ | nextval('dic_proxy_proxy_id_seq'::regclass) |
|
|
PK. Unique identifier. Generated by the database |
|||
| proxy | varchar | 20 | null |
|
|
Proxy abbreviation or code (e.g. FeHR/FeT, FePR, Ni/Co etc.) |
||||
| proxy_desc | varchar | 255 | √ | null |
|
|
Longer description or breakdown of proxy |
|||
| proxy_notes | varchar | 4000 | √ | null |
|
|
Notes about the proxy (e.g. updated method for determining highly-reactive to total iron) |
|||
| reference_id | int4 | 10 | √ | null |
|
|
FK. ID for the publication which originally described the proxy. Links to reference_work table |
|||
| timestamp_created | timestamptz | 35,6 | now() |
|
|
|||||
| timestamp_modified | timestamptz | 35,6 | √ | now() |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| proxy_id | Primary key | Asc | proxy_id |
Relationships
Close relationships within degrees of separation
