| id |
serial |
10 |
|
√ |
nextval('edp_core_tdta_project_id_seq'::regclass) |
|
|
Unique project identifier |
| name |
varchar |
255 |
|
|
null |
|
|
ESPON Project title - Mandatory, p.1.3.1.2 of the Specification |
| created |
timestamptz |
35,6 |
|
|
null |
|
|
ESPON project |
| updated |
timestamptz |
35,6 |
|
|
null |
|
|
ESPON project last update date |
| abstract |
text |
2147483647 |
√ |
|
null |
|
|
ESPON project description |
| leader |
varchar |
255 |
√ |
|
null |
|
|
ESPON responsible person name |
| acronym |
varchar |
20 |
√ |
|
null |
|
|
ESPON project acronym when existing |
| id_olddb |
int4 |
10 |
√ |
|
null |
|
|
ESPON Database 2013 project identity |
| status_id |
int4 |
10 |
√ |
|
null |
|
|
|
| url |
varchar |
200 |
√ |
|
null |
|
|
|
| workflow_state |
varchar |
20 |
|
|
null |
|
|
|
