/[volute]/trunk/projects/theory/snapdm/output/ddl/SNAP_ddl.sql
ViewVC logotype

Contents of /trunk/projects/theory/snapdm/output/ddl/SNAP_ddl.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 225 - (show annotations)
Tue Apr 15 12:40:50 2008 UTC (12 years, 7 months ago) by bourges.laurent
File size: 6304 byte(s)
added ddl ouput
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