[Adminsys-commits] r105 - in tutti/test/services: . dbImportBigfin

Author: kmorin Date: 2014-09-30 15:15:47 +0200 (Tue, 30 Sep 2014) New Revision: 105 Url: http://forge.codelutin.com/projects/adminsys/repository/revisions/105 Log: add test data for bigfin import Added: tutti/test/services/dbImportBigfin/ tutti/test/services/dbImportBigfin/allegro.backup tutti/test/services/dbImportBigfin/allegro.data tutti/test/services/dbImportBigfin/allegro.log tutti/test/services/dbImportBigfin/allegro.properties tutti/test/services/dbImportBigfin/allegro.script tutti/test/services/dbImportBigfin/protocol.tuttiProtocol tutti/test/services/dbImportBigfin/version.appup Added: tutti/test/services/dbImportBigfin/allegro.backup =================================================================== (Binary files differ) Property changes on: tutti/test/services/dbImportBigfin/allegro.backup ___________________________________________________________________ Added: svn:mime-type + application/octet-stream Added: tutti/test/services/dbImportBigfin/allegro.data =================================================================== (Binary files differ) Property changes on: tutti/test/services/dbImportBigfin/allegro.data ___________________________________________________________________ Added: svn:mime-type + application/octet-stream Added: tutti/test/services/dbImportBigfin/allegro.log =================================================================== --- tutti/test/services/dbImportBigfin/allegro.log (rev 0) +++ tutti/test/services/dbImportBigfin/allegro.log 2014-09-30 13:15:47 UTC (rev 105) @@ -0,0 +1,806 @@ +/*C111*/SET SCHEMA PUBLIC +CONNECT USER SA +DISCONNECT +/*C112*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C113*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C114*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C115*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C116*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C117*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C118*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C119*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C120*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C121*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C122*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C123*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C124*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C125*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C126*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C127*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C128*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C129*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C130*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C131*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C132*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C133*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C134*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C135*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C136*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C137*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C138*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C139*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C140*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C141*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C142*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C143*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C144*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C145*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C146*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C147*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C148*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C149*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C150*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C151*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C152*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C153*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C154*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C155*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C156*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C157*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C158*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C159*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C160*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C161*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C162*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C163*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C164*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C165*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C166*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C167*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C168*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C169*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C170*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C171*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C172*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C173*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C174*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C175*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C176*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C177*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C178*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C179*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C180*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C181*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C182*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C183*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C184*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C185*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C186*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C187*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C188*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C189*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C190*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C191*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C192*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C193*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C194*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C195*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C196*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C197*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C198*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C199*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +DELETE FROM SORTING_MEASUREMENT WHERE ID=840 +DELETE FROM BATCH WHERE ID=899 +DELETE FROM SORTING_MEASUREMENT WHERE ID=841 +DELETE FROM BATCH WHERE ID=900 +DELETE FROM BATCH WHERE ID=898 +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C200*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +DELETE FROM BATCH WHERE ID=889 +INSERT INTO BATCH VALUES(889,0,2,1.0E0,NULL,FALSE,TRUE,NULL,NULL,887,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +DELETE FROM BATCH WHERE ID=895 +INSERT INTO BATCH VALUES(895,0,1,NULL,1,FALSE,FALSE,NULL,NULL,889,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +DELETE FROM QUANTIFICATION_MEASUREMENT WHERE ID=508 +INSERT INTO QUANTIFICATION_MEASUREMENT VALUES(508,0.10000000149011612E0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,220,NULL,NULL,'0',NULL,NULL,TRUE,895) +DELETE FROM SORTING_MEASUREMENT WHERE ID=837 +INSERT INTO SORTING_MEASUREMENT VALUES(837,12.0E0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,1416,NULL,NULL,'0',NULL,1,895) +DELETE FROM BATCH WHERE ID=896 +INSERT INTO BATCH VALUES(896,0,2,NULL,2,FALSE,FALSE,NULL,NULL,889,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +DELETE FROM QUANTIFICATION_MEASUREMENT WHERE ID=509 +INSERT INTO QUANTIFICATION_MEASUREMENT VALUES(509,0.20000000298023224E0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,220,NULL,NULL,'0',NULL,NULL,TRUE,896) +DELETE FROM SORTING_MEASUREMENT WHERE ID=838 +INSERT INTO SORTING_MEASUREMENT VALUES(838,12.5E0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,1416,NULL,NULL,'0',NULL,1,896) +DELETE FROM BATCH WHERE ID=897 +INSERT INTO BATCH VALUES(897,0,3,NULL,3,FALSE,FALSE,NULL,NULL,889,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +DELETE FROM QUANTIFICATION_MEASUREMENT WHERE ID=510 +INSERT INTO QUANTIFICATION_MEASUREMENT VALUES(510,0.30000001192092896E0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,220,NULL,NULL,'0',NULL,NULL,TRUE,897) +DELETE FROM SORTING_MEASUREMENT WHERE ID=839 +INSERT INTO SORTING_MEASUREMENT VALUES(839,13.0E0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,1416,NULL,NULL,'0',NULL,1,897) +DELETE FROM SORTING_MEASUREMENT WHERE ID=831 +INSERT INTO SORTING_MEASUREMENT VALUES(831,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,196,NULL,NULL,'0',301,1,889) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C201*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +DELETE FROM QUANTIFICATION_MEASUREMENT WHERE ID=508 +DELETE FROM SORTING_MEASUREMENT WHERE ID=837 +DELETE FROM BATCH WHERE ID=895 +DELETE FROM QUANTIFICATION_MEASUREMENT WHERE ID=509 +DELETE FROM SORTING_MEASUREMENT WHERE ID=838 +DELETE FROM BATCH WHERE ID=896 +DELETE FROM QUANTIFICATION_MEASUREMENT WHERE ID=510 +DELETE FROM SORTING_MEASUREMENT WHERE ID=839 +DELETE FROM BATCH WHERE ID=897 +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C202*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 902 +ALTER SEQUENCE SORTING_MEASUREMENT_SEQ RESTART WITH 843 +INSERT INTO BATCH VALUES(901,0,1,1.0E0,NULL,FALSE,TRUE,NULL,NULL,889,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +INSERT INTO SORTING_MEASUREMENT VALUES(842,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,174,NULL,NULL,'0',272,1,901) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C203*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C204*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 903 +ALTER SEQUENCE SORTING_MEASUREMENT_SEQ RESTART WITH 844 +INSERT INTO BATCH VALUES(902,0,2,1.0E0,NULL,FALSE,TRUE,NULL,NULL,889,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +INSERT INTO SORTING_MEASUREMENT VALUES(843,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,174,NULL,NULL,'0',273,1,902) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C205*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C206*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 904 +ALTER SEQUENCE SORTING_MEASUREMENT_SEQ RESTART WITH 845 +INSERT INTO BATCH VALUES(903,0,3,1.0E0,NULL,FALSE,TRUE,NULL,NULL,889,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +INSERT INTO SORTING_MEASUREMENT VALUES(844,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,174,NULL,NULL,'0',274,1,903) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C207*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C208*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +DELETE FROM BATCH WHERE ID=903 +INSERT INTO BATCH VALUES(903,0,3,1.0E0,NULL,FALSE,TRUE,NULL,NULL,889,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +DELETE FROM SORTING_MEASUREMENT WHERE ID=844 +INSERT INTO SORTING_MEASUREMENT VALUES(844,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,174,NULL,NULL,'0',274,1,903) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C209*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C210*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 905 +ALTER SEQUENCE SORTING_MEASUREMENT_SEQ RESTART WITH 846 +INSERT INTO BATCH VALUES(904,0,1,1.0E0,NULL,FALSE,TRUE,NULL,NULL,886,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +INSERT INTO SORTING_MEASUREMENT VALUES(845,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,196,NULL,NULL,'0',300,1,904) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C211*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C212*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +DELETE FROM BATCH WHERE ID=904 +INSERT INTO BATCH VALUES(904,0,1,1.0E0,NULL,FALSE,TRUE,NULL,NULL,886,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +DELETE FROM SORTING_MEASUREMENT WHERE ID=845 +INSERT INTO SORTING_MEASUREMENT VALUES(845,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,196,NULL,NULL,'0',300,1,904) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C213*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C214*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 906 +INSERT INTO BATCH VALUES(905,0,2,1.0E0,NULL,FALSE,TRUE,NULL,NULL,3,NULL,NULL,1662,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C215*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C216*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 907 +ALTER SEQUENCE SORTING_MEASUREMENT_SEQ RESTART WITH 847 +INSERT INTO BATCH VALUES(906,0,1,1.0E0,NULL,FALSE,TRUE,NULL,NULL,905,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +INSERT INTO SORTING_MEASUREMENT VALUES(846,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,196,NULL,NULL,'0',300,1,906) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C217*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C218*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 908 +ALTER SEQUENCE SORTING_MEASUREMENT_SEQ RESTART WITH 848 +INSERT INTO BATCH VALUES(907,0,2,1.0E0,NULL,FALSE,TRUE,NULL,NULL,905,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +INSERT INTO SORTING_MEASUREMENT VALUES(847,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,196,NULL,NULL,'0',301,1,907) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C219*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C220*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +DELETE FROM BATCH WHERE ID=907 +INSERT INTO BATCH VALUES(907,0,2,1.0E0,NULL,FALSE,TRUE,NULL,NULL,905,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +DELETE FROM SORTING_MEASUREMENT WHERE ID=847 +INSERT INTO SORTING_MEASUREMENT VALUES(847,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,196,NULL,NULL,'0',301,1,907) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C221*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C222*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 909 +INSERT INTO BATCH VALUES(908,0,1,1.0E0,NULL,FALSE,TRUE,NULL,NULL,174,NULL,NULL,4100,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C223*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C224*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 910 +ALTER SEQUENCE SORTING_MEASUREMENT_SEQ RESTART WITH 849 +INSERT INTO BATCH VALUES(909,0,1,1.0E0,NULL,FALSE,TRUE,NULL,NULL,908,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +INSERT INTO SORTING_MEASUREMENT VALUES(848,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,174,NULL,NULL,'0',272,1,909) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C225*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C226*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +ALTER SEQUENCE BATCH_SEQ RESTART WITH 911 +ALTER SEQUENCE SORTING_MEASUREMENT_SEQ RESTART WITH 850 +INSERT INTO BATCH VALUES(910,0,2,1.0E0,NULL,FALSE,TRUE,NULL,NULL,908,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +INSERT INTO SORTING_MEASUREMENT VALUES(849,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,174,NULL,NULL,'0',273,1,910) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C227*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C228*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +DELETE FROM BATCH WHERE ID=910 +INSERT INTO BATCH VALUES(910,0,2,1.0E0,NULL,FALSE,TRUE,NULL,NULL,908,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL) +DELETE FROM SORTING_MEASUREMENT WHERE ID=849 +INSERT INTO SORTING_MEASUREMENT VALUES(849,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,181,174,NULL,NULL,'0',273,1,910) +COMMIT +SET AUTOCOMMIT TRUE +DISCONNECT +/*C229*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C230*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C231*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C232*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C233*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C234*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C235*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C236*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C237*/SET SCHEMA PUBLIC +CONNECT USER SA +DISCONNECT +/*C238*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C239*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C240*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C241*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C242*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C243*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C244*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C245*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C246*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C247*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C248*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C249*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C250*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT +/*C251*/SET SCHEMA PUBLIC +CONNECT USER SA +SET AUTOCOMMIT FALSE +SET AUTOCOMMIT TRUE +DISCONNECT Added: tutti/test/services/dbImportBigfin/allegro.properties =================================================================== --- tutti/test/services/dbImportBigfin/allegro.properties (rev 0) +++ tutti/test/services/dbImportBigfin/allegro.properties 2014-09-30 13:15:47 UTC (rev 105) @@ -0,0 +1,18 @@ +#HSQL Database Engine 1.8.0.10 +#Mon Sep 22 16:10:12 CEST 2014 +hsqldb.script_format=0 +runtime.gc_interval=0 +sql.enforce_strict_size=false +hsqldb.cache_size_scale=8 +readonly=true +hsqldb.nio_data_file=true +hsqldb.cache_scale=14 +version=1.8.0 +hsqldb.default_table_type=cached +hsqldb.cache_file_scale=1 +hsqldb.lock_file=true +hsqldb.log_size=200 +modified=yes +hsqldb.cache_version=1.7.0 +hsqldb.original_version=1.8.0 +hsqldb.compatible_version=1.8.0 Added: tutti/test/services/dbImportBigfin/allegro.script =================================================================== --- tutti/test/services/dbImportBigfin/allegro.script (rev 0) +++ tutti/test/services/dbImportBigfin/allegro.script 2014-09-30 13:15:47 UTC (rev 105) @@ -0,0 +1,938 @@ +CREATE SCHEMA PUBLIC AUTHORIZATION DBA +CREATE SEQUENCE ACTIVITY_CALENDAR_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE APPLIED_QUALIFICATION_RULE_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE BATCH_MODEL_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE BATCH_SEQ AS INTEGER START WITH 901 +CREATE SEQUENCE BLOC_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE CRITERIA_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE DAILY_ACTIVITY_CALENDAR_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE DECLARED_DOCUMENT_REFERENC_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE DELETED_ITEM_HISTORY_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE DENORMALIZED_BATCH_SORT_VA_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE ECONOMICAL_SURVEY_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE EXPECTED_SALE_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE FILTER_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE FISHING_AREA_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE FISHING_EFFORT_CALENDAR_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE FISHING_TRIP_ORIGIN_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE FISHING_TRIP_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE GEAR_PHYSICAL_FEATURES_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE GEAR_PHYSICAL_MEASUREMENT_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE GEAR_USE_FEATURES_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE GEAR_USE_MEASUREMENT_SEQ AS INTEGER START WITH 5 +CREATE SEQUENCE LANDING_MEASUREMENT_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE LANDING_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE LINKED_ITEM_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE LINKED_PROPERTY_CRITERIA_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE MEASUREMENT_FILE_SEQ AS INTEGER START WITH 56 +CREATE SEQUENCE OPERATION_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE OPERATOR_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE OR_CRITERIA_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE PHOTO_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE PHYSICAL_GEAR_SURVEY_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE PROCESSING_HISTORY_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE PRODUCE_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE QUALIFIED_ITEM_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE QUANTIFICATION_MEASUREMENT_SEQ AS INTEGER START WITH 511 +CREATE SEQUENCE RVALUE_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE SALE_MEASUREMENT_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE SALE_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE SAMPLE_MEASUREMENT_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE SAMPLE_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE SCIENTIFIC_CRUISE_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE SORTING_MEASUREMENT_SEQ AS INTEGER START WITH 842 +CREATE SEQUENCE SURVEY_MEASUREMENT_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE TAKE_OVER_MEASUREMENT_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE TAKE_OVER_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE TEMP_QUERY_PARAMETER_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE TRANSSHIPMENT_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE UTIL_FACTORY_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE VESSEL_PHYSICAL_FEATURES_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE VESSEL_PHYSICAL_MEASUREMEN_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE VESSEL_POSITION_MEASUREMEN_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE VESSEL_POSITION_SEQ AS INTEGER START WITH 2 +CREATE SEQUENCE VESSEL_USE_FEATURES_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE VESSEL_USE_MEASUREMENT_SEQ AS INTEGER START WITH 2 +CREATE SEQUENCE BATCH_EXHAUSTIVE_INVENTORY_SEQ AS INTEGER START WITH 0 +CREATE SEQUENCE INSERTED_ITEM_HISTORY_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE SORTING_MEASUREMENT_P_SEQ AS INTEGER START WITH 2 +CREATE SEQUENCE UPDATED_ITEM_HISTORY_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE VESSEL_PERSON_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE VESSEL_PERSON_FEATURES_SEQ AS INTEGER START WITH 2 +CREATE SEQUENCE VESSEL_PERSON_MEASUREMENT_SEQ AS INTEGER START WITH 1 +CREATE SEQUENCE SYSTEM_VERSION_SEQ AS INTEGER START WITH 11 +CREATE SEQUENCE OBSERVED_LOCATION_SEQ AS BIGINT START WITH 0 +CREATE SEQUENCE DENORMALIZED_VESSEL_SEQ AS BIGINT START WITH 0 +CREATE SEQUENCE OBSERVED_LOCATION_FEATURES_SEQ AS BIGINT START WITH 0 +CREATE SEQUENCE OBSERVED_LOCATION_MEASUREM_SEQ AS BIGINT START WITH 0 +CREATE SEQUENCE QUANTIFICATION_MEASUREMENT_P_SEQ AS BIGINT START WITH 1 +CREATE CACHED TABLE ACQUISITION_LEVEL(CODE VARCHAR(40) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL) +CREATE CACHED TABLE ACTIVITY_CALENDAR(ID INTEGER NOT NULL PRIMARY KEY,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,YEAR INTEGER NOT NULL,DIRECT_SURVEY_INVESTIGATION BOOLEAN NOT NULL,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,RECORDER_PERSON_FK INTEGER,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,FISHING_EFFORT_CALENDAR_FK INTEGER,CONSTRAINT SYS_CT_48 UNIQUE(FISHING_EFFORT_CALENDAR_FK)) +CREATE INDEX ACTIVITY_CALENDAR_NATIDX ON ACTIVITY_CALENDAR(YEAR,PROGRAM_FK,VESSEL_FK) +CREATE INDEX IX_RMTID_ACTIVITY_CALENDAR ON ACTIVITY_CALENDAR(REMOTE_ID) +CREATE INDEX IX_ACTIVITY_CALENDAR_UD ON ACTIVITY_CALENDAR(UPDATE_DATE) +CREATE CACHED TABLE AGE_READER_QUAL2LOCATION(AGE_READER_QUALIFICATION_FK INTEGER NOT NULL,LOCATION_FK INTEGER NOT NULL,PRIMARY KEY(AGE_READER_QUALIFICATION_FK,LOCATION_FK)) +CREATE CACHED TABLE AGE_READER_QUALIFICATION(ID INTEGER NOT NULL PRIMARY KEY,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,QUALIFICATION_LEVEL INTEGER NOT NULL,REFERENCE_TAXON_FK INTEGER NOT NULL) +CREATE CACHED TABLE AGE_READER_QUAL2PERSON(AGE_READER_QUALIFICATION_FK INTEGER NOT NULL,PERSON_FK INTEGER NOT NULL,PRIMARY KEY(PERSON_FK,AGE_READER_QUALIFICATION_FK),CONSTRAINT PERSON_AGE_READER_QUALIFICATIC FOREIGN KEY(AGE_READER_QUALIFICATION_FK) REFERENCES AGE_READER_QUALIFICATION(ID)) +CREATE CACHED TABLE AGGREGATION_LEVEL(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,RANK_ORDER INTEGER NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE ANALYSIS_INSTRUMENT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE APPLIED_PERIOD(START_DATE TIMESTAMP NOT NULL,APPLIED_STRATEGY_FK INTEGER NOT NULL,END_DATE TIMESTAMP NOT NULL,PRIMARY KEY(START_DATE,APPLIED_STRATEGY_FK)) +CREATE CACHED TABLE APPLIED_QUALIFICATION_RULE(ID INTEGER NOT NULL PRIMARY KEY,MESSAGE VARCHAR(256) NOT NULL,REMOTE_ID INTEGER,QUALIFIED_ITEM_FK INTEGER NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PROCESSING_HISTORY_FK INTEGER NOT NULL,QUALIFICATION_RULE_FK INTEGER NOT NULL) +CREATE INDEX IX_RMTID_APPLIED_QUALIFICATION_RULE ON APPLIED_QUALIFICATION_RULE(REMOTE_ID) +CREATE CACHED TABLE APPLIED_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY,STRATEGY_FK INTEGER NOT NULL,LOCATION_FK INTEGER NOT NULL) +CREATE CACHED TABLE AUTHOR(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(255),LOCATION VARCHAR(255),COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE BATCH(ID INTEGER NOT NULL PRIMARY KEY,IS_CATCH_BATCH INTEGER NOT NULL,RANK_ORDER SMALLINT NOT NULL,SUBGROUP_COUNT REAL,INDIVIDUAL_COUNT INTEGER,CHILD_BATCHS_REPLICATION BOOLEAN NOT NULL,EXHAUSTIVE_INVENTORY BOOLEAN NOT NULL,COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,PARENT_BATCH_FK INTEGER,SAMPLING_RATIO REAL,SAMPLING_RATIO_TEXT VARCHAR(50),REFERENCE_TAXON_FK INTEGER,TAXON_GROUP_FK INTEGER,ROOT_BATCH_FK INTEGER,SYNCHRONIZATION_STATUS VARCHAR(256),CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,LOCATION_FK INTEGER,LABEL VARCHAR(40),CONSTRAINT BATCH_PARENT_BATCH_FKC FOREIGN KEY(PARENT_BATCH_FK) REFERENCES BATCH(ID),CONSTRAINT SORTING_BATCH_ROOT_BATCH_FKC FOREIGN KEY(ROOT_BATCH_FK) REFERENCES BATCH(ID)) +CREATE INDEX IX_BATCH_UD ON BATCH(UPDATE_DATE) +CREATE INDEX IX_RMTID_BATCH ON BATCH(REMOTE_ID) +CREATE INDEX IX_FK_BATCH_ROOT ON BATCH(ROOT_BATCH_FK) +CREATE CACHED TABLE BATCH_MODEL(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,IS_GLOBAL BOOLEAN NOT NULL,UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,RECORDER_PERSON_FK INTEGER,CATCH_BATCH_FK INTEGER NOT NULL,CONSTRAINT SYS_CT_74 UNIQUE(CATCH_BATCH_FK),CONSTRAINT BATCH_MODEL_CATCH_BATCH_FKC FOREIGN KEY(CATCH_BATCH_FK) REFERENCES BATCH(ID)) +CREATE INDEX IX_RMTID_BATCH_MODEL ON BATCH_MODEL(REMOTE_ID) +CREATE CACHED TABLE BATCH_MODEL_APPLIED_STRATEGY(ACQUISITION_LEVEL_FK VARCHAR(40) NOT NULL,APPLIED_STRATEGY_FK INTEGER NOT NULL,BATCH_MODEL_FK INTEGER NOT NULL,PRIMARY KEY(ACQUISITION_LEVEL_FK,APPLIED_STRATEGY_FK),CONSTRAINT BATCH_MODEL_APPLIED_STRATEGY_E FOREIGN KEY(APPLIED_STRATEGY_FK) REFERENCES APPLIED_STRATEGY(ID),CONSTRAINT FK6E2BF6507B83D9FC FOREIGN KEY(ACQUISITION_LEVEL_FK) REFERENCES ACQUISITION_LEVEL(CODE),CONSTRAINT BATCH_MODEL_APPLIED_STRATEGY_C FOREIGN KEY(BATCH_MODEL_FK) REFERENCES BATCH_MODEL(ID)) +CREATE CACHED TABLE BETWEEN_OP(ID BIGINT NOT NULL PRIMARY KEY) +CREATE CACHED TABLE BINARY_OPERATOR(ID BIGINT NOT NULL PRIMARY KEY,RVALUE VARCHAR(256) NOT NULL) +CREATE CACHED TABLE BLOC(ID BIGINT NOT NULL PRIMARY KEY,ENTITY_NAME VARCHAR(256) NOT NULL,FILTER_FK BIGINT) +CREATE CACHED TABLE BUYER(ID INTEGER NOT NULL PRIMARY KEY,REGISTRATION_CODE VARCHAR(40),NAME VARCHAR(100),STREET VARCHAR(256),ZIP_CODE VARCHAR(256),CITY VARCHAR(256),ADDRESS VARCHAR(255),UPDATE_DATE TIMESTAMP,BUYER_TYPE_FK SMALLINT NOT NULL,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE BUYER_TYPE(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,LABEL VARCHAR(40),DESCRIPTION VARCHAR(255),COMMENTS VARCHAR(2000),STATUS_FK VARCHAR(1) DEFAULT '1' NOT NULL) +CREATE CACHED TABLE CITATION(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(255) NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE CORPUS(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,UPDATE_DATE TIMESTAMP,CORPUS_TYPE_FK INTEGER NOT NULL) +CREATE CACHED TABLE CORPUS2FISHERY(CORPUS_FK INTEGER NOT NULL,FISHERY_FK INTEGER NOT NULL,PRIMARY KEY(CORPUS_FK,FISHERY_FK),CONSTRAINT FISHERY_CORPUS_FKC FOREIGN KEY(CORPUS_FK) REFERENCES CORPUS(ID)) +CREATE CACHED TABLE CORPUS_TYPE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE CRITERIA(ID BIGINT NOT NULL PRIMARY KEY,ENTITY_NAME VARCHAR(256) NOT NULL,TYPE_CRIT INTEGER NOT NULL,BLOC_FK BIGINT,CONSTRAINT CRITERIA_BLOC_FKC FOREIGN KEY(BLOC_FK) REFERENCES BLOC(ID)) +CREATE CACHED TABLE DAILY_ACTIVITY_CALENDAR(ID INTEGER NOT NULL PRIMARY KEY,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP NOT NULL,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,RECORDER_PERSON_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,OBSERVED_LOCATION_FK INTEGER) +CREATE INDEX IX_RMTID_DAILY_ACTIVITY_CALENDAR ON DAILY_ACTIVITY_CALENDAR(REMOTE_ID) +CREATE INDEX IX_DAILY_ACTIVITY_CALENDAR_UD ON DAILY_ACTIVITY_CALENDAR(UPDATE_DATE) +CREATE INDEX DAILY_ACTIVITY_CALENDAR_NATIDX ON DAILY_ACTIVITY_CALENDAR(START_DATE,END_DATE,PROGRAM_FK,VESSEL_FK) +CREATE CACHED TABLE DECLARED_DOCUMENT_REFERENCE(ID INTEGER NOT NULL PRIMARY KEY,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,REFERENCE VARCHAR(100),FILE_NAME VARCHAR(255),DOCUMENT_DATE TIMESTAMP NOT NULL,OTHER_DOCUMENT_REFERENCE VARCHAR(256),FIRST_SHEET_NUMBER VARCHAR(40),LAST_SHEET_NUMBER VARCHAR(20),SHEET_COUNT SMALLINT,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,PARENT_FK INTEGER,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,RECORDER_PERSON_FK INTEGER,CONSTRAINT DECLARED_DOCUMENT_REFERENCE_PT FOREIGN KEY(PARENT_FK) REFERENCES DECLARED_DOCUMENT_REFERENCE(ID)) +CREATE INDEX DECLARED_DOCUMENT_REFER_NATIDX ON DECLARED_DOCUMENT_REFERENCE(REFERENCE,PROGRAM_FK,VESSEL_FK) +CREATE INDEX IX_DECLARED_DOCUMENT_REF_UD ON DECLARED_DOCUMENT_REFERENCE(UPDATE_DATE) +CREATE INDEX IX_RMTID_DECLARED_DOCUMENT_REFERENCE ON DECLARED_DOCUMENT_REFERENCE(REMOTE_ID) +CREATE INDEX IX_DECLARED_DOC_CREATION_DATE ON DECLARED_DOCUMENT_REFERENCE(CREATION_DATE) +CREATE CACHED TABLE DELETED_ITEM_HISTORY(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,VESSEL_FK VARCHAR(256),OBJECT_ID BIGINT,COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,PROCESSING_HISTORY_FK INTEGER,RECORDER_DEPARTMENT_FK INTEGER,RECORDER_PERSON_FK INTEGER,OBJECT_CODE VARCHAR(40)) +CREATE INDEX IX_RMTID_DELETED_ITEM_HISTORY ON DELETED_ITEM_HISTORY(REMOTE_ID) +CREATE CACHED TABLE DENORMALIZED_BATCH(ID BIGINT NOT NULL PRIMARY KEY,RANK_ORDER SMALLINT NOT NULL,FLAT_RANK_ORDER SMALLINT NOT NULL,WEIGHT REAL,INDIRECT_WEIGHT REAL,ELEVATE_WEIGHT REAL,INDIVIDUAL_COUNT INTEGER,INDIRECT_INDIVIDUAL_COUNT INTEGER,ELEVATE_INDIVIDUAL_COUNT INTEGER,SAMPLING_RATIO REAL,SAMPLING_RATIO_TEXT VARCHAR(50),EXHAUSTIVE_INVENTORY BOOLEAN,CHILD_BATCHS_REPLICATION BOOLEAN,COMMENTS VARCHAR(2000),TREE_LEVEL SMALLINT NOT NULL,TREE_INDENT VARCHAR(256),SORTING_VALUES_TEXT VARCHAR(256),IS_LANDING BOOLEAN NOT NULL,IS_DISCARD BOOLEAN NOT NULL,UPDATE_DATE TIMESTAMP,OPERATION_FK INTEGER,SALE_FK INTEGER,CALCULATED_TAXON_GROUP_FK INTEGER,INHERITED_REFERENCE_TAXON_FK INTEGER,PARENT_BATCH_FK BIGINT,WEIGHT_METHOD_FK INTEGER,TAXON_GROUP_FK INTEGER,REFERENCE_TAXON_FK INTEGER,INHERITED_TAXON_GROUP_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,ELEVATE_CONTEXT_WEIGHT REAL,LABEL VARCHAR(40),INDIRECT_CONTEXT_WEIGHT FLOAT,CONSTRAINT DENORMALIZED_BATCH_PARENT_BATC FOREIGN KEY(PARENT_BATCH_FK) REFERENCES DENORMALIZED_BATCH(ID) ON DELETE CASCADE) +CREATE CACHED TABLE DENORMALIZED_BATCH_SORT_VAL(ID INTEGER NOT NULL PRIMARY KEY,RANK_ORDER INTEGER NOT NULL,IS_INHERITED BOOLEAN NOT NULL,NUMERICAL_VALUE REAL,REMOTE_ID INTEGER,UNIT_FK INTEGER NOT NULL,BATCH_FK BIGINT NOT NULL,PARAMETER_FK VARCHAR(40) NOT NULL,PMFM_FK INTEGER NOT NULL,QUALITATIVE_VALUE_FK INTEGER,CONSTRAINT DENORMALIZED_BATCH_SORT_VAL_BC FOREIGN KEY(BATCH_FK) REFERENCES DENORMALIZED_BATCH(ID) ON DELETE CASCADE) +CREATE INDEX IX_RMTID_DENORMALISED_BATCH_SORTING_VALUE ON DENORMALIZED_BATCH_SORT_VAL(REMOTE_ID) +CREATE CACHED TABLE DENORMALIZED_OPERATION(ID BIGINT NOT NULL PRIMARY KEY,RANK_ORDER SMALLINT NOT NULL,IS_LANDING_SAMPLING BOOLEAN NOT NULL,IS_DISCARD_SAMPLING BOOLEAN NOT NULL,GEAR_MESH_SIZE REAL,GEAR_DEPTH REAL,MAIN_WATER_DEPTH REAL,UPDATE_DATE TIMESTAMP,SELECTIVE_DEVICE_FK INTEGER,METIER_FK INTEGER,SUBPOLYGON_LOCATION_FK INTEGER,RECTANGLE_LOCATION_FK INTEGER,GEAR_FK INTEGER,AREA_LOCATION_FK INTEGER,FISHING_TRIP_FK INTEGER NOT NULL) +CREATE CACHED TABLE DEPARTMENT(ID INTEGER NOT NULL PRIMARY KEY,CODE VARCHAR(40) NOT NULL,NAME VARCHAR(255) NOT NULL,EMAIL VARCHAR(255),ADDRESS VARCHAR(255),PHONE VARCHAR(255),IS_LDAP BOOLEAN NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,PARENT_DEPARTMENT_FK INTEGER,CONSTRAINT DEPARTMENT_PARENT_DEPARTMENT_C FOREIGN KEY(PARENT_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX DEPARTMENT_NATIDX ON DEPARTMENT(CODE) +CREATE CACHED TABLE DEPARTMENT_PRIVILEGE_TRANSFERT(TO_DEPARTMENT_FK INTEGER NOT NULL,FROM_DEPARTMENT_FK INTEGER NOT NULL,TRANSFERT_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,PRIMARY KEY(TO_DEPARTMENT_FK,FROM_DEPARTMENT_FK),CONSTRAINT DEPARTMENT_PRIVILEGE_TRANSFERL FOREIGN KEY(FROM_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT DEPARTMENT_PRIVILEGE_TRANSFERR FOREIGN KEY(TO_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE CACHED TABLE DEPTH_GRADIENT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255) NOT NULL,RANK_ORDER SMALLINT NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE DISTANCE_TO_COAST_GRADIENT(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255) NOT NULL,RANK_ORDER SMALLINT NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE ECONOMICAL_SURVEY(ID INTEGER NOT NULL PRIMARY KEY,SYNCHRONISATION_STATUS VARCHAR(256) NOT NULL,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12),VESSEL_OWNER_FK INTEGER,RECORDER_PERSON_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,CONSTRAINT ECONOMICAL_SURVEY_RECORDER_DEC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_RMTID_ECONOMICAL_SURVEY ON ECONOMICAL_SURVEY(REMOTE_ID) +CREATE CACHED TABLE EDUCATION_GRADE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE EQUALS(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT EQUALSIFKC FOREIGN KEY(ID) REFERENCES BINARY_OPERATOR(ID)) +CREATE CACHED TABLE EXPECTED_SALE(ID INTEGER NOT NULL PRIMARY KEY,REMOTE_ID INTEGER,OBSERVED_LANDING_FK INTEGER,SALE_TYPE_FK INTEGER NOT NULL,SALE_LOCATION_FK INTEGER,FISHING_TRIP_FK INTEGER) +CREATE INDEX IX_RMTID_EXPECTED_SALE ON EXPECTED_SALE(REMOTE_ID) +CREATE CACHED TABLE FILTER(ID BIGINT NOT NULL PRIMARY KEY,NAME VARCHAR(256) NOT NULL,ENTITY_NAME VARCHAR(256) NOT NULL,LAST_RUN_DATE TIMESTAMP NOT NULL,WIDGET_ID VARCHAR(256) NOT NULL,PERSON_FK INTEGER NOT NULL) +CREATE CACHED TABLE FISHERY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP,DESCRIPTION VARCHAR(255),LABEL VARCHAR(40) NOT NULL) +CREATE CACHED TABLE FISHING_AREA(ID INTEGER NOT NULL PRIMARY KEY,REMOTE_ID INTEGER,VESSEL_USE_FEATURES_FK INTEGER,GEAR_USE_FEATURES_FK INTEGER,SAMPLE_FK INTEGER,DISTANCE_TO_COAST_GRADIENT_FK INTEGER,DEPTH_GRADIENT_FK INTEGER,NEARBY_SPECIFIC_AREA_FK INTEGER,LOCATION_FK INTEGER,PRODUCE_FK INTEGER,SALE_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) DEFAULT '0' NOT NULL,QUALIFICATION_COMMENTS VARCHAR(2000),QUALIFICATION_DATE TIMESTAMP,CONSTRAINT FISHING_AREA_DEPTH_GRADIENT_FC FOREIGN KEY(DEPTH_GRADIENT_FK) REFERENCES DEPTH_GRADIENT(ID),CONSTRAINT FISHING_AREA_DISTANCE_TO_COASC FOREIGN KEY(DISTANCE_TO_COAST_GRADIENT_FK) REFERENCES DISTANCE_TO_COAST_GRADIENT(ID)) +CREATE INDEX IX_RMTID_FISHING_AREA ON FISHING_AREA(REMOTE_ID) +CREATE INDEX FISHING_AREA_NATIDX ON FISHING_AREA(VESSEL_USE_FEATURES_FK,GEAR_USE_FEATURES_FK,SAMPLE_FK,DISTANCE_TO_COAST_GRADIENT_FK,DEPTH_GRADIENT_FK,LOCATION_FK,PRODUCE_FK,SALE_FK) +CREATE CACHED TABLE FISHING_AREA2REG_LOCATION(FISHING_AREA_FK INTEGER NOT NULL,LOCATION_FK INTEGER NOT NULL,PRIMARY KEY(FISHING_AREA_FK,LOCATION_FK),CONSTRAINT FISHING_AREA2REG_LOCATION_FISC FOREIGN KEY(FISHING_AREA_FK) REFERENCES FISHING_AREA(ID)) +CREATE CACHED TABLE FISHING_EFFORT_CALENDAR(ID INTEGER NOT NULL PRIMARY KEY,YEAR INTEGER NOT NULL,DIRECT_SURVEY_INVESTIGATION BOOLEAN NOT NULL,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,RECORDER_PERSON_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,CONSTRAINT FISHING_EFFORT_CALENDAR_RECORC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_FISHING_EFFORT_CALENDAR_UD ON FISHING_EFFORT_CALENDAR(UPDATE_DATE) +CREATE INDEX FISHING_EFFORT_CALENDAR_NATIDX ON FISHING_EFFORT_CALENDAR(YEAR,VESSEL_FK,PROGRAM_FK) +CREATE INDEX IX_RMTID_FISHING_EFFORT_CALENDAR ON FISHING_EFFORT_CALENDAR(REMOTE_ID) +CREATE CACHED TABLE FISHING_TRIP(ID INTEGER NOT NULL PRIMARY KEY,IS_OBSERVED INTEGER NOT NULL,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,DEPARTURE_DATE_TIME TIMESTAMP,RETURN_DATE_TIME TIMESTAMP,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,RECORDER_PERSON_FK INTEGER,SCIENTIFIC_CRUISE_FK INTEGER,DECLARED_DOCUMENT_REFERENCE_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,DEPARTURE_LOCATION_FK INTEGER,RETURN_LOCATION_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,SAMPLING_STRATA_FK INTEGER,CONSTRAINT FISHING_TRIP_DECLARED_DOCUMENC FOREIGN KEY(DECLARED_DOCUMENT_REFERENCE_FK) REFERENCES DECLARED_DOCUMENT_REFERENCE(ID),CONSTRAINT FISHING_TRIP_RECORDER_DEPARTMC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_FISHING_TRIP_RETURN_DATE ON FISHING_TRIP(RETURN_DATE_TIME) +CREATE INDEX FISHING_TRIP_NATIDX ON FISHING_TRIP(DEPARTURE_DATE_TIME,DECLARED_DOCUMENT_REFERENCE_FK,PROGRAM_FK,VESSEL_FK) +CREATE INDEX IX_RMTID_FISHING_TRIP ON FISHING_TRIP(REMOTE_ID) +CREATE INDEX IX_FISHING_TRIP_UD ON FISHING_TRIP(UPDATE_DATE) +CREATE CACHED TABLE FISHING_TRIP2OBSERVER_PERSON(FISHING_TRIP_FK INTEGER NOT NULL,PERSON_FK INTEGER NOT NULL,PRIMARY KEY(FISHING_TRIP_FK,PERSON_FK),CONSTRAINT PERSON_FISHING_TRIP_FKC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID)) +CREATE CACHED TABLE FISHING_TRIP_ORIGIN(ID INTEGER NOT NULL PRIMARY KEY,REMOTE_ID INTEGER,ORIGIN_FISHING_TRIP_REMOTE_ID INTEGER,FISHING_TRIP_FK INTEGER NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,ORIGIN_FISHING_TRIP_FK INTEGER,CONSTRAINT FISHING_TRIP_ORIGIN_FISHING_TC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT FISHING_TRIP_ORIGIN_ORIGIN_FIC FOREIGN KEY(ORIGIN_FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID)) +CREATE INDEX IX_RMTID_FISHING_TRIP_ORIGIN ON FISHING_TRIP_ORIGIN(REMOTE_ID) +CREATE CACHED TABLE FRACTION(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE FRACTION2MATRIX(FRACTION_FK INTEGER NOT NULL,MATRIX_FK INTEGER NOT NULL,PRIMARY KEY(FRACTION_FK,MATRIX_FK),CONSTRAINT MATRIX_FRACTION_FKC FOREIGN KEY(FRACTION_FK) REFERENCES FRACTION(ID)) +CREATE CACHED TABLE GEAR(ID INTEGER NOT NULL PRIMARY KEY,IS_FISHING_GEAR INTEGER NOT NULL,LABEL VARCHAR(50) NOT NULL,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(256),UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,PARENT_GEAR_FK INTEGER,GEAR_CLASSIFICATION_FK INTEGER NOT NULL,IS_ACTIVE BOOLEAN,IS_TOWED BOOLEAN,CONSTRAINT GEAR_PARENT_GEAR_FKC FOREIGN KEY(PARENT_GEAR_FK) REFERENCES GEAR(ID)) +CREATE INDEX IX_GEAR_UD ON GEAR(UPDATE_DATE) +CREATE CACHED TABLE GEAR_ASSOCIATION(TO_GEAR_FK INTEGER NOT NULL,FROM_GEAR_FK INTEGER NOT NULL,UPDATE_DATE TIMESTAMP,PRIMARY KEY(TO_GEAR_FK,FROM_GEAR_FK),CONSTRAINT GEAR_ASSOCIATION_FROM_GEAR_FKC FOREIGN KEY(FROM_GEAR_FK) REFERENCES GEAR(ID),CONSTRAINT FKDCE941B1C6A799C6 FOREIGN KEY(TO_GEAR_FK) REFERENCES GEAR(ID)) +CREATE INDEX IX_GEAR_ASSOCIATION_UD ON GEAR_ASSOCIATION(UPDATE_DATE) +CREATE CACHED TABLE GEAR_CLASSIFICATION(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),IS_AGGREGATION BOOLEAN NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE GEAR_CLASSIFICATION_ASSOCIATIO(TO_GEAR_CLASSIFICATION_FK INTEGER NOT NULL,FROM_GEAR_CLASSIFICATION_FK INTEGER NOT NULL,UPDATE_DATE TIMESTAMP,PRIMARY KEY(TO_GEAR_CLASSIFICATION_FK,FROM_GEAR_CLASSIFICATION_FK),CONSTRAINT FKD79D78D6C0BA09AD FOREIGN KEY(TO_GEAR_CLASSIFICATION_FK) REFERENCES GEAR_CLASSIFICATION(ID),CONSTRAINT GEAR_CLASSIFICATION_ASSOCIATIC FOREIGN KEY(FROM_GEAR_CLASSIFICATION_FK) REFERENCES GEAR_CLASSIFICATION(ID)) +CREATE CACHED TABLE GEAR_PHYSICAL_FEATURES(ID INTEGER NOT NULL PRIMARY KEY,START_DATE TIMESTAMP,END_DATE TIMESTAMP,CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(256),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,RANK_ORDER SMALLINT NOT NULL,GEAR_FK INTEGER NOT NULL,FISHING_TRIP_FK INTEGER,PHYSICAL_GEAR_SURVEY_FK INTEGER,OTHER_GEAR_FK INTEGER,CONSTRAINT GEAR_PHYSICAL_FEATURES_FISHINC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT GEAR_PHYSICAL_FEATURES_GEAR_FC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID),CONSTRAINT GEAR_PHYSICAL_FEATURES_OTHER_C FOREIGN KEY(OTHER_GEAR_FK) REFERENCES GEAR(ID)) +CREATE INDEX GEAR_PHYSICAL_FEATURES_NATIDX ON GEAR_PHYSICAL_FEATURES(START_DATE,PROGRAM_FK,VESSEL_FK,RANK_ORDER,GEAR_FK,FISHING_TRIP_FK,PHYSICAL_GEAR_SURVEY_FK) +CREATE INDEX IX_RMTID_G_PHYSICAL_FEATURES ON GEAR_PHYSICAL_FEATURES(REMOTE_ID) +CREATE CACHED TABLE GEAR_PHYSICAL_FEATURES_ORIGIN(PROGRAM_FK VARCHAR(40) NOT NULL,GEAR_PHYSICAL_FEATURES_FK INTEGER NOT NULL,ACQUISITION_LEVEL_FK VARCHAR(40),PRIMARY KEY(PROGRAM_FK,GEAR_PHYSICAL_FEATURES_FK),CONSTRAINT GEAR_PHYSICAL_FEATURES_ORIGINC FOREIGN KEY(GEAR_PHYSICAL_FEATURES_FK) REFERENCES GEAR_PHYSICAL_FEATURES(ID),CONSTRAINT GEAR_PHYSICAL_FEATURES_ORIGINS FOREIGN KEY(ACQUISITION_LEVEL_FK) REFERENCES ACQUISITION_LEVEL(CODE)) +CREATE CACHED TABLE GEAR_PHYSICAL_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,GEAR_PHYSICAL_FEATURES_FK INTEGER NOT NULL,CONSTRAINT GEAR_PHYSIC_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT GEAR_PHYSIC_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT GEAR_PHYSICAL_M_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT GEAR_PHYSICAL_MEASUREMENT_GEAC FOREIGN KEY(GEAR_PHYSICAL_FEATURES_FK) REFERENCES GEAR_PHYSICAL_FEATURES(ID)) +CREATE INDEX IX_RMTID_GEAR_PHYS_MEASUREMENT ON GEAR_PHYSICAL_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE GEAR_USE_FEATURES(ID INTEGER NOT NULL PRIMARY KEY,START_DATE TIMESTAMP,END_DATE TIMESTAMP,CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,OPERATION_FK INTEGER,METIER_FK INTEGER,GEAR_FK INTEGER,DAILY_ACTIVITY_CALENDAR_FK INTEGER,ACTIVITY_CALENDAR_FK INTEGER,FISHING_EFFORT_CALENDAR_FK INTEGER,ECONOMICAL_SURVEY_FK INTEGER,OTHER_GEAR_FK INTEGER,RANK_ORDER SMALLINT DEFAULT 1 NOT NULL,CONSTRAINT GEAR_USE_FEATURES_ACTIVITY_CAC FOREIGN KEY(ACTIVITY_CALENDAR_FK) REFERENCES ACTIVITY_CALENDAR(ID),CONSTRAINT GEAR_USE_FEATURES_GEAR_FKC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID),CONSTRAINT GEAR_USE_FEATURES_DAILY_ACTIVC FOREIGN KEY(DAILY_ACTIVITY_CALENDAR_FK) REFERENCES DAILY_ACTIVITY_CALENDAR(ID),CONSTRAINT GEAR_USE_FEATURES_FISHING_EFFC FOREIGN KEY(FISHING_EFFORT_CALENDAR_FK) REFERENCES FISHING_EFFORT_CALENDAR(ID),CONSTRAINT GEAR_USE_FEATURES_ECONOMICAL_C FOREIGN KEY(ECONOMICAL_SURVEY_FK) REFERENCES ECONOMICAL_SURVEY(ID),CONSTRAINT GEAR_USE_FEATURES_OTHER_GEAR_C FOREIGN KEY(OTHER_GEAR_FK) REFERENCES GEAR(ID)) +CREATE INDEX IX_RMTID_G_USE_FEATURES ON GEAR_USE_FEATURES(REMOTE_ID) +CREATE INDEX GEAR_USE_FEATURES_NATIDX ON GEAR_USE_FEATURES(START_DATE,END_DATE,PROGRAM_FK,VESSEL_FK,OPERATION_FK,METIER_FK,GEAR_FK,DAILY_ACTIVITY_CALENDAR_FK,ACTIVITY_CALENDAR_FK,FISHING_EFFORT_CALENDAR_FK,ECONOMICAL_SURVEY_FK) +CREATE CACHED TABLE GEAR_USE_FEATURES_ORIGIN(PROGRAM_FK VARCHAR(40) NOT NULL,GEAR_USE_FEATURES_FK INTEGER NOT NULL,ACQUISITION_LEVEL_FK VARCHAR(40),PRIMARY KEY(PROGRAM_FK,GEAR_USE_FEATURES_FK),CONSTRAINT GEAR_USE_FEATURES_ORIGIN_GEARC FOREIGN KEY(GEAR_USE_FEATURES_FK) REFERENCES GEAR_USE_FEATURES(ID),CONSTRAINT GEAR_USE_FEATURES_ORIGIN_ACQUC FOREIGN KEY(ACQUISITION_LEVEL_FK) REFERENCES ACQUISITION_LEVEL(CODE)) +CREATE CACHED TABLE GEAR_USE_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,GEAR_USE_FEATURES_FK INTEGER NOT NULL,CONSTRAINT GEAR_USE_ME_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT GEAR_USE_ME_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT GEAR_USE_MEASUR_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT GEAR_USE_MEASUREMENT_GEAR_USEC FOREIGN KEY(GEAR_USE_FEATURES_FK) REFERENCES GEAR_USE_FEATURES(ID)) +CREATE INDEX IX_RMTID_G_USE_MEASUREMENT ON GEAR_USE_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE GREATER(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT GREATERIFKC FOREIGN KEY(ID) REFERENCES BINARY_OPERATOR(ID)) +CREATE CACHED TABLE GREATER_OR_EQUALS(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT GREATER_OR_EQUALSIFKC FOREIGN KEY(ID) REFERENCES BINARY_OPERATOR(ID)) +CREATE CACHED TABLE GROUPING(ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(50) NOT NULL,NAME VARCHAR(100) NOT NULL,MIN_VALUE DOUBLE,MAX_VALUE DOUBLE,UPDATE_DATE TIMESTAMP,GROUPING_CLASSIFICATION_FK INTEGER NOT NULL,PARENT_GROUPING_FK INTEGER,STATUS_FK VARCHAR(1) NOT NULL,GROUPING_LEVEL_FK INTEGER NOT NULL,CONSTRAINT GROUPING_PARENT_GROUPING_FKC FOREIGN KEY(PARENT_GROUPING_FK) REFERENCES GROUPING(ID)) +CREATE CACHED TABLE GROUPING_CLASSIFICATION(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,LABEL VARCHAR(40) NOT NULL,OBJECT_REFERENCE_QUERY VARCHAR(2000)) +CREATE CACHED TABLE GROUPING_ITEM(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID INTEGER,GROUPING_FK INTEGER NOT NULL,OBJECT_CODE VARCHAR(40),CONSTRAINT GROUPING_ITEM_GROUPING_FKC FOREIGN KEY(GROUPING_FK) REFERENCES GROUPING(ID)) +CREATE CACHED TABLE GROUPING_ITEM_HIERARCHY(OBJECT_ID INTEGER NOT NULL,GROUPING_FK INTEGER NOT NULL,GROUPING_CLASSIFICATION_FK INTEGER NOT NULL,PRIMARY KEY(OBJECT_ID,GROUPING_FK),CONSTRAINT GROUPING_ITEM_HIERARCHY_GROUPC FOREIGN KEY(GROUPING_CLASSIFICATION_FK) REFERENCES GROUPING_CLASSIFICATION(ID),CONSTRAINT FK97556EA5E148B96 FOREIGN KEY(GROUPING_FK) REFERENCES GROUPING(ID)) +CREATE CACHED TABLE GROUPING_LEVEL(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,PMFM_FK INTEGER,GROUPING_CLASSIFICATION_FK INTEGER NOT NULL,PARENT_GROUPING_LEVEL_FK INTEGER,LABEL VARCHAR(40) NOT NULL,CONSTRAINT GROUPING_LEVEL_GROUPING_CLASSC FOREIGN KEY(GROUPING_CLASSIFICATION_FK) REFERENCES GROUPING_CLASSIFICATION(ID),CONSTRAINT GROUPING_LEVEL_PARENT_GROUPINC FOREIGN KEY(PARENT_GROUPING_LEVEL_FK) REFERENCES GROUPING_LEVEL(ID)) +CREATE CACHED TABLE GROUPING_VESSEL_HIERARCHY(ID INTEGER NOT NULL PRIMARY KEY,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,UPDATE_DATE TIMESTAMP,GROUPING_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,LOCATION_FK INTEGER NOT NULL,GROUPING_CLASSIFICATION_FK INTEGER NOT NULL,ORIGIN_PROGRAM_FK VARCHAR(40) NOT NULL,ORIGIN_OBJECT_TYPE_FK VARCHAR(40) NOT NULL,CONSTRAINT GROUPING_VESSEL_HIERARCHY_GROR FOREIGN KEY(GROUPING_CLASSIFICATION_FK) REFERENCES GROUPING_CLASSIFICATION(ID),CONSTRAINT GROUPING_VESSEL_HIERARCHY_GROC FOREIGN KEY(GROUPING_FK) REFERENCES GROUPING(ID)) +CREATE CACHED TABLE HIERARCHY_PROPERTY_CRITERIA(ID BIGINT NOT NULL PRIMARY KEY) +CREATE CACHED TABLE IN_OP(ID BIGINT NOT NULL PRIMARY KEY) +CREATE CACHED TABLE IS_NOT_NULL(ID BIGINT NOT NULL PRIMARY KEY) +CREATE CACHED TABLE IS_NULL(ID BIGINT NOT NULL PRIMARY KEY) +CREATE CACHED TABLE LANDING(ID INTEGER NOT NULL PRIMARY KEY,IS_OBSERVED INTEGER NOT NULL,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,LANDING_DATE_TIME TIMESTAMP NOT NULL,RANK_ORDER SMALLINT,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,VESSEL_FK VARCHAR(12) NOT NULL,RECORDER_PERSON_FK INTEGER,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,FISHING_TRIP_FK INTEGER,LANDING_LOCATION_FK INTEGER NOT NULL,CATCH_BATCH_FK INTEGER,OBSERVED_LOCATION_FK INTEGER,SAMPLING_STRATA_FK INTEGER,CONSTRAINT SYS_CT_198 UNIQUE(CATCH_BATCH_FK),CONSTRAINT LANDING_FISHING_TRIP_FKC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT LANDING_CATCH_BATCH_FKC FOREIGN KEY(CATCH_BATCH_FK) REFERENCES BATCH(ID),CONSTRAINT LANDING_RECORDER_DEPARTMENT_FC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_RMTID_LANDING ON LANDING(REMOTE_ID) +CREATE INDEX LANDING_NATIDX ON LANDING(LANDING_DATE_TIME,RANK_ORDER,VESSEL_FK,PROGRAM_FK) +CREATE INDEX IX_LANDING_UD ON LANDING(UPDATE_DATE) +CREATE CACHED TABLE LANDING2OBSERVER_PERSON(LANDING_FK INTEGER NOT NULL,PERSON_FK INTEGER NOT NULL,PRIMARY KEY(LANDING_FK,PERSON_FK),CONSTRAINT PERSON_LANDING_FKC FOREIGN KEY(LANDING_FK) REFERENCES LANDING(ID)) +CREATE CACHED TABLE LANDING_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,LANDING_FK INTEGER NOT NULL,CONSTRAINT LANDING_MEASUREMENT_LANDING_FC FOREIGN KEY(LANDING_FK) REFERENCES LANDING(ID),CONSTRAINT LANDING_MEA_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT LANDING_MEA_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT LANDING_MEASURE_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_RMTID_LANDING_MEASUREMENT ON LANDING_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE LANDING_ORIGIN(PROGRAM_FK VARCHAR(40) NOT NULL,LANDING_FK INTEGER NOT NULL,PRIMARY KEY(PROGRAM_FK,LANDING_FK),CONSTRAINT LANDING_ORIGIN_LANDING_FKC FOREIGN KEY(LANDING_FK) REFERENCES LANDING(ID)) +CREATE CACHED TABLE LIKE_OP(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT LIKE_OPIFKC FOREIGN KEY(ID) REFERENCES BINARY_OPERATOR(ID)) +CREATE CACHED TABLE LINKED_ITEM(ID INTEGER NOT NULL PRIMARY KEY,FROM_OBJECT_ID INTEGER,FROM_OBJECT_CODE VARCHAR(40),TO_OBJECT_ID INTEGER,TO_OBJECT_CODE VARCHAR(40),START_DATE TIMESTAMP,END_DATE TIMESTAMP,UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,LINKED_ITEM_TYPE_FK INTEGER NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL) +CREATE INDEX IX_RMTID_LINKED_ITEM ON LINKED_ITEM(REMOTE_ID) +CREATE INDEX LINKED_ITEM_NATIDX ON LINKED_ITEM(FROM_OBJECT_ID,FROM_OBJECT_CODE,TO_OBJECT_ID,TO_OBJECT_CODE,START_DATE,LINKED_ITEM_TYPE_FK) +CREATE CACHED TABLE LINKED_ITEM_TYPE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,FROM_PROGRAM_FK VARCHAR(40) NOT NULL,STATUS_FK VARCHAR(1) NOT NULL,TO_OBJECT_TYPE_FK VARCHAR(40) NOT NULL,FROM_OBJECT_TYPE_FK VARCHAR(40) NOT NULL,TO_PROGRAM_FK VARCHAR(40) NOT NULL) +CREATE CACHED TABLE LINKED_PROPERTY_CRITERIA(ID BIGINT NOT NULL PRIMARY KEY,PROPERTY VARCHAR(256) NOT NULL,ENTRY_FK BIGINT NOT NULL,CRITERIA_FK BIGINT,CONSTRAINT LINKED_PROPERTY_CRITERIA_CRITC FOREIGN KEY(CRITERIA_FK) REFERENCES CRITERIA(ID),CONSTRAINT LINKED_PROPERTY_CRITERIA_ENTRC FOREIGN KEY(ENTRY_FK) REFERENCES CRITERIA(ID)) +CREATE CACHED TABLE LOCATION(ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(50),NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP,BATHYMETRY REAL,UT_FORMAT SMALLINT,DAYLIGHT_SAVING_TIME BOOLEAN,STATUS_FK VARCHAR(1) NOT NULL,LOCATION_LEVEL_FK INTEGER NOT NULL,LOCATION_CLASSIFICATION_FK INTEGER NOT NULL) +CREATE INDEX IX_LOCATION_UD ON LOCATION(UPDATE_DATE) +CREATE CACHED TABLE LOCATION_AREA(ID INTEGER NOT NULL PRIMARY KEY,UPDATE_DATE TIMESTAMP,CONSTRAINT LOCATION_AREAIFKC FOREIGN KEY(ID) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE LOCATION_ASSOCIATION(CHILD_LOCATION_FK INTEGER NOT NULL,PARENT_LOCATION_FK INTEGER NOT NULL,CHILD_SURFACE_RATIO REAL NOT NULL,UPDATE_DATE TIMESTAMP,PRIMARY KEY(CHILD_LOCATION_FK,PARENT_LOCATION_FK),CONSTRAINT FK81C376D725F8541 FOREIGN KEY(CHILD_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT FK81C376D7750FB3CF FOREIGN KEY(PARENT_LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE INDEX IX_LOCATION_ASSOCIATION_UD ON LOCATION_ASSOCIATION(UPDATE_DATE) +CREATE CACHED TABLE LOCATION_CLASSIFICATION(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE LOCATION_HIERARCHY(CHILD_LOCATION_FK INTEGER NOT NULL,PARENT_LOCATION_FK INTEGER NOT NULL,CHILD_SURFACE_RATIO REAL NOT NULL,IS_MAIN_ASSOCIATION BOOLEAN NOT NULL,PRIMARY KEY(CHILD_LOCATION_FK,PARENT_LOCATION_FK),CONSTRAINT FKC2ACCE0B25F8541 FOREIGN KEY(CHILD_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT FKC2ACCE0B750FB3CF FOREIGN KEY(PARENT_LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE LOCATION_HIERARCHY_EXCEPTION(CHILD_LOCATION_FK INTEGER NOT NULL,PARENT_LOCATION_FK INTEGER NOT NULL,CHILD_SURFACE_RATIO REAL NOT NULL,PRIMARY KEY(CHILD_LOCATION_FK,PARENT_LOCATION_FK),CONSTRAINT FK6EFFD6FB25F8541 FOREIGN KEY(CHILD_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT FK6EFFD6FB750FB3CF FOREIGN KEY(PARENT_LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE LOCATION_LEVEL(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP,PARENT_LOCATION_LEVEL_FK INTEGER,LOCATION_CLASSIFICATION_FK INTEGER NOT NULL,CONSTRAINT LOCATION_LEVEL_PARENT_LOCATIOC FOREIGN KEY(PARENT_LOCATION_LEVEL_FK) REFERENCES LOCATION_LEVEL(ID),CONSTRAINT LOCATION_LEVEL_LOCATION_CLASSC FOREIGN KEY(LOCATION_CLASSIFICATION_FK) REFERENCES LOCATION_CLASSIFICATION(ID)) +CREATE CACHED TABLE LOCATION_LINE(ID INTEGER NOT NULL PRIMARY KEY,UPDATE_DATE TIMESTAMP,CONSTRAINT LOCATION_LINEIFKC FOREIGN KEY(ID) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE LOCATION_POINT(ID INTEGER NOT NULL PRIMARY KEY,UPDATE_DATE TIMESTAMP,CONSTRAINT LOCATION_POINTIFKC FOREIGN KEY(ID) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE LOWER(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT LOWERIFKC FOREIGN KEY(ID) REFERENCES BINARY_OPERATOR(ID)) +CREATE CACHED TABLE LOWER_OR_EQUALS(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT LOWER_OR_EQUALSIFKC FOREIGN KEY(ID) REFERENCES BINARY_OPERATOR(ID)) +CREATE CACHED TABLE MANAGED_DATA(ID INTEGER NOT NULL PRIMARY KEY,UPDATE_DATE TIMESTAMP,MANAGER_PERSON_FK INTEGER NOT NULL,SUPERVISOR_PERSON_FK INTEGER,MANAGED_DATA_TYPE_FK INTEGER NOT NULL) +CREATE CACHED TABLE MANAGED_DATA2VIEWER_USER(MANAGED_DATA_FK INTEGER NOT NULL,PERSON_FK INTEGER NOT NULL,PRIMARY KEY(MANAGED_DATA_FK,PERSON_FK),CONSTRAINT PERSON_MANAGED_DATA_FKC FOREIGN KEY(MANAGED_DATA_FK) REFERENCES MANAGED_DATA(ID)) +CREATE CACHED TABLE MANAGED_DATA_TRANSFER(NEW_MANAGER_PERSON_FK INTEGER NOT NULL,MANAGED_DATA_FK INTEGER NOT NULL,TRANSFER_DATE TIMESTAMP NOT NULL,PRIMARY KEY(NEW_MANAGER_PERSON_FK,MANAGED_DATA_FK),CONSTRAINT MANAGED_DATA_TRANSFER_MANAGEDC FOREIGN KEY(MANAGED_DATA_FK) REFERENCES MANAGED_DATA(ID)) +CREATE CACHED TABLE MANAGED_DATA_TYPE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE MATRIX(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE MEASUREMENT_FILE(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID INTEGER NOT NULL,PATH VARCHAR(255) NOT NULL,NAME VARCHAR(100),COMMENTS VARCHAR(2000),CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,DEPARTMENT_FK INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PMFM_FK INTEGER,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,CONSTRAINT MEASUREMENT_FILE_ANALYSIS_INSC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT MEASUREMENT_FILE_DEPARTMENT_FC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_RMTID_MEASUREMENT_FILE ON MEASUREMENT_FILE(REMOTE_ID) +CREATE CACHED TABLE METHOD(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),CONDITIONING VARCHAR(2000),PREPARATION VARCHAR(2000),CONSERVATION VARCHAR(2000),REFERENCE VARCHAR(2000),RANK VARCHAR(100) NOT NULL,HANDBOOK_PATH VARCHAR(255),CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE METIER(ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(100),NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(256),UPDATE_DATE TIMESTAMP,GEAR_FK INTEGER,TAXON_GROUP_FK INTEGER,STATUS_FK VARCHAR(1) NOT NULL,CONSTRAINT METIER_GEAR_FKC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID)) +CREATE CACHED TABLE MINIMUM_SIZE_ALLOWED(ID INTEGER NOT NULL PRIMARY KEY,MINIMUM_SIZE REAL NOT NULL,UPDATE_DATE TIMESTAMP,TAXON_GROUP_FK INTEGER NOT NULL,CORPUS_FK INTEGER NOT NULL,UNIT_FK INTEGER NOT NULL,CONSTRAINT MINIMUM_SIZE_ALLOWED_CORPUS_FC FOREIGN KEY(CORPUS_FK) REFERENCES CORPUS(ID)) +CREATE INDEX IX_MINIMUM_SIZE_ALLOWED_UD ON MINIMUM_SIZE_ALLOWED(UPDATE_DATE) +CREATE CACHED TABLE MINIMUM_SIZE_ALLOWED2LOCATION(MINIMUM_SIZE_ALLOWED_FK INTEGER NOT NULL,LOCATION_FK INTEGER NOT NULL,PRIMARY KEY(MINIMUM_SIZE_ALLOWED_FK,LOCATION_FK),CONSTRAINT LOCATION_MINIMUM_SIZE_ALLOWEDC FOREIGN KEY(MINIMUM_SIZE_ALLOWED_FK) REFERENCES MINIMUM_SIZE_ALLOWED(ID),CONSTRAINT MINIMUM_SIZE_ALLOWED_LOCATIONC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE NARY_OPERATOR(ID BIGINT NOT NULL PRIMARY KEY) +CREATE CACHED TABLE NEARBY_SPECIFIC_AREA(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255) NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE NOT_EQUALS(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT NOT_EQUALSIFKC FOREIGN KEY(ID) REFERENCES BINARY_OPERATOR(ID)) +CREATE CACHED TABLE NOT_LIKE(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT NOT_LIKEIFKC FOREIGN KEY(ID) REFERENCES BINARY_OPERATOR(ID)) +CREATE CACHED TABLE NULL_OPERATOR(ID BIGINT NOT NULL PRIMARY KEY) +CREATE CACHED TABLE NUMERICAL_PRECISION(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255) NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE OBJECT_TYPE(CODE VARCHAR(40) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE OPERATION(ID INTEGER NOT NULL PRIMARY KEY,IS_FISHING_OPERATION INTEGER NOT NULL,NAME VARCHAR(100),RANK_ORDER_ON_PERIOD SMALLINT,START_DATE_TIME TIMESTAMP,END_DATE_TIME TIMESTAMP,IS_MAIN_OPERATION BOOLEAN,COMMENTS VARCHAR(2000),CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,VESSEL_FK VARCHAR(12) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,GEAR_PHYSICAL_FEATURES_FK INTEGER,FISHING_TRIP_FK INTEGER,FISHING_START_DATE_TIME TIMESTAMP,FISHING_END_DATE_TIME TIMESTAMP,HAS_CATCH BOOLEAN,CATCH_BATCH_FK INTEGER,CONSTRAINT SYS_CT_272 UNIQUE(CATCH_BATCH_FK),CONSTRAINT OPERATION_FISHING_TRIP_FKC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT OPERATION_GEAR_PHYSICAL_FEATUC FOREIGN KEY(GEAR_PHYSICAL_FEATURES_FK) REFERENCES GEAR_PHYSICAL_FEATURES(ID),CONSTRAINT FISHING_OPERATION_CATCH_BATCHC FOREIGN KEY(CATCH_BATCH_FK) REFERENCES BATCH(ID)) +CREATE INDEX IX_RMTID_OPERATION ON OPERATION(REMOTE_ID) +CREATE INDEX OPERATION_NATIDX ON OPERATION(RANK_ORDER_ON_PERIOD,START_DATE_TIME,VESSEL_FK,FISHING_TRIP_FK,FISHING_START_DATE_TIME) +CREATE CACHED TABLE OPERATION_VESSEL_ASSOCIATION(OPERATION_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,IS_CATCH_ON_OPERATION_VESSEL BOOLEAN NOT NULL,COMMENTS VARCHAR(2000),PRIMARY KEY(OPERATION_FK,VESSEL_FK),CONSTRAINT OPERATION_VESSEL_ASSOCIATION_C FOREIGN KEY(OPERATION_FK) REFERENCES OPERATION(ID)) +CREATE CACHED TABLE OPERATOR(ID BIGINT NOT NULL PRIMARY KEY,ATTRIBUTE VARCHAR(256) NOT NULL,CRITERIA_FK BIGINT,CONSTRAINT OPERATOR_CRITERIA_FKC FOREIGN KEY(CRITERIA_FK) REFERENCES CRITERIA(ID)) +CREATE CACHED TABLE ORDER_ITEM(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID INTEGER NOT NULL,RANK INTEGER NOT NULL,UPDATE_DATE TIMESTAMP,ORDER_TYPE_FK INTEGER NOT NULL) +CREATE INDEX IX_ORDER_ITEM_UD ON ORDER_ITEM(UPDATE_DATE) +CREATE INDEX IX_ORDER_ITEM_OBJID ON ORDER_ITEM(OBJECT_ID) +CREATE CACHED TABLE ORDER_TYPE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,CONSTRAINT ORDER_TYPE_OBJECT_TYPE_FKC FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE)) +CREATE CACHED TABLE OR_CRITERIA(ID BIGINT NOT NULL PRIMARY KEY,CLIENT_FK BIGINT NOT NULL,CRITERIA_FK BIGINT,CONSTRAINT OR_CRITERIA_CLIENT_FKC FOREIGN KEY(CLIENT_FK) REFERENCES CRITERIA(ID),CONSTRAINT OR_CRITERIA_CRITERIA_FKC FOREIGN KEY(CRITERIA_FK) REFERENCES CRITERIA(ID)) +CREATE CACHED TABLE PARAMETER(CODE VARCHAR(40) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),IS_QUALITATIVE BOOLEAN NOT NULL,IS_TAXINOMIC BOOLEAN NOT NULL,IS_CALCULATED BOOLEAN NOT NULL,IS_ALPHANUMERIC BOOLEAN NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,PARAMETER_GROUP_FK INTEGER NOT NULL) +CREATE INDEX IX_PARAMETER_UD ON PARAMETER(UPDATE_DATE) +CREATE CACHED TABLE PARAMETER_GROUP(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,PARENT_PARAMETER_GROUP_FK INTEGER,CONSTRAINT PARAMETER_GROUP_PARENT_PARAMEC FOREIGN KEY(PARENT_PARAMETER_GROUP_FK) REFERENCES PARAMETER_GROUP(ID)) +CREATE CACHED TABLE PERSON(ID INTEGER NOT NULL PRIMARY KEY,LASTNAME VARCHAR(100) NOT NULL,FIRSTNAME VARCHAR(100) NOT NULL,ADDRESS VARCHAR(255),CREATION_DATE TIMESTAMP NOT NULL,PHONE_NUMBER VARCHAR(50),MOBILE_NUMBER VARCHAR(50),FAX_NUMBER VARCHAR(50),EMAIL VARCHAR(255),UPDATE_DATE TIMESTAMP,CRYPT_PASSWORD VARCHAR(255),EMPLOYEE_NUMBER VARCHAR(40),USERNAME VARCHAR(40),USERNAME_EXTRANET VARCHAR(40),STATUS_FK VARCHAR(1) NOT NULL,DEPARTMENT_FK INTEGER NOT NULL,CONSTRAINT PERSON_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_PERSON_UD ON PERSON(UPDATE_DATE) +CREATE CACHED TABLE PERSON2USER_PROFIL(PERSON_FK INTEGER NOT NULL,USER_PROFIL_FK INTEGER NOT NULL,PRIMARY KEY(PERSON_FK,USER_PROFIL_FK),CONSTRAINT USER_PROFIL_PERSON_FKC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID)) +CREATE CACHED TABLE PERSON_SESSION(ID INTEGER NOT NULL PRIMARY KEY,UPDATE_DATE TIMESTAMP NOT NULL,PERSON_FK INTEGER NOT NULL,CONSTRAINT PERSON_SESSION_PERSON_FKC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID)) +CREATE CACHED TABLE PHOTO(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID INTEGER NOT NULL,NAME VARCHAR(100),DIRECTION_DESCRIPTION VARCHAR(255),COMMENTS VARCHAR(2000),PATH VARCHAR(255) NOT NULL,PHOTO_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,DEPARTMENT_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PHOTO_TYPE_FK VARCHAR(40) NOT NULL,CONSTRAINT PHOTO_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT PHOTO_OBJECT_TYPE_FKC FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE)) +CREATE INDEX IX_RMTID_PHOTO ON PHOTO(REMOTE_ID) +CREATE CACHED TABLE PHOTO_TYPE(CODE VARCHAR(40) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255) NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE PHYSICAL_GEAR_SURVEY(ID INTEGER NOT NULL PRIMARY KEY,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,YEAR INTEGER NOT NULL,DIRECT_SURVEY_INVESTIGATION BOOLEAN NOT NULL,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,VESSEL_FK VARCHAR(12) NOT NULL,RECORDER_PERSON_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,CONSTRAINT PHYSICAL_GEAR_SURVEY_RECORDERC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT PHYSICAL_GEAR_SURVEY_RECORDERY FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_PHYSICAL_GEAR_SURVEY_UD ON PHYSICAL_GEAR_SURVEY(UPDATE_DATE) +CREATE INDEX IX_RMTID_PHYSICAL_GEAR_SURVEY ON PHYSICAL_GEAR_SURVEY(REMOTE_ID) +CREATE INDEX PHYSICAL_GEAR_SURVEY_NATIDX ON PHYSICAL_GEAR_SURVEY(YEAR,VESSEL_FK,PROGRAM_FK) +CREATE CACHED TABLE PMFM(ID INTEGER NOT NULL PRIMARY KEY,SIGNIF_FIGURES_NUMBER INTEGER,MAXIMUM_NUMBER_DECIMALS INTEGER,DETECTION_THRESHOLD REAL,MIN_VALUE REAL,MAX_VALUE REAL,PRECISION REAL,DEFAULT_VALUE REAL,CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,DESCRIPTION VARCHAR(255),FRACTION_FK INTEGER NOT NULL,PARAMETER_FK VARCHAR(40) NOT NULL,UNIT_FK INTEGER NOT NULL,MATRIX_FK INTEGER NOT NULL,METHOD_FK INTEGER NOT NULL,AGGREGATION_LEVEL_FK INTEGER NOT NULL,STATUS_FK VARCHAR(1) NOT NULL,CONSTRAINT PMFM_PARAMETER_FKC FOREIGN KEY(PARAMETER_FK) REFERENCES PARAMETER(CODE),CONSTRAINT PMFM_AGGREGATION_LEVEL_FKC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT PMFM_MATRIX_FKC FOREIGN KEY(MATRIX_FK) REFERENCES MATRIX(ID),CONSTRAINT PMFM_FRACTION_FKC FOREIGN KEY(FRACTION_FK) REFERENCES FRACTION(ID),CONSTRAINT PMFM_METHOD_FKC FOREIGN KEY(METHOD_FK) REFERENCES METHOD(ID)) +CREATE INDEX IX_PMFM_UD ON PMFM(UPDATE_DATE) +CREATE CACHED TABLE PMFM2QUALITATIVE_VALUE(PMFM_FK INTEGER NOT NULL,QUALITATIVE_VALUE_FK INTEGER NOT NULL,PRIMARY KEY(PMFM_FK,QUALITATIVE_VALUE_FK),CONSTRAINT QUALITATIVE_VALUE_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID)) +CREATE CACHED TABLE PMFM_APPLIED_STRATEGY(PMFM_FK INTEGER NOT NULL,APPLIED_STRATEGY_FK INTEGER NOT NULL,METIER_FK INTEGER,GEAR_FK INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,REFERENCE_TAXON_FK INTEGER,PRIMARY KEY(PMFM_FK,APPLIED_STRATEGY_FK),CONSTRAINT PMFM_APPLIED_STRATEGY_ANALYSIC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT PMFM_APPLIED_STRATEGY_METIER_C FOREIGN KEY(METIER_FK) REFERENCES METIER(ID),CONSTRAINT PMFM_APPLIED_STRATEGY_GEAR_FKC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID),CONSTRAINT PMFM_APPLIED_STRATEGY_APPLIEDC FOREIGN KEY(APPLIED_STRATEGY_FK) REFERENCES APPLIED_STRATEGY(ID),CONSTRAINT FK7B33F47042B67A95 FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID)) +CREATE CACHED TABLE PMFM_STRATEGY(ID INTEGER NOT NULL PRIMARY KEY,ACQUISITION_NUMBER INTEGER NOT NULL,RANK_ORDER INTEGER NOT NULL,IS_MANDATORY BOOLEAN NOT NULL,MIN_VALUE REAL,MAX_VALUE REAL,PMFM_FK INTEGER NOT NULL,ACQUISITION_LEVEL_FK VARCHAR(40) NOT NULL,GEAR_FK INTEGER,STRATEGY_FK INTEGER NOT NULL,PRECISION_TYPE_FK INTEGER,METIER_FK INTEGER,REFERENCE_TAXON_FK INTEGER,CONSTRAINT PMFM_STRATEGY_METIER_FKC FOREIGN KEY(METIER_FK) REFERENCES METIER(ID),CONSTRAINT PMFM_STRATEGY_GEAR_FKC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID),CONSTRAINT PMFM_STRATEGY_ACQUISITION_LEVC FOREIGN KEY(ACQUISITION_LEVEL_FK) REFERENCES ACQUISITION_LEVEL(CODE),CONSTRAINT PMFM_STRATEGY_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID)) +CREATE CACHED TABLE PRECISION_TYPE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE PROCESSING_HISTORY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,PROCESSING_DATE TIMESTAMP NOT NULL,DATA_TRANSFERT_TYPE VARCHAR(256),DATA_TRANSFERT_DATE TIMESTAMP,DATA_TRANSFERT_ADDRESS VARCHAR(256),CONFIGURATION VARCHAR(256),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROCESSING_TYPE_FK VARCHAR(40) NOT NULL,PROCESSING_STATUS_FK VARCHAR(40) NOT NULL,XML_CONFIGURATION VARCHAR(3000)) +CREATE INDEX IX_RMTID_PROCESSING_HISTORY ON PROCESSING_HISTORY(REMOTE_ID) +CREATE CACHED TABLE PROCESSING_STATUS(CODE VARCHAR(40) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE PROCESSING_TYPE(CODE VARCHAR(40) NOT NULL PRIMARY KEY,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE PRODUCE(ID INTEGER NOT NULL PRIMARY KEY,IS_DISCARD BOOLEAN NOT NULL,SUBGROUP_COUNT REAL,INDIVIDUAL_COUNT SMALLINT,TAXON_GROUP_OTHER_INFORMATION VARCHAR(256),CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,FISHING_OPERATION_FK INTEGER,TRANSSHIPMENT_FK INTEGER,EXPECTED_SALE_FK INTEGER,TAXON_GROUP_FK INTEGER NOT NULL,OTHER_TAXON_GROUP_FK INTEGER,SALE_FK INTEGER,GEAR_FK INTEGER,TAKE_OVER_FK INTEGER,LANDING_FK INTEGER,BUYER_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,BATCH_FK INTEGER,OTHER_GEAR_FK INTEGER,DRESSING_FK INTEGER,PRESERVATION_FK INTEGER,FRESHNESS_CATEGORY_FK INTEGER,SIZE_CATEGORY_FK INTEGER,TRANSACTION_FK INTEGER,WEIGHT REAL,WEIGHT_METHOD_FK INTEGER,COST REAL,SALE_TYPE_FK INTEGER,CONSTRAINT PRODUCE_LANDING_FKC FOREIGN KEY(LANDING_FK) REFERENCES LANDING(ID),CONSTRAINT PRODUCE_GEAR_FKC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID),CONSTRAINT PRODUCE_BUYER_FKC FOREIGN KEY(BUYER_FK) REFERENCES BUYER(ID),CONSTRAINT PRODUCE_FISHING_OPERATION_FKC FOREIGN KEY(FISHING_OPERATION_FK) REFERENCES OPERATION(ID),CONSTRAINT PRODUCE_EXPECTED_SALE_FKC FOREIGN KEY(EXPECTED_SALE_FK) REFERENCES EXPECTED_SALE(ID),CONSTRAINT PRODUCE_BATCH_FKC FOREIGN KEY(BATCH_FK) REFERENCES BATCH(ID),CONSTRAINT PRODUCE_OTHER_GEAR_FKC FOREIGN KEY(OTHER_GEAR_FK) REFERENCES GEAR(ID),CONSTRAINT PRODUCE_WEIGHT_METHOD_FKC FOREIGN KEY(WEIGHT_METHOD_FK) REFERENCES METHOD(ID)) +CREATE INDEX IX_RMTID_PRODUCE ON PRODUCE(REMOTE_ID) +CREATE CACHED TABLE PROGRAM(CODE VARCHAR(40) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255) NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,TAXON_GROUP_TYPE_FK VARCHAR(40) NOT NULL,GEAR_CLASSIFICATION_FK INTEGER NOT NULL,CONSTRAINT PROGRAM_GEAR_CLASSIFICATION_FC FOREIGN KEY(GEAR_CLASSIFICATION_FK) REFERENCES GEAR_CLASSIFICATION(ID)) +CREATE CACHED TABLE PROGRAM2DEPARTMENT(ID INTEGER NOT NULL PRIMARY KEY,DEPARTMENT_FK INTEGER NOT NULL,PROGRAM_PRIVILEGE_FK INTEGER NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,LOCATION_FK INTEGER,CONSTRAINT PROGRAM2DEPARTMENT_DEPARTMENTC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT PROGRAM2DEPARTMENT_LOCATION_FC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT PROGRAM2DEPARTMENT_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE CACHED TABLE PROGRAM2LOCATION(PROGRAM_FK VARCHAR(40) NOT NULL,LOCATION_FK INTEGER NOT NULL,PRIMARY KEY(PROGRAM_FK,LOCATION_FK),CONSTRAINT PROGRAM_LOCATION_FKC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT LOCATION_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE CACHED TABLE PROGRAM2LOCATION_CLASSIF(PROGRAM_FK VARCHAR(40) NOT NULL,LOCATION_CLASSIFICATION_FK INTEGER NOT NULL,PRIMARY KEY(PROGRAM_FK,LOCATION_CLASSIFICATION_FK),CONSTRAINT PROGRAM_LOCATION_CLASSIFICATIC FOREIGN KEY(LOCATION_CLASSIFICATION_FK) REFERENCES LOCATION_CLASSIFICATION(ID),CONSTRAINT LOCATION_CLASSIFICATION_PROGRC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE CACHED TABLE PROGRAM2PERSON(ID INTEGER NOT NULL PRIMARY KEY,PERSON_FK INTEGER NOT NULL,PROGRAM_PRIVILEGE_FK INTEGER NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,LOCATION_FK INTEGER,CONSTRAINT PROGRAM2PERSON_PERSON_FKC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT PROGRAM2PERSON_LOCATION_FKC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT PROGRAM2PERSON_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE CACHED TABLE PROGRAM_PRIVILEGE(ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(100) NOT NULL,NAME VARCHAR(255) NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE QUALIFICATION_RULE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),JAVA_CLASS VARCHAR(256) NOT NULL,VERSION VARCHAR(256) NOT NULL,UPDATE_DATE TIMESTAMP,DEFAULT_QUALITY_FLAG_FK VARCHAR(40) NOT NULL,STATUS_FK VARCHAR(1) NOT NULL,LABEL VARCHAR(60)) +CREATE CACHED TABLE QUALIFIED_ITEM(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID INTEGER NOT NULL,UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,CONSTRAINT QUALIFIED_ITEM_OBJECT_TYPE_FKC FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE)) +CREATE INDEX IX_RMTID_QUALIFIED_ITEM ON QUALIFIED_ITEM(REMOTE_ID) +CREATE CACHED TABLE QUALITATIVE_VALUE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(256),STATUS_FK VARCHAR(1) NOT NULL,PARAMETER_FK VARCHAR(40) NOT NULL,LABEL VARCHAR(40),CONSTRAINT QUALITATIVE_VALUE_PARAMETER_FC FOREIGN KEY(PARAMETER_FK) REFERENCES PARAMETER(CODE)) +CREATE CACHED TABLE QUALITY_FLAG(CODE VARCHAR(40) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE QUANTIFICATION_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,SUBGROUP_NUMBER SMALLINT,IS_REFERENCE_QUANTIFICATION BOOLEAN,BATCH_FK INTEGER NOT NULL,CONSTRAINT QUANTIFICAT_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT QUANTIFICAT_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT QUANTIFICAT_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT QUANTIFICAT_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT QUANTIFICATION__DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT QUANTIFICATIO_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT QUANTIFICAT_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT QUANTIFICATION_MEASUR_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT QUANTIFICATION_MEASUREMENT_BAC FOREIGN KEY(BATCH_FK) REFERENCES BATCH(ID)) +CREATE INDEX IX_RMTID_QUANTIF_MEASUREMENT ON QUANTIFICATION_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE REFERENCE_DOCUMENT(ID INTEGER NOT NULL PRIMARY KEY,REFERENCE VARCHAR(255) NOT NULL,PUBLICATION_DATE TIMESTAMP,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL) +CREATE CACHED TABLE REFERENCE_DOCUMENT2AUTHOR(AUTHOR_FK INTEGER NOT NULL,REFERENCE_DOCUMENT_FK INTEGER NOT NULL,PRIMARY KEY(AUTHOR_FK,REFERENCE_DOCUMENT_FK),CONSTRAINT AUTHOR_REFERENCE_DOCUMENT_FKC FOREIGN KEY(REFERENCE_DOCUMENT_FK) REFERENCES REFERENCE_DOCUMENT(ID),CONSTRAINT REFERENCE_DOCUMENT_AUTHOR_FKC FOREIGN KEY(AUTHOR_FK) REFERENCES AUTHOR(ID)) +CREATE CACHED TABLE REFERENCE_TAXON(ID INTEGER NOT NULL PRIMARY KEY,UPDATE_DATE TIMESTAMP,NAME VARCHAR(256)) +CREATE INDEX IX_REFERENCE_TAXON_UD ON REFERENCE_TAXON(UPDATE_DATE) +CREATE CACHED TABLE REFERENCE_TAXON_STRATEGY(REFERENCE_TAXON_FK INTEGER NOT NULL,STRATEGY_FK INTEGER NOT NULL,PRIORITY_LEVEL SMALLINT,PRIMARY KEY(REFERENCE_TAXON_FK,STRATEGY_FK),CONSTRAINT REFERENCE_TAXON_STRATEGY_REFEC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID)) +CREATE CACHED TABLE REGULATION_AREA(ID INTEGER NOT NULL PRIMARY KEY,LOCATION_FK INTEGER,DEPTH_GRADIENT_FK INTEGER,DISTANCE_TO_COAST_GRADIENT_FK INTEGER,NEARBY_SPECIFIC_AREA_FK INTEGER,FISHERY_FK INTEGER NOT NULL,GROUPING_FK INTEGER,CONSTRAINT REGULATION_AREA_DEPTH_GRADIENC FOREIGN KEY(DEPTH_GRADIENT_FK) REFERENCES DEPTH_GRADIENT(ID),CONSTRAINT REGULATION_AREA_DISTANCE_TO_CC FOREIGN KEY(DISTANCE_TO_COAST_GRADIENT_FK) REFERENCES DISTANCE_TO_COAST_GRADIENT(ID),CONSTRAINT REGULATION_AREA_NEARBY_SPECIFC FOREIGN KEY(NEARBY_SPECIFIC_AREA_FK) REFERENCES NEARBY_SPECIFIC_AREA(ID),CONSTRAINT REGULATION_AREA_FISHERY_FKC FOREIGN KEY(FISHERY_FK) REFERENCES FISHERY(ID),CONSTRAINT REGULATION_AREA_GROUPING_FKC FOREIGN KEY(GROUPING_FK) REFERENCES GROUPING(ID),CONSTRAINT REGULATION_AREA_LOCATION_FKC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE INDEX REGULATION_AREA_NATIDX ON REGULATION_AREA(FISHERY_FK,GROUPING_FK,LOCATION_FK) +CREATE CACHED TABLE REGULATION_AREA2REG_LOCATION(REGULATION_AREA_FK INTEGER NOT NULL,LOCATION_FK INTEGER NOT NULL,PRIMARY KEY(REGULATION_AREA_FK,LOCATION_FK),CONSTRAINT FK57D2BB902C1FBE4 FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT REGULATION_AREA2REG_LOCATION_C FOREIGN KEY(REGULATION_AREA_FK) REFERENCES REGULATION_AREA(ID)) +CREATE CACHED TABLE RIGHT_TO_PRODUCE(ID INTEGER NOT NULL PRIMARY KEY,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,REFERENCE VARCHAR(100),UPDATE_DATE TIMESTAMP,CORPUS_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,RANK_ORDER_ON_PERIOD SMALLINT,CONSTRAINT RIGHT_TO_PRODUCE_CORPUS_FKC FOREIGN KEY(CORPUS_FK) REFERENCES CORPUS(ID),CONSTRAINT RIGHT_TO_PRODUCE_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE CACHED TABLE RIGHT_TO_PRODUCE2FISHERY(RIGHT_TO_PRODUCE_FK INTEGER NOT NULL,FISHERY_FK INTEGER NOT NULL,PRIMARY KEY(RIGHT_TO_PRODUCE_FK,FISHERY_FK),CONSTRAINT FISHERY_RIGHT_TO_PRODUCE_FKC FOREIGN KEY(RIGHT_TO_PRODUCE_FK) REFERENCES RIGHT_TO_PRODUCE(ID),CONSTRAINT RIGHT_TO_PRODUCE_FISHERY_FKC FOREIGN KEY(FISHERY_FK) REFERENCES FISHERY(ID)) +CREATE CACHED TABLE ROUND_WEIGHT_CONVERSION(ID INTEGER NOT NULL PRIMARY KEY,CONVERSION_COEFFICIENT REAL NOT NULL,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,TAXON_GROUP_FK INTEGER NOT NULL,LOCATION_FK INTEGER NOT NULL,PRESERVING_FK INTEGER NOT NULL,DRESSING_FK INTEGER NOT NULL,CONSTRAINT ROUND_WEIGHT_CONVERSION_PRESEC FOREIGN KEY(PRESERVING_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT ROUND_WEIGHT_CONVERSION_DRESSC FOREIGN KEY(DRESSING_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT ROUND_WEIGHT_CONVERSION_LOCATC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE INDEX IX_ROUND_WEIGHT_CONVERSION_UD ON ROUND_WEIGHT_CONVERSION(UPDATE_DATE) +CREATE CACHED TABLE RVALUE(ID BIGINT NOT NULL PRIMARY KEY,VALUE VARCHAR(256) NOT NULL,IS_LOWER_BOUND BOOLEAN,NARY_OPERATOR_FK BIGINT,CONSTRAINT RVALUE_NARY_OPERATOR_FKC FOREIGN KEY(NARY_OPERATOR_FK) REFERENCES NARY_OPERATOR(ID)) +CREATE CACHED TABLE SALE(ID INTEGER NOT NULL PRIMARY KEY,IS_OBSERVED INTEGER NOT NULL,SALE_START_DATE TIMESTAMP,SALE_END_DATE TIMESTAMP,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,VESSEL_FK VARCHAR(12) NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,SELLER_FK INTEGER,RECORDER_PERSON_FK INTEGER,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,TAKE_OVER_FK INTEGER,DECLARED_DOCUMENT_REFERENCE_FK INTEGER,LANDING_FK INTEGER,FISHING_TRIP_FK INTEGER,SALE_LOCATION_FK INTEGER,SALE_TYPE_FK INTEGER,CATCH_BATCH_FK INTEGER,SAMPLING_STRATA_FK INTEGER,CONSTRAINT SYS_CT_374 UNIQUE(CATCH_BATCH_FK),CONSTRAINT SALE_LANDING_FKC FOREIGN KEY(LANDING_FK) REFERENCES LANDING(ID),CONSTRAINT SALE_FISHING_TRIP_FKC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT SALE_DECLARED_DOCUMENT_REFEREC FOREIGN KEY(DECLARED_DOCUMENT_REFERENCE_FK) REFERENCES DECLARED_DOCUMENT_REFERENCE(ID),CONSTRAINT SALE_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT SALE_CATCH_BATCH_FKC FOREIGN KEY(CATCH_BATCH_FK) REFERENCES BATCH(ID),CONSTRAINT SALE_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT SALE_RECORDER_DEPARTMENT_FKC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT SALE_RECORDER_PERSON_FKC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT SALE_SALE_LOCATION_FKC FOREIGN KEY(SALE_LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE INDEX IX_RMTID_SALE ON SALE(REMOTE_ID) +CREATE INDEX IX_SALE_UD ON SALE(UPDATE_DATE) +CREATE INDEX IX_SALE_SALE_START_DATE ON SALE(SALE_START_DATE) +CREATE CACHED TABLE SALE2OBSERVER_PERSON(SALE_FK INTEGER NOT NULL,PERSON_FK INTEGER NOT NULL,PRIMARY KEY(SALE_FK,PERSON_FK),CONSTRAINT OBSERVED_SALE_PERSON_FKC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT PERSON_SALE_FKC FOREIGN KEY(SALE_FK) REFERENCES SALE(ID)) +CREATE CACHED TABLE SALE_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,EXPECTED_SALE_FK INTEGER,SALE_FK INTEGER,CONSTRAINT SALE_MEASUR_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT SALE_MEASUR_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT SALE_MEASUR_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT SALE_MEASUR_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT SALE_MEASUREMEN_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT SALE_MEASUREM_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT SALE_MEASUR_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT SALE_MEASUREMENT_EXPECTED_SALC FOREIGN KEY(EXPECTED_SALE_FK) REFERENCES EXPECTED_SALE(ID),CONSTRAINT SALE_MEASUREMENT_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT SALE_MEASUREMENT_SALE_FKC FOREIGN KEY(SALE_FK) REFERENCES SALE(ID)) +CREATE INDEX IX_RMTID_SALE_MEASUREMENT ON SALE_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE SALE_ORIGIN(PROGRAM_FK VARCHAR(40) NOT NULL,SALE_FK INTEGER NOT NULL,PRIMARY KEY(PROGRAM_FK,SALE_FK),CONSTRAINT FK7DB25A1E69342651 FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT SALE_ORIGIN_SALE_FKC FOREIGN KEY(SALE_FK) REFERENCES SALE(ID)) +CREATE CACHED TABLE SALE_TYPE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,STATUS_FK VARCHAR(1) NOT NULL,MARKETING_BUYER_TYPE_FK INTEGER,MARKETING_DESTINATION_FK INTEGER,MARKETING_STATUS_FK INTEGER,MARKETING_TRANSACTION_FK INTEGER,CONSTRAINT SALE_TYPE_MARKETING_BUYER_TYPC FOREIGN KEY(MARKETING_BUYER_TYPE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT SALE_TYPE_MARKETING_DESTINATIC FOREIGN KEY(MARKETING_DESTINATION_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT SALE_TYPE_MARKETING_STATUS_FKC FOREIGN KEY(MARKETING_STATUS_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT SALE_TYPE_MARKETING_TRANSACTIC FOREIGN KEY(MARKETING_TRANSACTION_FK) REFERENCES QUALITATIVE_VALUE(ID)) +CREATE CACHED TABLE SAMPLE(ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(100) NOT NULL,SAMPLE_DATE TIMESTAMP,INDIVIDUAL_COUNT SMALLINT,SAMPLE_SIZE REAL,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,FISHING_OPERATION_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,MATRIX_FK INTEGER NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,REFERENCE_TAXON_FK INTEGER,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,PARENT_SAMPLE_FK INTEGER,RECORDER_PERSON_FK INTEGER,TAXON_GROUP_FK INTEGER,SIZE_UNIT_FK INTEGER,BATCH_FK INTEGER,CONSTRAINT SAMPLE_RECORDER_PERSON_FKC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT SAMPLE_MATRIX_FKC FOREIGN KEY(MATRIX_FK) REFERENCES MATRIX(ID),CONSTRAINT SAMPLE_PARENT_SAMPLE_FKC FOREIGN KEY(PARENT_SAMPLE_FK) REFERENCES SAMPLE(ID),CONSTRAINT SAMPLE_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT SAMPLE_FISHING_OPERATION_FKC FOREIGN KEY(FISHING_OPERATION_FK) REFERENCES OPERATION(ID),CONSTRAINT SAMPLE_REFERENCE_TAXON_FKC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID),CONSTRAINT SAMPLE_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT SAMPLE_BATCH_FKC FOREIGN KEY(BATCH_FK) REFERENCES BATCH(ID),CONSTRAINT SAMPLE_RECORDER_DEPARTMENT_FKC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX SAMPLE_NATIDX ON SAMPLE(LABEL,FISHING_OPERATION_FK,PROGRAM_FK,MATRIX_FK) +CREATE INDEX IX_RMTID_SAMPLE ON SAMPLE(REMOTE_ID) +CREATE CACHED TABLE SAMPLE_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,INDIVIDUAL_NUMBER SMALLINT,IS_REFERENCE_MEASUREMENT BOOLEAN NOT NULL,SAMPLE_FK INTEGER NOT NULL,CONSTRAINT SAMPLE_MEAS_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT SAMPLE_MEAS_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT SAMPLE_MEAS_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT SAMPLE_MEAS_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT SAMPLE_MEASUREM_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT SAMPLE_MEASUR_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT SAMPLE_MEASUREMENT_SAMPLE_FKC FOREIGN KEY(SAMPLE_FK) REFERENCES SAMPLE(ID),CONSTRAINT SAMPLE_MEAS_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT SAMPLE_MEASUREMENT_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID)) +CREATE INDEX IX_RMTID_SAMPLE_MEASUREMENT ON SAMPLE_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE SCIENTIFIC_CRUISE(ID INTEGER NOT NULL PRIMARY KEY,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,NAME VARCHAR(100) NOT NULL,DEPARTURE_DATE_TIME TIMESTAMP NOT NULL,RETURN_DATE_TIME TIMESTAMP,REFERENCE VARCHAR(255),COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,RECORDER_PERSON_FK INTEGER,VESSEL_FK VARCHAR(12) NOT NULL,MANAGER_PERSON_FK INTEGER NOT NULL,CONSTRAINT SCIENTIFIC_CRUISE_RECORDER_PEC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT SCIENTIFIC_CRUISE_MANAGER_PERC FOREIGN KEY(MANAGER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT SCIENTIFIC_CRUISE_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT SCIENTIFIC_CRUISE_RECORDER_DEC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_SCIENTIFIC_CRUISE_UD ON SCIENTIFIC_CRUISE(UPDATE_DATE) +CREATE INDEX SCIENTIFIC_CRUISE_NATIDX ON SCIENTIFIC_CRUISE(DEPARTURE_DATE_TIME,PROGRAM_FK,VESSEL_FK) +CREATE INDEX IX_RMTID_SCIENTIFIC_CRUISE ON SCIENTIFIC_CRUISE(REMOTE_ID) +CREATE CACHED TABLE SELECT_PROPERTY_CRITERIA(ID BIGINT NOT NULL PRIMARY KEY,CONSTRAINT SELECT_PROPERTY_CRITERIAIFKC FOREIGN KEY(ID) REFERENCES LINKED_PROPERTY_CRITERIA(ID)) +CREATE CACHED TABLE SELLER(ID INTEGER NOT NULL PRIMARY KEY,REGISTRATION_CODE VARCHAR(40),NAME VARCHAR(100),BASE_SALE_LOCATION_FK INTEGER,SELLER_TYPE_FK SMALLINT NOT NULL,UPDATE_DATE TIMESTAMP,ADDRESS VARCHAR(255),CONSTRAINT SELLER_BASE_SALE_LOCATION_FKC FOREIGN KEY(BASE_SALE_LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE SELLER_TYPE(ID SMALLINT NOT NULL PRIMARY KEY,NAME VARCHAR(100),UPDATE_DATE TIMESTAMP,LABEL VARCHAR(40)) +CREATE CACHED TABLE SORTING_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,RANK_ORDER INTEGER NOT NULL,SORTING_BATCH_FK INTEGER NOT NULL,CONSTRAINT SORTING_MEA_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT SORTING_MEA_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT SORTING_MEA_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT SORTING_MEA_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT SORTING_MEASURE_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT SORTING_MEASU_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT SORTING_MEA_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT SORTING_MEASUREMENT_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT SORTING_MEASUREMENT_SORTING_BC FOREIGN KEY(SORTING_BATCH_FK) REFERENCES BATCH(ID)) +CREATE INDEX IX_RMTID_SORTING_MEASUREMENT ON SORTING_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE SPATIAL_ITEM(ID INTEGER NOT NULL PRIMARY KEY,OBJECT_ID INTEGER NOT NULL,UPDATE_DATE TIMESTAMP,SPATIAL_ITEM_TYPE_FK INTEGER NOT NULL) +CREATE INDEX IX_SPATIAL_ITEM_UD ON SPATIAL_ITEM(UPDATE_DATE) +CREATE INDEX IX_SPATIAL_ITEM_OBJID ON SPATIAL_ITEM(OBJECT_ID) +CREATE CACHED TABLE SPATIAL_ITEM2LOCATION(LOCATION_FK INTEGER NOT NULL,SPATIAL_ITEM_FK INTEGER NOT NULL,LOCALIZED_NAME VARCHAR(256),PRIMARY KEY(LOCATION_FK,SPATIAL_ITEM_FK),CONSTRAINT SPATIAL_ITEM2LOCATION_SPATIALC FOREIGN KEY(SPATIAL_ITEM_FK) REFERENCES SPATIAL_ITEM(ID),CONSTRAINT SPATIAL_ITEM2LOCATION_LOCATIOC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE SPATIAL_ITEM_AREA(ID INTEGER NOT NULL PRIMARY KEY,LOCALIZED_NAME VARCHAR(100),SPATIAL_ITEM_FK INTEGER NOT NULL,CONSTRAINT SPATIAL_ITEM_AREA_SPATIAL_ITEC FOREIGN KEY(SPATIAL_ITEM_FK) REFERENCES SPATIAL_ITEM(ID)) +CREATE CACHED TABLE SPATIAL_ITEM_LINE(ID INTEGER NOT NULL PRIMARY KEY,LOCALIZED_NAME VARCHAR(100),SPATIAL_ITEM_FK INTEGER NOT NULL,CONSTRAINT SPATIAL_ITEM_LINE_SPATIAL_ITEC FOREIGN KEY(SPATIAL_ITEM_FK) REFERENCES SPATIAL_ITEM(ID)) +CREATE CACHED TABLE SPATIAL_ITEM_POINT(ID INTEGER NOT NULL PRIMARY KEY,LOCALIZED_NAME VARCHAR(100),SPATIAL_ITEM_FK INTEGER NOT NULL,CONSTRAINT SPATIAL_ITEM_POINT_SPATIAL_ITC FOREIGN KEY(SPATIAL_ITEM_FK) REFERENCES SPATIAL_ITEM(ID)) +CREATE CACHED TABLE SPATIAL_ITEM_TYPE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,LABEL VARCHAR(40) NOT NULL,CONSTRAINT SPATIAL_ITEM_TYPE_OBJECT_TYPEC FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE)) +CREATE CACHED TABLE STATUS(CODE VARCHAR(1) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL) +CREATE CACHED TABLE STRATEGY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255) NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,PROGRAM_FK VARCHAR(40) NOT NULL,CONSTRAINT STRATEGY_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE CACHED TABLE STRATEGY2GEAR(STRATEGY_FK INTEGER NOT NULL,GEAR_FK INTEGER NOT NULL,PRIMARY KEY(STRATEGY_FK,GEAR_FK),CONSTRAINT GEAR_STRATEGY_FKC FOREIGN KEY(STRATEGY_FK) REFERENCES STRATEGY(ID),CONSTRAINT STRATEGY_GEAR_FKC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID)) +CREATE CACHED TABLE STRATEGY2MANAGER_PERSON(STRATEGY_FK INTEGER NOT NULL,PERSON_FK INTEGER NOT NULL,PRIMARY KEY(STRATEGY_FK,PERSON_FK),CONSTRAINT PERSON_STRATEGY_FKC FOREIGN KEY(STRATEGY_FK) REFERENCES STRATEGY(ID),CONSTRAINT STRATEGY_PERSON_FKC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID)) +CREATE CACHED TABLE SURVEY_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,TRANSSHIPMENT_FK INTEGER,SALE_FK INTEGER,ECONOMICAL_SURVEY_FK INTEGER,DAILY_ACTIVITY_CALENDAR_FK INTEGER,ACTIVITY_CALENDAR_FK INTEGER,DECLARED_DOCUMENT_REFERENCE_FK INTEGER,LANDING_FK INTEGER,FISHING_TRIP_FK INTEGER,PHYSICAL_GEAR_SURVEY_FK INTEGER,FISHING_EFFORT_CALENDAR_FK INTEGER,CONSTRAINT SURVEY_MEASUREMENT_FISHING_TRC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT SURVEY_MEASUREMENT_LANDING_FKC FOREIGN KEY(LANDING_FK) REFERENCES LANDING(ID),CONSTRAINT SURVEY_MEASUREMENT_DECLARED_DC FOREIGN KEY(DECLARED_DOCUMENT_REFERENCE_FK) REFERENCES DECLARED_DOCUMENT_REFERENCE(ID),CONSTRAINT SURVEY_MEASUREM_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT SURVEY_MEASUREMENT_ACTIVITY_CC FOREIGN KEY(ACTIVITY_CALENDAR_FK) REFERENCES ACTIVITY_CALENDAR(ID),CONSTRAINT SURVEY_MEASUR_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT SURVEY_MEASUREMENT_PHYSICAL_GC FOREIGN KEY(PHYSICAL_GEAR_SURVEY_FK) REFERENCES PHYSICAL_GEAR_SURVEY(ID),CONSTRAINT SURVEY_MEASUREMENT_FISHING_EFC FOREIGN KEY(FISHING_EFFORT_CALENDAR_FK) REFERENCES FISHING_EFFORT_CALENDAR(ID),CONSTRAINT SURVEY_MEAS_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT SURVEY_MEAS_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT SURVEY_MEAS_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT SURVEY_MEAS_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT SURVEY_MEASUREMENT_ECONOMICALC FOREIGN KEY(ECONOMICAL_SURVEY_FK) REFERENCES ECONOMICAL_SURVEY(ID),CONSTRAINT SURVEY_MEASUREMENT_DAILY_ACTIC FOREIGN KEY(DAILY_ACTIVITY_CALENDAR_FK) REFERENCES DAILY_ACTIVITY_CALENDAR(ID),CONSTRAINT SURVEY_MEAS_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT SURVEY_MEASUREMENT_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT SURVEY_MEASUREMENT_SALE_FKC FOREIGN KEY(SALE_FK) REFERENCES SALE(ID)) +CREATE INDEX IX_RMTID_SURVEY_MEASUREMENT ON SURVEY_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE TAKE_OVER(ID INTEGER NOT NULL PRIMARY KEY,TAKE_OVER_DATE_TIME TIMESTAMP NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,RECORDER_PERSON_FK INTEGER,VESSEL_FK VARCHAR(12) NOT NULL,LANDING_FK INTEGER,SELLER_FK INTEGER NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,FISHING_TRIP_FK INTEGER,TAKE_OVER_LOCATION_FK INTEGER NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,DECLARED_DOCUMENT_REFERENCE_FK INTEGER,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,STORAGE_FACILITY_FK INTEGER,CONSTRAINT TAKE_OVER_TAKE_OVER_LOCATION_C FOREIGN KEY(TAKE_OVER_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT TAKE_OVER_FISHING_TRIP_FKC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT TAKE_OVER_LANDING_FKC FOREIGN KEY(LANDING_FK) REFERENCES LANDING(ID),CONSTRAINT TAKE_OVER_RECORDER_PERSON_FKC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT TAKE_OVER_DECLARED_DOCUMENT_RC FOREIGN KEY(DECLARED_DOCUMENT_REFERENCE_FK) REFERENCES DECLARED_DOCUMENT_REFERENCE(ID),CONSTRAINT TAKE_OVER_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT TAKE_OVER_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT TAKE_OVER_SELLER_FKC FOREIGN KEY(SELLER_FK) REFERENCES SELLER(ID),CONSTRAINT TAKE_OVER_RECORDER_DEPARTMENTC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT TAKE_OVER_STORAGE_FACILITY_FKC FOREIGN KEY(STORAGE_FACILITY_FK) REFERENCES SELLER(ID)) +CREATE INDEX IX_RMTID_TAKE_OVER ON TAKE_OVER(REMOTE_ID) +CREATE INDEX IX_TAKE_OVER_UD ON TAKE_OVER(UPDATE_DATE) +CREATE CACHED TABLE TAKE_OVER_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,TAKE_OVER_FK INTEGER NOT NULL,CONSTRAINT TAKE_OVER_M_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT TAKE_OVER_M_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT TAKE_OVER_M_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT TAKE_OVER_M_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT TAKE_OVER_MEASU_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT TAKE_OVER_MEA_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT TAKE_OVER_M_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT TAKE_OVER_MEASUREMENT_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT TAKE_OVER_MEASUREMENT_TAKE_OVC FOREIGN KEY(TAKE_OVER_FK) REFERENCES TAKE_OVER(ID)) +CREATE INDEX IX_RMTID_TAKE_OVER_MEASUREMENT ON TAKE_OVER_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE TAXONOMIC_LEVEL(CODE VARCHAR(40) NOT NULL PRIMARY KEY,RANK INTEGER NOT NULL,NAME VARCHAR(100) NOT NULL,LABEL VARCHAR(100),COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,CONSTRAINT TAXONOMIC_LEVEL_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE)) +CREATE CACHED TABLE TAXON_GROUP(ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(100),NAME VARCHAR(100) NOT NULL,COMMENTS VARCHAR(2000),IS_CHILD_GROUP_EXCLUSIVE BOOLEAN NOT NULL,IS_UPDATABLE BOOLEAN NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,PARENT_TAXON_GROUP_FK INTEGER,STATUS_FK VARCHAR(1) NOT NULL,TAXON_GROUP_TYPE_FK VARCHAR(40) NOT NULL,CONSTRAINT TAXON_GROUP_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE),CONSTRAINT TAXON_GROUP_PARENT_TAXON_GROUC FOREIGN KEY(PARENT_TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID)) +CREATE INDEX IX_TAXON_GROUP_UD ON TAXON_GROUP(UPDATE_DATE) +CREATE INDEX TAXON_GROUP_NATIDX ON TAXON_GROUP(NAME,PARENT_TAXON_GROUP_FK,TAXON_GROUP_TYPE_FK) +CREATE CACHED TABLE TAXON_GROUP_HISTORICAL_RECORD(ID INTEGER NOT NULL PRIMARY KEY,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,TAXON_GROUP_FK INTEGER NOT NULL,REFERENCE_TAXON_FK INTEGER NOT NULL,CONSTRAINT TAXON_GROUP_HISTORICAL_RECORDC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID),CONSTRAINT TAXON_GROUP_HISTORICAL_RECORDS FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID)) +CREATE INDEX TAXON_GROUP_HISTORICAL__NATIDX ON TAXON_GROUP_HISTORICAL_RECORD(START_DATE,TAXON_GROUP_FK,REFERENCE_TAXON_FK) +CREATE CACHED TABLE TAXON_GROUP_INFORMATION(TAXON_GROUP_FK INTEGER NOT NULL,REFERENCE_DOCUMENT_FK INTEGER NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,PRIMARY KEY(TAXON_GROUP_FK,REFERENCE_DOCUMENT_FK),CONSTRAINT TAXON_GROUP_INFORMATION_TAXONC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID),CONSTRAINT FK9E84B8D7952DE3DE FOREIGN KEY(REFERENCE_DOCUMENT_FK) REFERENCES REFERENCE_DOCUMENT(ID)) +CREATE CACHED TABLE TAXON_GROUP_TYPE(CODE VARCHAR(40) NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE TAXON_INFORMATION(TAXON_NAME_FK INTEGER NOT NULL,REFERENCE_DOCUMENT_FK INTEGER NOT NULL,DESCRIPTION VARCHAR(256),UPDATE_DATE TIMESTAMP,PRIMARY KEY(TAXON_NAME_FK,REFERENCE_DOCUMENT_FK),CONSTRAINT FKD1264EF7952DE3DE FOREIGN KEY(REFERENCE_DOCUMENT_FK) REFERENCES REFERENCE_DOCUMENT(ID)) +CREATE CACHED TABLE TAXON_INFORMATION_HISTORY(TAXON_NAME_HISTORY_FK INTEGER NOT NULL,REFERENCE_DOCUMENT_FK INTEGER NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,PRIMARY KEY(TAXON_NAME_HISTORY_FK,REFERENCE_DOCUMENT_FK),CONSTRAINT TAXON_INFORMATION_HISTORY_REFC FOREIGN KEY(REFERENCE_DOCUMENT_FK) REFERENCES REFERENCE_DOCUMENT(ID)) +CREATE CACHED TABLE TAXON_NAME(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(255) NOT NULL,COMPLETE_NAME VARCHAR(255),IS_NAMING BOOLEAN NOT NULL,IS_REFERENT BOOLEAN NOT NULL,UPPER_RANK INTEGER NOT NULL,IS_VIRTUAL BOOLEAN NOT NULL,IS_OBSOLETE BOOLEAN NOT NULL,IS_TEMPORARY BOOLEAN NOT NULL,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,REFERENCE_TAXON_FK INTEGER NOT NULL,TAXONOMIC_LEVEL_FK VARCHAR(40) NOT NULL,PARENT_TAXON_NAME_FK INTEGER,CITATION_FK INTEGER,CONSTRAINT TAXON_NAME_PARENT_TAXON_NAME_C FOREIGN KEY(PARENT_TAXON_NAME_FK) REFERENCES TAXON_NAME(ID),CONSTRAINT TAXON_NAME_TAXONOMIC_LEVEL_FKC FOREIGN KEY(TAXONOMIC_LEVEL_FK) REFERENCES TAXONOMIC_LEVEL(CODE),CONSTRAINT TAXON_NAME_REFERENCE_TAXON_FKC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID),CONSTRAINT TAXON_NAME_CITATION_FKC FOREIGN KEY(CITATION_FK) REFERENCES CITATION(ID)) +CREATE INDEX IX_TAXON_NAME_UD ON TAXON_NAME(UPDATE_DATE) +CREATE CACHED TABLE TAXON_NAME_HISTORY(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(255),COMMENTS VARCHAR(2000),UPPER_RANK INTEGER,IS_REFERENT BOOLEAN,IS_VIRTUAL BOOLEAN,IS_OBSOLETE BOOLEAN,IS_TEMPORARY BOOLEAN,UPDATE_DATE TIMESTAMP,CITATION_FK INTEGER,PARENT_TAXON_NAME_FK INTEGER,TAXON_NAME_FK INTEGER,CONSTRAINT TAXON_NAME_HISTORY_PARENT_TAXC FOREIGN KEY(PARENT_TAXON_NAME_FK) REFERENCES TAXON_NAME(ID),CONSTRAINT TAXON_NAME_HISTORY_TAXON_NAMEC FOREIGN KEY(TAXON_NAME_FK) REFERENCES TAXON_NAME(ID),CONSTRAINT TAXON_NAME_HISTORY_CITATION_FC FOREIGN KEY(CITATION_FK) REFERENCES CITATION(ID)) +CREATE CACHED TABLE TEMP_QUERY_PARAMETER(ID INTEGER NOT NULL PRIMARY KEY,PERSON_FK INTEGER NOT NULL,PARAMETER_NAME VARCHAR(50) NOT NULL,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(50)) +CREATE INDEX IX_TEMP_QUERY_PAR ON TEMP_QUERY_PARAMETER(PERSON_FK,PARAMETER_NAME) +CREATE CACHED TABLE TRANSCRIBING_SIDE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP,DESCRIPTION VARCHAR(255)) +CREATE CACHED TABLE TRANSCRIBING_SYSTEM(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,LABEL VARCHAR(40) NOT NULL,CONSTRAINT TRANSCRIBING_SYSTEM_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE)) +CREATE CACHED TABLE TRANSSHIPMENT(ID INTEGER NOT NULL PRIMARY KEY,TRANSSHIPMENT_DATE_TIME TIMESTAMP NOT NULL,RANK_ORDER SMALLINT,COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,RECORDER_PERSON_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,FROM_VESSEL_FK VARCHAR(12) NOT NULL,FISHING_TRIP_FK INTEGER,TO_VESSEL_FK VARCHAR(12) NOT NULL,TRANSSHIPMENT_LOCATION_FK INTEGER,CONSTRAINT TRANSSHIPMENT_FISHING_TRIP_FKC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT TRANSSHIPMENT_RECORDER_PERSONC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT TRANSSHIPMENT_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT TRANSSHIPMENT_TRANSSHIPMENT_LC FOREIGN KEY(TRANSSHIPMENT_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT TRANSSHIPMENT_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT TRANSSHIPMENT_RECORDER_DEPARTC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_RMTID_TRANSSHIPMENT ON TRANSSHIPMENT(REMOTE_ID) +CREATE INDEX TRANSSHIPMENT_NATIDX ON TRANSSHIPMENT(TRANSSHIPMENT_DATE_TIME,RANK_ORDER,PROGRAM_FK,FROM_VESSEL_FK) +CREATE CACHED TABLE UNIT(ID INTEGER NOT NULL PRIMARY KEY,SYMBOL VARCHAR(100) NOT NULL,NAME VARCHAR(100) NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,CONSTRAINT UNIT_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE)) +CREATE CACHED TABLE UNIT_CONVERSION(FROM_UNIT_FK INTEGER NOT NULL,TO_UNIT_FK INTEGER NOT NULL,CONVERSION_COEFFICIENT REAL NOT NULL,UPDATE_DATE TIMESTAMP,PRIMARY KEY(FROM_UNIT_FK,TO_UNIT_FK),CONSTRAINT FK8A65AB1870FAF00 FOREIGN KEY(FROM_UNIT_FK) REFERENCES UNIT(ID),CONSTRAINT FK8A65AB116844D1 FOREIGN KEY(TO_UNIT_FK) REFERENCES UNIT(ID)) +CREATE CACHED TABLE USER_PROFIL(ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(50) NOT NULL,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE UTIL_FACTORY(ID BIGINT NOT NULL PRIMARY KEY) +CREATE CACHED TABLE VESSEL(CODE VARCHAR(12) NOT NULL PRIMARY KEY,UPDATE_DATE TIMESTAMP,VESSEL_TYPE_FK INTEGER NOT NULL,STATUS_FK VARCHAR(1) NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,CONSTRAINT VESSEL_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE),CONSTRAINT VESSEL_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE INDEX IX_VESSEL_UD ON VESSEL(UPDATE_DATE) +CREATE CACHED TABLE VESSEL2RIGHT_TO_PRODUCE(RIGHT_TO_PRODUCE_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,PRIMARY KEY(RIGHT_TO_PRODUCE_FK,VESSEL_FK),CONSTRAINT VESSEL_RIGHT_TO_PRODUCE_FKC FOREIGN KEY(RIGHT_TO_PRODUCE_FK) REFERENCES RIGHT_TO_PRODUCE(ID),CONSTRAINT RIGHT_TO_PRODUCE_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE)) +CREATE CACHED TABLE VESSEL_FEATURES(ID INTEGER NOT NULL PRIMARY KEY,START_DATE_TIME TIMESTAMP NOT NULL,END_DATE_TIME TIMESTAMP,NAME VARCHAR(100),EXTERIOR_MARKING VARCHAR(100),ADMINISTRATIVE_POWER REAL,AUXILIARY_POWER REAL,GROSS_TONNAGE_GT INTEGER,GROSS_TONNAGE_GRT INTEGER,LOA INTEGER,LBP INTEGER,CONSTRUCTION_YEAR INTEGER,IRCS VARCHAR(40),HAS_VMS BOOLEAN,IS_FPC BOOLEAN NOT NULL,UPDATE_DATE TIMESTAMP,BASE_PORT_LOCATION_FK INTEGER,HULL_MATERIAL_QV_FK INTEGER,VESSEL_FK VARCHAR(12) NOT NULL,CONSTRAINT VESSEL_FEATURES_BASE_PORT_LOCC FOREIGN KEY(BASE_PORT_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT VESSEL_FEATURES_HULL_MATERIALC FOREIGN KEY(HULL_MATERIAL_QV_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT VESSEL_FEATURES_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE)) +CREATE INDEX VESSEL_FEATURES_NATIDX ON VESSEL_FEATURES(START_DATE_TIME,VESSEL_FK) +CREATE INDEX IX_VESSEL_FEATURES_UD ON VESSEL_FEATURES(UPDATE_DATE) +CREATE CACHED TABLE VESSEL_MANAGE_PERIOD(START_DATE_TIME TIMESTAMP NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,MANAGED_DATA_FK INTEGER NOT NULL,END_DATE_TIME TIMESTAMP,PRIMARY KEY(START_DATE_TIME,VESSEL_FK,MANAGED_DATA_FK),CONSTRAINT FKCED63B92401A9063 FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE),CONSTRAINT VESSEL_MANAGE_PERIOD_MANAGED_C FOREIGN KEY(MANAGED_DATA_FK) REFERENCES MANAGED_DATA(ID)) +CREATE CACHED TABLE VESSEL_OWNER(ID INTEGER NOT NULL PRIMARY KEY,REGISTRATION_CODE VARCHAR(40),LASTNAME VARCHAR(100),FIRSTNAME VARCHAR(100),STREET VARCHAR(256),ZIP_CODE VARCHAR(256),CITY VARCHAR(256),ADDRESS VARCHAR(256),DATE_OF_BIRTH TIMESTAMP,RETIREMENT_DATE TIMESTAMP,IS_IN_RETIREMENT BOOLEAN,UPDATE_DATE TIMESTAMP,PHONE_NUMBER VARCHAR(50),MOBILE_NUMBER VARCHAR(50),FAX_NUMBER VARCHAR(50),EMAIL VARCHAR(255),ACTIVITY_START_DATE TIMESTAMP,COUNTRY_LOCATION_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,CONSTRAINT VESSEL_OWNER_COUNTRY_LOCATIONC FOREIGN KEY(COUNTRY_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT VESSEL_OWNER_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE INDEX IX_VESSEL_OWNER_UD ON VESSEL_OWNER(UPDATE_DATE) +CREATE INDEX VESSEL_OWNER_NATIDX ON VESSEL_OWNER(PROGRAM_FK,REGISTRATION_CODE) +CREATE CACHED TABLE VESSEL_OWNER2RIGHT_TO_PRODUCE(RIGHT_TO_PRODUCE_FK INTEGER NOT NULL,VESSEL_OWNER_FK INTEGER NOT NULL,PRIMARY KEY(RIGHT_TO_PRODUCE_FK,VESSEL_OWNER_FK),CONSTRAINT VESSEL_OWNER_RIGHT_TO_PRODUCEC FOREIGN KEY(RIGHT_TO_PRODUCE_FK) REFERENCES RIGHT_TO_PRODUCE(ID),CONSTRAINT RIGHT_TO_PRODUCE_VESSEL_OWNERC FOREIGN KEY(VESSEL_OWNER_FK) REFERENCES VESSEL_OWNER(ID)) +CREATE CACHED TABLE VESSEL_OWNER_PERIOD(START_DATE_TIME TIMESTAMP NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,VESSEL_OWNER_FK INTEGER NOT NULL,END_DATE_TIME TIMESTAMP,PRIMARY KEY(START_DATE_TIME,VESSEL_FK,VESSEL_OWNER_FK),CONSTRAINT FKF6EB8C56C0D9EB78 FOREIGN KEY(VESSEL_OWNER_FK) REFERENCES VESSEL_OWNER(ID),CONSTRAINT VESSEL_OWNER_PERIOD_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE)) +CREATE CACHED TABLE VESSEL_PHYSICAL_FEATURES(ID INTEGER NOT NULL PRIMARY KEY,START_DATE TIMESTAMP,END_DATE TIMESTAMP,CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(256),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,RANK_ORDER SMALLINT,NAME VARCHAR(100),EXTERIOR_MARKING VARCHAR(100),IRCS VARCHAR(40),COMMENTS VARCHAR(2000),BASE_LANDING_LOCATION_FK INTEGER,RECORDER_PERSON_FK INTEGER,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,PHYSICAL_GEAR_SURVEY_FK INTEGER,CONSTRAINT VESSEL_PHYSICAL_FEATURES_RECOC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT VESSEL_PHYSICAL_FEATURES_BASEC FOREIGN KEY(BASE_LANDING_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT VESSEL_PHYSICAL_F_QUALITY_FLAC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT VESSEL_PHYSICAL_FEATURES_PHYSC FOREIGN KEY(PHYSICAL_GEAR_SURVEY_FK) REFERENCES PHYSICAL_GEAR_SURVEY(ID),CONSTRAINT VESSEL_PHYSICAL_FEA_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE),CONSTRAINT VESSEL_PHYSICAL_FE_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT VESSEL_PHYSICAL_FEATURES_RECOE FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID)) +CREATE INDEX IX_RMTID_V_PHYSICAL_FEATURES ON VESSEL_PHYSICAL_FEATURES(REMOTE_ID) +CREATE INDEX VESSEL_PHYSICAL_FEATURE_NATIDX ON VESSEL_PHYSICAL_FEATURES(START_DATE,PROGRAM_FK,VESSEL_FK,RANK_ORDER,PHYSICAL_GEAR_SURVEY_FK) +CREATE CACHED TABLE VESSEL_PHYSICAL_FEATURES_ORIGI(VESSEL_PHYSICAL_FEATURES_FK INTEGER NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,ACQUISITION_LEVEL_FK VARCHAR(40),PRIMARY KEY(VESSEL_PHYSICAL_FEATURES_FK,PROGRAM_FK),CONSTRAINT VESSEL_PHYSICAL_FEATURES_ORIGR FOREIGN KEY(VESSEL_PHYSICAL_FEATURES_FK) REFERENCES VESSEL_PHYSICAL_FEATURES(ID),CONSTRAINT VESSEL_PHYSICAL_FEATURES_ORIGC FOREIGN KEY(ACQUISITION_LEVEL_FK) REFERENCES ACQUISITION_LEVEL(CODE),CONSTRAINT FKECD4450569342651 FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE CACHED TABLE VESSEL_PHYSICAL_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,VESSEL_PHYSICAL_FEATURES_FK INTEGER NOT NULL,CONSTRAINT VESSEL_PHYS_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT VESSEL_PHYS_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT VESSEL_PHYS_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT VESSEL_PHYS_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT VESSEL_PHYSICAL_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT VESSEL_PHYSICAL_MEASUREMENT_VC FOREIGN KEY(VESSEL_PHYSICAL_FEATURES_FK) REFERENCES VESSEL_PHYSICAL_FEATURES(ID),CONSTRAINT VESSEL_PHYSIC_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT VESSEL_PHYS_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT VESSEL_PHYSICAL_MEASU_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID)) +CREATE INDEX IX_RMTID_VESS_PHYS_MEASUREMENT ON VESSEL_PHYSICAL_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE VESSEL_POSITION(ID BIGINT NOT NULL PRIMARY KEY,DATE_TIME TIMESTAMP,LATITUDE REAL,LONGITUDE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,UPDATE_DATE TIMESTAMP,REMOTE_ID BIGINT,VESSEL_FK VARCHAR(12) NOT NULL,OPERATION_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,PROCESSING_HISTORY_FK INTEGER,VESSEL_DIRECTION FLOAT,VESSEL_SPEED FLOAT,CONSTRAINT VESSEL_POSITION_QUALITY_FLAG_C FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT VESSEL_POSITION_OPERATION_FKC FOREIGN KEY(OPERATION_FK) REFERENCES OPERATION(ID),CONSTRAINT VESSEL_POSITION_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE),CONSTRAINT VESSEL_POSITION_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT VESSEL_POSITION_RECORDER_DEPAC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT VESSEL_POSITION_PROCESSING_HIC FOREIGN KEY(PROCESSING_HISTORY_FK) REFERENCES PROCESSING_HISTORY(ID)) +CREATE INDEX VESSEL_POSITION_NATIDX ON VESSEL_POSITION(DATE_TIME,VESSEL_FK,OPERATION_FK,PROGRAM_FK) +CREATE INDEX IX_RMTID_VESSEL_POSITION ON VESSEL_POSITION(REMOTE_ID) +CREATE CACHED TABLE VESSEL_POSITION_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,VESSEL_POSITION_FK BIGINT NOT NULL,CONSTRAINT VESSEL_POSI_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT VESSEL_POSI_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT VESSEL_POSI_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT VESSEL_POSI_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT VESSEL_POSITION_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT VESSEL_POSITI_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT VESSEL_POSI_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT VESSEL_POSITION_MEASU_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT VESSEL_POSITION_MEASUREMENT_VC FOREIGN KEY(VESSEL_POSITION_FK) REFERENCES VESSEL_POSITION(ID)) +CREATE INDEX IX_RMTID_V_POS_MEASUREMENT ON VESSEL_POSITION_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE VESSEL_REGISTRATION_PERIOD(START_DATE_TIME TIMESTAMP NOT NULL,REGISTRATION_LOCATION_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,END_DATE_TIME TIMESTAMP,REGISTRATION_CODE VARCHAR(40),INT_REGISTRATION_CODE VARCHAR(40),QUALITY_FLAG_FK VARCHAR(40) DEFAULT '0',RANK_ORDER SMALLINT DEFAULT 1 NOT NULL,PRIMARY KEY(START_DATE_TIME,REGISTRATION_LOCATION_FK,VESSEL_FK),CONSTRAINT FK3752707E7B45F55E FOREIGN KEY(REGISTRATION_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT VESSEL_REGISTRATION_PERIOD_VEC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE),CONSTRAINT VESSEL_REGISTRATION_PERIOD_QUC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE)) +CREATE INDEX IX_VESSEL_REG_CODE ON VESSEL_REGISTRATION_PERIOD(REGISTRATION_CODE) +CREATE INDEX IX_VESSEL_REG_PERIOD_VESSEL ON VESSEL_REGISTRATION_PERIOD(END_DATE_TIME) +CREATE INDEX IX_INT_REG_CODE ON VESSEL_REGISTRATION_PERIOD(INT_REGISTRATION_CODE) +CREATE CACHED TABLE VESSEL_TYPE(ID INTEGER NOT NULL PRIMARY KEY,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP,STATUS_FK VARCHAR(1) NOT NULL,CONSTRAINT VESSEL_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE)) +CREATE CACHED TABLE VESSEL_USE_FEATURES(ID INTEGER NOT NULL PRIMARY KEY,START_DATE TIMESTAMP,END_DATE TIMESTAMP,CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,IS_ACTIVE INTEGER,OPERATION_FK INTEGER,BASE_PORT_LOCATION_FK INTEGER,ECONOMICAL_SURVEY_FK INTEGER,DAILY_ACTIVITY_CALENDAR_FK INTEGER,ACTIVITY_CALENDAR_FK INTEGER,FISHING_TRIP_FK INTEGER,FISHING_EFFORT_CALENDAR_FK INTEGER,CONSTRAINT VESSEL_USE_FEATURES_FISHING_TC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID),CONSTRAINT VESSEL_USE_FEATURES_BASE_PORTC FOREIGN KEY(BASE_PORT_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT VESSEL_USE_FEATURES_ACTIVITY_C FOREIGN KEY(ACTIVITY_CALENDAR_FK) REFERENCES ACTIVITY_CALENDAR(ID),CONSTRAINT VESSEL_USE_FEATURES_OPERATIONC FOREIGN KEY(OPERATION_FK) REFERENCES OPERATION(ID),CONSTRAINT VESSEL_USE_FE_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT VESSEL_USE_FEATURES_DAILY_ACTC FOREIGN KEY(DAILY_ACTIVITY_CALENDAR_FK) REFERENCES DAILY_ACTIVITY_CALENDAR(ID),CONSTRAINT VESSEL_USE_FEATURES_ECONOMICAC FOREIGN KEY(ECONOMICAL_SURVEY_FK) REFERENCES ECONOMICAL_SURVEY(ID),CONSTRAINT VESSEL_USE_FEATURES_FISHING_EC FOREIGN KEY(FISHING_EFFORT_CALENDAR_FK) REFERENCES FISHING_EFFORT_CALENDAR(ID),CONSTRAINT VESSEL_USE_FEATURES_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE),CONSTRAINT VESSEL_USE_FEATURE_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE)) +CREATE INDEX IX_RMTID_V_USE_FEATURES ON VESSEL_USE_FEATURES(REMOTE_ID) +CREATE INDEX VESSEL_USE_FEATURES_NATIDX ON VESSEL_USE_FEATURES(START_DATE,END_DATE,PROGRAM_FK,VESSEL_FK,OPERATION_FK,ECONOMICAL_SURVEY_FK,DAILY_ACTIVITY_CALENDAR_FK,ACTIVITY_CALENDAR_FK,FISHING_TRIP_FK) +CREATE CACHED TABLE VESSEL_USE_FEATURES_ORIGIN(PROGRAM_FK VARCHAR(40) NOT NULL,VESSEL_USE_FEATURES_FK INTEGER NOT NULL,ACQUISITION_LEVEL_FK VARCHAR(40),PRIMARY KEY(PROGRAM_FK,VESSEL_USE_FEATURES_FK),CONSTRAINT VESSEL_USE_FEATURES_ORIGIN_ACC FOREIGN KEY(ACQUISITION_LEVEL_FK) REFERENCES ACQUISITION_LEVEL(CODE),CONSTRAINT FK780B5B0769342651 FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT VESSEL_USE_FEATURES_ORIGIN_VEC FOREIGN KEY(VESSEL_USE_FEATURES_FK) REFERENCES VESSEL_USE_FEATURES(ID)) +CREATE CACHED TABLE VESSEL_USE_MEASUREMENT(ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,PRECISION_TYPE_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,NUMERICAL_PRECISION_FK INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,QUALITATIVE_VALUE_FK INTEGER,VESSEL_USE_FEATURES_FK INTEGER NOT NULL,CONSTRAINT VESSEL_USE__PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT VESSEL_USE__ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT VESSEL_USE__QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT VESSEL_USE__AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT VESSEL_USE_MEAS_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT VESSEL_USE_ME_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT VESSEL_USE__NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT VESSEL_USE_MEASUREMEN_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT VESSEL_USE_MEASUREMENT_VESSELC FOREIGN KEY(VESSEL_USE_FEATURES_FK) REFERENCES VESSEL_USE_FEATURES(ID)) +CREATE INDEX IX_RMTID_V_USE_MEASUREMENT ON VESSEL_USE_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE VIRTUAL_COMPONENT(TAXON_NAME_FK INTEGER NOT NULL,REFERENCE_TAXON_FK INTEGER NOT NULL,UPDATE_DATE TIMESTAMP,PRIMARY KEY(TAXON_NAME_FK,REFERENCE_TAXON_FK),CONSTRAINT FKA420688938CF210A FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID),CONSTRAINT FKA4206889A6049D5C FOREIGN KEY(TAXON_NAME_FK) REFERENCES TAXON_NAME(ID)) +CREATE CACHED TABLE WEIGHT_LENGTH_CONVERSION(ID INTEGER NOT NULL PRIMARY KEY,CONVERSION_COEFFICIENT_A DOUBLE NOT NULL,CONVERSION_COEFFICIENT_B DOUBLE NOT NULL,START_MONTH INTEGER NOT NULL,END_MONTH INTEGER NOT NULL,YEAR INTEGER,DESCRIPTION VARCHAR(255),COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,LOCATION_FK INTEGER NOT NULL,LENGTH_PARAMETER_FK VARCHAR(40) NOT NULL,SEX_QUALITATIVE_VALUE_FK INTEGER,REFERENCE_TAXON_FK INTEGER NOT NULL,LENGTH_UNIT_FK INTEGER NOT NULL,STATUS_FK VARCHAR(1) NOT NULL,CONSTRAINT WEIGHT_LENGTH_CONVERSION_STATC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE),CONSTRAINT WEIGHT_LENGTH_CONVERSION_SEX_C FOREIGN KEY(SEX_QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT WEIGHT_LENGTH_CONVERSION_LOCAC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT WEIGHT_LENGTH_CONVERSION_LENGO FOREIGN KEY(LENGTH_UNIT_FK) REFERENCES UNIT(ID),CONSTRAINT WEIGHT_LENGTH_CONVERSION_REFEC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID),CONSTRAINT WEIGHT_LENGTH_CONVERSION_LENGC FOREIGN KEY(LENGTH_PARAMETER_FK) REFERENCES PARAMETER(CODE)) +CREATE INDEX IX_WEIGHT_LENGTH_CONVER_UNIT ON WEIGHT_LENGTH_CONVERSION(LENGTH_UNIT_FK) +CREATE INDEX IX_WEIGHT_LENGTH_CONVERSION_UD ON WEIGHT_LENGTH_CONVERSION(UPDATE_DATE) +CREATE CACHED TABLE DUAL_ACTIVITY_CALENDAR_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_APPLIED_QUALIFICATION_RULE_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_BATCH_MODEL_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_BATCH_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_BLOC_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_CRITERIA_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_DAILY_ACTIVITY_CALENDAR_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_DECLARED_DOCUMENT_REFERENC_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_DELETED_ITEM_HISTORY_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_DENORMALIZED_BATCH_SORT_VA_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_ECONOMICAL_SURVEY_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_EXPECTED_SALE_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_FILTER_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_FISHING_AREA_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_FISHING_EFFORT_CALENDAR_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_FISHING_TRIP_ORIGIN_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_FISHING_TRIP_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_GEAR_PHYSICAL_FEATURES_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_GEAR_PHYSICAL_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_GEAR_USE_FEATURES_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_GEAR_USE_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_LANDING_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_LANDING_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_LINKED_ITEM_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_LINKED_PROPERTY_CRITERIA_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_MEASUREMENT_FILE_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_OPERATION_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_OPERATOR_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_OR_CRITERIA_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_PHOTO_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_PHYSICAL_GEAR_SURVEY_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_PROCESSING_HISTORY_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_PRODUCE_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_QUALIFIED_ITEM_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_QUANTIFICATION_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_RVALUE_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_SALE_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_SALE_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_SAMPLE_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_SAMPLE_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_SCIENTIFIC_CRUISE_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_SORTING_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_SURVEY_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_TAKE_OVER_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_TAKE_OVER_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_TEMP_QUERY_PARAMETER_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_TRANSSHIPMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_UTIL_FACTORY_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_VESSEL_PHYSICAL_FEATURES_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_VESSEL_PHYSICAL_MEASUREMEN_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_VESSEL_POSITION_MEASUREMEN_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_VESSEL_POSITION_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_VESSEL_USE_FEATURES_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_VESSEL_USE_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_BATCH_EXHAUSTIVE_INVENTORY_SEQ(ZERO INTEGER) +CREATE CACHED TABLE BATCH_EXHAUSTIVE_INVENTORY(ID INTEGER NOT NULL PRIMARY KEY,PRIORITY_LEVEL SMALLINT NOT NULL,REMOTE_ID INTEGER,BATCH_FK INTEGER NOT NULL,CONSTRAINT BATCH_EXHAUSTIVE_INVENTORY_BAC FOREIGN KEY(BATCH_FK) REFERENCES BATCH(ID)) +CREATE INDEX IX_RMTID_BATCH_EXHAUSTIVE_INVENTORY ON BATCH_EXHAUSTIVE_INVENTORY(REMOTE_ID) +CREATE CACHED TABLE DENORMALIZED_BATCH_OBSERVED_SALE(ID BIGINT NOT NULL PRIMARY KEY,SALE_FK BIGINT,TAXON_GROUP_FK BIGINT,TAXON_GROUP_BATCH_FK BIGINT,TAXON_GROUP_SORTING_TYPE VARCHAR,CATEGORY VARCHAR,CATEGORY_BATCH_FK BIGINT,CASE_NAME VARCHAR,CASE_BATCH_FK BIGINT,REF_TAXON_FK BIGINT,REF_TAXON_BATCH_FK BIGINT,SEX_AGE VARCHAR,SEX_AGE_BATCH_FK BIGINT,LENGTH REAL,LENGTH_LABEL VARCHAR,LENGTH_BATCH_FK BIGINT,PAGE INTEGER) +CREATE CACHED TABLE PERSON_SESSION_VESSEL(ID BIGINT NOT NULL PRIMARY KEY,READ_VESSEL BOOLEAN NOT NULL,READ_DATA BOOLEAN NOT NULL,WRITE_DATA BOOLEAN NOT NULL,VALIDATE_DATA BOOLEAN,START_DATE_TIME TIMESTAMP NOT NULL,END_DATE_TIME TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP NOT NULL,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,PERSON_SESSION_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,CONSTRAINT PERSON_SESSION_VESSEL_PROGRAMC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT PERSON_SESSION_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE),CONSTRAINT PERSON_SESSION_VESSEL_OBJECT_C FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE),CONSTRAINT PERSON_SESSION_VESSEL_PERSON_C FOREIGN KEY(PERSON_SESSION_FK) REFERENCES PERSON_SESSION(ID)) +CREATE INDEX PERSON_SESSION_VESSEL_NATIDX ON PERSON_SESSION_VESSEL(START_DATE_TIME,OBJECT_TYPE_FK,PROGRAM_FK,PERSON_SESSION_FK,VESSEL_FK) +CREATE CACHED TABLE DENORMALIZED_SAMPLING_STRATA(ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(40) NOT NULL,START_DATE TIMESTAMP,END_DATE TIMESTAMP,DESCRIPTION VARCHAR(255),COMMENTS VARCHAR(2000),OBSERVATION_LOCATION_COMMENTS VARCHAR(100),SAMPLING_STRATEGY VARCHAR(100),TAXON_GROUP_NAME VARCHAR(100),SAMPLING_SCHEME_LABEL VARCHAR(40) NOT NULL,SAMPLING_SCHEME_NAME VARCHAR(100) NOT NULL,SAMPLING_SCHEME_DESCRIPTION VARCHAR(255),GEAR_MESH_RANGE VARCHAR(100),VESSEL_LENGTH_RANGE VARCHAR(100),METIER VARCHAR(255),AREA_NAME VARCHAR(100),SUB_AREA_LOCATION_IDS VARCHAR(255),PERSON_FK INTEGER,OBSERVATION_LOCATION_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,DEPARTMENT_FK INTEGER,UPDATE_DATE TIMESTAMP,CONSTRAINT DENORMALIZED_SAMPLING_STRATA_C FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT DENORMALIZED_SAMPLING_STRATA_L FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT DENORMALIZED_SAMPLING_STRATA__ FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT DENORMALIZED_SAMPLING_STRATA_P FOREIGN KEY(OBSERVATION_LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE CACHED TABLE INSERTED_ITEM_HISTORY(ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,OBJECT_CODE VARCHAR(40),OBJECT_ID INTEGER,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,PROCESSING_HISTORY_FK INTEGER,REMOTE_ID BIGINT,UPDATE_DATE TIMESTAMP,CONSTRAINT INSERTED_ITEM_HISTORY_OBJECT_C FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE),CONSTRAINT INSERTED_ITEM_HISTORY_PROCESSC FOREIGN KEY(PROCESSING_HISTORY_FK) REFERENCES PROCESSING_HISTORY(ID) ON DELETE CASCADE) +CREATE INDEX IX_RMTID_INSERTED_ITEM_HISTORY ON INSERTED_ITEM_HISTORY(REMOTE_ID) +CREATE CACHED TABLE DUAL_INSERTED_ITEM_HISTORY_SEQ(ZERO INTEGER) +CREATE CACHED TABLE PROGRAM2PERSON_EXCEPTION(DESCRIPTION VARCHAR(255),IS_EXCLUDE BOOLEAN NOT NULL,PROGRAM2PERSON_FK INTEGER NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,PRIMARY KEY(PROGRAM2PERSON_FK,VESSEL_FK),CONSTRAINT PROGRAM2PERSON_EXCEPTION_PROGC FOREIGN KEY(PROGRAM2PERSON_FK) REFERENCES PROGRAM2PERSON(ID),CONSTRAINT FK97A04A13E9151C8A FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE)) +CREATE CACHED TABLE QUANTIFICATION_MEASUREMENT_P(AGGREGATION_LEVEL_FK INTEGER,ALPHANUMERICAL_VALUE VARCHAR(40),ANALYSIS_INSTRUMENT_FK INTEGER,CONTROL_DATE TIMESTAMP,DEPARTMENT_FK INTEGER,DIGIT_COUNT INTEGER,ID INTEGER NOT NULL PRIMARY KEY,IS_REFERENCE_QUANTIFICATION BOOLEAN,NUMERICAL_PRECISION_FK INTEGER,NUMERICAL_VALUE REAL,PMFM_FK INTEGER NOT NULL,PRECISION_TYPE_FK INTEGER,PRECISION_VALUE REAL,PRODUCE_FK INTEGER NOT NULL,QUALIFICATION_COMMENTS VARCHAR(2000),QUALIFICATION_DATE TIMESTAMP,QUALITATIVE_VALUE_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,REMOTE_ID INTEGER,SUBGROUP_NUMBER SMALLINT,VALIDATION_DATE TIMESTAMP,CONSTRAINT QUANTIFICAT_P_AGGREG_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT QUANTIF_P_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT QUANTIF_P_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT QUANTIF_P_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT QUANTIF_P_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT QUANTIF_P_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT QUANTIF_P_PRODUCEC FOREIGN KEY(PRODUCE_FK) REFERENCES PRODUCE(ID),CONSTRAINT QUANTIF_P_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT QUANTIF_P_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE)) +CREATE INDEX IX_RMTID_P_QU_MEASUREMENT ON QUANTIFICATION_MEASUREMENT_P(REMOTE_ID) +CREATE CACHED TABLE SORTING_MEASUREMENT_P(AGGREGATION_LEVEL_FK INTEGER,ALPHANUMERICAL_VALUE VARCHAR(40),ANALYSIS_INSTRUMENT_FK INTEGER,CONTROL_DATE TIMESTAMP,DEPARTMENT_FK INTEGER,DIGIT_COUNT INTEGER,ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_PRECISION_FK INTEGER,NUMERICAL_VALUE REAL,PMFM_FK INTEGER NOT NULL,PRECISION_TYPE_FK INTEGER,PRECISION_VALUE REAL,PRODUCE_FK INTEGER NOT NULL,QUALIFICATION_COMMENTS VARCHAR(2000),QUALIFICATION_DATE TIMESTAMP,QUALITATIVE_VALUE_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,RANK_ORDER INTEGER NOT NULL,REMOTE_ID INTEGER,VALIDATION_DATE TIMESTAMP,CONSTRAINT SORTING_P_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT SORTING_P_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT SORTING_P_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT SORTING_P_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT SORTING_P_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT SORTING_P_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT SORTING_P_PRODUCEC FOREIGN KEY(PRODUCE_FK) REFERENCES PRODUCE(ID),CONSTRAINT SORTING_P_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT SORTING_P_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE)) +CREATE INDEX IX_RMTID_P_SORT_MEASUREMENT ON SORTING_MEASUREMENT_P(REMOTE_ID) +CREATE CACHED TABLE DUAL_SORTING_MEASUREMENT_P_SEQ(ZERO INTEGER) +CREATE CACHED TABLE SYSTEM_VERSION(COMMENTS VARCHAR(2000),CREATION_DATE TIMESTAMP NOT NULL,DESCRIPTION VARCHAR(255),ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(40) NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE TAXON_GROUP2TAXON_HIERARCHY(CHILD_REFERENCE_TAXON_FK INTEGER NOT NULL,END_DATE TIMESTAMP,IS_INHERITED BOOLEAN NOT NULL,PARENT_TAXON_GROUP_FK INTEGER NOT NULL,START_DATE TIMESTAMP NOT NULL,PRIMARY KEY(START_DATE,CHILD_REFERENCE_TAXON_FK,PARENT_TAXON_GROUP_FK),CONSTRAINT FKDB938D8CC7567E1 FOREIGN KEY(PARENT_TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID),CONSTRAINT FKDB938D81C62C50D FOREIGN KEY(CHILD_REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID)) +CREATE CACHED TABLE TAXON_GROUP_HIERARCHY(CHILD_TAXON_GROUP_FK INTEGER NOT NULL,PARENT_TAXON_GROUP_FK INTEGER NOT NULL,PRIMARY KEY(CHILD_TAXON_GROUP_FK,PARENT_TAXON_GROUP_FK),CONSTRAINT FK56F4C8A0CC7567E1 FOREIGN KEY(PARENT_TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID),CONSTRAINT FK56F4C8A067FBC92F FOREIGN KEY(CHILD_TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID)) +CREATE UNIQUE INDEX IX_TAXON_GROUP_HPK ON TAXON_GROUP_HIERARCHY(PARENT_TAXON_GROUP_FK,CHILD_TAXON_GROUP_FK) +CREATE CACHED TABLE TRANSCRIBING_ITEM(EXTERNAL_CODE VARCHAR(100) NOT NULL,ID INTEGER NOT NULL PRIMARY KEY,OBJECT_CODE VARCHAR(40),OBJECT_ID INTEGER,TRANSCRIBING_ITEM_TYPE_FK INTEGER NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE INDEX IX_TRANSCRIBING_ITEM_OBJECT_ID_TYPE ON TRANSCRIBING_ITEM(OBJECT_ID,TRANSCRIBING_ITEM_TYPE_FK) +CREATE CACHED TABLE TRANSCRIBING_ITEM_TYPE(DESCRIPTION VARCHAR(255),ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(40) NOT NULL,NAME VARCHAR(100) NOT NULL,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,STATUS_FK VARCHAR(1) NOT NULL,TRANSCRIBING_SIDE_FK INTEGER NOT NULL,TRANSCRIBING_SYSTEM_FK INTEGER,UPDATE_DATE TIMESTAMP,OBJECT_REFERENCE_QUERY VARCHAR(2000),CONSTRAINT SYS_CT_2053 UNIQUE(LABEL),CONSTRAINT TRANSCRIBING_ITEM_TYPE_TRANSCT FOREIGN KEY(TRANSCRIBING_SYSTEM_FK) REFERENCES TRANSCRIBING_SYSTEM(ID),CONSTRAINT TRANSCRIBING_ITEM_TYPE_TRANSCC FOREIGN KEY(TRANSCRIBING_SIDE_FK) REFERENCES TRANSCRIBING_SIDE(ID),CONSTRAINT TRANSCRIBING_ITEM_TYPE_OBJECTC FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE),CONSTRAINT TRANSCRIBING_ITEM_TYPE_STATUSC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE)) +CREATE INDEX IX_TRANSCRIBING_ITEM_TYPE_UNIQ ON TRANSCRIBING_ITEM_TYPE(LABEL) +CREATE CACHED TABLE UPDATED_ITEM_HISTORY(COMMENTS VARCHAR(2000) NOT NULL,GEAR_FK INTEGER,ID BIGINT GENERATED BY DEFAULT AS IDENTITY(START WITH 0) NOT NULL PRIMARY KEY,IS_POST_VALIDATION BOOLEAN NOT NULL,METIER_FK INTEGER,NUMERICAL_VALUE REAL,OBJECT_CODE VARCHAR(40),OBJECT_ID INTEGER,OBJECT_TYPE_FK VARCHAR(40) NOT NULL,PMFM_FK INTEGER,PREVIOUS_COMMENTS VARCHAR(2000),PROCESSING_HISTORY_FK INTEGER,QUALITATIVE_VALUE_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40),RECORDER_DEPARTMENT_FK INTEGER NOT NULL,RECORDER_PERSON_FK INTEGER,REFERENCE_TAXON_FK INTEGER,REMOTE_ID BIGINT,TAXON_GROUP_FK INTEGER,UPDATE_DATE TIMESTAMP,CONSTRAINT UPDATED_ITEM_HISTORY_QUALITY_C FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT UPDATED_ITEM_HISTORY_GEAR_FKC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID),CONSTRAINT UPDATED_ITEM_HISTORY_REFERENCC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID),CONSTRAINT UPDATED_ITEM_HISTORY_RECORDERC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT UPDATED_ITEM_HISTORY_QUALITATC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT UPDATED_ITEM_HISTORY_RECORDER_ FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT UPDATED_ITEM_HISTORY_PROCESSIC FOREIGN KEY(PROCESSING_HISTORY_FK) REFERENCES PROCESSING_HISTORY(ID),CONSTRAINT UPDATED_ITEM_HISTORY_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT UPDATED_ITEM_HISTORY_TAXON_GRC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID),CONSTRAINT UPDATED_ITEM_HISTORY_OBJECT_TC FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE),CONSTRAINT UPDATED_ITEM_HISTORY_METIER_FC FOREIGN KEY(METIER_FK) REFERENCES METIER(ID)) +CREATE INDEX IX_RMTID_UPDATED_ITEM_HISTORY ON UPDATED_ITEM_HISTORY(REMOTE_ID) +CREATE CACHED TABLE DUAL_UPDATED_ITEM_HISTORY_SEQ(ZERO INTEGER) +CREATE CACHED TABLE VESSEL_COMMISSIONING_PERIOD(COMMISSIONING_LOCATION_FK INTEGER NOT NULL,END_DATE TIMESTAMP,START_DATE TIMESTAMP NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,PRIMARY KEY(START_DATE,COMMISSIONING_LOCATION_FK,VESSEL_FK),CONSTRAINT FKAA5C8E72203EDEBC FOREIGN KEY(COMMISSIONING_LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT VESSEL_COMMISSIONING_PERIOD_VC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE)) +CREATE CACHED TABLE VESSEL_FLEET_EVENT(EVENT_DATE TIMESTAMP NOT NULL,EVENT_TYPE_FK INTEGER NOT NULL,RANK_ORDER SMALLINT NOT NULL,VESSEL_FK VARCHAR(12) NOT NULL,PRIMARY KEY(EVENT_DATE,EVENT_TYPE_FK,RANK_ORDER,VESSEL_FK),CONSTRAINT FKC9E89BA0A6F8735C FOREIGN KEY(EVENT_TYPE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT VESSEL_FLEET_EVENT_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE)) +CREATE CACHED TABLE VESSEL_PERSON(ADDRESS VARCHAR(255),CITY VARCHAR(256),COUNTRY_LOCATION_FK INTEGER,DATE_OF_BIRTH TIMESTAMP,EDUCATION_GRADE_FK INTEGER,EMAIL VARCHAR(255),FAX_NUMBER VARCHAR(50),FIRSTNAME VARCHAR(100),ID INTEGER NOT NULL PRIMARY KEY,IS_IN_RETIREMENT BOOLEAN,LASTNAME VARCHAR(100),MOBILE_NUMBER VARCHAR(50),PHONE_NUMBER VARCHAR(50),PROGRAM_FK VARCHAR(40) NOT NULL,REGISTRATION_CODE VARCHAR(40),REMOTE_ID INTEGER,RETIREMENT_DATE TIMESTAMP,STREET VARCHAR(256),UPDATE_DATE TIMESTAMP,ZIP_CODE VARCHAR(256),CONSTRAINT VESSEL_PERSON_EDUCATION_GRADEC FOREIGN KEY(EDUCATION_GRADE_FK) REFERENCES EDUCATION_GRADE(ID),CONSTRAINT VESSEL_PERSON_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT VESSEL_PERSON_COUNTRY_LOCATIOC FOREIGN KEY(COUNTRY_LOCATION_FK) REFERENCES LOCATION(ID)) +CREATE INDEX IX_VESSEL_PERSON_UD ON VESSEL_PERSON(UPDATE_DATE) +CREATE INDEX IX_RMTID_VESSEL_PERSON ON VESSEL_PERSON(REMOTE_ID) +CREATE INDEX VESSEL_PERSON_NATIDX ON VESSEL_PERSON(REGISTRATION_CODE) +CREATE CACHED TABLE DUAL_VESSEL_PERSON_SEQ(ZERO INTEGER) +CREATE CACHED TABLE VESSEL_PERSON_FEATURES(CONTROL_DATE TIMESTAMP,CREATION_DATE TIMESTAMP,ECONOMICAL_SURVEY_FK INTEGER,END_DATE TIMESTAMP,FISHING_TRIP_FK INTEGER,ID INTEGER NOT NULL PRIMARY KEY,OPERATION_FK INTEGER,PERSON_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,QUALIFICATION_COMMENTS VARCHAR(2000),QUALIFICATION_DATE TIMESTAMP,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,RANK_ORDER SMALLINT,REMOTE_ID INTEGER,START_DATE TIMESTAMP NOT NULL,UPDATE_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,VESSEL_FK VARCHAR(12) NOT NULL,VESSEL_PERSON_FK INTEGER,CONSTRAINT VESSEL_PERSON_FEATURES_VESSELS FOREIGN KEY(VESSEL_PERSON_FK) REFERENCES VESSEL_PERSON(ID),CONSTRAINT VESSEL_PERSON_FEATURES_QUALITC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT VESSEL_PERSON_FEATURES_PROGRAC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT VESSEL_PERSON_FEATURES_PERSONC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT VESSEL_PERSON_FEATURES_VESSELC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE),CONSTRAINT VESSEL_PERSON_FEATURES_ECONOMC FOREIGN KEY(ECONOMICAL_SURVEY_FK) REFERENCES ECONOMICAL_SURVEY(ID),CONSTRAINT VESSEL_PERSON_FEATURES_OPERATC FOREIGN KEY(OPERATION_FK) REFERENCES OPERATION(ID) ON DELETE CASCADE,CONSTRAINT VESSEL_PERSON_FEATURES_FISHINC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID) ON DELETE CASCADE) +CREATE INDEX VESSEL_PERSON_FEATURES_NATIDX ON VESSEL_PERSON_FEATURES(RANK_ORDER,START_DATE,ECONOMICAL_SURVEY_FK,FISHING_TRIP_FK,OPERATION_FK,PERSON_FK,VESSEL_PERSON_FK) +CREATE INDEX IX_RMTID_VESSEL_PERSON_FEATURES ON VESSEL_PERSON_FEATURES(REMOTE_ID) +CREATE INDEX IX_VESSEL_PERSON_FEATURES_UD ON VESSEL_PERSON_FEATURES(UPDATE_DATE) +CREATE CACHED TABLE DUAL_VESSEL_PERSON_FEATURES_SEQ(ZERO INTEGER) +CREATE CACHED TABLE VESSEL_PERSON_ROLE(DESCRIPTION VARCHAR(255),ID INTEGER NOT NULL PRIMARY KEY,LABEL VARCHAR(40) NOT NULL,NAME VARCHAR(100) NOT NULL,UPDATE_DATE TIMESTAMP) +CREATE CACHED TABLE VESSEL_PERSON_FEATURES2ROLE(VESSEL_PERSON_FEATURES_FK INTEGER NOT NULL,VESSEL_PERSON_ROLES_FK INTEGER NOT NULL,PRIMARY KEY(VESSEL_PERSON_FEATURES_FK,VESSEL_PERSON_ROLES_FK),CONSTRAINT VESSEL_PERSON_ROLE_VESSEL_PERC FOREIGN KEY(VESSEL_PERSON_FEATURES_FK) REFERENCES VESSEL_PERSON_FEATURES(ID),CONSTRAINT VESSEL_PERSON_FEATURES_VESSELE FOREIGN KEY(VESSEL_PERSON_ROLES_FK) REFERENCES VESSEL_PERSON_ROLE(ID)) +CREATE CACHED TABLE VESSEL_PERSON_MEASUREMENT(AGGREGATION_LEVEL_FK INTEGER,ALPHANUMERICAL_VALUE VARCHAR(40),ANALYSIS_INSTRUMENT_FK INTEGER,CONTROL_DATE TIMESTAMP,DEPARTMENT_FK INTEGER,DIGIT_COUNT INTEGER,ID INTEGER NOT NULL PRIMARY KEY,NUMERICAL_PRECISION_FK INTEGER,NUMERICAL_VALUE REAL,PMFM_FK INTEGER NOT NULL,PRECISION_TYPE_FK INTEGER,PRECISION_VALUE REAL,QUALIFICATION_COMMENTS VARCHAR(2000),QUALIFICATION_DATE TIMESTAMP,QUALITATIVE_VALUE_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,REMOTE_ID INTEGER,VALIDATION_DATE TIMESTAMP,VESSEL_PERSON_FEATURES_FK INTEGER NOT NULL,CONSTRAINT VESSEL_PERSON_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT VESSEL_PERS_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT VESSEL_PERSON_M_DEPARTMENT_FKC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT VESSEL_PERS_ANALYSIS_INSTRUMEC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT VESSEL_PERS_AGGREGATION_LEVELC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT VESSEL_PERS_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT VESSEL_PERSON_MEASURE_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT VESSEL_PERS_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT VESSEL_PERSON_MEASUREMENT_VESC FOREIGN KEY(VESSEL_PERSON_FEATURES_FK) REFERENCES VESSEL_PERSON_FEATURES(ID) ON DELETE CASCADE) +CREATE INDEX IX_RMTID_VESSEL_PERSON_MEAS ON VESSEL_PERSON_MEASUREMENT(REMOTE_ID) +CREATE CACHED TABLE DUAL_VESSEL_PERSON_MEASUREMENT_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DATABASECHANGELOGLOCK(ID INTEGER NOT NULL,LOCKED BOOLEAN NOT NULL,LOCKGRANTED TIMESTAMP,LOCKEDBY VARCHAR(255),CONSTRAINT PK_DATABASECHANGELOGLOCK PRIMARY KEY(ID)) +CREATE CACHED TABLE DATABASECHANGELOG(ID VARCHAR(63) NOT NULL,AUTHOR VARCHAR(63) NOT NULL,FILENAME VARCHAR(200) NOT NULL,DATEEXECUTED TIMESTAMP NOT NULL,ORDEREXECUTED INTEGER NOT NULL,EXECTYPE VARCHAR(10) NOT NULL,MD5SUM VARCHAR(35),DESCRIPTION VARCHAR(255),COMMENTS VARCHAR(255),TAG VARCHAR(255),LIQUIBASE VARCHAR(20),CONSTRAINT PK_DATABASECHANGELOG PRIMARY KEY(ID,AUTHOR,FILENAME)) +CREATE CACHED TABLE DUAL_SYSTEM_VERSION_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_OBSERVED_LOCATION_SEQ(ZERO INTEGER) +CREATE CACHED TABLE APPLIED_SIZE_CATEGORY(ID INTEGER NOT NULL,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,DESCRIPTION VARCHAR(255),COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,SIZE_CATEGORY_FK INTEGER NOT NULL,LOCATION_FK INTEGER NOT NULL,DRESSING_FK INTEGER NOT NULL,ORIGIN_ITEM_TYPE_FK INTEGER NOT NULL,TAXON_GROUP_FK INTEGER NOT NULL,CONSTRAINT PK_APPLIED_SIZE_CATEGORY PRIMARY KEY(ID),CONSTRAINT APPLIED_SIZE_CATEGORY_DRESSINC FOREIGN KEY(DRESSING_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT APPLIED_SIZE_CATEGORY_LOCATIOC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT APPLIED_SIZE_CATEGORY_SIZE_CAC FOREIGN KEY(SIZE_CATEGORY_FK) REFERENCES QUALITATIVE_VALUE(ID),CONSTRAINT APPLIED_SIZE_CATEGORY_TAXON_GC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID)) +CREATE INDEX IX_APPLIED_SIZE_CATEGORY_UD ON APPLIED_SIZE_CATEGORY(UPDATE_DATE) +CREATE CACHED TABLE OBSERVED_LOCATION(ID INTEGER NOT NULL,START_DATE_TIME TIMESTAMP NOT NULL,END_DATE_TIME TIMESTAMP NOT NULL,COMMENTS VARCHAR(2000),QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,RECORDER_PERSON_FK INTEGER,RECORDER_DEPARTMENT_FK INTEGER NOT NULL,SAMPLING_STRATA_FK INTEGER,SAMPLING_STRATA_REFERENCE VARCHAR(40),LOCATION_FK INTEGER NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,SYNCHRONIZATION_STATUS VARCHAR(256) NOT NULL,CREATION_DATE TIMESTAMP NOT NULL,REMOTE_ID INTEGER,CONSTRAINT PK_OBSERVED_LOCATION PRIMARY KEY(ID),CONSTRAINT OBSERVED_LOCATION_LOCATION_FKC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID),CONSTRAINT OBSERVED_LOCATION_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT OBSERVED_LOCATION_QUALITY_FLAC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT OBSERVED_LOCATION_RECORDER_DEC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT OBSERVED_LOCATION_RECORDER_PEC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID)) +CREATE INDEX IX_OBSERVED_LANDING_UD ON OBSERVED_LOCATION(UPDATE_DATE) +CREATE INDEX OBSERVED_LOCATION_NATIDX ON OBSERVED_LOCATION(START_DATE_TIME,LOCATION_FK,PROGRAM_FK) +CREATE CACHED TABLE OBSERVED_LOCATION2PERSON(OBSERVED_LOCATION_FK INTEGER NOT NULL,OBSERVER_PERSON_FK INTEGER NOT NULL,PRIMARY KEY(OBSERVED_LOCATION_FK,OBSERVER_PERSON_FK),CONSTRAINT OBSERVED_LOCATION_OBSERVER_PEC FOREIGN KEY(OBSERVER_PERSON_FK) REFERENCES PERSON(ID),CONSTRAINT PERSON_OBSERVED_LOCATION_FKC FOREIGN KEY(OBSERVED_LOCATION_FK) REFERENCES OBSERVED_LOCATION(ID)) +CREATE CACHED TABLE ORIGIN_ITEM_TYPE(ID INTEGER NOT NULL,NAME VARCHAR(100) NOT NULL,DESCRIPTION VARCHAR(255),UPDATE_DATE TIMESTAMP,LABEL VARCHAR(40) NOT NULL,COMMENTS VARCHAR(2000) NOT NULL,STATUS_FK VARCHAR(1) DEFAULT '1' NOT NULL,CONSTRAINT CONVERSION_ORIGIN_PK PRIMARY KEY(ID)) +CREATE CACHED TABLE DENORMALIZED_VESSEL(ID INTEGER NOT NULL,VESSEL_FK VARCHAR(40) NOT NULL,NAME VARCHAR(100),INT_REGISTRATION_CODE VARCHAR(40),REGISTRATION_CODE VARCHAR(40),REGISTRATION_START_DATE TIMESTAMP NOT NULL,REGISTRATION_END_DATE TIMESTAMP,RANK_ORDER SMALLINT NOT NULL,EXTERIOR_MARKING VARCHAR(100),REGISTRATION_LOCATION_FK INTEGER NOT NULL,REGISTRATION_COUNTRY_FK INTEGER NOT NULL,VESSEL_OWNER_FK INTEGER,PROGRAM_FK VARCHAR(40) NOT NULL,UPDATE_DATE TIMESTAMP,BASE_PORT_LOCATION_FK INTEGER,CONSTRAINT DENORMALIZED_VESSEL_PK PRIMARY KEY(ID)) +CREATE INDEX DENORMALIZED_VESSEL_NATIDX ON DENORMALIZED_VESSEL(VESSEL_FK,REGISTRATION_START_DATE,PROGRAM_FK) +CREATE INDEX IX_DENORMALIZED_VESSEL_SEARCH ON DENORMALIZED_VESSEL(NAME,REGISTRATION_CODE,INT_REGISTRATION_CODE) +CREATE CACHED TABLE DUAL_DENORMALIZED_VESSEL_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DUAL_OBSERVED_LOCATION_MEASUREM_SEQ(ZERO INTEGER) +CREATE CACHED TABLE OBSERVED_LOCATION_FEATURES(ID INTEGER NOT NULL,START_DATE TIMESTAMP NOT NULL,END_DATE TIMESTAMP,RANK_ORDER SMALLINT NOT NULL,OBSERVED_LOCATION_FK INTEGER NOT NULL,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PROGRAM_FK VARCHAR(40) NOT NULL,VESSEL_TYPE_FK INTEGER NOT NULL,METIER_FK INTEGER,CREATION_DATE TIMESTAMP NOT NULL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),UPDATE_DATE TIMESTAMP,REMOTE_ID INTEGER,CONSTRAINT OBSERVED_LOCATION_FEATURES_PK PRIMARY KEY(ID),CONSTRAINT OBSERVED_LOCATION_FEAT_OBERVEC FOREIGN KEY(OBSERVED_LOCATION_FK) REFERENCES OBSERVED_LOCATION(ID),CONSTRAINT OBSERVED_LOCATION_FEAT_PROGRAC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE),CONSTRAINT OBSERVED_LOCATION_FEAT_QUALITC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT OBSERVED_LOCATION_FEAT_METIERC FOREIGN KEY(METIER_FK) REFERENCES METIER(ID),CONSTRAINT OBSERVED_LOCATION_FEAT_VES_TYC FOREIGN KEY(VESSEL_TYPE_FK) REFERENCES VESSEL_TYPE(ID)) +CREATE INDEX OBSERVED_LOCATION_F_NATIDX ON OBSERVED_LOCATION_FEATURES(START_DATE,END_DATE,RANK_ORDER,METIER_FK,PROGRAM_FK,VESSEL_TYPE_FK) +CREATE CACHED TABLE OBSERVED_LOCATION_MEASUREMENT(ID INTEGER NOT NULL,NUMERICAL_VALUE REAL,ALPHANUMERICAL_VALUE VARCHAR(40),DIGIT_COUNT INTEGER,PRECISION_VALUE REAL,CONTROL_DATE TIMESTAMP,VALIDATION_DATE TIMESTAMP,QUALIFICATION_DATE TIMESTAMP,QUALIFICATION_COMMENTS VARCHAR(2000),REMOTE_ID INTEGER,AGGREGATION_LEVEL_FK INTEGER,QUALITY_FLAG_FK VARCHAR(40) NOT NULL,PRECISION_TYPE_FK INTEGER,ANALYSIS_INSTRUMENT_FK INTEGER,NUMERICAL_PRECISION_FK INTEGER,DEPARTMENT_FK INTEGER,PMFM_FK INTEGER NOT NULL,QUALITATIVE_VALUE_FK INTEGER,OBSERVED_LOCATION_FEATURES_FK INTEGER NOT NULL,CONSTRAINT OBSERVED_LOCATION_MEAS_PK PRIMARY KEY(ID),CONSTRAINT OBSERVED_LOCATION_MEAS_OBSERVC FOREIGN KEY(OBSERVED_LOCATION_FEATURES_FK) REFERENCES OBSERVED_LOCATION_FEATURES(ID),CONSTRAINT OBSERVED_LOCATION_MEAS_PMFM_FC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID),CONSTRAINT OBSERVED_LOCATION_MEAS_DEPARTC FOREIGN KEY(DEPARTMENT_FK) REFERENCES DEPARTMENT(ID),CONSTRAINT OBSERVED_LOCATION_MEAS_QUALITC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE),CONSTRAINT OBSERVED_LOCATION_MEAS_AGGREGC FOREIGN KEY(AGGREGATION_LEVEL_FK) REFERENCES AGGREGATION_LEVEL(ID),CONSTRAINT OBSERVED_LOCATION_MEAS_ANALYSC FOREIGN KEY(ANALYSIS_INSTRUMENT_FK) REFERENCES ANALYSIS_INSTRUMENT(ID),CONSTRAINT OBSERVED_LOCATION_MEAS_NUMERIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID),CONSTRAINT OBSERVED_LOCATION_MEAS_PRECISC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID),CONSTRAINT OBSERVED_LOCATION_MEAS_QUAVALC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID)) +CREATE CACHED TABLE DUAL_QUANTIFICATION_MEASUREMENT_P_SEQ(ZERO INTEGER) +CREATE CACHED TABLE DEPARTMENT_HIERARCHY(PARENT_DEPARTMENT_FK INTEGER NOT NULL,CHILD_DEPARTMENT_FK INTEGER NOT NULL,CONSTRAINT DEPARTMENT_HIPK PRIMARY KEY(PARENT_DEPARTMENT_FK,CHILD_DEPARTMENT_FK)) +ALTER TABLE ACTIVITY_CALENDAR ADD CONSTRAINT ACTIVITY_CALENDAR_RECORDER_PEC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE ACTIVITY_CALENDAR ADD CONSTRAINT ACTIVITY_CALENDAR_QUALITY_FLAC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE ACTIVITY_CALENDAR ADD CONSTRAINT ACTIVITY_CALENDAR_FISHING_EFFC FOREIGN KEY(FISHING_EFFORT_CALENDAR_FK) REFERENCES FISHING_EFFORT_CALENDAR(ID) +ALTER TABLE ACTIVITY_CALENDAR ADD CONSTRAINT ACTIVITY_CALENDAR_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE ACTIVITY_CALENDAR ADD CONSTRAINT ACTIVITY_CALENDAR_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE ACTIVITY_CALENDAR ADD CONSTRAINT ACTIVITY_CALENDAR_RECORDER_DEC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID) +ALTER TABLE AGE_READER_QUAL2LOCATION ADD CONSTRAINT AGE_READER_QUALIFICATION_LOCAC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE AGE_READER_QUAL2LOCATION ADD CONSTRAINT LOCATION_AGE_READER_QUALIFICAC FOREIGN KEY(AGE_READER_QUALIFICATION_FK) REFERENCES AGE_READER_QUALIFICATION(ID) +ALTER TABLE AGE_READER_QUALIFICATION ADD CONSTRAINT AGE_READER_QUALIFICATION_REFEC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID) +ALTER TABLE AGE_READER_QUAL2PERSON ADD CONSTRAINT AGE_READER_QUALIFICATION_PEOPC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE ANALYSIS_INSTRUMENT ADD CONSTRAINT ANALYSIS_INSTRUMENT_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE APPLIED_PERIOD ADD CONSTRAINT APPLIED_PERIOD_APPLIED_STRATEC FOREIGN KEY(APPLIED_STRATEGY_FK) REFERENCES APPLIED_STRATEGY(ID) +ALTER TABLE APPLIED_QUALIFICATION_RULE ADD CONSTRAINT APPLIED_QUALIFICATION_RULE_QUR FOREIGN KEY(QUALIFICATION_RULE_FK) REFERENCES QUALIFICATION_RULE(ID) +ALTER TABLE APPLIED_QUALIFICATION_RULE ADD CONSTRAINT APPLIED_QUALIFICATION_RULE_QUL FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE APPLIED_QUALIFICATION_RULE ADD CONSTRAINT APPLIED_QUALIFICATION_RULE_QUC FOREIGN KEY(QUALIFIED_ITEM_FK) REFERENCES QUALIFIED_ITEM(ID) +ALTER TABLE APPLIED_QUALIFICATION_RULE ADD CONSTRAINT APPLIED_QUALIFICATION_RULE_PRC FOREIGN KEY(PROCESSING_HISTORY_FK) REFERENCES PROCESSING_HISTORY(ID) +ALTER TABLE APPLIED_STRATEGY ADD CONSTRAINT APPLIED_STRATEGY_STRATEGY_FKC FOREIGN KEY(STRATEGY_FK) REFERENCES STRATEGY(ID) +ALTER TABLE APPLIED_STRATEGY ADD CONSTRAINT APPLIED_STRATEGY_LOCATION_FKC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE AUTHOR ADD CONSTRAINT AUTHOR_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE BATCH ADD CONSTRAINT SORTING_BATCH_TAXON_GROUP_FKC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE BATCH ADD CONSTRAINT CATCH_BATCH_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE BATCH ADD CONSTRAINT SORTING_BATCH_REFERENCE_TAXONC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID) +ALTER TABLE BATCH ADD CONSTRAINT BATCH_LOCATION_FKC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE BATCH_MODEL ADD CONSTRAINT BATCH_MODEL_RECORDER_PERSON_FC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE BATCH_MODEL ADD CONSTRAINT BATCH_MODEL_RECORDER_DEPARTMEC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID) +ALTER TABLE BETWEEN_OP ADD CONSTRAINT BETWEEN_OPIFKC FOREIGN KEY(ID) REFERENCES NARY_OPERATOR(ID) +ALTER TABLE BINARY_OPERATOR ADD CONSTRAINT BINARY_OPERATORIFKC FOREIGN KEY(ID) REFERENCES OPERATOR(ID) +ALTER TABLE BLOC ADD CONSTRAINT BLOC_FILTER_FKC FOREIGN KEY(FILTER_FK) REFERENCES FILTER(ID) +ALTER TABLE BUYER ADD CONSTRAINT BUYER_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE BUYER ADD CONSTRAINT BUYER_BUYER_TYPE_FKC FOREIGN KEY(BUYER_TYPE_FK) REFERENCES BUYER_TYPE(ID) +ALTER TABLE CITATION ADD CONSTRAINT CITATION_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE CORPUS ADD CONSTRAINT CORPUS_CORPUS_TYPE_FKC FOREIGN KEY(CORPUS_TYPE_FK) REFERENCES CORPUS_TYPE(ID) +ALTER TABLE CORPUS2FISHERY ADD CONSTRAINT CORPUS_FISHERY_FKC FOREIGN KEY(FISHERY_FK) REFERENCES FISHERY(ID) +ALTER TABLE DAILY_ACTIVITY_CALENDAR ADD CONSTRAINT DAILY_ACTIVITY_CALENDAR_RECORC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE DAILY_ACTIVITY_CALENDAR ADD CONSTRAINT DAILY_ACTIVITY_CALENDAR_QUALIC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE DAILY_ACTIVITY_CALENDAR ADD CONSTRAINT DAILY_ACTIVITY_CALENDAR_VESSEC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE DAILY_ACTIVITY_CALENDAR ADD CONSTRAINT DAILY_ACTIVITY_CALENDAR_PROGRC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE DAILY_ACTIVITY_CALENDAR ADD CONSTRAINT DAILY_ACTIVITY_CALENDAR_RECORA FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID) +ALTER TABLE DAILY_ACTIVITY_CALENDAR ADD CONSTRAINT DAILY_ACTIVITY_CALENDAR_OBSERC FOREIGN KEY(OBSERVED_LOCATION_FK) REFERENCES OBSERVED_LOCATION(ID) +ALTER TABLE DECLARED_DOCUMENT_REFERENCE ADD CONSTRAINT DECLARED_DOCUMENT_REFERENCE_RT FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE DECLARED_DOCUMENT_REFERENCE ADD CONSTRAINT DECLARED_DOCUMENT_REFERENCE_QC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE DECLARED_DOCUMENT_REFERENCE ADD CONSTRAINT DECLARED_DOCUMENT_REFERENCE_VC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE DECLARED_DOCUMENT_REFERENCE ADD CONSTRAINT DECLARED_DOCUMENT_REFERENCE_PC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE DECLARED_DOCUMENT_REFERENCE ADD CONSTRAINT DECLARED_DOCUMENT_REFERENCE_RC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID) +ALTER TABLE DELETED_ITEM_HISTORY ADD CONSTRAINT DELETED_ITEM_HISTORY_RECORDERT FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE DELETED_ITEM_HISTORY ADD CONSTRAINT DELETED_ITEM_HISTORY_OBJECT_TC FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE) +ALTER TABLE DELETED_ITEM_HISTORY ADD CONSTRAINT DELETED_ITEM_HISTORY_PROCESSIC FOREIGN KEY(PROCESSING_HISTORY_FK) REFERENCES PROCESSING_HISTORY(ID) +ALTER TABLE DELETED_ITEM_HISTORY ADD CONSTRAINT DELETED_ITEM_HISTORY_RECORDERC FOREIGN KEY(RECORDER_DEPARTMENT_FK) REFERENCES DEPARTMENT(ID) +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_TAXON_GROUC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_WEIGHT_METC FOREIGN KEY(WEIGHT_METHOD_FK) REFERENCES METHOD(ID) +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_OPERATION_C FOREIGN KEY(OPERATION_FK) REFERENCES OPERATION(ID) ON DELETE CASCADE +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_SALE_C FOREIGN KEY(SALE_FK) REFERENCES SALE(ID) ON DELETE CASCADE +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_INHERITED__ FOREIGN KEY(INHERITED_TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_REFERENCE_C FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID) +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_INHERITED_C FOREIGN KEY(INHERITED_REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID) +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_CALCULATEDC FOREIGN KEY(CALCULATED_TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE DENORMALIZED_BATCH ADD CONSTRAINT DENORMALIZED_BATCH_QUALITY_FLC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE DENORMALIZED_BATCH_SORT_VAL ADD CONSTRAINT DENORMALIZED_BATCH_SORT_VAL_PC FOREIGN KEY(PARAMETER_FK) REFERENCES PARAMETER(CODE) +ALTER TABLE DENORMALIZED_BATCH_SORT_VAL ADD CONSTRAINT DENORMALIZED_BATCH_SORT_VAL_UC FOREIGN KEY(UNIT_FK) REFERENCES UNIT(ID) +ALTER TABLE DENORMALIZED_BATCH_SORT_VAL ADD CONSTRAINT DENORMALIZED_BATCH_SORT_VAL_QC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE DENORMALIZED_BATCH_SORT_VAL ADD CONSTRAINT DENORMALIZED_BATCH_SORT_VAL_PP FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID) +ALTER TABLE DENORMALIZED_OPERATION ADD CONSTRAINT DENORMALIZED_OPERATION_SUBPOLC FOREIGN KEY(SUBPOLYGON_LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE DENORMALIZED_OPERATION ADD CONSTRAINT DENORMALIZED_OPERATION_METIERC FOREIGN KEY(METIER_FK) REFERENCES METIER(ID) +ALTER TABLE DENORMALIZED_OPERATION ADD CONSTRAINT DENORMALIZED_OPERATION_GEAR_FC FOREIGN KEY(GEAR_FK) REFERENCES GEAR(ID) +ALTER TABLE DENORMALIZED_OPERATION ADD CONSTRAINT DENORMALIZED_OPERATION_SELECTC FOREIGN KEY(SELECTIVE_DEVICE_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE DENORMALIZED_OPERATION ADD CONSTRAINT DENORMALIZED_OPERATION_AREA_LC FOREIGN KEY(AREA_LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE DENORMALIZED_OPERATION ADD CONSTRAINT DENORMALIZED_OPERATION_RECTANC FOREIGN KEY(RECTANGLE_LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE DEPARTMENT ADD CONSTRAINT DEPARTMENT_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE DEPARTMENT_PRIVILEGE_TRANSFERT ADD CONSTRAINT DEPARTMENT_PRIVILEGE_TRANSFERC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE DEPTH_GRADIENT ADD CONSTRAINT DEPTH_GRADIENT_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE DISTANCE_TO_COAST_GRADIENT ADD CONSTRAINT DISTANCE_TO_COAST_GRADIENT_STC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE ECONOMICAL_SURVEY ADD CONSTRAINT ECONOMICAL_SURVEY_RECORDER_PEC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE ECONOMICAL_SURVEY ADD CONSTRAINT ECONOMICAL_SURVEY_QUALITY_FLAC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE ECONOMICAL_SURVEY ADD CONSTRAINT ECONOMICAL_SURVEY_VESSEL_OWNEC FOREIGN KEY(VESSEL_OWNER_FK) REFERENCES VESSEL_OWNER(ID) +ALTER TABLE ECONOMICAL_SURVEY ADD CONSTRAINT ECONOMICAL_SURVEY_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE ECONOMICAL_SURVEY ADD CONSTRAINT ECONOMICAL_SURVEY_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE EXPECTED_SALE ADD CONSTRAINT EXPECTED_SALE_FISHING_TRIP_FKC FOREIGN KEY(FISHING_TRIP_FK) REFERENCES FISHING_TRIP(ID) +ALTER TABLE EXPECTED_SALE ADD CONSTRAINT EXPECTED_SALE_SALE_TYPE_FKC FOREIGN KEY(SALE_TYPE_FK) REFERENCES SALE_TYPE(ID) +ALTER TABLE EXPECTED_SALE ADD CONSTRAINT EXPECTED_SALE_SALE_LOCATION_FC FOREIGN KEY(SALE_LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE EXPECTED_SALE ADD CONSTRAINT EXPECTED_SALE_OBSERVED_LANDINC FOREIGN KEY(OBSERVED_LANDING_FK) REFERENCES LANDING(ID) +ALTER TABLE FILTER ADD CONSTRAINT FILTER_PERSON_FKC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE FISHING_AREA ADD CONSTRAINT FISHING_AREA_PRODUCE_FKC FOREIGN KEY(PRODUCE_FK) REFERENCES PRODUCE(ID) +ALTER TABLE FISHING_AREA ADD CONSTRAINT FISHING_AREA_SALE_FKC FOREIGN KEY(SALE_FK) REFERENCES SALE(ID) +ALTER TABLE FISHING_AREA ADD CONSTRAINT FISHING_AREA_SAMPLE_FKC FOREIGN KEY(SAMPLE_FK) REFERENCES SAMPLE(ID) +ALTER TABLE FISHING_AREA ADD CONSTRAINT FISHING_AREA_GEAR_USE_FEATUREC FOREIGN KEY(GEAR_USE_FEATURES_FK) REFERENCES GEAR_USE_FEATURES(ID) +ALTER TABLE FISHING_AREA ADD CONSTRAINT FISHING_AREA_LOCATION_FKC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE FISHING_AREA ADD CONSTRAINT FISHING_AREA_NEARBY_SPECIFIC_C FOREIGN KEY(NEARBY_SPECIFIC_AREA_FK) REFERENCES NEARBY_SPECIFIC_AREA(ID) +ALTER TABLE FISHING_AREA ADD CONSTRAINT FISHING_AREA_VESSEL_USE_FEATUC FOREIGN KEY(VESSEL_USE_FEATURES_FK) REFERENCES VESSEL_USE_FEATURES(ID) +ALTER TABLE FISHING_AREA ADD CONSTRAINT FISHING_AREA_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE FISHING_AREA2REG_LOCATION ADD CONSTRAINT FKEDD322502C1FBE4 FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE FISHING_EFFORT_CALENDAR ADD CONSTRAINT FISHING_EFFORT_CALENDAR_RECORS FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE FISHING_EFFORT_CALENDAR ADD CONSTRAINT FISHING_EFFORT_CALENDAR_QUALIC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE FISHING_EFFORT_CALENDAR ADD CONSTRAINT FISHING_EFFORT_CALENDAR_VESSEC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE FISHING_EFFORT_CALENDAR ADD CONSTRAINT FISHING_EFFORT_CALENDAR_PROGRC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE FISHING_TRIP ADD CONSTRAINT FISHING_TRIP_SCIENTIFIC_CRUISC FOREIGN KEY(SCIENTIFIC_CRUISE_FK) REFERENCES SCIENTIFIC_CRUISE(ID) +ALTER TABLE FISHING_TRIP ADD CONSTRAINT FISHING_TRIP_RECORDER_PERSON_C FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE FISHING_TRIP ADD CONSTRAINT FISHING_TRIP_DEPARTURE_LOCATIC FOREIGN KEY(DEPARTURE_LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE FISHING_TRIP ADD CONSTRAINT FISHING_TRIP_RETURN_LOCATION_C FOREIGN KEY(RETURN_LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE FISHING_TRIP ADD CONSTRAINT FISHING_TRIP_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE FISHING_TRIP ADD CONSTRAINT FISHING_TRIP_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE FISHING_TRIP ADD CONSTRAINT FISHING_TRIP_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE FISHING_TRIP ADD CONSTRAINT OBSERVED_FISHING_TRIP_SAMPLINC FOREIGN KEY(SAMPLING_STRATA_FK) REFERENCES DENORMALIZED_SAMPLING_STRATA(ID) +ALTER TABLE FISHING_TRIP2OBSERVER_PERSON ADD CONSTRAINT OBSERVED_FISHING_TRIP_PERSON_C FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE FISHING_TRIP_ORIGIN ADD CONSTRAINT FISHING_TRIP_ORIGIN_PROGRAM_FC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE FRACTION ADD CONSTRAINT FRACTION_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE FRACTION2MATRIX ADD CONSTRAINT FRACTION_MATRIX_FKC FOREIGN KEY(MATRIX_FK) REFERENCES MATRIX(ID) +ALTER TABLE GEAR ADD CONSTRAINT GEAR_GEAR_CLASSIFICATION_FKC FOREIGN KEY(GEAR_CLASSIFICATION_FK) REFERENCES GEAR_CLASSIFICATION(ID) +ALTER TABLE GEAR ADD CONSTRAINT GEAR_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE GEAR_PHYSICAL_FEATURES ADD CONSTRAINT GEAR_PHYSICAL_FEA_QUALITY_FLAC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE GEAR_PHYSICAL_FEATURES ADD CONSTRAINT GEAR_PHYSICAL_FEATURES_PHYSICC FOREIGN KEY(PHYSICAL_GEAR_SURVEY_FK) REFERENCES PHYSICAL_GEAR_SURVEY(ID) +ALTER TABLE GEAR_PHYSICAL_FEATURES ADD CONSTRAINT GEAR_PHYSICAL_FEATU_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE GEAR_PHYSICAL_FEATURES ADD CONSTRAINT GEAR_PHYSICAL_FEAT_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE GEAR_PHYSICAL_FEATURES_ORIGIN ADD CONSTRAINT FK839D66B069342651 FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE GEAR_PHYSICAL_MEASUREMENT ADD CONSTRAINT GEAR_PHYSIC_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID) +ALTER TABLE GEAR_PHYSICAL_MEASUREMENT ADD CONSTRAINT GEAR_PHYSIC_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE GEAR_PHYSICAL_MEASUREMENT ADD CONSTRAINT GEAR_PHYSICAL_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE GEAR_PHYSICAL_MEASUREMENT ADD CONSTRAINT GEAR_PHYSIC_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID) +ALTER TABLE GEAR_PHYSICAL_MEASUREMENT ADD CONSTRAINT GEAR_PHYSICAL_MEASURE_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID) +ALTER TABLE GEAR_USE_FEATURES ADD CONSTRAINT GEAR_USE_FEATURES_METIER_FKC FOREIGN KEY(METIER_FK) REFERENCES METIER(ID) +ALTER TABLE GEAR_USE_FEATURES ADD CONSTRAINT GEAR_USE_FEATURES_OPERATION_FC FOREIGN KEY(OPERATION_FK) REFERENCES OPERATION(ID) +ALTER TABLE GEAR_USE_FEATURES ADD CONSTRAINT GEAR_USE_FEAT_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE GEAR_USE_FEATURES ADD CONSTRAINT GEAR_USE_FEATURES_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE GEAR_USE_FEATURES ADD CONSTRAINT GEAR_USE_FEATURES_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE GEAR_USE_FEATURES_ORIGIN ADD CONSTRAINT FK8ABA6FE069342651 FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE GEAR_USE_MEASUREMENT ADD CONSTRAINT GEAR_USE_ME_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID) +ALTER TABLE GEAR_USE_MEASUREMENT ADD CONSTRAINT GEAR_USE_ME_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE GEAR_USE_MEASUREMENT ADD CONSTRAINT GEAR_USE_MEAS_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE GEAR_USE_MEASUREMENT ADD CONSTRAINT GEAR_USE_ME_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID) +ALTER TABLE GEAR_USE_MEASUREMENT ADD CONSTRAINT GEAR_USE_MEASUREMENT_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID) +ALTER TABLE GROUPING ADD CONSTRAINT GROUPING_GROUPING_LEVEL_FKC FOREIGN KEY(GROUPING_LEVEL_FK) REFERENCES GROUPING_LEVEL(ID) +ALTER TABLE GROUPING ADD CONSTRAINT GROUPING_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE GROUPING ADD CONSTRAINT GROUPING_GROUPING_CLASSIFICATC FOREIGN KEY(GROUPING_CLASSIFICATION_FK) REFERENCES GROUPING_CLASSIFICATION(ID) +ALTER TABLE GROUPING_CLASSIFICATION ADD CONSTRAINT GROUPING_CLASSIFICATION_OBJECC FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE) +ALTER TABLE GROUPING_LEVEL ADD CONSTRAINT GROUPING_LEVEL_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID) +ALTER TABLE GROUPING_VESSEL_HIERARCHY ADD CONSTRAINT GROUPING_VESSEL_HIERARCHY_LOCC FOREIGN KEY(LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE GROUPING_VESSEL_HIERARCHY ADD CONSTRAINT GROUPING_VESSEL_HIERARCHY_VESC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE GROUPING_VESSEL_HIERARCHY ADD CONSTRAINT GROUPING_VESSEL_HIERARCHY_ORIR FOREIGN KEY(ORIGIN_PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE GROUPING_VESSEL_HIERARCHY ADD CONSTRAINT GROUPING_VESSEL_HIERARCHY_ORIC FOREIGN KEY(ORIGIN_OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE) +ALTER TABLE HIERARCHY_PROPERTY_CRITERIA ADD CONSTRAINT HIERARCHY_PROPERTY_CRITERIAIFKC FOREIGN KEY(ID) REFERENCES LINKED_PROPERTY_CRITERIA(ID) +ALTER TABLE IN_OP ADD CONSTRAINT IN_OPIFKC FOREIGN KEY(ID) REFERENCES NARY_OPERATOR(ID) +ALTER TABLE IS_NOT_NULL ADD CONSTRAINT IS_NOT_NULLIFKC FOREIGN KEY(ID) REFERENCES NULL_OPERATOR(ID) +ALTER TABLE IS_NULL ADD CONSTRAINT IS_NULLIFKC FOREIGN KEY(ID) REFERENCES NULL_OPERATOR(ID) +ALTER TABLE LANDING ADD CONSTRAINT LANDING_RECORDER_PERSON_FKC FOREIGN KEY(RECORDER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE LANDING ADD CONSTRAINT LANDING_LANDING_LOCATION_FKC FOREIGN KEY(LANDING_LOCATION_FK) REFERENCES LOCATION(ID) +ALTER TABLE LANDING ADD CONSTRAINT LANDING_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE LANDING ADD CONSTRAINT LANDING_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE LANDING ADD CONSTRAINT LANDING_PROGRAM_FKC FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE LANDING ADD CONSTRAINT LANDING_OBSERVED_LOCATION_FKC FOREIGN KEY(OBSERVED_LOCATION_FK) REFERENCES OBSERVED_LOCATION(ID) +ALTER TABLE LANDING2OBSERVER_PERSON ADD CONSTRAINT OBSERVED_LANDING_PERSON_FKC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE LANDING_MEASUREMENT ADD CONSTRAINT LANDING_MEA_PRECISION_TYPE_FKC FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID) +ALTER TABLE LANDING_MEASUREMENT ADD CONSTRAINT LANDING_MEA_QUALITATIVE_VALUEC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE LANDING_MEASUREMENT ADD CONSTRAINT LANDING_MEASU_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE LANDING_MEASUREMENT ADD CONSTRAINT LANDING_MEA_NUMERICAL_PRECISIC FOREIGN KEY(NUMERICAL_PRECISION_FK) REFERENCES NUMERICAL_PRECISION(ID) +ALTER TABLE LANDING_MEASUREMENT ADD CONSTRAINT LANDING_MEASUREMENT_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID) +ALTER TABLE LANDING_ORIGIN ADD CONSTRAINT FK541F866E69342651 FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE LINKED_ITEM ADD CONSTRAINT LINKED_ITEM_LINKED_ITEM_TYPE_C FOREIGN KEY(LINKED_ITEM_TYPE_FK) REFERENCES LINKED_ITEM_TYPE(ID) +ALTER TABLE LINKED_ITEM ADD CONSTRAINT LINKED_ITEM_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE LINKED_ITEM_TYPE ADD CONSTRAINT LINKED_ITEM_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE LINKED_ITEM_TYPE ADD CONSTRAINT LINKED_ITEM_TYPE_FROM_OBJECT_C FOREIGN KEY(FROM_OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE) +ALTER TABLE LINKED_ITEM_TYPE ADD CONSTRAINT LINKED_ITEM_TYPE_TO_PROGRAM_FC FOREIGN KEY(TO_PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE LINKED_ITEM_TYPE ADD CONSTRAINT LINKED_ITEM_TYPE_TO_OBJECT_TYC FOREIGN KEY(TO_OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE) +ALTER TABLE LINKED_ITEM_TYPE ADD CONSTRAINT LINKED_ITEM_TYPE_FROM_PROGRAMC FOREIGN KEY(FROM_PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE LOCATION ADD CONSTRAINT LOCATION_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE LOCATION ADD CONSTRAINT LOCATION_LOCATION_CLASSIFICATC FOREIGN KEY(LOCATION_CLASSIFICATION_FK) REFERENCES LOCATION_CLASSIFICATION(ID) +ALTER TABLE LOCATION ADD CONSTRAINT LOCATION_LOCATION_LEVEL_FKC FOREIGN KEY(LOCATION_LEVEL_FK) REFERENCES LOCATION_LEVEL(ID) +ALTER TABLE MANAGED_DATA ADD CONSTRAINT MANAGED_DATA_MANAGED_DATA_TYPC FOREIGN KEY(MANAGED_DATA_TYPE_FK) REFERENCES MANAGED_DATA_TYPE(ID) +ALTER TABLE MANAGED_DATA ADD CONSTRAINT MANAGED_DATA_MANAGER_PERSON_FC FOREIGN KEY(MANAGER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE MANAGED_DATA ADD CONSTRAINT MANAGED_DATA_SUPERVISOR_PERSOC FOREIGN KEY(SUPERVISOR_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE MANAGED_DATA2VIEWER_USER ADD CONSTRAINT MANAGED_DATA_PERSON_FKC FOREIGN KEY(PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE MANAGED_DATA_TRANSFER ADD CONSTRAINT FKB90DD420FDEF2ADA FOREIGN KEY(NEW_MANAGER_PERSON_FK) REFERENCES PERSON(ID) +ALTER TABLE MANAGED_DATA_TYPE ADD CONSTRAINT MANAGED_DATA_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE MATRIX ADD CONSTRAINT MATRIX_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE MEASUREMENT_FILE ADD CONSTRAINT MEASUREMENT_FILE_QUALITY_FLAGC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE MEASUREMENT_FILE ADD CONSTRAINT MEASUREMENT_FILE_OBJECT_TYPE_C FOREIGN KEY(OBJECT_TYPE_FK) REFERENCES OBJECT_TYPE(CODE) +ALTER TABLE MEASUREMENT_FILE ADD CONSTRAINT MEASUREMENT_FILE_PMFM_FKC FOREIGN KEY(PMFM_FK) REFERENCES PMFM(ID) +ALTER TABLE METHOD ADD CONSTRAINT METHOD_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE METIER ADD CONSTRAINT METIER_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE METIER ADD CONSTRAINT METIER_TAXON_GROUP_FKC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE MINIMUM_SIZE_ALLOWED ADD CONSTRAINT MINIMUM_SIZE_ALLOWED_UNIT_FKC FOREIGN KEY(UNIT_FK) REFERENCES UNIT(ID) +ALTER TABLE MINIMUM_SIZE_ALLOWED ADD CONSTRAINT MINIMUM_SIZE_ALLOWED_TAXON_GRC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE NARY_OPERATOR ADD CONSTRAINT NARY_OPERATORIFKC FOREIGN KEY(ID) REFERENCES OPERATOR(ID) +ALTER TABLE NEARBY_SPECIFIC_AREA ADD CONSTRAINT NEARBY_SPECIFIC_AREA_STATUS_FC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE NULL_OPERATOR ADD CONSTRAINT NULL_OPERATORIFKC FOREIGN KEY(ID) REFERENCES OPERATOR(ID) +ALTER TABLE NUMERICAL_PRECISION ADD CONSTRAINT NUMERICAL_PRECISION_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE OPERATION ADD CONSTRAINT OPERATION_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE OPERATION ADD CONSTRAINT OPERATION_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE OPERATION_VESSEL_ASSOCIATION ADD CONSTRAINT FK9B5CF9D0401A9063 FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE ORDER_ITEM ADD CONSTRAINT ORDER_ITEM_ORDER_TYPE_FKC FOREIGN KEY(ORDER_TYPE_FK) REFERENCES ORDER_TYPE(ID) +ALTER TABLE ORDER_TYPE ADD CONSTRAINT ORDER_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PARAMETER ADD CONSTRAINT PARAMETER_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PARAMETER ADD CONSTRAINT PARAMETER_PARAMETER_GROUP_FKC FOREIGN KEY(PARAMETER_GROUP_FK) REFERENCES PARAMETER_GROUP(ID) +ALTER TABLE PARAMETER_GROUP ADD CONSTRAINT PARAMETER_GROUP_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PERSON ADD CONSTRAINT PERSON_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PERSON2USER_PROFIL ADD CONSTRAINT PERSON_USER_PROFIL_FKC FOREIGN KEY(USER_PROFIL_FK) REFERENCES USER_PROFIL(ID) +ALTER TABLE PHOTO ADD CONSTRAINT PHOTO_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE PHOTO ADD CONSTRAINT PHOTO_PHOTO_TYPE_FKC FOREIGN KEY(PHOTO_TYPE_FK) REFERENCES PHOTO_TYPE(CODE) +ALTER TABLE PHOTO_TYPE ADD CONSTRAINT PHOTO_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PHYSICAL_GEAR_SURVEY ADD CONSTRAINT PHYSICAL_GEAR_SURVEY_QUALITY_C FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE PHYSICAL_GEAR_SURVEY ADD CONSTRAINT PHYSICAL_GEAR_SURVEY_VESSEL_FC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE PHYSICAL_GEAR_SURVEY ADD CONSTRAINT PHYSICAL_GEAR_SURVEY_PROGRAM_C FOREIGN KEY(PROGRAM_FK) REFERENCES PROGRAM(CODE) +ALTER TABLE PMFM ADD CONSTRAINT PMFM_UNIT_FKC FOREIGN KEY(UNIT_FK) REFERENCES UNIT(ID) +ALTER TABLE PMFM ADD CONSTRAINT PMFM_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PMFM2QUALITATIVE_VALUE ADD CONSTRAINT PMFM_QUALITATIVE_VALUE_FKC FOREIGN KEY(QUALITATIVE_VALUE_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE PMFM_APPLIED_STRATEGY ADD CONSTRAINT PMFM_APPLIED_STRATEGY_REFERENC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID) +ALTER TABLE PMFM_STRATEGY ADD CONSTRAINT PMFM_STRATEGY_PRECISION_TYPE_C FOREIGN KEY(PRECISION_TYPE_FK) REFERENCES PRECISION_TYPE(ID) +ALTER TABLE PMFM_STRATEGY ADD CONSTRAINT PMFM_STRATEGY_STRATEGY_FKC FOREIGN KEY(STRATEGY_FK) REFERENCES STRATEGY(ID) +ALTER TABLE PMFM_STRATEGY ADD CONSTRAINT PMFM_STRATEGY_REFERENCE_TAXONC FOREIGN KEY(REFERENCE_TAXON_FK) REFERENCES REFERENCE_TAXON(ID) +ALTER TABLE PRECISION_TYPE ADD CONSTRAINT PRECISION_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PROCESSING_HISTORY ADD CONSTRAINT PROCESSING_HISTORY_PROCESSINGO FOREIGN KEY(PROCESSING_STATUS_FK) REFERENCES PROCESSING_STATUS(CODE) +ALTER TABLE PROCESSING_HISTORY ADD CONSTRAINT PROCESSING_HISTORY_PROCESSINGC FOREIGN KEY(PROCESSING_TYPE_FK) REFERENCES PROCESSING_TYPE(CODE) +ALTER TABLE PROCESSING_STATUS ADD CONSTRAINT PROCESSING_STATUS_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PROCESSING_TYPE ADD CONSTRAINT PROCESSING_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_TRANSSHIPMENT_FKC FOREIGN KEY(TRANSSHIPMENT_FK) REFERENCES TRANSSHIPMENT(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_TAXON_GROUP_FKC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_QUALITY_FLAG_FKC FOREIGN KEY(QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_OTHER_TAXON_GROUP_FKC FOREIGN KEY(OTHER_TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_TAKE_OVER_FKC FOREIGN KEY(TAKE_OVER_FK) REFERENCES TAKE_OVER(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_SALE_FKC FOREIGN KEY(SALE_FK) REFERENCES SALE(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_DRESSING_FKC FOREIGN KEY(DRESSING_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_FRESHNESS_CATEGORY_FKC FOREIGN KEY(FRESHNESS_CATEGORY_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_PRESERVATION_FKC FOREIGN KEY(PRESERVATION_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_SIZE_CATEGORY_FKC FOREIGN KEY(SIZE_CATEGORY_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_TRANSACTION_FKC FOREIGN KEY(TRANSACTION_FK) REFERENCES QUALITATIVE_VALUE(ID) +ALTER TABLE PRODUCE ADD CONSTRAINT PRODUCE_SALE_TYPE_FKC FOREIGN KEY(SALE_TYPE_FK) REFERENCES SALE_TYPE(ID) +ALTER TABLE PROGRAM ADD CONSTRAINT PROGRAM_TAXON_GROUP_TYPE_FKC FOREIGN KEY(TAXON_GROUP_TYPE_FK) REFERENCES TAXON_GROUP_TYPE(CODE) +ALTER TABLE PROGRAM2DEPARTMENT ADD CONSTRAINT PROGRAM2DEPARTMENT_PROGRAM_PRC FOREIGN KEY(PROGRAM_PRIVILEGE_FK) REFERENCES PROGRAM_PRIVILEGE(ID) +ALTER TABLE PROGRAM2PERSON ADD CONSTRAINT PROGRAM2PERSON_PROGRAM_PRIVILC FOREIGN KEY(PROGRAM_PRIVILEGE_FK) REFERENCES PROGRAM_PRIVILEGE(ID) +ALTER TABLE QUALIFICATION_RULE ADD CONSTRAINT QUALIFICATION_RULE_DEFAULT_QUC FOREIGN KEY(DEFAULT_QUALITY_FLAG_FK) REFERENCES QUALITY_FLAG(CODE) +ALTER TABLE QUALIFICATION_RULE ADD CONSTRAINT QUALIFICATION_RULE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE QUALITATIVE_VALUE ADD CONSTRAINT QUALITATIVE_VALUE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE QUALITY_FLAG ADD CONSTRAINT QUALITY_FLAG_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE REFERENCE_DOCUMENT ADD CONSTRAINT REFERENCE_DOCUMENT_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE REFERENCE_TAXON_STRATEGY ADD CONSTRAINT REFERENCE_TAXON_STRATEGY_STRAC FOREIGN KEY(STRATEGY_FK) REFERENCES STRATEGY(ID) +ALTER TABLE ROUND_WEIGHT_CONVERSION ADD CONSTRAINT ROUND_WEIGHT_CONVERSION_TAXONC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE SALE ADD CONSTRAINT SALE_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE SALE ADD CONSTRAINT SALE_SELLER_FKC FOREIGN KEY(SELLER_FK) REFERENCES SELLER(ID) +ALTER TABLE SALE ADD CONSTRAINT SALE_SALE_TYPE_FKC FOREIGN KEY(SALE_TYPE_FK) REFERENCES SALE_TYPE(ID) +ALTER TABLE SALE ADD CONSTRAINT SALE_TAKE_OVER_FKC FOREIGN KEY(TAKE_OVER_FK) REFERENCES TAKE_OVER(ID) +ALTER TABLE SALE ADD CONSTRAINT OBSERVED_SALE_SAMPLING_STRATAC FOREIGN KEY(SAMPLING_STRATA_FK) REFERENCES DENORMALIZED_SAMPLING_STRATA(ID) +ALTER TABLE SALE_TYPE ADD CONSTRAINT SALE_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE SAMPLE ADD CONSTRAINT SAMPLE_TAXON_GROUP_FKC FOREIGN KEY(TAXON_GROUP_FK) REFERENCES TAXON_GROUP(ID) +ALTER TABLE SAMPLE ADD CONSTRAINT SAMPLE_SIZE_UNIT_FKC FOREIGN KEY(SIZE_UNIT_FK) REFERENCES UNIT(ID) +ALTER TABLE SCIENTIFIC_CRUISE ADD CONSTRAINT SCIENTIFIC_CRUISE_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE SELLER ADD CONSTRAINT SELLER_SELLER_TYPE_FKC FOREIGN KEY(SELLER_TYPE_FK) REFERENCES SELLER_TYPE(ID) +ALTER TABLE SPATIAL_ITEM ADD CONSTRAINT SPATIAL_ITEM_SPATIAL_ITEM_TYPC FOREIGN KEY(SPATIAL_ITEM_TYPE_FK) REFERENCES SPATIAL_ITEM_TYPE(ID) +ALTER TABLE SPATIAL_ITEM_TYPE ADD CONSTRAINT SPATIAL_ITEM_TYPE_STATUS_FKC FOREIGN KEY(STATUS_FK) REFERENCES STATUS(CODE) +ALTER TABLE SURVEY_MEASUREMENT ADD CONSTRAINT SURVEY_MEASUREMENT_TRANSSHIPMC FOREIGN KEY(TRANSSHIPMENT_FK) REFERENCES TRANSSHIPMENT(ID) +ALTER TABLE TAKE_OVER ADD CONSTRAINT TAKE_OVER_VESSEL_FKC FOREIGN KEY(VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE TAXON_GROUP ADD CONSTRAINT TAXON_GROUP_TAXON_GROUP_TYPE_C FOREIGN KEY(TAXON_GROUP_TYPE_FK) REFERENCES TAXON_GROUP_TYPE(CODE) +ALTER TABLE TAXON_INFORMATION ADD CONSTRAINT FKD1264EF7A6049D5C FOREIGN KEY(TAXON_NAME_FK) REFERENCES TAXON_NAME(ID) +ALTER TABLE TAXON_INFORMATION_HISTORY ADD CONSTRAINT FK219A7F2C249FD42B FOREIGN KEY(TAXON_NAME_HISTORY_FK) REFERENCES TAXON_NAME_HISTORY(ID) +ALTER TABLE TRANSSHIPMENT ADD CONSTRAINT TRANSSHIPMENT_FROM_VESSEL_FKC FOREIGN KEY(FROM_VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE TRANSSHIPMENT ADD CONSTRAINT TRANSSHIPMENT_TO_VESSEL_FKC FOREIGN KEY(TO_VESSEL_FK) REFERENCES VESSEL(CODE) +ALTER TABLE VESSEL ADD CONSTRAINT VESSEL_VESSEL_TYPE_FKC FOREIGN KEY(VESSEL_TYPE_FK) REFERENCES VESSEL_TYPE(ID) +ALTER TABLE TRANSCRIBING_ITEM ADD CONSTRAINT TRANSCRIBING_ITEM_TRANSCRIBINC FOREIGN KEY(TRANSCRIBING_ITEM_TYPE_FK) REFERENCES TRANSCRIBING_ITEM_TYPE(ID) +SET TABLE ACQUISITION_LEVEL INDEX'468085664 0' +SET TABLE AGGREGATION_LEVEL INDEX'1952 0' +SET TABLE APPLIED_PERIOD INDEX'3320 2744 0' +SET TABLE APPLIED_STRATEGY INDEX'468561336 468561120 468561480 0' +SET TABLE BATCH INDEX'168380000 320877200 168380000 168380000 168380000 168380000 168380000 168380000 472383056 168380000 0' +SET TABLE CITATION INDEX'205536 205536 0' +SET TABLE DEPARTMENT INDEX'547032 540768 541928 546328 0' +SET TABLE DEPTH_GRADIENT INDEX'558376 558376 0' +SET TABLE DISTANCE_TO_COAST_GRADIENT INDEX'559632 559184 0' +SET TABLE FISHING_AREA INDEX'168383272 168383272 168383272 168383272 168383272 168383272 168383272 168383272 168383272 168383272 168383272 168383272 168383272 0' +SET TABLE FISHING_AREA2REG_LOCATION INDEX'168383520 168383520 168383520 0' +SET TABLE FISHING_TRIP INDEX'168380736 168380736 168380736 168380736 168380736 168380736 168380736 168380736 168380736 168380736 168380736 168380736 168380736 168380736 168380736 0' +SET TABLE FRACTION INDEX'563264 563264 0' +SET TABLE GEAR INDEX'580360 587600 594840 580360 565536 0' +SET TABLE GEAR_ASSOCIATION INDEX'609064 608968 609064 608968 0' +SET TABLE GEAR_CLASSIFICATION INDEX'609640 0' +SET TABLE GEAR_CLASSIFICATION_ASSOCIATIO INDEX'610168 610168 610168 0' +SET TABLE GEAR_PHYSICAL_FEATURES INDEX'168381400 168381400 168381400 168381400 168381400 168381400 168381400 168381400 168381400 168381400 0' +SET TABLE GEAR_PHYSICAL_MEASUREMENT INDEX'168381664 168381664 168381664 168381664 168381664 168381664 168381664 168381664 168381664 168381664 168381664 0' +SET TABLE GEAR_USE_FEATURES INDEX'320822776 320822776 320822776 320822776 320822776 320822776 320822776 320822776 320822776 320822776 320822776 320822776 320822776 320822776 0' +SET TABLE GEAR_USE_MEASUREMENT INDEX'320960656 320960656 320960656 320960656 320960656 320960656 320960656 320960656 320960656 320960656 320959960 0' +SET TABLE LOCATION INDEX'332407952 334077960 331236248 327665920 332900992 0' +SET TABLE LOCATION_ASSOCIATION INDEX'324704784 324704784 321506056 324292944 0' +SET TABLE LOCATION_CLASSIFICATION INDEX'15659432 0' +SET TABLE LOCATION_HIERARCHY INDEX'346851416 346851416 337185656 0' +SET TABLE LOCATION_LEVEL INDEX'33649400 33647096 33647520 0' +SET TABLE MATRIX INDEX'33653128 33652712 0' +SET TABLE MEASUREMENT_FILE INDEX'320866440 320866440 320866440 320866440 320866440 320866440 320866440 0' +SET TABLE METHOD INDEX'33657312 33657128 0' +SET TABLE METIER INDEX'33706272 33675472 33728304 33664832 0' +SET TABLE NEARBY_SPECIFIC_AREA INDEX'33787520 33787520 0' +SET TABLE OBJECT_TYPE INDEX'33790864 0' +SET TABLE OPERATION INDEX'320822512 320822512 320822512 320822512 320822512 320822512 320822512 320822512 320822512 0' +SET TABLE ORDER_ITEM INDEX'34006448 34006448 33951120 34006448 0' +SET TABLE ORDER_TYPE INDEX'34262600 34262600 34262600 0' +SET TABLE PARAMETER INDEX'34299192 34270912 34287160 34263224 0' +SET TABLE PARAMETER_GROUP INDEX'34317824 34317824 34317824 0' +SET TABLE PERSON INDEX'319897624 319877304 319868208 319881952 0' +SET TABLE PERSON2USER_PROFIL INDEX'34458208 34458208 468064608 0' +SET TABLE PERSON_SESSION INDEX'34477920 34477920 0' +SET TABLE PHOTO_TYPE INDEX'34478088 34478088 0' +SET TABLE PMFM INDEX'34540096 34500832 34539600 34481664 34544472 34483576 34492904 34481168 34532720 0' +SET TABLE PMFM2QUALITATIVE_VALUE INDEX'321215744 321215744 321216064 0' +SET TABLE PMFM_APPLIED_STRATEGY INDEX'468484512 468484512 468484512 468484512 468556592 468484512 468484512 0' +SET TABLE PMFM_STRATEGY INDEX'468766400 468766400 468639600 468909248 468729856 468766400 468660040 468766400 0' +SET TABLE PROGRAM INDEX'468076688 468078800 468077248 0' +SET TABLE PROGRAM2LOCATION INDEX'168380400 468083552 168380400 0' +SET TABLE PROGRAM2LOCATION_CLASSIF INDEX'468084528 468084528 468084528 0' +SET TABLE PROGRAM2PERSON INDEX'468300008 468121928 468270368 468188888 468186488 0' +SET TABLE PROGRAM_PRIVILEGE INDEX'35556648 0' +SET TABLE QUALITATIVE_VALUE INDEX'321071264 320996384 321057528 0' +SET TABLE QUALITY_FLAG INDEX'320978848 320978848 0' +SET TABLE QUANTIFICATION_MEASUREMENT INDEX'472385800 472385800 472385800 472385800 472385800 472385800 472385800 472385800 472385800 472385800 472385800 0' +SET TABLE REFERENCE_DOCUMENT INDEX'35723240 35723240 0' +SET TABLE REFERENCE_TAXON INDEX'36039424 35816832 0' +SET TABLE ROUND_WEIGHT_CONVERSION INDEX'36789216 36428944 36431056 36549152 36789216 36430352 0' +SET TABLE SALE_TYPE INDEX'168292400 168292400 168292400 168292400 168292400 168291832 0' +SET TABLE SCIENTIFIC_CRUISE INDEX'168380472 168380472 168380472 168380472 168380472 168380472 168380472 168380472 168380472 0' +SET TABLE SELLER INDEX'168346488 168344648 168339616 0' +SET TABLE SELLER_TYPE INDEX'168364424 0' +SET TABLE SORTING_MEASUREMENT INDEX'320865448 320865448 320865448 320966472 320865448 320865448 320865448 320865448 320957864 320865448 320865448 0' +SET TABLE SPATIAL_ITEM INDEX'37471592 37471688 37277288 37471496 0' +SET TABLE SPATIAL_ITEM2LOCATION INDEX'38114328 38291672 38114328 0' +SET TABLE SPATIAL_ITEM_TYPE INDEX'38940816 38941104 38940816 0' +SET TABLE STATUS INDEX'320978496 0' +SET TABLE STRATEGY INDEX'38943576 38942960 0' +SET TABLE STRATEGY2GEAR INDEX'468916200 468916200 468913192 0' +SET TABLE STRATEGY2MANAGER_PERSON INDEX'468414048 468414048 468414240 0' +SET TABLE TAXONOMIC_LEVEL INDEX'38954576 38954576 0' +SET TABLE TAXON_GROUP INDEX'40675552 40555800 39154576 39879968 38959336 40675552 0' +SET TABLE TAXON_GROUP_HISTORICAL_RECORD INDEX'42054256 41998896 41899216 41998896 0' +SET TABLE TAXON_GROUP_INFORMATION INDEX'42346896 42346896 42346976 0' +SET TABLE TAXON_GROUP_TYPE INDEX'42347280 0' +SET TABLE TAXON_INFORMATION INDEX'42347760 42347760 42347760 0' +SET TABLE TAXON_NAME INDEX'204058296 202978832 204303456 202800384 202787528 201874944 0' +SET TABLE TAXON_NAME_HISTORY INDEX'47553472 47553472 46914008 46912080 0' +SET TABLE TRANSCRIBING_SIDE INDEX'48206480 0' +SET TABLE TRANSCRIBING_SYSTEM INDEX'48208328 48208328 0' +SET TABLE UNIT INDEX'48211264 48211264 0' +SET TABLE UNIT_CONVERSION INDEX'48213064 48213064 48212800 0' +SET TABLE USER_PROFIL INDEX'48213600 0' +SET TABLE VESSEL INDEX'454777888 443734520 454777888 456986360 451616672 0' +SET TABLE VESSEL_FEATURES INDEX'422677560 400568640 422677560 411463048 400412360 401833712 0' +SET TABLE VESSEL_OWNER INDEX'112628800 112628800 112628800 110431208 110431496 0' +SET TABLE VESSEL_OWNER_PERIOD INDEX'117395272 115871648 116129912 0' +SET TABLE VESSEL_POSITION INDEX'320774880 320774880 320774880 320774880 320774880 320774880 320774880 320774880 320774880 0' +SET TABLE VESSEL_REGISTRATION_PERIOD INDEX'381213856 365211520 363297656 374901656 375425888 355127528 355506448 0' +SET TABLE VESSEL_TYPE INDEX'163974680 163974680 0' +SET TABLE VESSEL_USE_FEATURES INDEX'320823104 320823104 320823104 320823104 320823104 320823104 320823104 320823104 320823104 320823104 320823104 320823104 320823104 0' +SET TABLE VESSEL_USE_MEASUREMENT INDEX'168382496 168382496 168382496 168382496 168382496 168382496 168382496 168382496 168382496 168382496 168382496 0' +SET TABLE VIRTUAL_COMPONENT INDEX'163977808 163977488 163977808 0' +SET TABLE WEIGHT_LENGTH_CONVERSION INDEX'164288152 164050968 164225592 163994000 164327696 164030080 164281128 164327696 164392920 0' +SET TABLE DUAL_ACTIVITY_CALENDAR_SEQ INDEX'164879832 0' +SET TABLE DUAL_APPLIED_QUALIFICATION_RULE_SEQ INDEX'164879864 0' +SET TABLE DUAL_BATCH_MODEL_SEQ INDEX'164879896 0' +SET TABLE DUAL_BATCH_SEQ INDEX'164879928 0' +SET TABLE DUAL_BLOC_SEQ INDEX'164879960 0' +SET TABLE DUAL_CRITERIA_SEQ INDEX'164879992 0' +SET TABLE DUAL_DAILY_ACTIVITY_CALENDAR_SEQ INDEX'164880024 0' +SET TABLE DUAL_DECLARED_DOCUMENT_REFERENC_SEQ INDEX'164880056 0' +SET TABLE DUAL_DELETED_ITEM_HISTORY_SEQ INDEX'164880088 0' +SET TABLE DUAL_DENORMALIZED_BATCH_SORT_VA_SEQ INDEX'164880120 0' +SET TABLE DUAL_ECONOMICAL_SURVEY_SEQ INDEX'164880152 0' +SET TABLE DUAL_EXPECTED_SALE_SEQ INDEX'164880184 0' +SET TABLE DUAL_FILTER_SEQ INDEX'164880216 0' +SET TABLE DUAL_FISHING_AREA_SEQ INDEX'164880248 0' +SET TABLE DUAL_FISHING_EFFORT_CALENDAR_SEQ INDEX'164880280 0' +SET TABLE DUAL_FISHING_TRIP_ORIGIN_SEQ INDEX'164880312 0' +SET TABLE DUAL_FISHING_TRIP_SEQ INDEX'164880344 0' +SET TABLE DUAL_GEAR_PHYSICAL_FEATURES_SEQ INDEX'164880376 0' +SET TABLE DUAL_GEAR_PHYSICAL_MEASUREMENT_SEQ INDEX'164880408 0' +SET TABLE DUAL_GEAR_USE_FEATURES_SEQ INDEX'164880440 0' +SET TABLE DUAL_GEAR_USE_MEASUREMENT_SEQ INDEX'164880472 0' +SET TABLE DUAL_LANDING_MEASUREMENT_SEQ INDEX'164880504 0' +SET TABLE DUAL_LANDING_SEQ INDEX'164880536 0' +SET TABLE DUAL_LINKED_ITEM_SEQ INDEX'164880568 0' +SET TABLE DUAL_LINKED_PROPERTY_CRITERIA_SEQ INDEX'164880600 0' +SET TABLE DUAL_MEASUREMENT_FILE_SEQ INDEX'164880632 0' +SET TABLE DUAL_OPERATION_SEQ INDEX'164880664 0' +SET TABLE DUAL_OPERATOR_SEQ INDEX'164880696 0' +SET TABLE DUAL_OR_CRITERIA_SEQ INDEX'164880728 0' +SET TABLE DUAL_PHOTO_SEQ INDEX'164880760 0' +SET TABLE DUAL_PHYSICAL_GEAR_SURVEY_SEQ INDEX'164880792 0' +SET TABLE DUAL_PROCESSING_HISTORY_SEQ INDEX'164880824 0' +SET TABLE DUAL_PRODUCE_SEQ INDEX'164880856 0' +SET TABLE DUAL_QUALIFIED_ITEM_SEQ INDEX'164880888 0' +SET TABLE DUAL_QUANTIFICATION_MEASUREMENT_SEQ INDEX'164880920 0' +SET TABLE DUAL_RVALUE_SEQ INDEX'164880952 0' +SET TABLE DUAL_SALE_MEASUREMENT_SEQ INDEX'164880984 0' +SET TABLE DUAL_SALE_SEQ INDEX'164881016 0' +SET TABLE DUAL_SAMPLE_MEASUREMENT_SEQ INDEX'164881048 0' +SET TABLE DUAL_SAMPLE_SEQ INDEX'164881080 0' +SET TABLE DUAL_SCIENTIFIC_CRUISE_SEQ INDEX'164881112 0' +SET TABLE DUAL_SORTING_MEASUREMENT_SEQ INDEX'164881144 0' +SET TABLE DUAL_SURVEY_MEASUREMENT_SEQ INDEX'164881176 0' +SET TABLE DUAL_TAKE_OVER_MEASUREMENT_SEQ INDEX'164881208 0' +SET TABLE DUAL_TAKE_OVER_SEQ INDEX'164881240 0' +SET TABLE DUAL_TEMP_QUERY_PARAMETER_SEQ INDEX'164881272 0' +SET TABLE DUAL_TRANSSHIPMENT_SEQ INDEX'164881304 0' +SET TABLE DUAL_UTIL_FACTORY_SEQ INDEX'164881336 0' +SET TABLE DUAL_VESSEL_PHYSICAL_FEATURES_SEQ INDEX'164881368 0' +SET TABLE DUAL_VESSEL_PHYSICAL_MEASUREMEN_SEQ INDEX'164881400 0' +SET TABLE DUAL_VESSEL_POSITION_MEASUREMEN_SEQ INDEX'164881432 0' +SET TABLE DUAL_VESSEL_POSITION_SEQ INDEX'164881464 0' +SET TABLE DUAL_VESSEL_USE_FEATURES_SEQ INDEX'164881496 0' +SET TABLE DUAL_VESSEL_USE_MEASUREMENT_SEQ INDEX'164881528 0' +SET TABLE DUAL_BATCH_EXHAUSTIVE_INVENTORY_SEQ INDEX'164881560 0' +SET TABLE PERSON_SESSION_VESSEL INDEX'164881592 164881592 164881592 164881592 164881592 164881592 0' +SET TABLE DENORMALIZED_SAMPLING_STRATA INDEX'164961016 164898864 164900592 164961016 164882296 0' +SET TABLE DUAL_INSERTED_ITEM_HISTORY_SEQ INDEX'165044816 0' +SET TABLE DUAL_SORTING_MEASUREMENT_P_SEQ INDEX'165044848 0' +SET TABLE SYSTEM_VERSION INDEX'167972480 0' +SET TABLE TRANSCRIBING_ITEM INDEX'470503624 469404144 470110408 0' +SET TABLE TRANSCRIBING_ITEM_TYPE INDEX'168131336 168123696 168123352 168089136 168130264 168090856 168123696 0' +SET TABLE DUAL_UPDATED_ITEM_HISTORY_SEQ INDEX'166504120 0' +SET TABLE VESSEL_COMMISSIONING_PERIOD INDEX'167234232 167234232 166526616 0' +SET TABLE DUAL_VESSEL_PERSON_SEQ INDEX'167971328 0' +SET TABLE VESSEL_PERSON_FEATURES INDEX'168381104 168381104 168381104 168381104 168381104 168381104 168381104 168381104 168381104 168381104 168381104 168381104 0' +SET TABLE DUAL_VESSEL_PERSON_FEATURES_SEQ INDEX'167971360 0' +SET TABLE VESSEL_PERSON_ROLE INDEX'167971496 0' +SET TABLE VESSEL_PERSON_FEATURES2ROLE INDEX'168381896 168381896 168381896 0' +SET TABLE DUAL_VESSEL_PERSON_MEASUREMENT_SEQ INDEX'167971960 0' +SET TABLE DATABASECHANGELOGLOCK INDEX'167972384 0' +SET TABLE DATABASECHANGELOG INDEX'168001280 0' +SET TABLE DUAL_SYSTEM_VERSION_SEQ INDEX'167972352 0' +SET TABLE DUAL_OBSERVED_LOCATION_SEQ INDEX'167971992 0' +SET TABLE DUAL_DENORMALIZED_VESSEL_SEQ INDEX'168304608 0' +SET TABLE DUAL_OBSERVED_LOCATION_MEASUREM_SEQ INDEX'168308936 0' +SET TABLE DUAL_QUANTIFICATION_MEASUREMENT_P_SEQ INDEX'168316920 0' +ALTER TABLE DELETED_ITEM_HISTORY ALTER COLUMN ID RESTART WITH 0 +ALTER TABLE INSERTED_ITEM_HISTORY ALTER COLUMN ID RESTART WITH 0 +ALTER TABLE UPDATED_ITEM_HISTORY ALTER COLUMN ID RESTART WITH 0 +CREATE VIEW AGE_READER_QUALIFICATIONS2PEOP (AGE_READER_QUALIFICATIONS_FK,PEOPLE_FK) AS select\u000a AGE_READER_QUALIFICATION_FK as AGE_READER_QUALIFICATIONS_FK,\u000a PERSON_FK as PEOPLE_FK\u000a from \u000a AGE_READER_QUAL2PERSON +CREATE USER SA PASSWORD "" +GRANT DBA TO SA +SET WRITE_DELAY 10 Added: tutti/test/services/dbImportBigfin/protocol.tuttiProtocol =================================================================== --- tutti/test/services/dbImportBigfin/protocol.tuttiProtocol (rev 0) +++ tutti/test/services/dbImportBigfin/protocol.tuttiProtocol 2014-09-30 13:15:47 UTC (rev 105) @@ -0,0 +1,71 @@ +id: 7746706e-c0b7-49e9-9308-fee0bd620a22 +name: Protocole Import Bigfin +gearUseFeaturePmfmId: +- 896 +- 924 +lengthClassesPmfmId: +- 1425 +- 1416 +- 622 +species: +- !SpeciesProtocol + id: 880146e2-1de2-46e9-994a-aa62437092de + calcifySampleEnabled: true + countIfNoFrequencyEnabled: true + lengthStepPmfmId: 1416 + mandatorySampleCategoryId: + - 198 + - 196 + - 174 + - 1430 + speciesReferenceTaxonId: 4100 + speciesSurveyCode: ESP1 + weightEnabled: true +- !SpeciesProtocol + id: 8590b532-0604-48f8-bf79-e343c00464bd + calcifySampleEnabled: true + countIfNoFrequencyEnabled: true + lengthStepPmfmId: 1425 + mandatorySampleCategoryId: + - 198 + - 196 + - 174 + - 1430 + speciesReferenceTaxonId: 1662 + speciesSurveyCode: ESP2 + weightEnabled: true +- !SpeciesProtocol + calcifySampleEnabled: true + countIfNoFrequencyEnabled: true + mandatorySampleCategoryId: + - 198 + - 196 + - 174 + - 1430 + speciesReferenceTaxonId: 1543 + speciesSurveyCode: NOLS-ESP + weightEnabled: true +- !SpeciesProtocol + calcifySampleEnabled: true + countIfNoFrequencyEnabled: true + lengthStepPmfmId: 1416 + mandatorySampleCategoryId: + - 198 + - 196 + - 174 + - 1430 + speciesReferenceTaxonId: 1304 + speciesSurveyCode: ESP3 + weightEnabled: true +- !SpeciesProtocol + calcifySampleEnabled: true + countIfNoFrequencyEnabled: true + lengthStepPmfmId: 1416 + mandatorySampleCategoryId: + - 198 + - 196 + - 174 + - 1430 + speciesReferenceTaxonId: 1644 + speciesSurveyCode: + weightEnabled: true Added: tutti/test/services/dbImportBigfin/version.appup =================================================================== --- tutti/test/services/dbImportBigfin/version.appup (rev 0) +++ tutti/test/services/dbImportBigfin/version.appup 2014-09-30 13:15:47 UTC (rev 105) @@ -0,0 +1 @@ +2014.09.16 \ No newline at end of file