|
1
|
SELECT
|
|
2
|
po.project AS project,
|
|
3
|
po.resporganization AS resporganization,
|
|
4
|
po.participantnumber AS participantnumber,
|
|
5
|
po.contribution AS contribution,
|
|
6
|
NULL AS startdate,
|
|
7
|
NULL AS enddate,
|
|
8
|
false AS inferred,
|
|
9
|
false AS deletedbyinference,
|
|
10
|
po.trust AS trust,
|
|
11
|
NULL AS inferenceprovenance,
|
|
12
|
|
|
13
|
po.semanticclass || '@@@' || po.semanticclass || '@@@dnet:project_organization_relations@@@dnet:project_organization_relations' AS semantics,
|
|
14
|
'sysimport:crosswalk:entityregistry@@@sysimport:crosswalk:entityregistry@@@dnet:provenance_actions@@@dnet:provenance_actions' AS provenanceaction
|
|
15
|
|
|
16
|
FROM project_organization po
|