01ba_Anhang B Annex_1_DatenbankModell.pdf

[Seite 1]

EUGINIUS2_PUB.DESCRIPTION

P * ID NUMBER (19)

• MODIFIED DATE DESCRIPTION CLOB CREATED TIMESTAMP

DESCRIPTION_PK (ID)

EUGINIUS2_PUB.ABSTRACT_GMO

• DISCR VARCHAR2 (31 CHAR) P * ID NUMBER (19)
• MODIFIED DATE
• CBIFIELDS NUMBER (10) GMO_COMMENT VARCHAR2 (4000 CHAR) INSERTNUMBER NUMBER (10) U * NAME VARCHAR2 (255 CHAR) U OECDID VARCHAR2 (255 CHAR) TYPE NUMBER (10) F DESCRIPTION_ID NUMBER (19) F * SPECIES_ID NUMBER (19) F TRANSFORMATION_ID NUMBER (19) CREATED TIMESTAMP EUGINIUS2_PUB.METHOD_TARGET_CONSTRUCT ABSTRACT_GMO_PK (ID) UF* METHOD_TARGET_ID NUMBER (19) ABSTRACT_GMO_OECDID_UN (OECDID) UF* GMOS_ID NUMBER (19) ABSTRACT_GMO_NAME_UN (NAME)

METHOD_TARGET_CONSTRUCT_METHOD_TARGET_ID_GMOS_ID_UN (METHOD_TARGET_ID, GMOS_ID) FK5D0B428CB67D39B4 (TRANSFORMATION_ID)

FK5D0B428C1D4EA0E0 (SPECIES_ID) FKEE1EAE274A09F799 (METHOD_TARGET_ID) FK5D0B428C1F4BF0CB (DESCRIPTION_ID) FKEE1EAE2789995E9D (GMOS_ID) EUGINIUS2_PUB.COMMONNAME

P * ID NUMBER (19) EUGINIUS2_PUB.TRANSFORMATION

• MODIFIED DATE EUGINIUS2_PUB.GMO2DNA
• NAME VARCHAR2 (255 CHAR) P * ID NUMBER (19) UF* DNA_ID NUMBER (19) F SPECIES_ID NUMBER (19) * MODIFIED DATE UF* GMO_ID NUMBER (19) CREATED TIMESTAMP U * TRANSFORMATION_NAME VARCHAR2 (255 CHAR) EUGINIUS2_PUB.METHOD_TARGET CREATED TIMESTAMP GMO2DNA_DNA_ID_GMO_ID_UN (DNA_ID, GMO_ID)
• DISCR VARCHAR2 (31 CHAR) COMMONNAME_PK (ID) TRANSFORMATION_PK (ID) FK8D6836E369C733E (GMO_ID) P * ID NUMBER (19) FK638FA2F61D4EA0E0 (SPECIES_ID) TRANSFORMATION_TRANSFORMATION_NAME_UN (TRANSFORMATION_NAME) FK8D6836E63F3E96D (DNA_ID)
• MODIFIED DATE NAME VARCHAR2 (255 CHAR) EUGINIUS2_PUB.APPLICATION2GMO CHILD_GMO_ID) F GMO_ID NUMBER (19) UF* APPLICATION_ID NUMBER (19) F SPECIES_ID NUMBER (19) EUGINIUS2_PUB.LITERATURE_GMO UF* GMO_ID NUMBER (19) EUGINIUS2_PUB.APPLICATION EUGINIUS2_PUB.APPLICANT CREATED TIMESTAMP UF* LITERATURE_ID NUMBER (19) APPLICATION2GMO_APPLICATION_ID_GMO_ID_UN (APPLICATION_ID, GMO_ID) P * ID NUMBER (19) P * ID NUMBER (19) METHOD_TARGET_PK (ID) EUGINIUS2_PUB.SPECIES UF* GMO_ID NUMBER (19) FKB5992827BB507560 (APPLICATION_ID) * MODIFIED DATE * MODIFIED DATE FKED6C8EAF1D4EA0E0 (SPECIES_ID) LITERATURE_GMO_LITERATURE_ID_GMO_ID_UN (LITERATURE_ID, GMO_ID) FKB5992827369C733E (GMO_ID) * CBIFIELDS NUMBER (10) * CBIFIELDS NUMBER (10) FKED6C8EAF67F86CC0 (GMO_ID) P * ID NUMBER (19) APPLICATION_COMMENT VARCHAR2 (4000 CHAR) APPLICANT_COMMENT VARCHAR2 (4000 CHAR)
• MODIFIED DATE EUGINIUS2_PUB.MATERIAL FKD443F43B2CB311B4 (LITERATURE_ID) DECISION_DATE DATE U * APPLICANT_NAME VARCHAR2 (255 CHAR)
• CBIFIELDS NUMBER (10) FKD443F43B369C733E (GMO_ID) EXPIRY_DATE DATE CREATED TIMESTAMP
• ID NUMBER (19)
• NAME VARCHAR2 (255 CHAR) U * FILE_REF VARCHAR2 (255 CHAR)
• MODIFIED DATE APPLICANT_PK (ID) CREATED TIMESTAMP
• RECEIPT_DATE DATE
• CBIFIELDS NUMBER (10) APPLICANT_APPLICANT_NAME_UN (APPLICANT_NAME) SPECIES_PK (ID) EUGINIUS2_PUB.COUNTRY RIKILT_NO VARCHAR2 (4000 CHAR) CATALOGUE_NO VARCHAR2 (255 CHAR) F APPLICANT_ID NUMBER (19) CERTIFIED NUMBER (1) P * ID NUMBER (19) F * COUNTRY_ID NUMBER (19) EUGINIUS2_PUB.THESAURUS MATERIAL_COMMENT VARCHAR2 (4000 CHAR) * MODIFIED DATE FK8758C4E1B8B8B41C (FORWARDPRIMER_ID) F LEGISLATION_ID NUMBER (19)
• DISCR VARCHAR2 (31 CHAR) COMMERCIALLY_AVAILABLE NUMBER (1) * EUROPE NUMBER (1) FK8758C4E1FB92A644 (PROBE_ID) CREATED TIMESTAMP P * ID NUMBER (19) FK8758C4E16B78F40B (DETECTION_TYPE_ID) CONCENTRATION VARCHAR2 (255 CHAR) EUGINIUS2_PUB.LITERATURE_DNA U * COUNTRY_NAME VARCHAR2 (255 CHAR) FILE_REF_GROUP NUMBER (1) EUGINIUS2_PUB.LEGISLATION
• M FU O L D L I N F A IE M D E D VA A R TE CHAR2 (500 CHAR) F FK K 8 8 7 7 5 5 8 8 C C 4 4 E E 1 1 6 6 9 0 3 9 F 0C C E D 3 A 4 0 ( ( A S M TA P N LI D C A O R N D _ I I S D A ) TION_ID) D EX E T S R C A R _ IP C T O IO M N M _ E N N A T ME V V A A R R C C H H A A R R 2 2 ( ( 4 4 0 0 0 0 0 0 C C H H A A R R ) ) EUGINIUS2_PUB.GMO_LINK EUGINIUS2_PUB.LITERATURE U U F F * * L D I N TE A R _I A D TURE_ID N N U U M M B B E E R R ( ( 1 1 9 9 ) ) P * ID EUGINIUS2_PUB N .C U O M M B P E O R S (1 IT 9 E ) DNA EUGINIUS2_PUB.DNA_INTEGRATIONTYPE P * ID EUGINIUS N 2 U _P M U B B E . R Z O (1 N 9 E ) F * Z C O R N EA E T _I E D D N TI U M M E B S E T R A M (1 P 9) F F I I L L E E _ _ R R E E F F _ _ G G R R O O U U P P _ _ S S O O R R T T _ _ 1 2 V V A A R R C C H H A A R R 2 2 ( ( 2 2 5 5 5 5 B B Y Y T T E E ) ) P * ID NUMBER (19) THES_LEVEL NUMBER (10) FK8758C4E19CADC27 (VALIDATION_STATUS_ID) EUGINIUS2_PUB.GMOS_COMPANIES UNEXPECTED_RESULT NUMBER (1) P * ID NUMBER (19) P * ID NUMBER (19) * MODIFIED DATE UF* DNA_ID NUMBER (19) * MODIFIED DATE COUNTRY_PK (ID) FILE_REF_GROUP_SORT VARCHAR2 (255 BYTE) * MODIFIED DATE U NAME VARCHAR2 (255 CHAR) FK8758C4E1911586B4 (TARGET_ID) UF* GMO_ID NUMBER (19) F SOURCE_PROVIDER_ID NUMBER (19) * MODIFIED DATE EUGINIUS2_PUB.LITERATUREBACKUP * MODIFIED DATE LITERATURE_DNA_LITERATURE_ID_DNA_ID_UN (LITERATURE_ID, DNA_ID) * CBIFIELDS NUMBER (10) UF* INTEGRATION_ID NUMBER (19) U * ZONE_NAME VARCHAR2 (255 CHAR) COUNTRY_COUNTRY_NAME_UN (COUNTRY_NAME) * LEGISLATION_NAME VARCHAR2 (255 CHAR)
• O B D C E B H F O I I _ N D T IT R I A O I N T_ID V V V A A A R R R C C C H H H A A A R R R 2 2 2 ( ( ( 2 2 2 5 5 5 5 5 5 C C C H H H A A A R R R ) ) ) FK8758C4E19737C49F (REVERSEPRIMER_ID) UF* G C M O O M S P C A O N M Y P ID ANIES N _ U G M M B O E _ R ID ( _ 1 C 9 O ) MPANY_ID_UN (GMO_ID, COMPANY_ID) F F M G CR M A E T O A E _ T R ID E IA D L_TYPE_ID N N TI U U M M M E B B S E E T R R A M ( ( 1 1 P 9 9 ) ) F * D L G I E M N S K O C _ R ID IPTION V V N A A U R R M C C B H H E A A R R R ( 2 2 1 9 ( ( 2 2 ) 5 5 5 5 C C H H A A R R ) ) P * * I M P D D O F DIFIED N D BL U A O T M E B BER (19) U * * C C LI B I T T I _ A F C I T E O IO L M D N M S ENT N V V A A U R R M C C B H H E A A R R R ( 2 2 1 0 ( ( 4 4 ) 0 0 0 0 0 0 C C H H A A R R ) ) F F K K D D 4 4 4 4 3 3 E E 9 9 0 0 9 9 2 6 C 3F B 3 3 E 1 9 1 6 B D 4 ( ( D LI N T A E _ R I A D T ) URE_ID) * D D D E N N R A A I _ _ V F C E U O D N M F C M R T O E IO N M N T V V V A A A R R R C C C H H H A A A R R R 2 2 2 ( ( ( 4 4 2 0 0 5 0 0 5 0 0 C C C H H H A A A R R R ) ) ) D FK N 6 A 4 _ 1 IN B2 T 7 E A G 6 R 5 A F T 40 IO 2D N 3 T A Y P (I E N _ T D E N G A R _ A ID T _ IO IN N T _ E ID G ) RATION_ID_UN (DNA_ID, INTEGRATION_ID) ZO C N R E E _ A P T K E D (ID) TIMESTAMP FK63E2E37687926B54 (ZONE_ID) A A FK P P D P P C L L I I F C C 7 A A 9 T T 9 I I 3 O O 0 N N C _ _ C P F B I K L 7 E ( C I _ D A R ) A E 0 F ( _ C U O N U ( N F T IL R E Y _ _ R ID EF ) ) LE C G R I E S A L T A E T D ION_PK (ID) TIMESTAMP EUGINIUS2_PUB.ACT_RU_TASK FUNCTION VARCHAR2 (4000 CHAR) FK106C906D6664D40 (COMPANY_ID) MATERIAL_PK (ID) CREATED TIMESTAMP CREATED TIMESTAMP DATE_VISITED DATE * DNA_NAME VARCHAR2 (255 CHAR) FK641B27A663F3E96D (DNA_ID) ZONE_ZONE_NAME_UN (ZONE_NAME) FKDCF799308FFFF1A0 (APPLICANT_ID) P * ID_ NVARCHAR2 (64) F F P D A O R N E O N R T _ _ ID ID N N U U M M B B E E R R ( ( 1 1 9 9 ) ) FK106C906369C733E (GMO_ID) FK15ADC947C1DC4143 (MATERIAL_TYPE_ID) GMO_LINK_PK (ID) LITERATUREBACKUP_PK (ID) F LI I T L U E_ R R L EF V V A A R R C C H H A A R R 2 2 ( ( 2 2 5 5 5 5 C C H H A A R R ) ) CREATED TIMESTAMP FKDCF79930868A93C0 (LEGISLATION_ID) REV_ NUMBER (,0) FK15ADC947E2D667CB (SOURCE_PROVIDER_ID) COMPOSITEDNA_PK (ID) F TRAIT_ID NUMBER (19) PUBLICATION_YEAR NUMBER (10) F EXECUTION_ID_ NVARCHAR2 (64) FK44E07E50369C733E (GMO_ID) FK15ADC947369C733E (GMO_ID) FULLNAME_2 VARCHAR2 (500 BYTE) F BACKUP_ID NUMBER (19) EUGINIUS2_PUB.INTEGRATION F PROC_INST_ID_ NVARCHAR2 (64) CREATED TIMESTAMP F LITERATUREABSTRACT_ID NUMBER (19) F PROC_DEF_ID_ NVARCHAR2 (64) P * ID NUMBER (19) F PUBLICATION_TYPE_ID NUMBER (19) EUGINIUS2_PUB.ACT_RU_IDENTITYLINK NAME_ NVARCHAR2 (255) THESAURUS_PK (ID) * MODIFIED DATE F AUTORITY_ID NUMBER (19) P * ID_ NVARCHAR2 (64) PARENT_TASK_ID_ NVARCHAR2 (64) THESAURUS_NAME_UN (NAME) * NAME VARCHAR2 (255 CHAR) CREATED TIMESTAMP REV_ NUMBER (,0) DESCRIPTION_ NVARCHAR2 (2000) CREATED TIMESTAMP FKB13518DADE260EE (PARENT_ID) COMMISSION_DECISION_NUMBER VARCHAR2 (256 CHAR) GROUP_ID_ NVARCHAR2 (64) TASK_DEF_KEY_ NVARCHAR2 (255) FKB13518DA83E60920 (TRAIT_ID) INTEGRATION_PK (ID) TYPE_ NVARCHAR2 (255) OWNER_ NVARCHAR2 (64) FKB13518DA9E5E8B76 (D LITERATURE_PK (ID) EUGINIUS2_PUB.APPLICATION_LITERATURE EUGINIUS2_PUB.APPLICATION2APPLICATION USER_ID_ NVARCHAR2 (64) ASSIGNEE_ NVARCHAR2 (64) LITERATURE_CITATION_UN (CITATION) EUGINIUS2_PUB.APPLICATION2USE2STATUS F TASK_ID_ NVARCHAR2 (64) D PR EL IO E R G I A T T Y I _ ON_ N N V U A M R B C E H R A ( R *,0 2 ) (64) EUGINIUS2_PUB.MATERIALDESCRIPTION FKB4EAC151B5121065 (AUTORITY_ID) U U F F * * L A I P T P E L R IC AT A U TI R O E N _ _ ID ID N N U U M M B B E E R R ( ( 1 1 9 9 ) ) P * * I M D ODIFIED N D U AT M E BER (19) U U F F * * A R P E P LA LI T C E A D T _ IO ID N_ID N N U U M M B B E E R R ( ( 1 1 9 9 ) ) ACT_RU_IDENTITYLINK_PK (ID_) P * ID NUMBER (19) FKB4EAC151C4271545 (BACKUP_ID) CREATE_TIME_ TIMESTAMP APPLICATION_LITERATURE_LITERATURE_ID_APPLICATION_ID_UN (LITERATURE_ID, APPLICATION_ID) * CBIFIELDS NUMBER (10) APPLICATION2APPLICATION_APPLICATION_ID_RELATED_ID_UN (APPLICATION_ID, RELATED_ID)
• MODIFIED DATE FKB4EAC15177DC5094 (LITERATUREABSTRACT_ID) ACT_FK_TSKASS_TASK (TASK_ID_) DUE_DATE_ TIMESTAMP DESCRIPTION_NAME VARCHAR2 (4000 CHAR) FKB4EAC1518ABF6F59 (PUBLICATION_TYPE_ID) EUGINIUS2_PUB.ANNOTATEDSEQUENCE FKC596DFC0BB507560 (APPLICATION_ID) USE_STATUS_COMMENT VARCHAR2 (4000 CHAR) FK7C0CDF2EBB507560 (APPLICATION_ID) UF* APPLICATION_ID NUMBER (19) ACT_IDX_IDENT_LNK_GROUP (GROUP_ID_) ACT_RU_TASK_PK (ID_) CREATED TIMESTAMP P * ID NUMBER (19) FKC596DFC02CB311B4 (LITERATURE_ID) FK7C0CDF2EF9A8ACA5 (RELATED_ID) F * STATUS_ID NUMBER (19) ACT_IDX_IDENT_LNK_USER (USER_ID_) * MODIFIED DATE ACT_FK_TASK_EXE (EXECUTION_ID_) EUGINIUS2_PUB.THESAURUSRELATI MATERIALDESCRIPTION_PK (ID) UF* USE_ID NUMBER (19) ACT_IDX_TSKASS_TASK (TASK_ID_) * CBIFIELDS NUMBER (10) EUGINIUS2_PUB.DNAMAP ACT_FK_TASK_PROCDEF (PROC_DEF_ID_) P * ID NUMBER (19) CREATED TIMESTAMP ACT_FK_TASK_PROCINST (PROC_INST_ID_) * MODIFIED DATE EUGINIUS2_ ACCESSIONNUMBER VARCHAR2 (255 CHAR) P * ID NUMBER (19) ANNOTATION VARCHAR2 (4000 CHAR) * MODIFIED DATE APPLICATION2USE2STATUS_PK (ID) ACT_IDX_TASK_CREATE (CREATE_TIME_) F CHILD_ID NUMBER (19) P * ID SEQUENCE_COMMENT VARCHAR2 (4000 CHAR) DESCRIPTION VARCHAR2 (255 CHAR) APPLICATION2USE2STATUS_APPLICATION_ID_USE_ID_UN (APPLICATION_ID, USE_ID) ACT_IDX_TASK_EXEC (EXECUTION_ID_) F PARENT_ID NUMBER (19) * MODIFIED FIRSTREFERENCE NUMBER (1) PICTURE BLOB ACT_IDX_TASK_PROCDEF (PROC_DEF_ID_) CREATED TIMESTAMP * NAME FKFA14ADDFBB507560 (APPLICATION_ID) ACT_IDX_TASK_PROCINST (PROC_INST_ID_) CREATED NUMBEROFPARTS NUMBER (10) F DNA_ID NUMBER (19) EUGINIUS2_PUB.PRIVATEROLES FKFA14ADDF1914B9D5 (USE_ID) THESAURUSRELATION_PK (ID) SEQUENCE CLOB CREATED TIMESTAMP P * ID NUMBER (19) FKFA14ADDF67761C60 (STATUS_ID) MATERIAL_TY DNA_SIZE NUMBER (10) FK59FC0CF6DE260EE (PARENT_ID) DNAMAP_PK (ID) * MODIFIED DATE F REFERENCE_ID NUMBER (19) FK59FC0CF6F565C73C (CHILD_ID) U * ROLE VARCHAR2 (255 CHAR) F DNA_ID NUMBER (19) FK7A44E8E563F3E96D (DNA_ID) CREATED TIMESTAMP PRIVATEROLES_PK (ID) PRIVATEROLES_ROLE_UN (ROLE) EUGINIUS2_PUB.ACT_RU_EVENT_SUBSCR ANNOTATEDSEQUENCE_PK (ID) P * ID_ NVARCHAR2 (64) EUGINIUS2_PUB.STANDARDISATION FK1511B83963F3E96D (DNA_ID) REV_ NUMBER (*,0) FK1511B8397FED2100 (REFERENCE_ID) P * ID NUMBER (19)
• EVENT_TYPE_ NVARCHAR2 (255)
• MODIFIED DATE ID, DEVELOPER_ID) EVENT_NAME NVARCHAR2 (255) EUGINIUS2_PUB.ACT_RE_PROCDEF U * STANDARDISATION_NAME VARCHAR2 (255 CHAR) 2_PUB.LITERATURE_PUBLICATION_ F EXECUTION_ID_ NVARCHAR2 (64) P * ID_ NVARCHAR2 (64) CREATED TIMESTAMP EUGINIUS2_PUB.LITERATURE_CONTENTTYPE EUGINIUS2_PUB.INTENDED_USE EUGINIUS2_PUB.STATUS PROC_INST_ID_ NVARCHAR2 (64) REV_ NUMBER (,0) P * ID NUMBER (19) P * ID NUMBER (19) NUMBER (19) UF LITERATURE_ID NUMBER (19) ACTIVITY_ID_ NVARCHAR2 (64) CATEGORY_ NVARCHAR2 (255) STANDARDISATION_PK (ID) * MODIFIED DATE * MODIFIED DATE D DATE UF* CONTENTTYPE_ID NUMBER (19) CONFIGURATION_ NVARCHAR2 (255) NAME_ NVARCHAR2 (255) STANDARDISATION_STANDARDISATION_NAME_UN (STANDARDISATION_NAME) U * TEXT VARCHAR2 (255 CHAR) * LEGAL_STATUS VARCHAR2 (255 CHAR) VARCHAR2 (255 CHAR)
• CREATED_ TIMESTAMP KEY_ NVARCHAR2 (255) LITERATURE_CONTENTTYPE_LITERATURE_ID_CONTENTTYPE_ID_UN (LITERATURE_ID, CONTENTTYPE_ID) EUGINIUS2_PUB.PRIVATEUSER_PRIVATEROLE USECATEGORY VARCHAR2 (255 CHAR) U * STATUS_TEXT VARCHAR2 (255 CHAR) D TIMESTAMP ACT_RU_EVENT_SUBSCR_PK (ID_) VERSION_ NUMBER (,0) FK29632125134E7AA0 (CONTENTTYPE_ID) UF USER_ID NUMBER (19) CREATED TIMESTAMP CREATED TIMESTAMP DEPLOYMENT_ID_ NVARCHAR2 (64) RE_PUBLICATION_TYPE_PK (ID) FK296321252CB311B4 (LITERATURE_ID) UF* ROLE_ID NUMBER (19) * COLOR_APPROVED VARCHAR2 (10 BYTE) STATUS_PK (ID) ACT_FK_EVENT_EXEC (EXECUTION_ID_) RESOURCE_NAME_ NVARCHAR2 (2000) EUGINIUS2_PUB.REFERENCE PRIVATEUSER_PRIVATEROLE_USER_ID_ROLE_ID_UN (USER_ID, ROLE_ID) INTENDED_USE_PK (ID) STATUS_STATUS_TEXT_UN (STATUS_TEXT) ACT_IDX_EVENT_SUBSCR (EXECUTION_ID_) DGRM_RESOURCE_NAME_ VARCHAR2 (4000 BYTE) ACT_IDX_EVENT_SUBSCR_CONFIG_ (CONFIGURATION_) HAS_START_FORM_KEY_ NUMBER (1) P * ID NUMBER (19) INIUS2_PUB.LITERATURE_KEYWORD FK435F35481824BFA3 (USER_ID) INTENDED_USE_TEXT_UN (TEXT) SUSPENSION_STATE_ NUMBER (*,0) * MODIFIED DATE (19) FK435F354872F9FBC3 (ROLE_ID)
• CBIFIELDS NUMBER (10) (19) ACT_RE_PROCDEF_PK (ID_) REFERNCE_COMMENT VARCHAR2 (4000 CHAR)
• REFERENCE_NAME VARCHAR2 (255 CHAR) ATURE_ID_KEYWORD_ID_UN (LITERATURE_ID, KEYWORD_ID) EUGINIUS2_PUB.CONTENTTYPE CREATED TIMESTAMP RD_ID) P * ID NUMBER (19) REFERENCE_PK (ID) TURE_ID) * MODIFIED DATE
• CONTENTYPE_NAME VARCHAR2 (255 CHAR) EUGINIUS2_PUB.ACT_RU_EXECUTION CREATED TIMESTAMP P * ID_ NVARCHAR2 (64) CONTENTTYPE_PK (ID) EUGINIUS2_PUB.PRIVATEUSER REV_ NUMBER (*,0) P * ID NUMBER (19) F PROC_INST_ID_ NVARCHAR2 (64) ORD * MODIFIED DATE BUSINESS_KEY_ NVARCHAR2 (255) 9) EMAIL VARCHAR2 (255 CHAR) F PARENT_ID_ NVARCHAR2 (64) EUGINIUS2_PUB.PUBLISHINGAUTHORITY * PASSWORD VARCHAR2 (256 CHAR) PROC_DEF_ID_ NVARCHAR2 (64) (255 CHAR) P * ID NUMBER (19) EUGINIUS2_PUB.ACT_HI_DETAIL EUGINIUS2_PUB.ACT_HI_TASKINST EUGINIUS2_PUB.ACT_HI_ACTINST U * USERNAME VARCHAR2 (30 CHAR) F SUPER_EXEC_ NVARCHAR2 (64) * MODIFIED DATE P * ID_ VARCHAR2 (64 BYTE) P * ID_ NVARCHAR2 (64) P * ID_ NVARCHAR2 (64) PRIVATEUSER_PK (ID) EUGINIUS2_PUB.ACT_GE_PROPERTY ACT_ID_ NVARCHAR2 (255) U * AUTHORITY_NAME VARCHAR2 (255 CHAR) * TYPE_ NVARCHAR2 (255) PROC_DEF_ID_ NVARCHAR2 (64)
• PROC_DEF_ID_ NVARCHAR2 (64) PRIVATEUSER_USERNAME_UN (USERNAME) P * NAME_ NVARCHAR2 (64) IS_ACTIVE_ NUMBER (1) CREATED TIMESTAMP * PROC_INST_ID_ NVARCHAR2 (64) TASK_DEF_KEY_ NVARCHAR2 (255) EUGINIUS2_PUB.VALIDATION_STATUS * PROC_INST_ID_ NVARCHAR2 (64) VALUE_ NVARCHAR2 (300) IS_CONCURRENT_ NUMBER (1) * EXECUTION_ID_ NVARCHAR2 (64) PROC_INST_ID_ NVARCHAR2 (64) PUBLISHINGAUTHORITY_PK (ID) * EXECUTION_ID_ NVARCHAR2 (64) REV_ NUMBER (,0) IS_SCOPE_ NUMBER (1) P * ID NUMBER (19) TASK_ID_ NVARCHAR2 (64) EXECUTION_ID_ NVARCHAR2 (64) PUBLISHINGAUTHORITY_AUTHORITY_NAME_UN (AUTHORITY_NAME) * ACT_ID_ NVARCHAR2 (255) IS_EVENT_SCOPE_ NUMBER (1) * MODIFIED DATE ACT_INST_ID_ NVARCHAR2 (64) PARENT_TASK_ID_ NVARCHAR2 (64) ACT_GE_PROPERTY_PK (NAME_) ACT_NAME_ NVARCHAR2 (255) SUSPENSION_STATE_ NUMBER (,0) * IMPORTANCE NUMBER (10) * NAME_ NVARCHAR2 (255) NAME_ NVARCHAR2 (255)
• ACT_TYPE_ NVARCHAR2 (255) U * VALIDATION_STATUS_NAME VARCHAR2 (255 CHAR) VAR_TYPE_ NVARCHAR2 (64) DESCRIPTION_ NVARCHAR2 (2000) ACT_RU_EXECUTION_PK (ID_) ASSIGNEE_ NVARCHAR2 (64) CREATED TIMESTAMP REV_ NUMBER (*,0) OWNER_ NVARCHAR2 (64) ACT_FK_EXE_PARENT (PARENT_ID_) * TIME_ TIMESTAMP ASSIGNEE_ NVARCHAR2 (64) * START_TIME_ TIMESTAMP

A A C C T T _ _ F F K K _ _ E E X X E E _ _ P P A R R O E C N IN T S ( T P A (P R R E O N C T _ _ I I N D S ) T_ID) VALIDATION_STATUS_PK (ID) EUGINIUS2_PUB.PLACEDGENETICELEMENT * T B I Y M T E E _ ARRAY_ID_ T N I V M A E R S C T H A A M R P 2 (64) * A S S TA S R IG T N _ E TI E M _ E_ N TI V M A E R S C T H A A M R P 2 (64) * S E T N A D R T T I _ M T E IM _ E T T I I M M E E S S T T A A M M P P ACT_FK_EXE_SUPER (SUPER_EXEC_) VALIDATION_STATUS_VALIDATION_STATUS_NAME_UN (VALIDATION_STATUS_NAME) P * ID NUMBER (19) DOUBLE_ NUMBER (,10) END_TIME_ TIMESTAMP DURATION_ NUMBER (19) ACT_IDX_EXEC_BUSKEY (BUSINESS_KEY_) * MODIFIED DATE LONG_ NUMBER (19) DURATION_ NUMBER (19) ACT_HI_ACTINST_PK (ID_) ACT_IDX_EXE_PARENT (PARENT_ID_) * CBIFIELDS NUMBER (10) TEXT_ NVARCHAR2 (2000) DELETE_REASON_ NVARCHAR2 (2000) ACT_IDX_HI_ACT_INST_END (END_TIME_) EUGINIUS2_PUB.EDITABLE_CONTENT ACT_IDX_EXE_PROCINST (PROC_INST_ID_) ELEMENT_COMMENT VARCHAR2 (4000 CHAR) EUGINIUS2_PUB.DATACHANGERECORD EUGINIUS2_PUB.ACT_HI_PROCINST TEXT2_ NVARCHAR2 (2000) PRIORITY_ NUMBER (,0) ACT_IDX_HI_ACT_INST_START (START_TIME_) * ID NUMBER (19) ACT_IDX_EXE_SUPER (SUPER_EXEC_) END_POSITION NUMBER (10) P * ID_ NVARCHAR2 (64) DUE_DATE_ TIMESTAMP EUGINIUS2_PUB.ARTICLE EUGINIUS2_PUB.LINK ACT_UNIQ_RU_BUS_KEY (CASE WHEN "BUSINESS_KEY_" IS NULL THEN NULL ELSE "PROC_DEF_ID_" END, CASE WHEN "BUSINESS_KEY_" IS NULL THEN NULL ELSE "BUSINESS_KEY_" END) F P S S A T E A R Q R T U O T E _ R N P D C O E E S R _ I I T D ION N N N U U U M M M B B B E E E R R R ( ( ( 1 1 1 0 0 9 ) ) ) P * * I M B D A O S D E IF T I E E X D T N D C U L A O T M E B BER (19) U * * P B P U R R S O O I C C N _ _ E I D N S E S S F _ T _ K _ I I E D D Y _ _ _ N N N V V V A A A R R R C C C H H H A A A R R R 2 2 2 ( ( ( 2 6 6 5 4 4 5 ) ) ) A A AC C C T T T _ _ _ I H I D D I X _ X D _ _ H H E I T I _ _ A D D I E E L_ T T P A A K I I L L ( _ _ I N A D C A ) M T E IN (N ST A M (A E C _ T ) INST_ID) ACT_HI_TASKINST_PK (ID_) * * * T C LA Y O S P N T E T _ E M N O T DIFIED V C D A L A O R TE C B HAR2 (50 BYTE) P * * * I M A D R O T D IC IF L IE E D CONTENT N D C U L A O T M E B BER (19) P * * I M D D E O S D C IF R IE IP D TION N D VA U A R T M E C B H E A R R ( 2 1 9 (2 ) 000 CHAR) F DNATHESAURUS_ID NUMBER (19) NEWTEXT CLOB * START_TIME TIMESTAMP ACT_IDX_HI_DETAIL_PROC_INST (PROC_INST_ID_) * ARTICLE_DATE DATE * LINK VARCHAR2 (255 CHAR) CREATED TIMESTAMP U PROCESSINSTANCEID VARCHAR2 (255 CHAR) END_TIME_ TIMESTAMP ACT_IDX_HI_DETAIL_TIME (TIME_) * TITLE VARCHAR2 (255 CHAR) * TITLE VARCHAR2 (50 CHAR) CREATED TIMESTAMP EUGINIUS2_PUB.ACT_ID_INFO EUGINIUS2_PUB.DATAENTRY_CHANGE PLACEDGENETICELEMENT_PK (ID) DURATION_ NUMBER (19) CREATED TIMESTAMP CREATED TIMESTAMP P * E I R U D E G _ V IN _ IUS2_PUB.ACT N N H V U I A M _ R A B T C E T H R A A ( C R *, H 0 2 ) M (6 E 4 N ) T P * I T E D Y U _ P G E I _ NIUS2_PUB.AC N N T V V _ A A H R R I C C C H H O A A M R R M 2 2 E ( ( 2 6 N 5 4 T 5 ) ) P * * E I M U D G O I D N IF IU IE S D 2_PUB.D N D A U A T T M A E B R E E R T R (1 IE 9 V ) ALPROFILE * * I T D YPE EUGINIUS2_PU N V B A U . R M P C I B C H E T A R U R R ( 2 1 E 9 ( S ) 50 BYTE) P * I R U D S E _ E V R _ ID N N N V V U A A M R R B C C E H H R A A ( R R ,0 2 2 ) ( ( 6 6 4 4 ) ) P * * * D I M D I O S D C I R FIED V N D A U A R T M E C B H E A R R ( 2 1 9 (3 ) 1 CHAR) F FK K F F 0 0 1 1 2 2 F F 9 9 0 0 0 0 9 F D 71 C 4 1 C 0 3 5 F D 8 4 ( ( S D E N Q A U T E H N E C S E A _ U I R D U ) S_ID) D DA A T T A A C C H H A A N N G G E E R R E E C C O O R R D D _ _ P P R K O (I C D E ) SSINSTANCEID_UN (PROCESSINSTANCEID) S S E T T N A A D R R A T T _ _ C U A T C S I E T D _ R _ I _ D I _ D N N N V V V A A A R R R C C C H H H A A A R R R 2 2 2 ( ( ( 2 2 2 5 5 5 5 5 5 ) ) ) EUGINIUS2_PUB.ACT_ID_MEMBERSHIP ARTICLE_PK (ID) LINK_PK (ID) USER_ID NVARCHAR2 (255) * TIME_ TIMESTAMP ATTRIBUTES LONG RAW * CONTENT BLOB TYPE_ NVARCHAR2 (64) * CREATION_DATE TIMESTAMP SUPER_PROCESS_INSTANCE_ID_ NVARCHAR2 (64) PF USER_ID_ NVARCHAR2 (64) NAME_ NVARCHAR2 (255) USER_ID_ NVARCHAR2 (255) * NAME VARCHAR2 (255 CHAR) * LAST_MODIFIED DATE KEY_ NVARCHAR2 (255) STATE VARCHAR2 (255 CHAR) DELETE_REASON_ NVARCHAR2 (2000) PF* GROUP_ID_ NVARCHAR2 (64) DESCRIPTION_ NVARCHAR2 (2000) TASK_ID_ NVARCHAR2 (64) USERNAME VARCHAR2 (255 CHAR) VALUE_ NVARCHAR2 (255) U * TARGET_ID NUMBER (19) ACT_HI_PROCINST_PK (ID_) EUGINIUS2_PUB.ACT_RU_VARIABLE EUGINIUS2_PUB.ACT_GE_BYTEARRAY EUGINIUS2_PUB.ACT_RU_JOB TYPE_ NVARCHAR2 (255) PROC_INST_ID_ NVARCHAR2 (64) CREATED TIMESTAMP PASSWORD_ BLOB TYPE VARCHAR2 (255 CHAR) ACT_ID_MEMBERSHIP_PK (USER_ID_, GROUP_ID_) ACT_IDX_HI_PRO_I_BUSKEY (BUSINESS_KEY_) P * ID_ NVARCHAR2 (64) P * ID_ NVARCHAR2 (64) TASK_ID_ NVARCHAR2 (64) ACTION_ NVARCHAR2 (255) DATARETRIEVALPROFILE_PK (ID) PARENT_ID_ NVARCHAR2 (255) CREATED TIMESTAMP ACT_FK_MEMB_GROUP (GROUP_ID_) P * ID_ NVARCHAR2 (64) REV_ NUMBER (,0) REV_ NUMBER (,0) PROC_INST_ID_ NVARCHAR2 (64) MESSAGE_ NVARCHAR2 (2000) ACT_FK_MEMB_USER (USER_ID_)

• TYPE_ NVARCHAR2 (255) REV_ NUMBER (*,0) * TYPE_ NVARCHAR2 (255) URL_ NVARCHAR2 (2000) FULL_MSG_ BLOB ACT_ID_INFO_PK (ID_) DATAENTRY_CHANGE_PK (ID) NAME_ NVARCHAR2 (255) DATAENTRY_CHANGE_TARGET_ID_UN (TARGET_ID) ACT_IDX_MEMB_GROUP (GROUP_ID_)
• NAME_ NVARCHAR2 (255) F DEPLOYMENT_ID_ NVARCHAR2 (64) LOCK_EXP_TIME_ TIMESTAMP CONTENT_ID_ NVARCHAR2 (64) ACT_HI_COMMENT_PK (ID_) ACT_IDX_MEMB_USER (USER_ID_) F EXECUTION_ID_ NVARCHAR2 (64) LOCK_OWNER_ NVARCHAR2 (255) BYTES_ BLOB ACT_HI_ATTACHMENT_PK (ID_) F PROC_INST_ID_ NVARCHAR2 (64) EXCLUSIVE_ NUMBER (1) GENERATED_ NUMBER (1) TASK_ID_ NVARCHAR2 (64) EXECUTION_ID_ NVARCHAR2 (64) F BYTEARRAY_ID_ NVARCHAR2 (64) ACT_GE_BYTEARRAY_PK (ID_) PROCESS_INSTANCE_ID_ NVARCHAR2 (64) DOUBLE_ NUMBER (,10) RETRIES_ NUMBER (,0) ACT_FK_BYTEARR_DEPL (DEPLOYMENT_ID_) LONG_ NUMBER (19) F EXCEPTION_STACK_ID_ NVARCHAR2 (64) TEXT_ NVARCHAR2 (2000) ACT_IDX_BYTEAR_DEPL (DEPLOYMENT_ID_) EXCEPTION_MSG_ NVARCHAR2 (2000) TEXT2_ NVARCHAR2 (2000) DUEDATE_ TIMESTAMP EUGINIUS2_PUB.ACT_ID_USER REPEAT_ NVARCHAR2 (255) ACT_RU_VARIABLE_PK (ID_) P * ID_ NVARCHAR2 (64) EUGINIUS2_PUB.ACT_ID_GROUP HANDLER_TYPE_ NVARCHAR2 (255) REV_ NUMBER (,0) ACT_FK_VAR_BYTEARRAY (BYTEARRAY_ID_) HANDLER_CFG_ NVARCHAR2 (2000) P * ID_ NVARCHAR2 (64) FIRST_ NVARCHAR2 (255) ACT_FK_VAR_EXE (EXECUTION_ID_) REV_ NUMBER (,0) ACT_FK_VAR_PROCINST (PROC_INST_ID_) EUGINIUS2_PUB.ACT_RE_DEPLOYMENT ACT_RU_JOB_PK (ID_) LAST_ NVARCHAR2 (255) NAME_ NVARCHAR2 (255) EMAIL_ NVARCHAR2 (255) ACT_IDX_VAR_BYTEARRAY (BYTEARRAY_ID_) P * ID_ NVARCHAR2 (64) ACT_FK_JOB_EXCEPTION (EXCEPTION_STACK_ID_) TYPE_ NVARCHAR2 (255) PWD_ NVARCHAR2 (255) NAME_ NVARCHAR2 (255) ACT_IDX_VAR_EXE (EXECUTION_ID_) ACT_IDX_JOB_EXCEPTION (EXCEPTION_STACK_ID_) PICTURE_ID_ NVARCHAR2 (64) ACT_ID_GROUP_PK (ID_) DEPLOY_TIME_ TIMESTAMP ACT_IDX_VAR_PROCINST (PROC_INST_ID_) ACT_ID_USER_PK (ID_) ACT_RE_DEPLOYMENT_PK (ID_)