<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE database SYSTEM "database.dtd">
<!--  Auto-generated by the Maven Impex Plugin -->
<database defaultJavaNamingMethod="nochange" name="rice-impex-client-demo">
    <table name="BK_ADDRESS_T">
        <column name="ADDRESS_ID" primaryKey="true" size="22" type="DECIMAL"/>
        <column name="AUTHOR_ID" size="22" type="DECIMAL"/>
        <column name="ADDR_TYP" size="40" type="VARCHAR"/>
        <column name="STREET1" size="50" type="VARCHAR"/>
        <column name="STREET2" size="50" type="VARCHAR"/>
        <column name="CITY" size="50" type="VARCHAR"/>
        <column name="PROVIENCE" size="50" type="VARCHAR"/>
        <column name="COUNTRY" size="50" type="VARCHAR"/>
        <column default="Y" name="ACTV_IND" size="1" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
    </table>
    <table name="BK_ADDRESS_TYP_T">
        <column name="ADDR_TYP" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="DESC_TXT" size="255" type="VARCHAR"/>
        <column default="Y" name="ACTV_IND" size="1" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
    </table>
    <table name="BK_AUTHOR_ACCOUNT_T">
        <column name="AUTHOR_ID" primaryKey="true" size="22" type="DECIMAL"/>
        <column name="ACCOUNT_NUMBER" size="50" type="VARCHAR"/>
        <column name="BANK_NAME" size="100" type="VARCHAR"/>
    </table>
    <table name="BK_AUTHOR_T">
        <column name="AUTHOR_ID" primaryKey="true" size="22" type="DECIMAL"/>
        <column name="NM" size="100" type="VARCHAR"/>
        <column name="ADDRESS" size="200" type="VARCHAR"/>
        <column name="EMAIL" size="50" type="VARCHAR"/>
        <column name="PHONE_NBR" size="20" type="VARCHAR"/>
        <column default="Y" name="ACTV_IND" size="1" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
    </table>
    <table name="BK_BOOK_AUTHOR_T">
        <column name="BOOK_ID" primaryKey="true" size="22" type="DECIMAL"/>
        <column name="AUTHOR_ID" primaryKey="true" size="22" type="DECIMAL"/>
    </table>
    <table name="BK_BOOK_T">
        <column name="BOOK_ID" primaryKey="true" size="22" type="DECIMAL"/>
        <column name="TITLE" size="100" type="VARCHAR"/>
        <column name="AUTHOR" size="100" type="VARCHAR"/>
        <column name="TYP_CD" size="40" type="VARCHAR"/>
        <column name="ISBN" size="17" type="VARCHAR"/>
        <column name="PUBLISHER" size="100" type="VARCHAR"/>
        <column name="PUB_DATE" type="DATE"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="PRICE" scale="2" size="15" type="DECIMAL"/>
        <column name="RATING" size="22" type="DECIMAL"/>
    </table>
    <table name="BK_BOOK_TYP_T">
        <column name="TYP_CD" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="NM" size="100" type="VARCHAR"/>
        <column name="DESC_TXT" size="255" type="VARCHAR"/>
        <column default="Y" name="ACTV_IND" size="1" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
    </table>
    <table name="BK_ORDER_DOC_T">
        <column name="DOC_HDR_ID" primaryKey="true" size="22" type="DECIMAL"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
    </table>
    <table name="BK_ORDER_ENTRY_T">
        <column name="BK_ORDER_ENTRY_ID" primaryKey="true" size="22" type="DECIMAL"/>
        <column name="DOC_HDR_ID" required="true" size="14" type="VARCHAR"/>
        <column name="BOOK_ID" required="true" size="22" type="DECIMAL"/>
        <column name="QUANTITY" required="true" size="22" type="DECIMAL"/>
        <column name="UNIT_PRICE" scale="2" size="15" type="DECIMAL"/>
        <column name="DISCOUNT" scale="2" size="5" type="DECIMAL"/>
        <column name="TOTAL_PRICE" scale="2" size="15" type="DECIMAL"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <foreign-key foreignTable="KRNS_DOC_HDR_T" name="BK_ORDER_ENTRY_T_KRNS_DO_ADV1">
            <reference foreign="DOC_HDR_ID" local="DOC_HDR_ID"/>
        </foreign-key>
        <foreign-key foreignTable="BK_BOOK_T" name="BK_ORDER_ENTRY_T_BK_BOOK_T">
            <reference foreign="BOOK_ID" local="BOOK_ID"/>
        </foreign-key>
    </table>
    <table name="KRAD_MSG_T">
        <column name="NMSPC_CD" primaryKey="true" size="20" type="VARCHAR"/>
        <column name="CMPNT_CD" primaryKey="true" size="100" type="VARCHAR"/>
        <column name="MSG_KEY" primaryKey="true" size="100" type="VARCHAR"/>
        <column name="LOC" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="MSG_DESC" size="255" type="VARCHAR"/>
        <column name="TXT" size="4000" type="VARCHAR"/>
        <unique name="KRAD_MSG_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="KRNS_ADHOC_RTE_ACTN_RECIP_T">
        <column name="RECIP_TYP_CD" primaryKey="true" size="1" type="DECIMAL"/>
        <column name="ACTN_RQST_CD" primaryKey="true" size="30" type="VARCHAR"/>
        <column name="ACTN_RQST_RECIP_ID" primaryKey="true" size="70" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="DOC_HDR_ID" primaryKey="true" size="14" type="VARCHAR"/>
        <unique name="KRNS_ADHOC_RTE_ACTN_RECIP_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
        <index name="KRNS_ADHOC_RTE_ACTN_RECIP_T2">
            <index-column name="DOC_HDR_ID"/>
        </index>
    </table>
    <table name="KRNS_ATT_CNTNT_T">
        <column name="ATT_ID" size="36" type="VARCHAR"/>
        <column name="ATT_CNTNT" type="BLOB"/>
    </table>
    <table name="KRNS_ATT_T">
        <column name="NTE_ID" primaryKey="true" size="14" type="DECIMAL"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="MIME_TYP" size="255" type="VARCHAR"/>
        <column name="FILE_NM" size="250" type="VARCHAR"/>
        <column name="ATT_ID" size="36" type="VARCHAR"/>
        <column name="FILE_SZ" size="14" type="DECIMAL"/>
        <column name="ATT_TYP_CD" size="40" type="VARCHAR"/>
        <foreign-key foreignTable="KRNS_NTE_T" name="KRNS_ATT_TR1">
            <reference foreign="NTE_ID" local="NTE_ID"/>
        </foreign-key>
        <unique name="KRNS_ATT_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="KRNS_DOC_HDR_T">
        <column name="DOC_HDR_ID" primaryKey="true" size="14" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="FDOC_DESC" size="255" type="VARCHAR"/>
        <column name="ORG_DOC_HDR_ID" size="10" type="VARCHAR"/>
        <column name="TMPL_DOC_HDR_ID" size="14" type="VARCHAR"/>
        <column name="EXPLANATION" size="400" type="VARCHAR"/>
        <unique name="KRNS_DOC_HDR_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
        <index name="KRNS_DOC_HDR_TI3">
            <index-column name="ORG_DOC_HDR_ID"/>
        </index>
    </table>
    <table name="KRNS_LOOKUP_RSLT_T">
        <column name="LOOKUP_RSLT_ID" primaryKey="true" size="14" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="PRNCPL_ID" required="true" size="40" type="VARCHAR"/>
        <column name="LOOKUP_DT" required="true" type="DATE"/>
        <column name="SERIALZD_RSLTS" type="CLOB"/>
        <unique name="KRNS_LOOKUP_RSLT_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="KRNS_LOOKUP_SEL_T">
        <column name="LOOKUP_RSLT_ID" primaryKey="true" size="14" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="PRNCPL_ID" required="true" size="40" type="VARCHAR"/>
        <column name="LOOKUP_DT" required="true" type="DATE"/>
        <column name="SEL_OBJ_IDS" type="CLOB"/>
        <unique name="KRNS_LOOKUP_SEL_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="KRNS_MAINT_DOC_ATT_LST_T">
        <column name="ATT_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="DOC_HDR_ID" required="true" size="14" type="VARCHAR"/>
        <column name="ATT_CNTNT" required="true" type="BLOB"/>
        <column name="FILE_NM" size="150" type="VARCHAR"/>
        <column name="CNTNT_TYP" size="255" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="0" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <foreign-key foreignTable="KRNS_MAINT_DOC_T" name="KRNS_MAINT_DOC_ATT_LST_FK1">
            <reference foreign="DOC_HDR_ID" local="DOC_HDR_ID"/>
        </foreign-key>
        <unique name="KRNS_MAINT_DOC_ATT_LST_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
        <index name="KRNS_MAINT_DOC_ATT_LST_TI1">
            <index-column name="DOC_HDR_ID"/>
        </index>
    </table>
    <table name="KRNS_MAINT_DOC_ATT_T">
        <column name="DOC_HDR_ID" primaryKey="true" size="14" type="VARCHAR"/>
        <column name="ATT_CNTNT" required="true" type="BLOB"/>
        <column name="FILE_NM" size="150" type="VARCHAR"/>
        <column name="CNTNT_TYP" size="255" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <unique name="KRNS_MAINT_DOC_ATT_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="KRNS_MAINT_DOC_T">
        <column name="DOC_HDR_ID" primaryKey="true" size="14" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="DOC_CNTNT" type="CLOB"/>
        <foreign-key foreignTable="KRNS_DOC_HDR_T" name="KRNS_MAINT_DOC_TR1">
            <reference foreign="DOC_HDR_ID" local="DOC_HDR_ID"/>
        </foreign-key>
        <unique name="KRNS_MAINT_DOC_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="KRNS_MAINT_LOCK_T">
        <column name="MAINT_LOCK_REP_TXT" size="500" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="DOC_HDR_ID" required="true" size="14" type="VARCHAR"/>
        <column name="MAINT_LOCK_ID" primaryKey="true" size="14" type="VARCHAR"/>
        <unique name="KRNS_MAINT_LOCK_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
        <index name="KRNS_MAINT_LOCK_TI2">
            <index-column name="DOC_HDR_ID"/>
        </index>
    </table>
    <table name="KRNS_NTE_T">
        <column name="NTE_ID" primaryKey="true" size="14" type="DECIMAL"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="RMT_OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column name="AUTH_PRNCPL_ID" required="true" size="40" type="VARCHAR"/>
        <column name="POST_TS" required="true" type="DATE"/>
        <column name="NTE_TYP_CD" required="true" size="4" type="VARCHAR"/>
        <column name="TXT" size="800" type="VARCHAR"/>
        <column name="PRG_CD" size="1" type="VARCHAR"/>
        <column name="TPC_TXT" size="40" type="VARCHAR"/>
        <foreign-key foreignTable="KRNS_NTE_TYP_T" name="KRNS_NTE_TR1">
            <reference foreign="NTE_TYP_CD" local="NTE_TYP_CD"/>
        </foreign-key>
        <unique name="KRNS_NTE_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
        <index name="KRNS_NTE_TI1">
            <index-column name="RMT_OBJ_ID"/>
        </index>
    </table>
    <table name="KRNS_NTE_TYP_T">
        <column name="NTE_TYP_CD" primaryKey="true" size="4" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="TYP_DESC_TXT" size="100" type="VARCHAR"/>
        <column name="ACTV_IND" size="1" type="VARCHAR"/>
        <unique name="KRNS_NTE_TYP_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="KRNS_PESSIMISTIC_LOCK_T">
        <column name="PESSIMISTIC_LOCK_ID" primaryKey="true" size="14" type="DECIMAL"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="LOCK_DESC_TXT" size="4000" type="VARCHAR"/>
        <column name="DOC_HDR_ID" required="true" size="14" type="VARCHAR"/>
        <column name="GNRT_DT" required="true" type="DATE"/>
        <column name="PRNCPL_ID" required="true" size="40" type="VARCHAR"/>
        <column default="undefined" name="SESN_ID" required="true"
            size="40" type="VARCHAR"/>
        <unique name="KRNS_PESSIMISTIC_LOCK_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
        <index name="KRNS_PESSIMISTIC_LOCK_TI1">
            <index-column name="DOC_HDR_ID"/>
        </index>
        <index name="KRNS_PESSIMISTIC_LOCK_TI2">
            <index-column name="PRNCPL_ID"/>
        </index>
    </table>
    <table name="KRNS_SESN_DOC_T">
        <column name="SESN_DOC_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="DOC_HDR_ID" primaryKey="true" size="14" type="VARCHAR"/>
        <column name="PRNCPL_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="IP_ADDR" primaryKey="true" size="60" type="VARCHAR"/>
        <column name="SERIALZD_DOC_FRM" type="BLOB"/>
        <column name="LAST_UPDT_DT" type="DATE"/>
        <column default="N" name="CONTENT_ENCRYPTED_IND" size="1" type="CHAR"/>
        <column name="OBJ_ID" size="36" type="VARCHAR"/>
        <column default="0" name="VER_NBR" size="8" type="DECIMAL"/>
        <index name="KRNS_SESN_DOC_TI1">
            <index-column name="LAST_UPDT_DT"/>
        </index>
    </table>
    <table name="KRSB_BAM_PARM_T">
        <column name="BAM_PARM_ID" primaryKey="true" size="14" type="DECIMAL"/>
        <column name="BAM_ID" required="true" size="14" type="DECIMAL"/>
        <column name="PARM" required="true" type="CLOB"/>
        <index name="KREW_BAM_PARM_TI1">
            <index-column name="BAM_ID"/>
        </index>
    </table>
    <table name="KRSB_BAM_T">
        <column name="BAM_ID" primaryKey="true" size="14" type="DECIMAL"/>
        <column name="SVC_NM" required="true" size="255" type="VARCHAR"/>
        <column name="SVC_URL" required="true" size="500" type="VARCHAR"/>
        <column name="MTHD_NM" required="true" size="2000" type="VARCHAR"/>
        <column name="THRD_NM" required="true" size="500" type="VARCHAR"/>
        <column name="CALL_DT" required="true" type="DATE"/>
        <column name="TGT_TO_STR" required="true" size="2000" type="VARCHAR"/>
        <column name="SRVR_IND" required="true" size="1" type="DECIMAL"/>
        <column name="EXCPN_TO_STR" size="2000" type="VARCHAR"/>
        <column name="EXCPN_MSG" type="CLOB"/>
        <index name="KRSB_BAM_TI1">
            <index-column name="SVC_NM"/>
            <index-column name="MTHD_NM"/>
        </index>
        <index name="KRSB_BAM_TI2">
            <index-column name="SVC_NM"/>
        </index>
    </table>
    <table name="KRSB_MSG_PYLD_T">
        <column name="MSG_QUE_ID" primaryKey="true" size="14" type="DECIMAL"/>
        <column name="MSG_PYLD" required="true" type="CLOB"/>
    </table>
    <table name="KRSB_MSG_QUE_T">
        <column name="MSG_QUE_ID" primaryKey="true" size="14" type="DECIMAL"/>
        <column name="DT" required="true" type="DATE"/>
        <column name="EXP_DT" type="DATE"/>
        <column name="PRIO" required="true" size="8" type="DECIMAL"/>
        <column name="STAT_CD" required="true" size="1" type="CHAR"/>
        <column name="RTRY_CNT" required="true" size="8" type="DECIMAL"/>
        <column name="IP_NBR" required="true" size="2000" type="VARCHAR"/>
        <column name="SVC_NM" size="255" type="VARCHAR"/>
        <column name="APPL_ID" required="true" size="255" type="VARCHAR"/>
        <column name="SVC_MTHD_NM" size="2000" type="VARCHAR"/>
        <column name="APP_VAL_ONE" size="2000" type="VARCHAR"/>
        <column name="APP_VAL_TWO" size="2000" type="VARCHAR"/>
        <column default="0" name="VER_NBR" size="8" type="DECIMAL"/>
        <index name="KRSB_MSG_QUE_TI1">
            <index-column name="SVC_NM"/>
            <index-column name="SVC_MTHD_NM"/>
        </index>
        <index name="KRSB_MSG_QUE_TI2">
            <index-column name="APPL_ID"/>
            <index-column name="STAT_CD"/>
            <index-column name="IP_NBR"/>
            <index-column name="DT"/>
        </index>
    </table>
    <table name="KRSB_QRTZ_BLOB_TRIGGERS">
        <column name="TRIGGER_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="TRIGGER_GROUP" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="BLOB_DATA" type="BLOB"/>
        <foreign-key foreignTable="KRSB_QRTZ_TRIGGERS" name="KRSB_QRTZ_BLOB_TRIGGERS_TR1">
            <reference foreign="TRIGGER_NAME" local="TRIGGER_NAME"/>
            <reference foreign="TRIGGER_GROUP" local="TRIGGER_GROUP"/>
        </foreign-key>
    </table>
    <table name="KRSB_QRTZ_CALENDARS">
        <column name="CALENDAR_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="CALENDAR" required="true" type="BLOB"/>
    </table>
    <table name="KRSB_QRTZ_CRON_TRIGGERS">
        <column name="TRIGGER_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="TRIGGER_GROUP" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="CRON_EXPRESSION" required="true" size="80" type="VARCHAR"/>
        <column name="TIME_ZONE_ID" size="80" type="VARCHAR"/>
        <foreign-key foreignTable="KRSB_QRTZ_TRIGGERS" name="KRSB_QRTZ_CRON_TRIGGERS_TR1">
            <reference foreign="TRIGGER_NAME" local="TRIGGER_NAME"/>
            <reference foreign="TRIGGER_GROUP" local="TRIGGER_GROUP"/>
        </foreign-key>
    </table>
    <table name="KRSB_QRTZ_FIRED_TRIGGERS">
        <column name="ENTRY_ID" primaryKey="true" size="95" type="VARCHAR"/>
        <column name="TRIGGER_NAME" required="true" size="80" type="VARCHAR"/>
        <column name="TRIGGER_GROUP" required="true" size="80" type="VARCHAR"/>
        <column name="IS_VOLATILE" required="true" size="1" type="VARCHAR"/>
        <column name="INSTANCE_NAME" required="true" size="80" type="VARCHAR"/>
        <column name="FIRED_TIME" required="true" size="13" type="DECIMAL"/>
        <column name="PRIORITY" required="true" size="13" type="DECIMAL"/>
        <column name="STATE" required="true" size="16" type="VARCHAR"/>
        <column name="JOB_NAME" size="80" type="VARCHAR"/>
        <column name="JOB_GROUP" size="80" type="VARCHAR"/>
        <column name="IS_STATEFUL" size="1" type="VARCHAR"/>
        <column name="REQUESTS_RECOVERY" size="1" type="VARCHAR"/>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI1">
            <index-column name="JOB_GROUP"/>
        </index>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI2">
            <index-column name="JOB_NAME"/>
        </index>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI3">
            <index-column name="REQUESTS_RECOVERY"/>
        </index>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI4">
            <index-column name="IS_STATEFUL"/>
        </index>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI5">
            <index-column name="TRIGGER_GROUP"/>
        </index>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI6">
            <index-column name="INSTANCE_NAME"/>
        </index>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI7">
            <index-column name="TRIGGER_NAME"/>
        </index>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI8">
            <index-column name="TRIGGER_NAME"/>
            <index-column name="TRIGGER_GROUP"/>
        </index>
        <index name="KRSB_QRTZ_FIRED_TRIGGERS_TI9">
            <index-column name="IS_VOLATILE"/>
        </index>
    </table>
    <table name="KRSB_QRTZ_JOB_DETAILS">
        <column name="JOB_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="JOB_GROUP" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="DESCRIPTION" size="120" type="VARCHAR"/>
        <column name="JOB_CLASS_NAME" required="true" size="128" type="VARCHAR"/>
        <column name="IS_DURABLE" required="true" size="1" type="VARCHAR"/>
        <column name="IS_VOLATILE" required="true" size="1" type="VARCHAR"/>
        <column name="IS_STATEFUL" required="true" size="1" type="VARCHAR"/>
        <column name="REQUESTS_RECOVERY" required="true" size="1" type="VARCHAR"/>
        <column name="JOB_DATA" type="BLOB"/>
        <index name="KRSB_QRTZ_JOB_DETAILS_TI1">
            <index-column name="REQUESTS_RECOVERY"/>
        </index>
    </table>
    <table name="KRSB_QRTZ_JOB_LISTENERS">
        <column name="JOB_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="JOB_GROUP" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="JOB_LISTENER" primaryKey="true" size="80" type="VARCHAR"/>
        <foreign-key foreignTable="KRSB_QRTZ_JOB_DETAILS" name="KRSB_QUARTZ_JOB_LISTENERS_TR1">
            <reference foreign="JOB_NAME" local="JOB_NAME"/>
            <reference foreign="JOB_GROUP" local="JOB_GROUP"/>
        </foreign-key>
    </table>
    <table name="KRSB_QRTZ_LOCKS">
        <column name="LOCK_NAME" primaryKey="true" size="40" type="VARCHAR"/>
    </table>
    <table name="KRSB_QRTZ_PAUSED_TRIGGER_GRPS">
        <column name="TRIGGER_GROUP" primaryKey="true" size="80" type="VARCHAR"/>
    </table>
    <table name="KRSB_QRTZ_SCHEDULER_STATE">
        <column name="INSTANCE_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="LAST_CHECKIN_TIME" required="true" size="13" type="DECIMAL"/>
        <column name="CHECKIN_INTERVAL" required="true" size="13" type="DECIMAL"/>
    </table>
    <table name="KRSB_QRTZ_SIMPLE_TRIGGERS">
        <column name="TRIGGER_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="TRIGGER_GROUP" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="REPEAT_COUNT" required="true" size="7" type="DECIMAL"/>
        <column name="REPEAT_INTERVAL" required="true" size="12" type="DECIMAL"/>
        <column name="TIMES_TRIGGERED" required="true" size="7" type="DECIMAL"/>
        <foreign-key foreignTable="KRSB_QRTZ_TRIGGERS" name="KRSB_QRTZ_SIMPLE_TRIGGERS_TR1">
            <reference foreign="TRIGGER_NAME" local="TRIGGER_NAME"/>
            <reference foreign="TRIGGER_GROUP" local="TRIGGER_GROUP"/>
        </foreign-key>
    </table>
    <table name="KRSB_QRTZ_TRIGGERS">
        <column name="TRIGGER_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="TRIGGER_GROUP" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="JOB_NAME" required="true" size="80" type="VARCHAR"/>
        <column name="JOB_GROUP" required="true" size="80" type="VARCHAR"/>
        <column name="IS_VOLATILE" required="true" size="1" type="VARCHAR"/>
        <column name="DESCRIPTION" size="120" type="VARCHAR"/>
        <column name="NEXT_FIRE_TIME" size="13" type="DECIMAL"/>
        <column name="PREV_FIRE_TIME" size="13" type="DECIMAL"/>
        <column name="PRIORITY" size="13" type="DECIMAL"/>
        <column name="TRIGGER_STATE" required="true" size="16" type="VARCHAR"/>
        <column name="TRIGGER_TYPE" required="true" size="8" type="VARCHAR"/>
        <column name="START_TIME" required="true" size="13" type="DECIMAL"/>
        <column name="END_TIME" size="13" type="DECIMAL"/>
        <column name="CALENDAR_NAME" size="80" type="VARCHAR"/>
        <column name="MISFIRE_INSTR" size="2" type="DECIMAL"/>
        <column name="JOB_DATA" type="BLOB"/>
        <index name="KRSB_QRTZ_TRIGGERS_TI1">
            <index-column name="NEXT_FIRE_TIME"/>
        </index>
        <index name="KRSB_QRTZ_TRIGGERS_TI2">
            <index-column name="NEXT_FIRE_TIME"/>
            <index-column name="TRIGGER_STATE"/>
        </index>
        <index name="KRSB_QRTZ_TRIGGERS_TI3">
            <index-column name="TRIGGER_STATE"/>
        </index>
        <index name="KRSB_QRTZ_TRIGGERS_TI4">
            <index-column name="IS_VOLATILE"/>
        </index>
    </table>
    <table name="KRSB_QRTZ_TRIGGER_LISTENERS">
        <column name="TRIGGER_NAME" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="TRIGGER_GROUP" primaryKey="true" size="80" type="VARCHAR"/>
        <column name="TRIGGER_LISTENER" primaryKey="true" size="80" type="VARCHAR"/>
        <foreign-key foreignTable="KRSB_QRTZ_TRIGGERS" name="KRSB_QRTZ_TRIGGER_LISTENE_TR1">
            <reference foreign="TRIGGER_NAME" local="TRIGGER_NAME"/>
            <reference foreign="TRIGGER_GROUP" local="TRIGGER_GROUP"/>
        </foreign-key>
    </table>
    <table name="TRAV_DOC_2_ACCOUNTS">
        <column name="FDOC_NBR" primaryKey="true" size="14" type="VARCHAR"/>
        <column name="ACCT_NUM" primaryKey="true" size="10" type="VARCHAR"/>
    </table>
    <table name="TRVL_AUTH_DOC_T">
        <column name="TRVL_AUTH_DOC_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="TRAVELER_DTL_ID" size="40" type="VARCHAR"/>
        <column name="TRVL_TYP_CD" size="3" type="VARCHAR"/>
        <column name="TRVL_BGN_DT" type="DATE"/>
        <column name="TRVL_END_DT" type="DATE"/>
        <column name="TRVL_DEST_ID" size="40" type="VARCHAR"/>
        <column default="0.00" name="EXP_LMT" scale="2" size="19" type="DECIMAL"/>
        <column default="" name="TRVL_DESC" size="255" type="VARCHAR"/>
        <column name="CELL_PH_NUM" size="20" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <foreign-key foreignTable="TRVL_DEST_T" name="TRVL_AUTH_DOC_FK1">
            <reference foreign="TRVL_DEST_ID" local="TRVL_DEST_ID"/>
        </foreign-key>
        <unique name="TRVL_AUTH_DOC_TC1">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="TRVL_CO_T">
        <column name="CO_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="CO_NM" required="true" size="40" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column default="Y" name="ACTV_IND" required="true" size="1" type="VARCHAR"/>
        <unique name="TRVL_CO_TC1">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="TRVL_DEST_T">
        <column name="TRVL_DEST_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="DEST_NM" required="true" size="40" type="VARCHAR"/>
        <column name="POSTAL_CNTRY_CD" required="true" size="40" type="VARCHAR"/>
        <column name="POSTAL_STATE_CD" required="true" size="40" type="VARCHAR"/>
        <column default="Y" name="ACTV_IND" required="true" size="1" type="VARCHAR"/>
        <unique name="TRVL_DEST_TC1">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="TRVL_EXP_ITM_T">
        <column name="EXP_ITM_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="TRVL_AUTH_DOC_ID" required="true" size="40" type="VARCHAR"/>
        <column name="TRVL_CO_NM" required="true" size="40" type="VARCHAR"/>
        <column name="EXP_TYP_CD" required="true" size="40" type="VARCHAR"/>
        <column name="EXP_AMT" required="true" scale="2" size="19" type="DECIMAL"/>
        <column name="EXP_DESC" required="true" size="255" type="VARCHAR"/>
        <column name="EXP_DT" type="DATE"/>
        <column default="Y" name="EXP_REIMB" size="1" type="VARCHAR"/>
        <column default="Y" name="EXP_TXBL" size="1" type="VARCHAR"/>
        <foreign-key foreignTable="TRVL_AUTH_DOC_T" name="TRVL_EXP_ITEM_FK1">
            <reference foreign="TRVL_AUTH_DOC_ID" local="TRVL_AUTH_DOC_ID"/>
        </foreign-key>
        <unique name="TRVL_EXP_ITEM_TC1">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="TRVL_MLG_RT_T">
        <column name="MLG_RT_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="MLG_RT_CD" required="true" size="40" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="MLG_RT_NM" required="true" size="40" type="VARCHAR"/>
        <column name="MLG_RT" required="true" scale="3" size="7" type="DECIMAL"/>
        <column default="Y" name="ACTV_IND" size="1" type="VARCHAR"/>
        <unique name="TRVL_MIL_RT_TC1">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="TRVL_PD_EXP_T">
        <column name="PD_EXP_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="TRVL_DEST_ID" required="true" size="40" type="VARCHAR"/>
        <column name="TRVL_AUTH_DOC_ID" required="true" size="40" type="VARCHAR"/>
        <column name="PD_DT" type="DATE"/>
        <column name="BKFST_VAL" required="true" scale="2" size="19" type="DECIMAL"/>
        <column name="LNCH_VAL" required="true" scale="2" size="19" type="DECIMAL"/>
        <column name="DNNR_VAL" required="true" scale="2" size="19" type="DECIMAL"/>
        <column name="INCD_VAL" required="true" scale="2" size="19" type="DECIMAL"/>
        <column name="MLG_RT_ID" required="true" size="40" type="VARCHAR"/>
        <column name="MLG_EST" required="true" size="8" type="DECIMAL"/>
        <foreign-key foreignTable="TRVL_AUTH_DOC_T" name="TRVL_PD_EXP_FK3">
            <reference foreign="TRVL_AUTH_DOC_ID" local="TRVL_AUTH_DOC_ID"/>
        </foreign-key>
        <foreign-key foreignTable="TRVL_MLG_RT_T" name="TRVL_PD_EXP_FK1">
            <reference foreign="MLG_RT_ID" local="MLG_RT_ID"/>
        </foreign-key>
        <foreign-key foreignTable="TRVL_DEST_T" name="TRVL_PD_EXP_FK2">
            <reference foreign="TRVL_DEST_ID" local="TRVL_DEST_ID"/>
        </foreign-key>
        <unique name="TRVL_PD_EXP_TC1">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="TRVL_TRAVELER_DTL_T">
        <column name="ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column default="Y" name="ACTV_IND" size="1" type="VARCHAR"/>
        <column name="CITIZENSHIP" size="40" type="VARCHAR"/>
        <column name="CITY_NM" size="50" type="VARCHAR"/>
        <column name="COUNTRY_CD" size="2" type="VARCHAR"/>
        <column name="CUSTOMER_NUM" size="40" type="VARCHAR"/>
        <column name="DOC_NBR" size="14" type="VARCHAR"/>
        <column name="DRIVE_LIC_EXP_DT" type="DATE"/>
        <column name="DRIVE_LIC_NUM" size="20" type="VARCHAR"/>
        <column name="EMAIL_ADDR" size="50" type="VARCHAR"/>
        <column name="FIRST_NM" size="40" type="VARCHAR"/>
        <column name="GENDER" size="1" type="VARCHAR"/>
        <column name="LAST_NM" size="40" type="VARCHAR"/>
        <column name="MIDDLENAME" size="40" type="VARCHAR"/>
        <column name="NON_RES_ALIEN" size="1" type="VARCHAR"/>
        <column name="PHONE_NBR" size="20" type="VARCHAR"/>
        <column name="EMP_PRINCIPAL_ID" size="255" type="VARCHAR"/>
        <column name="POSTAL_STATE_CD" size="2" type="VARCHAR"/>
        <column name="ADDR_LINE_1" size="50" type="VARCHAR"/>
        <column name="ADDR_LINE_2" size="50" type="VARCHAR"/>
        <column name="TRAVELER_TYP_CD" size="3" type="VARCHAR"/>
        <column name="POSTAL_CD" size="11" type="VARCHAR"/>
        <unique name="TRVL_TRAVELER_DTL_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="TRVL_TRAVELER_TYP_T">
        <column name="CODE" primaryKey="true" size="45" type="VARCHAR"/>
        <column name="SRC_CODE" size="45" type="VARCHAR"/>
        <column name="NM" size="45" type="VARCHAR"/>
        <column name="ADVANCES_IND" size="45" type="VARCHAR"/>
        <column name="ACTV_IND" size="45" type="VARCHAR"/>
        <column name="OBJ_ID" size="45" type="VARCHAR"/>
        <column name="VER_NBR" type="DECIMAL"/>
        <unique name="TRVL_TRAVELER_TYP_T_TC0">
            <unique-column name="OBJ_ID"/>
        </unique>
    </table>
    <table name="TRV_ACCT">
        <column name="ACCT_NUM" primaryKey="true" size="10" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="ACCT_NAME" size="40" type="VARCHAR"/>
        <column name="ACCT_TYPE" size="3" type="VARCHAR"/>
        <column name="ACCT_FO_ID" size="40" type="VARCHAR"/>
        <column name="CREATE_DT" type="DATE"/>
        <column name="SUBSIDIZED_PCT" scale="2" size="5" type="DECIMAL"/>
        <foreign-key foreignTable="TRV_ACCT_TYPE" name="TRV_ACCT_TR1">
            <reference foreign="ACCT_TYPE" local="ACCT_TYPE"/>
        </foreign-key>
    </table>
    <table name="TRV_ACCT_EXT">
        <column name="ACCT_NUM" primaryKey="true" size="10" type="VARCHAR"/>
        <column name="ACCT_TYPE" primaryKey="true" size="100" type="VARCHAR"/>
        <column name="OBJ_ID" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
    </table>
    <table name="TRV_ACCT_TYPE">
        <column name="ACCT_TYPE" primaryKey="true" size="3" type="VARCHAR"/>
        <column name="ACCT_TYPE_NAME" size="40" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="ACTV_IND" size="1" type="VARCHAR"/>
    </table>
    <table name="TRV_ACCT_USE_RT_T">
        <column name="ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="ACCT_NUM" size="10" type="VARCHAR"/>
        <column name="RATE" size="8" type="DECIMAL"/>
        <column name="ACTV_FRM_DT" type="DATE"/>
        <column name="ACTV_TO_DT" type="DATE"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
    </table>
    <table name="TRV_ATT_GRP_SAMPLE">
        <column name="ATT_GRP_NUM" primaryKey="true" size="10" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="ATT_GRP_NAME" size="40" type="VARCHAR"/>
    </table>
    <table name="TRV_ATT_SAMPLE">
        <column name="ATTACHMENT_ID" primaryKey="true" size="30" type="VARCHAR"/>
        <column name="ATT_GRP_NUM" primaryKey="true" size="30" type="VARCHAR"/>
        <column name="DESCRIPTION" size="4000" type="VARCHAR"/>
        <column name="ATTACHMENT_FILENAME" size="300" type="VARCHAR"/>
        <column name="ATTACHMENT_FILE_CONTENT_TYPE" size="255" type="VARCHAR"/>
        <column name="ATTACHMENT_FILE" type="BLOB"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="0" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
    </table>
    <table name="TRV_DOC_2">
        <column name="FDOC_NBR" primaryKey="true" size="14" type="VARCHAR"/>
        <column default="SYS_GUID()" name="OBJ_ID" required="true"
            size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="FDOC_EXPLAIN_TXT" size="400" type="VARCHAR"/>
        <column name="REQUEST_TRAV" required="true" size="30" type="VARCHAR"/>
        <column name="TRAVELER" size="200" type="VARCHAR"/>
        <column name="ORG" size="60" type="VARCHAR"/>
        <column name="DEST" size="60" type="VARCHAR"/>
    </table>
    <table name="TRV_DOC_ACCT">
        <column name="DOC_HDR_ID" primaryKey="true" size="40" type="VARCHAR"/>
        <column name="ACCT_NUM" primaryKey="true" size="10" type="VARCHAR"/>
    </table>
    <table name="TRV_SUB_ACCT">
        <column name="ACCT_NUM" primaryKey="true" size="10" type="VARCHAR"/>
        <column name="SUB_ACCT" primaryKey="true" size="10" type="VARCHAR"/>
        <column name="OBJ_ID" required="true" size="36" type="VARCHAR"/>
        <column default="1" name="VER_NBR" required="true" size="8" type="DECIMAL"/>
        <column name="SUB_ACCT_NAME" size="40" type="VARCHAR"/>
        <foreign-key foreignTable="TRV_ACCT" name="TRV_SUB_ACCT_TR1">
            <reference foreign="ACCT_NUM" local="ACCT_NUM"/>
        </foreign-key>
    </table>
    <sequence name="BK_ADDRESS_ID_S" nextval="1"/>
    <sequence name="BK_AUTHOR_ID_S" nextval="1"/>
    <sequence name="BK_BOOK_ID_S" nextval="1"/>
    <sequence name="BK_ORDER_ENTRY_S" nextval="1"/>
    <sequence name="KRNS_DOC_TYP_ATTR_S" nextval="1000"/>
    <sequence name="KRNS_LOCK_S" nextval="2000"/>
    <sequence name="KRNS_LOOKUP_RSLT_S" nextval="2000"/>
    <sequence name="KRNS_MAINT_DOC_ATT_S" nextval="10000"/>
    <sequence name="KRNS_MAINT_LOCK_S" nextval="2020"/>
    <sequence name="KRNS_NTE_S" nextval="2020"/>
    <sequence name="KRSB_BAM_PARM_S" nextval="2000"/>
    <sequence name="KRSB_BAM_S" nextval="2000"/>
    <sequence name="KRSB_MSG_QUE_S" nextval="467"/>
    <sequence name="TRVL_CO_ID_S" nextval="10021"/>
    <sequence name="TRVL_DEST_ID_S" nextval="10001"/>
    <sequence name="TRVL_EXP_ITM_ID_S" nextval="10001"/>
    <sequence name="TRVL_ID_SEQ" nextval="1"/>
    <sequence name="TRVL_MLG_RT_ID_S" nextval="10001"/>
    <sequence name="TRVL_PD_EXP_ID_S" nextval="10001"/>
    <sequence name="TRVL_TRAVELER_DTL_ID_S" nextval="10001"/>
</database>
