output/ddl/SNAP_ddl.sql


    
-- last modification date of the UML model 1208256514000

    
  CREATE TABLE SNAPResource (
    id bigint NOT NULL 
    
  
-- fields from SNAPResource
,
  name 
        varchar(256)
      
,
  description 
        varchar(256)
      
,
  referenceURL 
        varchar(256)
      
,
  created dateTime
,
  updated dateTime
,
  status 
        varchar(256)
      
  
-- fields from SNAPExperiment
,
  publisherDID 
        varchar(256)
      
,
protocolId bigint not null
  
-- fields from SNAPPostProcessing
,
primaryExperimentId bigint not null
  
-- fields from ClusterDetection
  
-- fields from SubvolumeExtraction
  
-- fields from Visualisation
  
-- fields from SNAPSimulation
,
  executionTime dateTime
  
-- fields from SNAPProject
  
-- fields from SNAPProtocol
,
  code 
        varchar(256)
      
,
  version 
        varchar(256)
      
  
-- fields from ClusterFinder
  
-- fields from SNAPSimulator
  
-- fields from SNAPVisualiser
  
-- fields from SubvolumeExtractor
  );


  CREATE TABLE Contact (
    id bigint NOT NULL 
    
  
-- fields from Contact
,
  name 
        varchar(256)
       not null
,
  address 
        varchar(256)
       not null
,
  email 
        varchar(256)
       not null
,
  telephone 
        varchar(256)
       not null
  );


  CREATE TABLE Curation (
    id bigint NOT NULL 
    
  
-- fields from Curation
,
  publisher 
        varchar(256)
       not null
,
  creator 
        varchar(256)
      
,
  contributor 
        varchar(256)
      
,
  date dateTime
,
  version 
        varchar(256)
       not null
,
contactId bigint
  );


  CREATE TABLE Algorithm (
    id bigint NOT NULL 
    
  
-- fields from Algorithm
,
  name 
        varchar(256)
       not null
,
  description 
        varchar(256)
       not null
,
  label 
        varchar(256)
       not null
  );


  CREATE TABLE AppliedPhysics (
    id bigint NOT NULL 
    
  
-- fields from AppliedPhysics
,
physicsId bigint not null
  );


  CREATE TABLE Characterisation (
    id bigint NOT NULL 
    
  
-- fields from Characterisationvalue0..1type0..1
,
  aPriori bit
,
axisId bigint not null
  );


  CREATE TABLE ChildObject (
    id bigint NOT NULL 
    
  
-- fields from ChildObject
,
  name 
        varchar(256)
       not nullcardinality0..1
,
objectId bigint not null
  );


  CREATE TABLE InputDataset (
    id bigint NOT NULL 
    
  
-- fields from InputDataset
,
snapshotId bigint not null
  );


  CREATE TABLE ObjectCollection (
    id bigint NOT NULL 
    
  
-- fields from ObjectCollection
,
  numberOfObjects integer
,
objectTypeId bigint not null
  );


  CREATE TABLE ObjectType (
    id bigint NOT NULL 
    
  
-- fields from ObjectType
,
  name 
        varchar(256)
       not null
,
  description 
        varchar(256)
      
  
-- fields from RepresentationObjectTypelabel0..1
,
  astroJournalSubject 
        varchar(256)
       not null
  
-- fields from TargetObjectTypemultiplicity1
,
  identityName 
        varchar(256)
       not null
,
  astroJournalSubject 
        varchar(256)
       not null
  );


  CREATE TABLE ParameterSetting (
    id bigint NOT NULL 
    
  
-- fields from ParameterSettingvalue1
,
inputParameterId bigint
  );


  CREATE TABLE Property (
    id bigint NOT NULL 
    
  
-- fields from Property
,
  name 
        varchar(256)
       not nulldatatype1cardinality1
,
  ucd 
        varchar(256)
       not null
,
  description 
        varchar(256)
       not null
  );


  CREATE TABLE PropertyGroup (
    id bigint NOT NULL 
    
  
-- fields from PropertyGroup
,
  name 
        varchar(256)
       not null
,
  description 
        varchar(256)
      
  );


  CREATE TABLE PropertyGroupMember (
    id bigint NOT NULL 
    
  
-- fields from PropertyGroupMember
,
propertyId bigint not null
  );


  CREATE TABLE SNAPWebService (
    id bigint NOT NULL 
    
  
-- fields from SNAPWebService
,
  baseURL 
        varchar(256)
       not null
,
  description 
        varchar(256)
       not nulltype1
  );


  CREATE TABLE Snapshot (
    id bigint NOT NULL 
    
  
-- fields from Snapshot
,
  publisherDID 
        varchar(256)
       not nulltime1spatialSizePhysical1
  );


  CREATE TABLE TargetProcess (
    id bigint NOT NULL 
    
  
-- fields from TargetProcess
,
  name 
        varchar(256)
       not null
,
  description 
        varchar(256)
       not null
,
  astroJournalSubject 
        varchar(256)
       not null
  );


  CREATE TABLE SNAPProjectExperiment (
    id bigint NOT NULL 
    
  
-- fields from SNAPProjectExperiment
,
experimentId bigint not null
  );


  CREATE TABLE InputParameter (
    id bigint NOT NULL 
    
  
-- fields from InputParameter
,
  name 
        varchar(256)
      datatype0..1cardinality0..1
,
  label 
        varchar(256)
      
,
  description 
        varchar(256)
      
  );


  CREATE TABLE ParameterGroup (
    id bigint NOT NULL 
    
  
-- fields from ParameterGroup
,
  name 
        varchar(256)
      
,
  description 
        varchar(256)
      
  );


  CREATE TABLE ParameterGroupMember (
    id bigint NOT NULL 
    
  
-- fields from ParameterGroupMember
,
parameterId bigint not null
  );


  CREATE TABLE Physics (
    id bigint NOT NULL 
    
  
-- fields from Physics
,
  name 
        varchar(256)
       not null
,
  description 
        varchar(256)
       not null
,
  texForm 
        varchar(256)
      
,
  physicslabel 
        varchar(256)
       not null
  );


  CREATE TABLE Ontology (
    id bigint NOT NULL 
    
  
-- fields from Ontology
,
  name 
        varchar(256)
       not null
,
  description 
        varchar(256)
       not null
,
  url 
        varchar(256)
       not null
  );


  CREATE TABLE Term (
    id bigint NOT NULL 
    
  
-- fields from Term
,
  name 
        varchar(256)
       not null
,
  description 
        varchar(256)
       not null
,
  uri 
        varchar(256)
       not null
  );


  CREATE TABLE Triple (
    id bigint NOT NULL 
    
  
-- fields from Triple
,
  name 
        varchar(256)
       not null
,
  description 
        varchar(256)
       not null
,
  uri 
        varchar(256)
       not null
,
toId bigint not null
,
fromId bigint not null
  );

1	bourges.laurent	225
2
3
4			-- last modification date of the UML model 1208256514000
5
6
7			CREATE TABLE SNAPResource (
8			id bigint NOT NULL
9
10
11			-- fields from SNAPResource
12			,
13			name
14			varchar(256)
15
16			,
17			description
18			varchar(256)
19
20			,
21			referenceURL
22			varchar(256)
23
24			,
25			created dateTime
26			,
27			updated dateTime
28			,
29			status
30			varchar(256)
31
32
33			-- fields from SNAPExperiment
34			,
35			publisherDID
36			varchar(256)
37
38			,
39			protocolId bigint not null
40
41			-- fields from SNAPPostProcessing
42			,
43			primaryExperimentId bigint not null
44
45			-- fields from ClusterDetection
46
47			-- fields from SubvolumeExtraction
48
49			-- fields from Visualisation
50
51			-- fields from SNAPSimulation
52			,
53			executionTime dateTime
54
55			-- fields from SNAPProject
56
57			-- fields from SNAPProtocol
58			,
59			code
60			varchar(256)
61
62			,
63			version
64			varchar(256)
65
66
67			-- fields from ClusterFinder
68
69			-- fields from SNAPSimulator
70
71			-- fields from SNAPVisualiser
72
73			-- fields from SubvolumeExtractor
74			);
75
76
77
78			CREATE TABLE Contact (
79			id bigint NOT NULL
80
81
82			-- fields from Contact
83			,
84			name
85			varchar(256)
86			not null
87			,
88			address
89			varchar(256)
90			not null
91			,
92			email
93			varchar(256)
94			not null
95			,
96			telephone
97			varchar(256)
98			not null
99			);
100
101
102
103			CREATE TABLE Curation (
104			id bigint NOT NULL
105
106
107			-- fields from Curation
108			,
109			publisher
110			varchar(256)
111			not null
112			,
113			creator
114			varchar(256)
115
116			,
117			contributor
118			varchar(256)
119
120			,
121			date dateTime
122			,
123			version
124			varchar(256)
125			not null
126			,
127			contactId bigint
128			);
129
130
131
132			CREATE TABLE Algorithm (
133			id bigint NOT NULL
134
135
136			-- fields from Algorithm
137			,
138			name
139			varchar(256)
140			not null
141			,
142			description
143			varchar(256)
144			not null
145			,
146			label
147			varchar(256)
148			not null
149			);
150
151
152
153			CREATE TABLE AppliedPhysics (
154			id bigint NOT NULL
155
156
157			-- fields from AppliedPhysics
158			,
159			physicsId bigint not null
160			);
161
162
163
164			CREATE TABLE Characterisation (
165			id bigint NOT NULL
166
167
168			-- fields from Characterisationvalue0..1type0..1
169			,
170			aPriori bit
171			,
172			axisId bigint not null
173			);
174
175
176
177			CREATE TABLE ChildObject (
178			id bigint NOT NULL
179
180
181			-- fields from ChildObject
182			,
183			name
184			varchar(256)
185			not nullcardinality0..1
186			,
187			objectId bigint not null
188			);
189
190
191
192			CREATE TABLE InputDataset (
193			id bigint NOT NULL
194
195
196			-- fields from InputDataset
197			,
198			snapshotId bigint not null
199			);
200
201
202
203			CREATE TABLE ObjectCollection (
204			id bigint NOT NULL
205
206
207			-- fields from ObjectCollection
208			,
209			numberOfObjects integer
210			,
211			objectTypeId bigint not null
212			);
213
214
215
216			CREATE TABLE ObjectType (
217			id bigint NOT NULL
218
219
220			-- fields from ObjectType
221			,
222			name
223			varchar(256)
224			not null
225			,
226			description
227			varchar(256)
228
229
230			-- fields from RepresentationObjectTypelabel0..1
231			,
232			astroJournalSubject
233			varchar(256)
234			not null
235
236			-- fields from TargetObjectTypemultiplicity1
237			,
238			identityName
239			varchar(256)
240			not null
241			,
242			astroJournalSubject
243			varchar(256)
244			not null
245			);
246
247
248
249			CREATE TABLE ParameterSetting (
250			id bigint NOT NULL
251
252
253			-- fields from ParameterSettingvalue1
254			,
255			inputParameterId bigint
256			);
257
258
259
260			CREATE TABLE Property (
261			id bigint NOT NULL
262
263
264			-- fields from Property
265			,
266			name
267			varchar(256)
268			not nulldatatype1cardinality1
269			,
270			ucd
271			varchar(256)
272			not null
273			,
274			description
275			varchar(256)
276			not null
277			);
278
279
280
281			CREATE TABLE PropertyGroup (
282			id bigint NOT NULL
283
284
285			-- fields from PropertyGroup
286			,
287			name
288			varchar(256)
289			not null
290			,
291			description
292			varchar(256)
293
294			);
295
296
297
298			CREATE TABLE PropertyGroupMember (
299			id bigint NOT NULL
300
301
302			-- fields from PropertyGroupMember
303			,
304			propertyId bigint not null
305			);
306
307
308
309			CREATE TABLE SNAPWebService (
310			id bigint NOT NULL
311
312
313			-- fields from SNAPWebService
314			,
315			baseURL
316			varchar(256)
317			not null
318			,
319			description
320			varchar(256)
321			not nulltype1
322			);
323
324
325
326			CREATE TABLE Snapshot (
327			id bigint NOT NULL
328
329
330			-- fields from Snapshot
331			,
332			publisherDID
333			varchar(256)
334			not nulltime1spatialSizePhysical1
335			);
336
337
338
339			CREATE TABLE TargetProcess (
340			id bigint NOT NULL
341
342
343			-- fields from TargetProcess
344			,
345			name
346			varchar(256)
347			not null
348			,
349			description
350			varchar(256)
351			not null
352			,
353			astroJournalSubject
354			varchar(256)
355			not null
356			);
357
358
359
360			CREATE TABLE SNAPProjectExperiment (
361			id bigint NOT NULL
362
363
364			-- fields from SNAPProjectExperiment
365			,
366			experimentId bigint not null
367			);
368
369
370
371			CREATE TABLE InputParameter (
372			id bigint NOT NULL
373
374
375			-- fields from InputParameter
376			,
377			name
378			varchar(256)
379			datatype0..1cardinality0..1
380			,
381			label
382			varchar(256)
383
384			,
385			description
386			varchar(256)
387
388			);
389
390
391
392			CREATE TABLE ParameterGroup (
393			id bigint NOT NULL
394
395
396			-- fields from ParameterGroup
397			,
398			name
399			varchar(256)
400
401			,
402			description
403			varchar(256)
404
405			);
406
407
408
409			CREATE TABLE ParameterGroupMember (
410			id bigint NOT NULL
411
412
413			-- fields from ParameterGroupMember
414			,
415			parameterId bigint not null
416			);
417
418
419
420			CREATE TABLE Physics (
421			id bigint NOT NULL
422
423
424			-- fields from Physics
425			,
426			name
427			varchar(256)
428			not null
429			,
430			description
431			varchar(256)
432			not null
433			,
434			texForm
435			varchar(256)
436
437			,
438			physicslabel
439			varchar(256)
440			not null
441			);
442
443
444
445			CREATE TABLE Ontology (
446			id bigint NOT NULL
447
448
449			-- fields from Ontology
450			,
451			name
452			varchar(256)
453			not null
454			,
455			description
456			varchar(256)
457			not null
458			,
459			url
460			varchar(256)
461			not null
462			);
463
464
465
466			CREATE TABLE Term (
467			id bigint NOT NULL
468
469
470			-- fields from Term
471			,
472			name
473			varchar(256)
474			not null
475			,
476			description
477			varchar(256)
478			not null
479			,
480			uri
481			varchar(256)
482			not null
483			);
484
485
486
487			CREATE TABLE Triple (
488			id bigint NOT NULL
489
490
491			-- fields from Triple
492			,
493			name
494			varchar(256)
495			not null
496			,
497			description
498			varchar(256)
499			not null
500			,
501			uri
502			varchar(256)
503			not null
504			,
505			toId bigint not null
506			,
507			fromId bigint not null
508			);
509
msdemlei@ari.uni-heidelberg.de	ViewVC Help
Powered by ViewVC 1.1.26