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 | 100 | 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() |
|
|
|||||
| in_phase1_website | bool | 1 | √ | null |
|
|
Whether or not the proxy was available through the SGP Phase 1 search website |
||||
| in_phase2_website | bool | 1 | √ | null |
|
|
Whether or not the proxy was available through the SGP Phase 2 search website |
||||
| category | varchar | 2147483647 | √ | null |
|
|
Category of the proxy, as organized on the SGP search website (e.g. iron_sulfur, carbonate_proxy) |
||||
| api_code | varchar | 2147483647 | √ | null |
|
|
Short code, lower case, no special characters - equivalent to the api code used for analytes, for use on SGP website. |
||||
| website_proxy | varchar | 2147483647 | √ | null |
|
|
Formatted name for the proxy, as it should appear on the SGP search website. |
||||
| website_order | int4 | 10 | √ | null |
|
|
Order in which the proxy appears on the SGP search website (combined with website_order on the dic_analyte table) |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| proxy_id | Primary key | Asc | proxy_id |
Relationships
Close relationships within degrees of separation
