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
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