Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | text | 2147483647 | √ | null |
|
|
||
| name | text | 2147483647 | √ | null |
|
|
||
| type | text | 2147483647 | √ | null |
|
|
||
| lat | float8 | 17,17 | √ | null |
|
|
||
| lng | float8 | 17,17 | √ | null |
|
|
||
| city | text | 2147483647 | √ | null |
|
|
||
| country | text | 2147483647 | √ | null |
|
|
||
| status | text | 2147483647 | √ | null |
|
|
||
| ec_legalbody | bool | 1 | √ | null |
|
|
||
| ec_legalperson | bool | 1 | √ | null |
|
|
||
| ec_nonprofit | bool | 1 | √ | null |
|
|
||
| ec_researchorganization | bool | 1 | √ | null |
|
|
||
| ec_highereducation | bool | 1 | √ | null |
|
|
||
| ec_internationalorganizationeurinterests | bool | 1 | √ | null |
|
|
||
| ec_internationalorganization | bool | 1 | √ | null |
|
|
||
| ec_enterprise | bool | 1 | √ | null |
|
|
||
| ec_smevalidated | bool | 1 | √ | null |
|
|
||
| ec_nutscode | bool | 1 | √ | null |
|
|
||
| openaire_id | text | 2147483647 | √ | null |
|
|
||
| openaire_persistent | bool | 1 | √ | null |
|
|
||
| other_ids | jsonb | 2147483647 | √ | null |
|
|
||
| other_names | jsonb | 2147483647 | √ | null |
|
|
||
| acronyms | jsonb | 2147483647 | √ | null |
|
|
||
| urls | jsonb | 2147483647 | √ | null |
|
|