|
1
|
SELECT po.project as project,
|
|
2
|
po.resporganization as resporganization,
|
|
3
|
po.participantnumber as participantnumber,
|
|
4
|
po.startdate as startdate,
|
|
5
|
po.enddate as enddate,
|
|
6
|
po.inferred as inferred,
|
|
7
|
po.deletedbyinference as deletedbyinference,
|
|
8
|
po.trust as trust,
|
|
9
|
po.inferenceprovenance as inferenceprovenance,
|
|
10
|
|
|
11
|
poc.code || '@@@' || poc.name || '@@@' || pos.code || '@@@' || pos.name as semantics,
|
|
12
|
pac.code || '@@@' || pac.name || '@@@' || pas.code || '@@@' || pas.name as provenanceaction
|
|
13
|
|
|
14
|
FROM project_organization po
|
|
15
|
|
|
16
|
left outer join projects p on (po.project = p.id)
|
|
17
|
|
|
18
|
left outer join class pac on (pac.code = p.provenanceactionclass)
|
|
19
|
left outer join scheme pas on (pas.code = p.provenanceactionscheme)
|
|
20
|
|
|
21
|
left outer join class poc on (poc.code = po.semanticclass)
|
|
22
|
left outer join scheme pos on (pos.code = po.semanticscheme)
|