Check constraint CKC_CLASS_DESC_TRANS__CLASSIFI CLASS_DESC_TRANS_TYPE in ('Original','Human','Machine') Table Classification description What is wrong CLASS_DESC_TRANS_TYPE has type CHAR(1) while allowed values are longer New table creation statemant create table CLASSIFICATION_DESCRIPTION ( CLASS_DESC_LANG CHAR(2) not null, CLASS_DESC_TRANS_TYPE CHAR(1) not null constraint CKC_CLASS_DESC_TRANS__CLASSIFI check ( CLASS_DESC_TRANS_TYPE in ('O','H','M')), CLASS VARCHAR2(16) not null, CLASS_CODE VARCHAR2(16) not null, CLASS_DESCRIPTION VARCHAR2(64) null , constraint PK_CLASSIFICATION_DESCRIPTION primary key (CLASS_DESC_LANG, CLASS_DESC_TRANS_TYPE, CLASS, CLASS_CODE) ) New insert statements ----------------------------------------- Check constraint CKC_EQUIP_DESC_TRANS__EQUIPMEN Table EQUIPMENT_DESCRIPTION What is wrong EQUIP_DESC_TRANS_TYPE has type char 1 while allowed values are longer New table creation statemant create table EQUIPMENT_DESCRIPTION ( EQUIP_DESC_LANGUAGE CHAR(2) not null, EQUIP_DESC_TRANS_TYPE CHAR(1) not null constraint CKC_EQUIP_DESC_TRANS__EQUIPMEN check ( EQUIP_DESC_TRANS_TYPE in ('O','H','M')), EQUIP_ID CHAR(32) not null, EQUIP_DESCRIPTION VARCHAR2(1024) null , constraint PK_EQUIPMENT_DESCRIPTION primary key (EQUIP_DESC_LANGUAGE, EQUIP_DESC_TRANS_TYPE, EQUIP_ID) ) New insert statements ----------------------------------------- Check constraint CKC_EQUIP_ID_EQUIPMEN Table EQUIPMENT_NAME What is wrong Constraint has bo sense. in CERIF database may be stored more then two equipments New table creation statemant Look at next paragraph New insert statements ----------------------------------------- Check constraint CKC_EQUIP_NAME_TRANS__EQUIPMEN Table EQUIPMENT_NAME What is wrong EQUIP_NAME_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table EQUIPMENT_NAME ( EQUIP_NAME_LANGUAGE CHAR(2) not null, EQUIP_NAME_TRANS_TYPE CHAR(1) not null constraint CKC_EQUIP_NAME_TRANS__EQUIPMEN check ( EQUIP_NAME_TRANS_TYPE in ('O','H','M')), EQUIP_ID CHAR(32) not null, EQUIP_NAME VARCHAR2(512) null , constraint PK_EQUIPMENT_NAME primary key (EQUIP_NAME_LANGUAGE, EQUIP_NAME_TRANS_TYPE, EQUIP_ID) ) New insert statements ----------------------------------------- Check constraint CKC_EQUIP_ID_EQUIP_CL Table EQUIP_CLASS What is wrong There maybe more then two equipments New table creation statemant create table EQUIP_CLASS ( CLASS VARCHAR2(16) not null, CLASS_CODE VARCHAR2(16) not null, EQUIP_ID CHAR(32) not null, constraint PK_EQUIP_CLASS primary key (CLASS, CLASS_CODE, EQUIP_ID) ) New insert statements ----------------------------------------- Check constraint CKC_EVENT_FEE_OR_FREE_EVENT Table EVENT What is wrong EVENT_FEE_OR_FREE has char(1) datatype while allowed values are longer ("Fee" "Free") New table creation statemant -- datatype of column is changed. EVENT_FEE_OR_FREE create table EVENT ( EVENT_ID CHAR(32) not null, EVENT_LOCATION VARCHAR2(80) null , EVENT_START_DATE DATE null , EVENT_END_DATE DATE null , EVENT_FEE_OR_FREE VARCHAR2(4) null constraint CKC_EVENT_FEE_OR_FREE_EVENT check (EVENT_FEE_OR_FREE is null or (EVENT_FEE_OR_FREE in ('Fee','Free'))), EVENT_URL VARCHAR2(512) not null, EVENT_TYPE VARCHAR2(16) not null, constraint PK_EVENT primary key (EVENT_ID) ) New insert statements ----------------------------------------- Check constraint CKC_EVENT_DESC_TRANS__EVENT_DE Table EVENT_DESCRIPTION What is wrong EVENT_DESC_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table EVENT_DESCRIPTION ( EVENT_DESC_LANGUAGE CHAR(2) not null, EVENT_DESC_TRANS_TYPE CHAR(1) not null constraint CKC_EVENT_DESC_TRANS__EVENT_DE check ( EVENT_DESC_TRANS_TYPE in ('O','H','M')), EVENT_ID CHAR(32) not null, EVENT_DESCRIPTION VARCHAR2(1024) null , constraint PK_EVENT_DESCRIPTION primary key (EVENT_DESC_LANGUAGE, EVENT_DESC_TRANS_TYPE, EVENT_ID) ) New insert statements ----------------------------------------- Check constraint CKC_EVENT_TRANS_TYPE_EVENT_NA Table EVENT_NAME What is wrong EVENT_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table EVENT_NAME ( EVENT_LANGUAGE CHAR(2) not null, EVENT_TRANS_TYPE CHAR(1) not null constraint CKC_EVENT_TRANS_TYPE_EVENT_NA check ( EVENT_TRANS_TYPE in ('O','H','M')), EVENT_ID CHAR(32) not null, EVENT_NAME VARCHAR2(512) null , constraint PK_EVENT_NAME primary key (EVENT_LANGUAGE, EVENT_TRANS_TYPE, EVENT_ID) ) New insert statements ----------------------------------------- Check constraint EXP_SKILL_DESC_TRANS_TYPE Table EXPERTISE_SKILLS_DESCRIPTION What is wrong EXP_SKILL_DESC_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table EXPERTISE_SKILLS_DESCRIPTION ( EXP_SKILL_DESC_LANGUAGE CHAR(2) not null, EXP_SKILL_DESC_TRANS_TYPE CHAR(1) not null constraint CKC_EXP_SKILL_DESC_TR_EXPERTIS check ( EXP_SKILL_DESC_TRANS_TYPE in ('O','H','M')), EXP_SKILL_ID CHAR(32) not null, EXP_SKILL_DESCRIPTION VARCHAR2(1024) not null, constraint PK_EXPERTISE_SKILLS_DESCRIPTIO primary key (EXP_SKILL_DESC_LANGUAGE, EXP_SKILL_DESC_TRANS_TYPE, EXP_SKILL_ID) ) New insert statements ----------------------------------------- Check constraint CKC_EXP_SKILL_NAME_TR_EXPERTIS Table EXPERTISE_SKILLS_NAME What is wrong EXP_SKILL_NAME_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant New insert statements ----------------------------------------- Check constraint CKC_FACILITY_DESC_TRA_FACILITY Table FACILITY_DESCRIPTION What is wrong FACILITY_DESC_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table FACILITY_DESCRIPTION ( FACILITY_DESC_LANGUAGE CHAR(2) not null, FACILITY_DESC_TRANS_TYPE CHAR(1) not null constraint CKC_FACILITY_DESC_TRA_FACILITY check ( FACILITY_DESC_TRANS_TYPE in ('O','H','M')), FACILITY_ID CHAR(32) not null, FACILITY_DESCRIPTION VARCHAR2(1024) null , constraint PK_FACILITY_DESCRIPTION primary key (FACILITY_DESC_LANGUAGE, FACILITY_DESC_TRANS_TYPE, FACILITY_ID) ) New insert statements ----------------------------------------- Check constraint CKC_FACILITY_TRANS_TY_FACILITY Table FACILITY_NAME What is wrong FACILITY_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table FACILITY_NAME ( FACILITY_LANGUAGE CHAR(2) not null, FACILITY_TRANS_TYPE CHAR(1) not null constraint CKC_FACILITY_TRANS_TY_FACILITY check ( FACILITY_TRANS_TYPE in ('O','H','M')), FACILITY_ID CHAR(32) not null, FACILITY_NAME VARCHAR2(512) null , constraint PK_FACILITY_NAME primary key (FACILITY_LANGUAGE, FACILITY_TRANS_TYPE, FACILITY_ID) ) New insert statements ----------------------------------------- Check constraint CKC_ORG_FUND_ROLE_FUNDING_ Table FUNDING_ORG What is wrong One of the allowed values is "Coordiantor". Must be "Coordinator" New table creation statemant create table FUNDING_ORG ( FUNDING_ID CHAR(32) not null, ORGUNITID CHAR(32) not null, ORG_FUND_ROLE VARCHAR2(16) null constraint CKC_ORG_FUND_ROLE_FUNDING_ check (ORG_FUND_ROLE is null or (ORG_FUND_ROLE in ('Manager','Coordinator'))), ORG_FUND_START DATE null , ORG_FUND_END DATE null , constraint PK_FUNDING_ORG primary key (FUNDING_ID, ORGUNITID) ) New insert statements ----------------------------------------- Check constraint CKC_FUNDING_DESC_TRAN_FUNDING_ Table FUNDING_PROGRAMME_DESCRIPTION What is wrong FUNDING_DESC_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table FUNDING_PROGRAMME_DESCRIPTION ( FUNDING_DESC_LANGUAGE CHAR(2) not null, FUNDING_DESC_TRANS_TYPE CHAR(1) not null constraint CKC_FUNDING_DESC_TRAN_FUNDING_ check ( FUNDING_DESC_TRANS_TYPE in ('O','H','M')), FUNDING_ID CHAR(32) not null, FUNDING_DESCRIPTION VARCHAR2(1024) null , constraint PK_FUNDING_PROGRAMME_DESCRIPTI primary key (FUNDING_DESC_LANGUAGE, FUNDING_DESC_TRANS_TYPE, FUNDING_ID) ) New insert statements ----------------------------------------- Check constraint CKC_FUNDING_TRANS_TYP_FUNDING_ Table FUNDING_PROGRAMME_NAME What is wrong FUNDING_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table FUNDING_PROGRAMME_NAME ( FUNDING_LANGUAGE CHAR(2) not null, FUNDING_TRANS_TYPE CHAR(1) not null constraint CKC_FUNDING_TRANS_TYP_FUNDING_ check ( FUNDING_TRANS_TYPE in ('O','H','M')), FUNDING_ID CHAR(32) not null, FUNDING_NAME VARCHAR2(512) null , constraint PK_FUNDING_PROGRAMME_NAME primary key (FUNDING_LANGUAGE, FUNDING_TRANS_TYPE, FUNDING_ID) ) New insert statements ----------------------------------------- Check constraint CKC_ORG_PROD_ROLE_ORGUNIT_ Table ORGUNIT_PRODUCT What is wrong CKC_ORG_PROD_ROLE_ORGUNIT_ has type varchar2(16) while allowed values are longer New table creation statemant -- datatype changed on varchar2(64) create table ORGUNIT_PRODUCT ( ORGUNITID CHAR(32) not null, PROD_ID CHAR(32) not null, ORG_PROD_ROLE VARCHAR2(64) null constraint CKC_ORG_PROD_ROLE_ORGUNIT_ check (ORG_PROD_ROLE is null or (ORG_PROD_ROLE in ('after sales service','exclusive ownership','franchise','free licensing','distribution','division application markets','joint ownership','license','manufacturer', 'marketing','ownership','purchase','sales','sublicense','territorial ownership', 'value added retailer','- other -'))), ORG_PROD_IPR VARCHAR2(32) null , ORG_PROD_CONDITIONS VARCHAR2(1024) null , ORG_PROD_PRICE NUMBER(12,2) null , ORG_PROD_CURRENCY CHAR(3) null , ORG_PROD_AVAILABILITY VARCHAR2(64) null , ORG_PROD_START DATE null , ORG_PROD_END DATE null , constraint PK_ORGUNIT_PRODUCT primary key (ORGUNITID, PROD_ID) ) -- also table ORG_PROD_ROLE changed due to referential integrity -- it seems wrong that ORG_PROD_ROLE_FULL has a more limited number of values then ORG_PROD_ROLE -- check constrained was changed on ORG_PROD_ROLE like constraint New insert statements ----------------------------------------- Check constraint CKC_ORGUNIT_TRANS_TYP_ORGUNIT_ Table ORGUNIT_TRANSLATION What is wrong CKC_ORGUNIT_TRANS_TYP_ORGUNIT_ has type char(1) while allowed values are longer New table creation statemant create table ORGUNIT_TRANSLATION ( ORG_LANGUAGE CHAR(2) not null, ORGUNIT_TRANS_TYPE CHAR(1) not null constraint CKC_ORGUNIT_TRANS_TYP_ORGUNIT_ check ( ORGUNIT_TRANS_TYPE in ('O','H','M')), ORGUNITID CHAR(32) not null, ORGUNIT_NAME VARCHAR2(512) null , constraint PK_ORGUNIT_TRANSLATION primary key (ORG_LANGUAGE, ORGUNIT_TRANS_TYPE, ORGUNITID) ) New insert statements ----------------------------------------- Check constraint CKC_EQUIP_ID_ORG_EQUI Table ORG_EQUIPMENT What is wrong Onlu two equipment allowed New table creation statemant create table ORG_EQUIPMENT ( EQUIP_ID CHAR(32) not null, ORGUNITID CHAR(32) not null, ORG_EQUIP_ROLE VARCHAR2(16) null constraint CKC_ORG_EQUIP_ROLE_ORG_EQUI check (ORG_EQUIP_ROLE is null or (ORG_EQUIP_ROLE in ('own','manage'))), ORG_EQUIP_CONDITIONS VARCHAR2(1024) null , ORG_EQUIP_PRICE NUMBER(12,2) null , ORG_EQUIP_CURRENCY CHAR(3) null , ORG_EQUIP_AVAILABILITY VARCHAR2(64) null , ORG_EQUIP_START DATE null , ORG_EQUIP_END DATE null , constraint PK_ORG_EQUIPMENT primary key (EQUIP_ID, ORGUNITID) ) New insert statements ----------------------------------------- Check constraint CKC_ORG_ORG_ROLE_ORG_ORG Table ORG_ORG What is wrong ORG_ORG_ROLE has type char(16) while allowed values are longer New table creation statemant -- changed the length of the column create table ORG_ORG ( ORGUNITID CHAR(32) not null, ORG_ORGUNITID CHAR(32) not null, ORG_ORG_ROLE VARCHAR2(64) null constraint CKC_ORG_ORG_ROLE_ORG_ORG check (ORG_ORG_ROLE is null or (ORG_ORG_ROLE in ('head office','distribution office','personnel office','procurement office','finance office','manufacturer','manufacturing plant','sales/marketing','R&D Facilities','supplier', '- other -'))), constraint PK_ORG_ORG primary key (ORGUNITID, ORG_ORGUNITID) ) New insert statements ----------------------------------------- Check constraint CKC_ORG_PUB_ROLE_ORG_PUB Table ORG_PUB What is wrong One of the value of ORG_PUB_ROLE is incorrect It is "Distrinutor" instead of "Distributor" New table creation statemant create table ORG_PUB ( ORGUNITID CHAR(32) not null, PUB_ID CHAR(32) not null, ORG_PUB_ROLE VARCHAR2(16) null constraint CKC_ORG_PUB_ROLE_ORG_PUB check (ORG_PUB_ROLE is null or (ORG_PUB_ROLE in ('Publisher','Distrinutor'))), ORG_PUB_COPYRIGHT VARCHAR2(32) not null, constraint PK_ORG_PUB primary key (ORGUNITID, PUB_ID) ) New insert statements ----------------------------------------- Check constraint CKC_ORG_RESEARCH_TRAN_ORG_RESE Table ORG_RESERACH_INTEREST What is wrong ORG_RESEARCH_TRANS has type char(1) while allowed values are longer New table creation statemant create table ORG_RESERACH_INTEREST ( ORGUNITID CHAR(32) not null, ORG_RESEARCH_LANG CHAR(2) not null, ORG_RESEARCH_TRANS CHAR(1) not null constraint CKC_ORG_RESEARCH_TRAN_ORG_RESE check ( ORG_RESEARCH_TRANS in ('O','H','M')), KEYWORDS VARCHAR2(1024) null , constraint PK_ORG_RESERACH_INTEREST primary key (ORGUNITID, ORG_RESEARCH_LANG, ORG_RESEARCH_TRANS) ) New insert statements ----------------------------------------- Check constraint CKC_PATENT_ABS_TRANS__PATENT_A Table PATENT_ABSTRACT What is wrong PATENT_ABS_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PATENT_ABSTRACT ( PATENT_ABS_LANGUAGE CHAR(2) not null, PATENT_ABS_TRANS_TYPE CHAR(1) not null constraint CKC_PATENT_ABS_TRANS__PATENT_A check ( PATENT_ABS_TRANS_TYPE in ('O','H','M')), PATENT_ID CHAR(32) not null, PATENT_ABSTRACT VARCHAR2(1024) null , constraint PK_PATENT_ABSTRACT primary key (PATENT_ABS_LANGUAGE, PATENT_ABS_TRANS_TYPE, PATENT_ID) ) New insert statements ----------------------------------------- Check constraint CKC_PATENT_TITLE_TRAN_PATENT_T Table PATENT_TITLE What is wrong PATENT_TITLE_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PATENT_TITLE ( PATENT_TITLE_LANGUAGE CHAR(2) not null, PATENT_TITLE_TRANS_TYPE CHAR(1) not null constraint CKC_PATENT_TITLE_TRAN_PATENT_T check ( PATENT_TITLE_TRANS_TYPE in ('O','H','M')), PATENT_ID CHAR(32) not null, PATENT_TITLE VARCHAR2(1024) null , constraint PK_PATENT_TITLE primary key (PATENT_TITLE_LANGUAGE, PATENT_TITLE_TRANS_TYPE, PATENT_ID) ) New insert statements ----------------------------------------- Check constraint CKC_PERS_RES_INT_TRAN_PERSON_R Table PERSON_RESEARCH_INTEREST What is wrong PERS_RES_INT_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PERSON_RESEARCH_INTEREST ( PERS_RES_INT_LANGUAGE CHAR(2) not null, PERS_RES_INT_TRANS_TYPE CHAR(1) not null constraint CKC_PERS_RES_INT_TRAN_PERSON_R check ( PERS_RES_INT_TRANS_TYPE in ('O','H','M')), PER_ID CHAR(32) not null, PERS_RES_INT_KEYWORDS VARCHAR2(1024) null , constraint PK_PERSON_RESEARCH_INTEREST primary key (PERS_RES_INT_LANGUAGE, PERS_RES_INT_TRANS_TYPE, PER_ID) ) New insert statements ----------------------------------------- Check constraint CKC_EQUIP_ID_PERS_EQU Table PERS_EQUIP What is wrong This constraint allows to have only two equipments in database New table creation statemant create table PERS_EQUIP ( PER_ID CHAR(32) not null, EQUIP_ID CHAR(32) not null, PER_EQUIP_ROLE VARCHAR2(16) null , PER_EQUIP_CONDITIONS VARCHAR2(1024) null , PER_EQUIP_PRICE NUMBER(12,2) null , PER_EQUIP_CURRENCY CHAR(3) null , PER_EQUIP_AVAILABILITY VARCHAR2(64) null , PER_EQUIP_START DATE null , PER_EQUIP_END DATE null , constraint PK_PERS_EQUIP primary key (PER_ID, EQUIP_ID) ) New insert statements ----------------------------------------- Check constraint CKC_PROD_DESC_TRANS_T_PRODUCT_ Table PRODUCT_DESCRIPTION What is wrong PROD_DESC_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PRODUCT_DESCRIPTION ( PROD_DESC_LANGUAGE CHAR(2) not null, PROD_DESC_TRANS_TYPE CHAR(1) not null constraint CKC_PROD_DESC_TRANS_T_PRODUCT_ check ( PROD_DESC_TRANS_TYPE in ('O','H','M')), PROD_ID CHAR(32) not null, PROD_DESCRIPTION VARCHAR2(1024) null , constraint PK_PRODUCT_DESCRIPTION primary key (PROD_DESC_LANGUAGE, PROD_DESC_TRANS_TYPE, PROD_ID) ) New insert statements ----------------------------------------- Check constraint CKC_PROD_NAME_TRANS_T_PRODUCT_ Table PRODUCT_NAME What is wrong PROD_NAME_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PRODUCT_NAME ( PROD_NAME_LANGUAGE CHAR(2) not null, PROD_NAME_TRANS_TYPE CHAR(1) not null constraint CKC_PROD_NAME_TRANS_T_PRODUCT_ check ( PROD_NAME_TRANS_TYPE in ('O','H','M')), PROD_ID CHAR(32) not null, PROD_NAME VARCHAR2(512) null , constraint PK_PRODUCT_NAME primary key (PROD_NAME_LANGUAGE, PROD_NAME_TRANS_TYPE, PROD_ID) ) New insert statements ----------------------------------------- Check constraint CKC_PROJ_STATUS_PROJECT Table PROJECT What is wrong CKC_PROJ_STATUS_PROJECT has type varchar2(8) while allowed values are longer New table creation statemant create table PROJECT ( PROJ_ID CHAR(32) not null, PROJ_STATUS VARCHAR2(8) not null constraint CKC_PROJ_STATUS_PROJECT check (PROJ_STATUS in ('Proposed','Accepted','Execution','Stalled','Completed')), PROJ_START_DATE DATE null , PROJ_END_DATE DATE null , PROJ_PRIZE_AWARD VARCHAR(64) null , PROJ_URL VARCHAR2(512) null , constraint PK_PROJECT primary key (PROJ_ID) ) --- also project_status table changed create table PROJECT_STATUS ( PROJ_STATUS VARCHAR2(16) not null, PROJ_STATUS_NAME VARCHAR2(32) not null, constraint PK_PROJECT_STATUS primary key (PROJ_STATUS) ) New insert statements ----------------------------------------- Check constraint CKC_PROJ_ABS_TRANS_TY_PROJECT_ Table PROJECT_ABSTRACT What is wrong PROJ_ABS_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PROJECT_ABSTRACT ( PROJ_ABS_LANGUAGE CHAR(2) not null, PROJ_ABS_TRANS_TYPE CHAR(1) not null constraint CKC_PROJ_ABS_TRANS_TY_PROJECT_ check ( PROJ_ABS_TRANS_TYPE in ('O','H','M')), PROJ_ID CHAR(32) not null, PROJ_ABSTRACT VARCHAR2(1024) null , constraint PK_PROJECT_ABSTRACT primary key (PROJ_ABS_LANGUAGE, PROJ_ABS_TRANS_TYPE, PROJ_ID) ) New insert statements ----------------------------------------- Check constraint CKC_PROJ_KEYW_TRANS_T_PROJECT_ Table PROJECT_KEYWORDS What is wrong PROJ_KEYW_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PROJECT_KEYWORDS ( PROJ_KEYW_LANGUAGE CHAR(2) not null, PROJ_KEYW_TRANS_TYPE CHAR(1) not null constraint CKC_PROJ_KEYW_TRANS_T_PROJECT_ check ( PROJ_KEYW_TRANS_TYPE in ('O','H','M')), PROJ_ID CHAR(32) not null, PROJ_KEYWORDS VARCHAR2(1024) null , constraint PK_PROJECT_KEYWORDS primary key (PROJ_KEYW_LANGUAGE, PROJ_KEYW_TRANS_TYPE, PROJ_ID) ) New insert statements ----------------------------------------- Check constraint CKC_PROJ_TITLE_TRANS__PROJECT_ Table PROJECT_TITLE What is wrong PROJ_TITLE_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PROJECT_TITLE ( PROJ_TITLE_LANGUAGE CHAR(2) not null, PROJ_TITLE_TRANS_TYPE CHAR(1) not null constraint CKC_PROJ_TITLE_TRANS__PROJECT_ check ( PROJ_TITLE_TRANS_TYPE in ('O','H','M')), PROJ_ID CHAR(32) not null, PROJ_TITLE VARCHAR2(1024) null , constraint PK_PROJECT_TITLE primary key (PROJ_TITLE_LANGUAGE, PROJ_TITLE_TRANS_TYPE, PROJ_ID) ) New insert statements ----------------------------------------- Check constraint CKC_EQUIP_ID_PROJ_EQU Table PROJ_EQUIPMENT What is wrong This constraint allows to have only 2 equipments in database New table creation statemant create table PROJ_EQUIPMENT ( EQUIP_ID CHAR(32) not null, PROJ_ID CHAR(32) not null, PROJ_EQUIP_ROLE VARCHAR2(16) null constraint CKC_PROJ_EQUIP_ROLE_PROJ_EQU check (PROJ_EQUIP_ROLE is null or (PROJ_EQUIP_ROLE in ('User','Purchaser'))), PROJ_EQUIP_CONDITIONS VARCHAR2(1032) null , PROJ_EQUP_PRICE NUMBER(12,2) null , PROJ_EQUIP_CURRENCY CHAR(3) null , PROJ_EQUIP__AVAILABILITY VARCHAR2(64) null , PROJ_EQUIP_START DATE null , PROJ_EQUIP_END DATE null , constraint PK_PROJ_EQUIPMENT primary key (EQUIP_ID, PROJ_ID) ) New insert statements ----------------------------------------- Check constraint CKC_PUB_TRANS_TYPE_PUBLICAT Table PUBLICATION_TRANSLATION What is wrong PUB_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant create table PUBLICATION_TRANSLATION ( PUB_LANGUAGE CHAR(2) not null, PUB_TRANS_TYPE CHAR(1) not null constraint CKC_PUB_TRANS_TYPE_PUBLICAT check (PUB_TRANS_TYPE in ('O','H','M')), PUB_ID CHAR(32) not null, PUB_TITLE VARCHAR2(1024) null , constraint PK_PUBLICATION_TRANSLATION primary key (PUB_LANGUAGE, PUB_TRANS_TYPE, PUB_ID) ) New insert statements ----------------------------------------- Check constraint CKC_RES_ACT_TRANSLATI_RESEARCH Table RESEARCH_ACTIVITY What is wrong RES_ACT_TRANSLATION has type char(1) while allowed values are longer New table creation statemant create table RESEARCH_ACTIVITY ( RES_ACT_LANGUAGE CHAR(2) not null, RES_ACT_TRANSLATION CHAR(1) not null constraint CKC_RES_ACT_TRANSLATI_RESEARCH check ( RES_ACT_TRANSLATION in ('O','H','M')), ORGUNITID CHAR(32) not null, RES_ACT_KEYWORDS VARCHAR2(1024) null , constraint PK_RESEARCH_ACTIVITY primary key (RES_ACT_LANGUAGE, RES_ACT_TRANSLATION, ORGUNITID) ) New insert statements ----------------------------------------- Check constraint CKC_SERV_TR_TYP_SRV_D Table SERVICE_DESCRIPTION What is wrong SERVICE_TRANS_TYPE2 has type char(1) while allowed values are longer New table creation statemant create table SERVICE_DESCRIPTION ( SERVICE_DERSC_LANGUAGE CHAR(2) not null, SERVICE_TRANS_TYPE2 CHAR(1) not null constraint CKC_SERV_TR_TYP_SRV_D check ( SERVICE_TRANS_TYPE2 in ('O','H','M')), SERVICE_ID CHAR(32) not null, SERVICE_DESCRIPTION VARCHAR2(1024) null , constraint PK_SERVICE_DESCRIPTION primary key (SERVICE_DERSC_LANGUAGE, SERVICE_TRANS_TYPE2, SERVICE_ID) ) New insert statements ----------------------------------------- Check constraint CKC_SERVICE_TRANS_TYP_SERVICE_ Table SERVICE_NAME What is wrong SERVICE_TRANS_TYPE has type char(1) while allowed values are longer New table creation statemant New insert statements