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

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

Parent Directory Parent Directory | Revision Log Revision Log


Revision 357 - (show annotations)
Thu May 1 19:39:14 2008 UTC (12 years, 6 months ago) by bourges.laurent
File size: 5287 byte(s)
ULTRA BIG UPDATE :
- jpa : entity / id / superClass / temporal 
- many new classes in src/ : utils + JPA Environment for tests
- added run target in build.xml to launch unit tests

PS : Edit jpa.xsl to change Database settings
1 -- last modification date of the UML model 1209669938000
2
3 CREATE TABLE Resource (
4 id bigint not null
5 , DTYPE varchar(128)
6 , name varchar(256)
7 , description varchar(256)
8 , referenceURL varchar(256)
9 , created timestamp
10 , updated timestamp
11 , status varchar(256)
12 );
13
14
15 CREATE TABLE Curation (
16 id bigint not null
17 , DTYPE varchar(128)
18 , publisher varchar(256) not null
19 , creator varchar(256)
20 , contributor varchar(256)
21 , date timestamp
22 , version varchar(256)
23 , contactId bigint null--
24 );
25
26
27 CREATE TABLE Contact (
28 id bigint not null
29 , DTYPE varchar(128)
30 , name varchar(256) not null
31 , address varchar(256)
32 , email varchar(256)
33 , telephone varchar(256)
34 );
35
36
37 CREATE TABLE Simulation (
38 id bigint not null
39 , executionTime timestamp
40 );
41
42
43 CREATE TABLE Characterisation (
44 id bigint not null
45 , DTYPE varchar(128)
46 , value_value varchar(256) not null
47 , value_unit varchar(32)
48 , type varchar(256) -- CharacterisationType
49 , aPriori bit
50 , axisId bigint not null--
51 );
52
53
54 CREATE TABLE ObjectCollection (
55 id bigint not null
56 , DTYPE varchar(128)
57 , numberOfObjects integer
58 , objectTypeId bigint not null--
59 );
60
61
62 CREATE TABLE Experiment (
63 id bigint not null
64 , publisherDID varchar(256)
65 , protocolId bigint not null--
66 );
67
68
69 CREATE TABLE Snapshot (
70 id bigint not null
71 , DTYPE varchar(128)
72 , publisherDID varchar(256) not null
73 , time_value varchar(256) not null
74 , time_unit varchar(32)
75 , spatialSizePhysical_value varchar(256) not null
76 , spatialSizePhysical_unit varchar(32)
77 );
78
79
80 CREATE TABLE ClusterDetection (
81 id bigint not null
82 );
83
84
85 CREATE TABLE Algorithm (
86 id bigint not null
87 , DTYPE varchar(128)
88 , name varchar(256) not null
89 , description varchar(256)
90 , label varchar(256)
91 );
92
93
94 CREATE TABLE Visualisation (
95 id bigint not null
96 );
97
98
99 CREATE TABLE PostProcessing (
100 id bigint not null
101 , primaryExperimentId bigint null--
102 );
103
104
105 CREATE TABLE InputDataset (
106 id bigint not null
107 , DTYPE varchar(128)
108 , snapshotId bigint not null--
109 );
110
111
112 CREATE TABLE WebService (
113 id bigint not null
114 , DTYPE varchar(128)
115 , baseURL varchar(256) not null
116 , description varchar(256)
117 , type varchar(256) -- ServiceType
118 );
119
120
121 CREATE TABLE TargetProcess (
122 id bigint not null
123 , astroJournalSubject varchar(256)
124 );
125
126
127 CREATE TABLE ParameterSetting (
128 id bigint not null
129 , DTYPE varchar(128)
130 , inputParameterId bigint null--
131 );
132
133
134 CREATE TABLE AppliedPhysics (
135 id bigint not null
136 , DTYPE varchar(128)
137 , physicsId bigint not null--
138 );
139
140
141 CREATE TABLE SubvolumeExtraction (
142 id bigint not null
143 );
144
145
146 CREATE TABLE ExperimentRepresentationObject (
147 id bigint not null
148 , DTYPE varchar(128)
149 , typeId bigint not null--
150 );
151
152
153 CREATE TABLE ExperimentProperty (
154 id bigint not null
155 , DTYPE varchar(128)
156 , propertyId bigint not null--
157 );
158
159
160 CREATE TABLE TargetObjectType (
161 id bigint not null
162 , multiplicity varchar(256) -- Cardinality
163 , identityName varchar(256)
164 , astroJournalSubject varchar(256)
165 );
166
167
168 CREATE TABLE CompositeExperiment (
169 id bigint not null
170 );
171
172
173 CREATE TABLE CompositeProtocol (
174 id bigint not null
175 );
176
177
178 CREATE TABLE ChildExperiment (
179 id bigint not null
180 , DTYPE varchar(128)
181 , experimentId bigint not null--
182 );
183
184
185 CREATE TABLE ChildProtocol (
186 id bigint not null
187 , DTYPE varchar(128)
188 , protocolId bigint not null--
189 );
190
191
192 CREATE TABLE Physics (
193 id bigint not null
194 , DTYPE varchar(128)
195 , name varchar(256)
196 , description varchar(256)
197 , texForm varchar(256)
198 , physicslabel varchar(256)
199 );
200
201
202 CREATE TABLE Simulator (
203 id bigint not null
204 );
205
206
207 CREATE TABLE Protocol (
208 id bigint not null
209 , code varchar(256)
210 , version varchar(256)
211 );
212
213
214 CREATE TABLE ClusterFinder (
215 id bigint not null
216 );
217
218
219 CREATE TABLE Visualiser (
220 id bigint not null
221 );
222
223
224 CREATE TABLE InputParameter (
225 id bigint not null
226 , DTYPE varchar(128)
227 , name varchar(256)
228 , datatype varchar(256) -- DataType
229 , cardinality varchar(256) -- Cardinality
230 , label varchar(256)
231 , description varchar(256)
232 );
233
234
235 CREATE TABLE ParameterGroup (
236 id bigint not null
237 , DTYPE varchar(128)
238 , name varchar(256)
239 , description varchar(256)
240 );
241
242
243 CREATE TABLE ParameterGroupMember (
244 id bigint not null
245 , DTYPE varchar(128)
246 , parameterId bigint not null--
247 );
248
249
250 CREATE TABLE SubvolumeExtractor (
251 id bigint not null
252 );
253
254
255 CREATE TABLE RepresentationObjectType (
256 id bigint not null
257 , label varchar(256) -- RepresentationObject
258 , astroJournalSubject varchar(256)
259 );
260
261
262 CREATE TABLE ProjectExperiment (
263 id bigint not null
264 , DTYPE varchar(128)
265 , experimentId bigint not null--
266 );
267
268
269 CREATE TABLE Project (
270 id bigint not null
271 );
272
273
274 CREATE TABLE ChildObject (
275 id bigint not null
276 , DTYPE varchar(128)
277 , name varchar(32) not null
278 , cardinality varchar(256) -- Cardinality
279 , objectId bigint not null--
280 );
281
282
283 CREATE TABLE PropertyGroupMember (
284 id bigint not null
285 , DTYPE varchar(128)
286 , propertyId bigint not null--
287 );
288
289
290 CREATE TABLE PropertyGroup (
291 id bigint not null
292 , DTYPE varchar(128)
293 , name varchar(256) not null
294 , description varchar(256)
295 );
296
297
298 CREATE TABLE Property (
299 id bigint not null
300 , DTYPE varchar(128)
301 , name varchar(256) not null
302 , datatype varchar(256) -- DataType
303 , cardinality varchar(256) -- Cardinality
304 , ucd varchar(256)
305 , description varchar(256)
306 );
307
308
309 CREATE TABLE ObjectType (
310 id bigint not null
311 , DTYPE varchar(128)
312 , name varchar(32) not null
313 , description text
314 );
315

msdemlei@ari.uni-heidelberg.de
ViewVC Help
Powered by ViewVC 1.1.26