Project

General

Profile

Revision c9c6b8e2

IDc9c6b8e21214f130d0ef756d036ea00d3987b345
Parent fc3346c1
Child 69637162

Added by Andreas Müller over 8 years ago

add timeperiod to descriptionElementBase #3312

View differences:

cdmlib-persistence/src/test/resources/dbscripts/001-cdm.h2.sql
1346 1346
    CREATED TIMESTAMP,
1347 1347
    UUID VARCHAR(36),
1348 1348
    UPDATED TIMESTAMP,
1349
    ORDERRELEVANT BOOLEAN,
1350 1349
    NAME VARCHAR(255),
1350
    TIMEPERIOD_START VARCHAR(255),
1351
    TIMEPERIOD_END VARCHAR(255),
1352
    TIMEPERIOD_FREETEXT VARCHAR(255),
1353
    ORDERRELEVANT BOOLEAN,
1351 1354
    CREATEDBY_ID INTEGER,
1352 1355
    UPDATEDBY_ID INTEGER,
1353 1356
    FEATURE_ID INTEGER,
......
1369 1372
    CREATED TIMESTAMP,
1370 1373
    UUID VARCHAR(36),
1371 1374
    UPDATED TIMESTAMP,
1375
    NAME VARCHAR(255),
1376
    TIMEPERIOD_START VARCHAR(255),
1377
    TIMEPERIOD_END VARCHAR(255),
1378
    TIMEPERIOD_FREETEXT VARCHAR(255),
1379
    ORDERRELEVANT BOOLEAN,
1372 1380
    CREATEDBY_ID INTEGER,
1373 1381
    UPDATEDBY_ID INTEGER,
1374 1382
    FEATURE_ID INTEGER,
......
1379 1387
    UNIT_ID INTEGER,
1380 1388
    FORMAT_ID INTEGER,
1381 1389
    ASSOCIATEDSPECIMENOROBSERVATION_ID INTEGER,
1382
    NAME VARCHAR(255),
1383
    LANGUAGE_ID INTEGER,
1384
    ORDERRELEVANT BOOLEAN
1390
    LANGUAGE_ID INTEGER
1385 1391
);
1386 1392
-- 0 +/- SELECT COUNT(*) FROM PUBLIC.DESCRIPTIONELEMENTBASE_AUD;
1387 1393
CREATE CACHED TABLE PUBLIC.DESCRIPTIONELEMENTBASE_ANNOTATION(

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)