Revision 52c34f45
Added by Andreas Müller almost 8 years ago
cdmlib-test/src/main/resources/dbscripts/001-cdm.h2.sql | ||
---|---|---|
448 | 448 |
UUID VARCHAR(36), |
449 | 449 |
UPDATED TIMESTAMP, |
450 | 450 |
TEXT CLOB, |
451 |
ANNOTATEDOBJ_TYPE VARCHAR(255), |
|
452 |
ANNOTATEDOBJ_ID INTEGER NOT NULL, |
|
453 | 451 |
LINKBACKURI CLOB, |
454 | 452 |
CREATEDBY_ID INTEGER, |
455 | 453 |
UPDATEDBY_ID INTEGER, |
... | ... | |
1744 | 1742 |
CREATED TIMESTAMP, |
1745 | 1743 |
UUID VARCHAR(36), |
1746 | 1744 |
UPDATED TIMESTAMP, |
1747 |
EXTENDEDOBJ_TYPE VARCHAR(255), |
|
1748 |
EXTENDEDOBJ_ID INTEGER NOT NULL, |
|
1749 | 1745 |
VALUE CLOB, |
1750 | 1746 |
CREATEDBY_ID INTEGER, |
1751 | 1747 |
UPDATEDBY_ID INTEGER, |
... | ... | |
2176 | 2172 |
UUID VARCHAR(36), |
2177 | 2173 |
CREATED TIMESTAMP, |
2178 | 2174 |
UPDATED TIMESTAMP, |
2179 |
IDENTIFIEDOBJ_TYPE VARCHAR(255), |
|
2180 |
IDENTIFIEDOBJ_ID INTEGER, |
|
2181 | 2175 |
IDENTIFIER VARCHAR(800), |
2182 | 2176 |
CREATEDBY_ID INTEGER, |
2183 | 2177 |
UPDATEDBY_ID INTEGER, |
... | ... | |
2191 | 2185 |
UUID VARCHAR(36), |
2192 | 2186 |
CREATED TIMESTAMP, |
2193 | 2187 |
UPDATED TIMESTAMP, |
2194 |
IDENTIFIEDOBJ_TYPE VARCHAR(255), |
|
2195 |
IDENTIFIEDOBJ_ID INTEGER, |
|
2196 | 2188 |
IDENTIFIER VARCHAR(800), |
2197 | 2189 |
CREATEDBY_ID INTEGER, |
2198 | 2190 |
UPDATEDBY_ID INTEGER, |
... | ... | |
2436 | 2428 |
UUID VARCHAR(36), |
2437 | 2429 |
UPDATED TIMESTAMP, |
2438 | 2430 |
FLAG BOOLEAN NOT NULL, |
2439 |
MARKEDOBJ_TYPE VARCHAR(255), |
|
2440 |
MARKEDOBJ_ID INTEGER NOT NULL, |
|
2441 | 2431 |
CREATEDBY_ID INTEGER, |
2442 | 2432 |
UPDATEDBY_ID INTEGER, |
2443 | 2433 |
MARKERTYPE_ID INTEGER |
... | ... | |
3004 | 2994 |
ORIGINALNAMESTRING VARCHAR(255), |
3005 | 2995 |
IDINSOURCE VARCHAR(255), |
3006 | 2996 |
IDNAMESPACE VARCHAR(255), |
3007 |
SOURCEDOBJ_TYPE VARCHAR(255), |
|
3008 |
SOURCEDOBJ_ID INTEGER NOT NULL, |
|
3009 | 2997 |
CREATEDBY_ID INTEGER, |
3010 | 2998 |
UPDATEDBY_ID INTEGER, |
3011 | 2999 |
CITATION_ID INTEGER, |
Also available in: Unified diff
Remove bidirectionality for supplemental data #5743