1 -- ---------------------------------------------------------------------------------------------------------------
2 -- This script creates tables in the COMMON version 2.1.0 of the ONAP SDK application database.
3 -- Additional DDL scripts may be required!
5 -- Note to database admin: set the MySQL system variable called lower_case_table_names to 1
6 -- It can be set 3 different ways:
7 -- command-line options (Cmd-line),
8 -- options valid in configuration files (Option file), or
9 -- server system variables (System Var).
11 -- When set to 1 table names are stored in lowercase on disk and comparisons are not case sensitive.
13 -- MySql/MariaDB Version compatibility information
15 -- bash-4.2$ mysql --version – cluster version
16 -- mysql Ver 15.1 Distrib 10.1.17-MariaDB, for Linux (x86_64) using readline 5.1
18 -- All versions newer or older than these DO NOT necessarily mean they are compatible.
19 -- ---------------------------------------------------------------------------------------------------------------
21 SET FOREIGN_KEY_CHECKS=1;
23 CREATE DATABASE IF NOT EXISTS akraino;
27 -- ---------- create table SECTION
29 -- NAME: CR_FAVORITE_REPORTS; TYPE: TABLE
31 create table cr_favorite_reports (
32 USER_ID INTEGER NOT NULL,
33 REP_ID INTEGER NOT NULL
37 -- NAME: CR_FILEHIST_LOG; TYPE: TABLE
39 create table cr_filehist_log (
40 SCHEDULE_ID NUMERIC(11,0) NOT NULL,
41 URL CHARACTER VARYING(4000),
42 NOTES CHARACTER VARYING(3500),
47 -- NAME: CR_FOLDER; TYPE: TABLE
49 create table cr_folder (
50 FOLDER_ID INTEGER NOT NULL,
51 FOLDER_NAME CHARACTER VARYING(50) NOT NULL,
52 DESCR CHARACTER VARYING(500),
53 CREATE_ID INTEGER NOT NULL,
54 CREATE_DATE TIMESTAMP NOT NULL,
55 PARENT_FOLDER_ID INTEGER,
56 PUBLIC_YN CHARACTER VARYING(1) DEFAULT 'N' NOT NULL
60 -- NAME: CR_FOLDER_ACCESS; TYPE: TABLE
62 create table cr_folder_access (
63 FOLDER_ACCESS_ID NUMERIC(11,0) NOT NULL,
64 FOLDER_ID NUMERIC(11,0) NOT NULL,
65 ORDER_NO NUMERIC(11,0) NOT NULL,
66 ROLE_ID NUMERIC(11,0),
67 USER_ID NUMERIC(11,0),
68 READ_ONLY_YN CHARACTER VARYING(1) DEFAULT 'N' NOT NULL
72 -- NAME: CR_HIST_USER_MAP; TYPE: TABLE
74 create table cr_hist_user_map (
75 HIST_ID INT(11) NOT NULL,
76 USER_ID INT(11) NOT NULL
80 -- NAME: CR_LU_FILE_TYPE; TYPE: TABLE
82 create table cr_lu_file_type (
83 LOOKUP_ID NUMERIC(2,0) NOT NULL,
84 LOOKUP_DESCR CHARACTER VARYING(255) NOT NULL,
85 ACTIVE_YN CHARACTER(1) DEFAULT 'Y',
86 ERROR_CODE NUMERIC(11,0)
90 -- NAME: CR_RAPTOR_ACTION_IMG; TYPE: TABLE
92 create table cr_raptor_action_img (
93 IMAGE_ID CHARACTER VARYING(100) NOT NULL,
94 IMAGE_LOC CHARACTER VARYING(400)
98 -- NAME: CR_RAPTOR_PDF_IMG; TYPE: TABLE
100 create table cr_raptor_pdf_img (
101 IMAGE_ID CHARACTER VARYING(100) NOT NULL,
102 IMAGE_LOC CHARACTER VARYING(400)
106 -- NAME: CR_REMOTE_SCHEMA_INFO; TYPE: TABLE
108 create table cr_remote_schema_info (
109 SCHEMA_PREFIX CHARACTER VARYING(5) NOT NULL,
110 SCHEMA_DESC CHARACTER VARYING(75) NOT NULL,
111 DATASOURCE_TYPE CHARACTER VARYING(100)
115 -- NAME: CR_REPORT; TYPE: TABLE
117 create table cr_report (
118 REP_ID NUMERIC(11,0) NOT NULL,
119 TITLE CHARACTER VARYING(100) NOT NULL,
120 DESCR CHARACTER VARYING(255),
121 PUBLIC_YN CHARACTER VARYING(1) DEFAULT 'N' NOT NULL,
123 CREATE_ID NUMERIC(11,0),
124 CREATE_DATE TIMESTAMP default now(),
125 MAINT_ID NUMERIC(11,0),
126 MAINT_DATE TIMESTAMP DEFAULT NOW(),
127 MENU_ID CHARACTER VARYING(500),
128 MENU_APPROVED_YN CHARACTER VARYING(1) DEFAULT 'N' NOT NULL,
129 OWNER_ID NUMERIC(11,0),
130 FOLDER_ID INTEGER DEFAULT 0,
131 DASHBOARD_TYPE_YN CHARACTER VARYING(1) DEFAULT 'N',
132 DASHBOARD_YN CHARACTER VARYING(1) DEFAULT 'N'
136 -- NAME: CR_REPORT_ACCESS; TYPE: TABLE
138 create table cr_report_access (
139 REP_ID NUMERIC(11,0) NOT NULL,
140 ORDER_NO NUMERIC(11,0) NOT NULL,
141 ROLE_ID NUMERIC(11,0),
142 USER_ID NUMERIC(11,0),
143 READ_ONLY_YN CHARACTER VARYING(1) DEFAULT 'N' NOT NULL
147 -- NAME: CR_REPORT_DWNLD_LOG; TYPE: TABLE
149 create table cr_report_dwnld_log (
150 USER_ID NUMERIC(11,0) NOT NULL,
151 REP_ID INTEGER NOT NULL,
152 FILE_NAME CHARACTER VARYING(100) NOT NULL,
153 DWNLD_START_TIME TIMESTAMP DEFAULT NOW() NOT NULL,
154 RECORD_READY_TIME TIMESTAMP DEFAULT NOW(),
155 FILTER_PARAMS CHARACTER VARYING(2000)
159 -- NAME: CR_REPORT_EMAIL_SENT_LOG; TYPE: TABLE
161 create table cr_report_email_sent_log (
162 LOG_ID INTEGER NOT NULL,
163 SCHEDULE_ID NUMERIC(11,0),
164 GEN_KEY CHARACTER VARYING(25) NOT NULL,
165 REP_ID NUMERIC(11,0) NOT NULL,
166 USER_ID NUMERIC(11,0),
167 SENT_DATE TIMESTAMP DEFAULT NOW(),
168 ACCESS_FLAG CHARACTER VARYING(1) DEFAULT 'Y' NOT NULL,
169 TOUCH_DATE TIMESTAMP DEFAULT NOW()
173 -- NAME: CR_REPORT_FILE_HISTORY; TYPE: TABLE
175 create table cr_report_file_history (
176 HIST_ID INT(11) NOT NULL,
177 SCHED_USER_ID NUMERIC(11,0) NOT NULL,
178 SCHEDULE_ID NUMERIC(11,0) NOT NULL,
179 USER_ID NUMERIC(11,0) NOT NULL,
180 REP_ID NUMERIC(11,0),
182 RECURRENCE CHARACTER VARYING(50),
183 FILE_TYPE_ID NUMERIC(2,0),
184 FILE_NAME CHARACTER VARYING(80),
186 FILE_SIZE NUMERIC(11,0),
187 RAPTOR_URL CHARACTER VARYING(4000),
188 ERROR_YN CHARACTER(1) DEFAULT 'N',
189 ERROR_CODE NUMERIC(11,0),
190 DELETED_YN CHARACTER(1) DEFAULT 'N',
191 DELETED_BY NUMERIC(38,0)
195 -- NAME: CR_REPORT_LOG; TYPE: TABLE
197 create table cr_report_log (
198 REP_ID NUMERIC(11,0) NOT NULL,
199 LOG_TIME TIMESTAMP NOT NULL,
200 USER_ID NUMERIC(11,0) NOT NULL,
201 ACTION CHARACTER VARYING(2000) NOT NULL,
202 ACTION_VALUE CHARACTER VARYING(50),
203 FORM_FIELDS CHARACTER VARYING(4000)
207 -- NAME: CR_REPORT_SCHEDULE; TYPE: TABLE
209 create table cr_report_schedule (
210 SCHEDULE_ID NUMERIC(11,0) NOT NULL,
211 SCHED_USER_ID NUMERIC(11,0) NOT NULL,
212 REP_ID NUMERIC(11,0) NOT NULL,
213 ENABLED_YN CHARACTER VARYING(1) NOT NULL,
214 START_DATE TIMESTAMP DEFAULT NOW(),
215 END_DATE TIMESTAMP DEFAULT NOW(),
216 RUN_DATE TIMESTAMP DEFAULT NOW(),
217 RECURRENCE CHARACTER VARYING(50),
218 CONDITIONAL_YN CHARACTER VARYING(1) NOT NULL,
219 CONDITION_SQL CHARACTER VARYING(4000),
220 NOTIFY_TYPE INTEGER DEFAULT 0,
221 MAX_ROW INTEGER DEFAULT 1000,
222 INITIAL_FORMFIELDS CHARACTER VARYING(3500),
223 PROCESSED_FORMFIELDS CHARACTER VARYING(3500),
224 FORMFIELDS CHARACTER VARYING(3500),
225 CONDITION_LARGE_SQL TEXT,
226 ENCRYPT_YN CHARACTER(1) DEFAULT 'N',
227 ATTACHMENT_YN CHARACTER(1) DEFAULT 'Y'
231 -- NAME: CR_REPORT_SCHEDULE_USERS; TYPE: TABLE
233 create table cr_report_schedule_users (
234 SCHEDULE_ID NUMERIC(11,0) NOT NULL,
235 REP_ID NUMERIC(11,0) NOT NULL,
236 USER_ID NUMERIC(11,0) NOT NULL,
237 ROLE_ID NUMERIC(11,0),
238 ORDER_NO NUMERIC(11,0) NOT NULL
242 -- NAME: CR_REPORT_TEMPLATE_MAP; TYPE: TABLE
244 create table cr_report_template_map (
245 REPORT_ID INTEGER NOT NULL,
246 TEMPLATE_FILE CHARACTER VARYING(200)
250 -- NAME: CR_SCHEDULE_ACTIVITY_LOG; TYPE: TABLE
252 create table cr_schedule_activity_log (
253 SCHEDULE_ID NUMERIC(11,0) NOT NULL,
254 URL CHARACTER VARYING(4000),
255 NOTES CHARACTER VARYING(2000),
260 -- NAME: CR_TABLE_JOIN; TYPE: TABLE
262 create table cr_table_join (
263 SRC_TABLE_NAME CHARACTER VARYING(30) NOT NULL,
264 DEST_TABLE_NAME CHARACTER VARYING(30) NOT NULL,
265 JOIN_EXPR CHARACTER VARYING(500) NOT NULL
269 -- NAME: CR_TABLE_ROLE; TYPE: TABLE
271 create table cr_table_role (
272 TABLE_NAME CHARACTER VARYING(30) NOT NULL,
273 ROLE_ID NUMERIC(11,0) NOT NULL
277 -- NAME: CR_TABLE_SOURCE; TYPE: TABLE
279 create table cr_table_source (
280 TABLE_NAME CHARACTER VARYING(30) NOT NULL,
281 DISPLAY_NAME CHARACTER VARYING(30) NOT NULL,
282 PK_FIELDS CHARACTER VARYING(200),
283 WEB_VIEW_ACTION CHARACTER VARYING(50),
284 LARGE_DATA_SOURCE_YN CHARACTER VARYING(1) DEFAULT 'N' NOT NULL,
285 FILTER_SQL CHARACTER VARYING(4000),
286 SOURCE_DB CHARACTER VARYING(50)
290 -- NAME: FN_LU_TIMEZONE; TYPE: TABLE
292 create table fn_lu_timezone (
293 TIMEZONE_ID INT(11) NOT NULL,
294 TIMEZONE_NAME CHARACTER VARYING(100) NOT NULL,
295 TIMEZONE_VALUE CHARACTER VARYING(100) NOT NULL
298 create table fn_user (
299 USER_ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
302 FIRST_NAME CHARACTER VARYING(50),
303 MIDDLE_NAME CHARACTER VARYING(50),
304 LAST_NAME CHARACTER VARYING(50),
305 PHONE CHARACTER VARYING(25),
306 FAX CHARACTER VARYING(25),
307 CELLULAR CHARACTER VARYING(25),
308 EMAIL CHARACTER VARYING(50),
309 ADDRESS_ID NUMERIC(11,0),
310 ALERT_METHOD_CD CHARACTER VARYING(10),
311 HRID CHARACTER VARYING(20),
312 ORG_USER_ID CHARACTER VARYING(20),
313 ORG_CODE CHARACTER VARYING(30),
314 LOGIN_ID CHARACTER VARYING(25),
315 LOGIN_PWD CHARACTER VARYING(25),
316 LAST_LOGIN_DATE TIMESTAMP,
317 ACTIVE_YN CHARACTER VARYING(1) DEFAULT 'Y' NOT NULL,
319 CREATED_DATE TIMESTAMP DEFAULT NOW(),
321 MODIFIED_DATE TIMESTAMP default now(),
322 IS_INTERNAL_YN CHARACTER(1) DEFAULT 'N' NOT NULL,
323 ADDRESS_LINE_1 CHARACTER VARYING(100),
324 ADDRESS_LINE_2 CHARACTER VARYING(100),
325 CITY CHARACTER VARYING(50),
326 STATE_CD CHARACTER VARYING(3),
327 ZIP_CODE CHARACTER VARYING(11),
328 COUNTRY_CD CHARACTER VARYING(3),
329 LOCATION_CLLI CHARACTER VARYING(8),
330 ORG_MANAGER_USERID CHARACTER VARYING(20),
331 COMPANY CHARACTER VARYING(100),
332 DEPARTMENT_NAME CHARACTER VARYING(100),
333 JOB_TITLE CHARACTER VARYING(100),
335 DEPARTMENT CHARACTER VARYING(25),
336 BUSINESS_UNIT CHARACTER VARYING(25),
337 BUSINESS_UNIT_NAME CHARACTER VARYING(100),
338 COST_CENTER CHARACTER VARYING(25),
339 FIN_LOC_CODE CHARACTER VARYING(10),
340 SILO_STATUS CHARACTER VARYING(10)
344 -- NAME: FN_ROLE; TYPE: TABLE
346 create table fn_role (
347 ROLE_ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
348 ROLE_NAME CHARACTER VARYING(300) NOT NULL,
349 ACTIVE_YN CHARACTER VARYING(1) DEFAULT 'Y' NOT NULL,
350 PRIORITY NUMERIC(4,0)
354 -- NAME: FN_AUDIT_ACTION; TYPE: TABLE
356 create table fn_audit_action (
357 AUDIT_ACTION_ID INTEGER NOT NULL,
358 CLASS_NAME CHARACTER VARYING(500) NOT NULL,
359 METHOD_NAME CHARACTER VARYING(50) NOT NULL,
360 AUDIT_ACTION_CD CHARACTER VARYING(20) NOT NULL,
361 AUDIT_ACTION_DESC CHARACTER VARYING(200),
362 ACTIVE_YN CHARACTER VARYING(1)
366 -- NAME: FN_AUDIT_ACTION_LOG; TYPE: TABLE
368 create table fn_audit_action_log (
369 AUDIT_LOG_ID INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
370 AUDIT_ACTION_CD CHARACTER VARYING(200),
371 ACTION_TIME TIMESTAMP,
372 USER_ID NUMERIC(11,0),
373 CLASS_NAME CHARACTER VARYING(100),
374 METHOD_NAME CHARACTER VARYING(50),
375 SUCCESS_MSG CHARACTER VARYING(20),
376 ERROR_MSG CHARACTER VARYING(500)
380 -- NAME: FN_LU_ACTIVITY; TYPE: TABLE
382 create table fn_lu_activity (
383 ACTIVITY_CD CHARACTER VARYING(50) NOT NULL PRIMARY KEY,
384 ACTIVITY CHARACTER VARYING(50) NOT NULL
388 -- NAME: FN_AUDIT_LOG; TYPE: TABLE
390 create table fn_audit_log (
391 LOG_ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
392 USER_ID INT(11) NOT NULL,
393 ACTIVITY_CD CHARACTER VARYING(50) NOT NULL,
394 AUDIT_DATE TIMESTAMP DEFAULT NOW() NOT NULL,
395 COMMENTS CHARACTER VARYING(1000),
396 AFFECTED_RECORD_ID_BK CHARACTER VARYING(500),
397 AFFECTED_RECORD_ID CHARACTER VARYING(4000),
398 CONSTRAINT FK_FN_AUDIT_REF_209_FN_USER FOREIGN KEY (USER_ID) REFERENCES FN_USER(USER_ID)
402 -- NAME: FN_BROADCAST_MESSAGE; TYPE: TABLE
404 create table fn_broadcast_message (
405 MESSAGE_ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
406 MESSAGE_TEXT CHARACTER VARYING(1000) NOT NULL,
407 MESSAGE_LOCATION_ID NUMERIC(11,0) NOT NULL,
408 BROADCAST_START_DATE TIMESTAMP NOT NULL DEFAULT NOW(),
409 BROADCAST_END_DATE TIMESTAMP NOT NULL DEFAULT NOW(),
410 ACTIVE_YN CHARACTER(1) DEFAULT 'Y' NOT NULL,
411 SORT_ORDER NUMERIC(4,0) NOT NULL,
412 BROADCAST_SITE_CD CHARACTER VARYING(50)
416 -- NAME: FN_CHAT_LOGS; TYPE: TABLE
418 create table fn_chat_logs (
419 CHAT_LOG_ID INTEGER NOT NULL,
420 CHAT_ROOM_ID INTEGER,
422 MESSAGE CHARACTER VARYING(1000),
423 MESSAGE_DATE_TIME TIMESTAMP
427 -- NAME: FN_CHAT_ROOM; TYPE: TABLE
429 create table fn_chat_room (
430 CHAT_ROOM_ID INTEGER NOT NULL,
431 NAME CHARACTER VARYING(50) NOT NULL,
432 DESCRIPTION CHARACTER VARYING(500),
434 CREATED_DATE TIMESTAMP DEFAULT NOW(),
435 UPDATED_DATE TIMESTAMP DEFAULT NOW()
439 -- NAME: FN_CHAT_USERS; TYPE: TABLE
441 create table fn_chat_users (
442 CHAT_ROOM_ID INTEGER,
444 LAST_ACTIVITY_DATE_TIME TIMESTAMP,
445 CHAT_STATUS CHARACTER VARYING(20),
450 -- NAME: FN_DATASOURCE; TYPE: TABLE
452 create table fn_datasource (
453 ID INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
454 NAME CHARACTER VARYING(50),
455 DRIVER_NAME CHARACTER VARYING(256),
456 SERVER CHARACTER VARYING(256),
458 USER_NAME CHARACTER VARYING(256),
459 PASSWORD CHARACTER VARYING(256),
460 URL CHARACTER VARYING(256),
461 MIN_POOL_SIZE INTEGER,
462 MAX_POOL_SIZE INTEGER,
464 DS_TYPE CHARACTER VARYING(20)
468 -- NAME: FN_FUNCTION; TYPE: TABLE
470 create table fn_function (
471 FUNCTION_CD CHARACTER VARYING(30) NOT NULL PRIMARY KEY,
472 FUNCTION_NAME CHARACTER VARYING(50) NOT NULL,
473 TYPE VARCHAR(20) NOT NULL,
474 ACTION VARCHAR(20) NOT NULL,
475 UNIQUE KEY function (FUNCTION_CD,TYPE,ACTION)
479 -- NAME: FN_LU_ALERT_METHOD; TYPE: TABLE
481 create table fn_lu_alert_method (
482 ALERT_METHOD_CD CHARACTER VARYING(10) NOT NULL,
483 ALERT_METHOD CHARACTER VARYING(50) NOT NULL
487 -- NAME: FN_LU_BROADCAST_SITE; TYPE: TABLE
489 create table fn_lu_broadcast_site (
490 BROADCAST_SITE_CD CHARACTER VARYING(50) NOT NULL,
491 BROADCAST_SITE_DESCR CHARACTER VARYING(100)
494 -- NAME: FN_LU_MENU_SET; TYPE: TABLE
496 create table fn_lu_menu_set (
497 MENU_SET_CD CHARACTER VARYING(10) NOT NULL PRIMARY KEY,
498 MENU_SET_NAME CHARACTER VARYING(50) NOT NULL
502 -- NAME: FN_LU_PRIORITY; TYPE: TABLE
504 create table fn_lu_priority (
505 PRIORITY_ID NUMERIC(11,0) NOT NULL,
506 PRIORITY CHARACTER VARYING(50) NOT NULL,
507 ACTIVE_YN CHARACTER(1) NOT NULL,
508 SORT_ORDER NUMERIC(5,0)
512 -- NAME: FN_LU_ROLE_TYPE; TYPE: TABLE
514 create table fn_lu_role_type (
515 ROLE_TYPE_ID NUMERIC(11,0) NOT NULL,
516 ROLE_TYPE CHARACTER VARYING(50) NOT NULL
519 -- NAME: FN_LU_TAB_SET; TYPE: TABLE
521 create table fn_lu_tab_set (
522 TAB_SET_CD CHARACTER VARYING(30) NOT NULL,
523 TAB_SET_NAME CHARACTER VARYING(50) NOT NULL
527 -- NAME: FN_MENU; TYPE: TABLE
529 create table fn_menu (
530 MENU_ID INT(11) NOT NULL PRIMARY KEY AUTO_INCREMENT,
531 LABEL CHARACTER VARYING(100),
533 SORT_ORDER NUMERIC(4,0),
534 ACTION CHARACTER VARYING(200),
535 FUNCTION_CD CHARACTER VARYING(30),
536 ACTIVE_YN CHARACTER VARYING(1) DEFAULT 'Y' NOT NULL,
537 SERVLET CHARACTER VARYING(50),
538 QUERY_STRING CHARACTER VARYING(200),
539 EXTERNAL_URL CHARACTER VARYING(200),
540 TARGET CHARACTER VARYING(25),
541 MENU_SET_CD CHARACTER VARYING(10) DEFAULT 'APP',
542 SEPARATOR_YN CHARACTER(1) DEFAULT 'N',
543 IMAGE_SRC CHARACTER VARYING(100),
544 CONSTRAINT FK_FN_MENU_REF_196_FN_MENU FOREIGN KEY (PARENT_ID) REFERENCES FN_MENU(MENU_ID),
545 CONSTRAINT FK_FN_MENU_MENU_SET_CD FOREIGN KEY (MENU_SET_CD) REFERENCES FN_LU_MENU_SET(MENU_SET_CD)
549 -- NAME: FN_ORG; TYPE: TABLE
551 create table fn_org (
552 ORG_ID INT(11) NOT NULL,
553 ORG_NAME CHARACTER VARYING(50) NOT NULL,
554 ACCESS_CD CHARACTER VARYING(10)
558 -- NAME: FN_RESTRICTED_URL; TYPE: TABLE
560 create table fn_restricted_url (
561 RESTRICTED_URL CHARACTER VARYING(250) NOT NULL,
562 FUNCTION_CD CHARACTER VARYING(30) NOT NULL
566 -- NAME: FN_ROLE_COMPOSITE; TYPE: TABLE
568 create table fn_role_composite (
569 PARENT_ROLE_ID INT(11) NOT NULL,
570 CHILD_ROLE_ID INT(11) NOT NULL,
571 CONSTRAINT FK_FN_ROLE_COMPOSITE_CHILD FOREIGN KEY (CHILD_ROLE_ID) REFERENCES FN_ROLE(ROLE_ID),
572 CONSTRAINT FK_FN_ROLE_COMPOSITE_PARENT FOREIGN KEY (PARENT_ROLE_ID) REFERENCES FN_ROLE(ROLE_ID)
576 -- NAME: FN_ROLE_FUNCTION; TYPE: TABLE
578 create table fn_role_function (
579 ROLE_ID INT(11) NOT NULL,
580 FUNCTION_CD CHARACTER VARYING(30) NOT NULL,
581 CONSTRAINT FK_FN_ROLE__REF_198_FN_ROLE FOREIGN KEY (ROLE_ID) REFERENCES FN_ROLE(ROLE_ID)
585 -- NAME: FN_TAB; TYPE: TABLE
587 create table fn_tab (
588 TAB_CD CHARACTER VARYING(30) NOT NULL,
589 TAB_NAME CHARACTER VARYING(50) NOT NULL,
590 TAB_DESCR CHARACTER VARYING(100),
591 ACTION CHARACTER VARYING(100) NOT NULL,
592 FUNCTION_CD CHARACTER VARYING(30) NOT NULL,
593 ACTIVE_YN CHARACTER(1) NOT NULL,
594 SORT_ORDER NUMERIC(11,0) NOT NULL,
595 PARENT_TAB_CD CHARACTER VARYING(30),
596 TAB_SET_CD CHARACTER VARYING(30)
600 -- NAME: FN_TAB_SELECTED; TYPE: TABLE
602 create table fn_tab_selected (
603 SELECTED_TAB_CD CHARACTER VARYING(30) NOT NULL,
604 TAB_URI CHARACTER VARYING(40) NOT NULL
608 -- NAME: FN_USER_PSEUDO_ROLE; TYPE: TABLE
610 create table fn_user_pseudo_role (
611 PSEUDO_ROLE_ID INT(11) NOT NULL,
612 USER_ID INT(11) NOT NULL
616 -- NAME: FN_USER_ROLE; TYPE: TABLE
618 create table fn_user_role (
619 USER_ID INT(10) NOT NULL,
620 ROLE_ID INT(10) NOT NULL,
621 PRIORITY NUMERIC(4,0),
622 APP_ID INT(11) DEFAULT 1,
623 CONSTRAINT FK_FN_USER__REF_172_FN_USER FOREIGN KEY (USER_ID) REFERENCES FN_USER(USER_ID),
624 CONSTRAINT FK_FN_USER__REF_175_FN_ROLE FOREIGN KEY (ROLE_ID) REFERENCES FN_ROLE(ROLE_ID)
627 -- NAME: SCHEMA_INFO; TYPE: TABLE
629 create table schema_info (
630 SCHEMA_ID CHARACTER VARYING(25) NOT NULL,
631 SCHEMA_DESC CHARACTER VARYING(75) NOT NULL,
632 DATASOURCE_TYPE CHARACTER VARYING(100),
633 CONNECTION_URL VARCHAR(200) NOT NULL,
634 USER_NAME VARCHAR(45) NOT NULL,
635 PASSWORD VARCHAR(45) NULL DEFAULT NULL,
636 DRIVER_CLASS VARCHAR(100) NOT NULL,
637 MIN_POOL_SIZE INT NOT NULL,
638 MAX_POOL_SIZE INT NOT NULL,
639 IDLE_CONNECTION_TEST_PERIOD INT NOT NULL
643 -- ----------------------------------------------------------
644 -- NAME: FN_APP; TYPE: TABLE
645 -- ----------------------------------------------------------
646 create table fn_app (
647 APP_ID int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,
648 APP_NAME varchar(100) NOT NULL DEFAULT '?',
649 APP_IMAGE_URL varchar(256) DEFAULT NULL,
650 APP_DESCRIPTION varchar(512) DEFAULT NULL,
651 APP_NOTES varchar(4096) DEFAULT NULL,
652 APP_URL varchar(256) DEFAULT NULL,
653 APP_ALTERNATE_URL varchar(256) DEFAULT NULL,
654 APP_REST_ENDPOINT varchar(2000) DEFAULT NULL,
655 ML_APP_NAME varchar(50) NOT NULL DEFAULT '?',
656 ML_APP_ADMIN_ID varchar(7) NOT NULL DEFAULT '?',
657 MOTS_ID int(11) DEFAULT NULL,
658 APP_PASSWORD varchar(256) NOT NULL DEFAULT '?',
659 OPEN char(1) DEFAULT 'N',
660 ENABLED char(1) DEFAULT 'Y',
661 THUMBNAIL mediumblob,
662 APP_USERNAME varchar(50),
663 UEB_KEY VARCHAR(256) DEFAULT NULL,
664 UEB_SECRET VARCHAR(256) DEFAULT NULL,
665 UEB_TOPIC_NAME VARCHAR(256) DEFAULT NULL
669 -- ----------------------------------------------------------
670 -- NAME: FN_FN_WORKFLOW; TYPE: TABLE
671 -- ----------------------------------------------------------
672 create table fn_workflow (
673 id mediumint(9) NOT NULL AUTO_INCREMENT,
674 name varchar(20) NOT NULL,
675 description varchar(500) DEFAULT NULL,
676 run_link varchar(300) DEFAULT NULL,
677 suspend_link varchar(300) DEFAULT NULL,
678 modified_link varchar(300) DEFAULT NULL,
679 active_yn varchar(300) DEFAULT NULL,
680 created varchar(300) DEFAULT NULL,
681 created_by int(11) DEFAULT NULL,
682 modified varchar(300) DEFAULT NULL,
683 modified_by int(11) DEFAULT NULL,
684 workflow_key varchar(50) DEFAULT NULL,
686 UNIQUE KEY name (name)
689 -- ----------------------------------------------------------
690 -- NAME: FN_SCHEDULE_WORKFLOWS; TYPE: TABLE
691 -- ----------------------------------------------------------
692 create table fn_schedule_workflows (
693 id_schedule_workflows bigint(25) PRIMARY KEY NOT NULL AUTO_INCREMENT,
694 workflow_server_url varchar(45) DEFAULT NULL,
695 workflow_key varchar(45) NOT NULL,
696 workflow_arguments varchar(45) DEFAULT NULL,
697 startDateTimeCron varchar(45) DEFAULT NULL,
698 endDateTime TIMESTAMP DEFAULT NOW(),
699 start_date_time TIMESTAMP DEFAULT NOW(),
700 recurrence varchar(45) DEFAULT NULL
703 -- For demo reporting application add : demo_bar_chart, demo_bar_chart_inter, demo_line_chart, demo_pie_chart and demo_util_chart
704 -- demo_scatter_chart, demo_scatter_plot
705 -- ----------------------------------------------------------
706 -- NAME: DEMO_BAR_CHART; TYPE: TABLE
707 -- ----------------------------------------------------------
708 create table demo_bar_chart (
713 -- ----------------------------------------------------------
714 -- NAME: DEMO_BAR_CHART_INTER; TYPE: TABLE
715 -- ----------------------------------------------------------
716 create table demo_bar_chart_inter (
718 num_rpt_sources numeric(10,0),
719 num_det_sources numeric(10,0)
722 -- ----------------------------------------------------------
723 -- NAME: DEMO_LINE_CHART; TYPE: TABLE
724 -- ----------------------------------------------------------
725 create table demo_line_chart (
728 data_value numeric(10,5)
731 -- ----------------------------------------------------------
732 -- NAME: DEMO_PIE_CHART; TYPE: TABLE
733 -- ----------------------------------------------------------
734 create table demo_pie_chart (
736 data_value numeric(10,5)
739 -- ----------------------------------------------------------
740 -- NAME: DEMO_UTIL_CHART; TYPE: TABLE
741 -- ----------------------------------------------------------
742 create table demo_util_chart (
744 util_perc numeric(10,5)
747 -- ----------------------------------------------------------
748 -- NAME: DEMO_SCATTER_CHART; TYPE: TABLE
749 -- ----------------------------------------------------------
750 create table demo_scatter_chart (
751 rainfall numeric(10,2),
752 key_value varchar(20),
753 measurements numeric(10,2)
756 -- ----------------------------------------------------------
757 -- NAME: DEMO_SCATTER_PLOT; TYPE: TABLE
758 -- ----------------------------------------------------------
759 create table demo_scatter_plot
762 VALUEX numeric(25,15),
763 VALUEY numeric(25,15)
766 -- ----------------------------------------------------------
767 -- NAME: FN_QZ_JOB_DETAILS; TYPE: TABLE
768 -- ----------------------------------------------------------
769 create table fn_qz_job_details (
770 SCHED_NAME VARCHAR(120) NOT NULL,
771 JOB_NAME VARCHAR(200) NOT NULL,
772 JOB_GROUP VARCHAR(200) NOT NULL,
773 DESCRIPTION VARCHAR(250) NULL,
774 JOB_CLASS_NAME VARCHAR(250) NOT NULL,
775 IS_DURABLE VARCHAR(1) NOT NULL,
776 IS_NONCONCURRENT VARCHAR(1) NOT NULL,
777 IS_UPDATE_DATA VARCHAR(1) NOT NULL,
778 REQUESTS_RECOVERY VARCHAR(1) NOT NULL,
780 PRIMARY KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
783 -- ----------------------------------------------------------
784 -- NAME: FN_QZ_TRIGGERS; TYPE: TABLE
785 -- ----------------------------------------------------------
786 create table fn_qz_triggers (
787 SCHED_NAME VARCHAR(120) NOT NULL,
788 TRIGGER_NAME VARCHAR(200) NOT NULL,
789 TRIGGER_GROUP VARCHAR(200) NOT NULL,
790 JOB_NAME VARCHAR(200) NOT NULL,
791 JOB_GROUP VARCHAR(200) NOT NULL,
792 DESCRIPTION VARCHAR(250) NULL,
793 NEXT_FIRE_TIME BIGINT(13) NULL,
794 PREV_FIRE_TIME BIGINT(13) NULL,
795 PRIORITY INTEGER NULL,
796 TRIGGER_STATE VARCHAR(16) NOT NULL,
797 TRIGGER_TYPE VARCHAR(8) NOT NULL,
798 START_TIME BIGINT(13) NOT NULL,
799 END_TIME BIGINT(13) NULL,
800 CALENDAR_NAME VARCHAR(200) NULL,
801 MISFIRE_INSTR SMALLINT(2) NULL,
803 PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
804 FOREIGN KEY (SCHED_NAME,JOB_NAME,JOB_GROUP)
805 REFERENCES FN_QZ_JOB_DETAILS(SCHED_NAME,JOB_NAME,JOB_GROUP)
808 -- ----------------------------------------------------------
809 -- NAME: FN_QZ_SIMPLE_TRIGGERS; TYPE: TABLE
810 -- ----------------------------------------------------------
811 create table fn_qz_simple_triggers (
812 SCHED_NAME VARCHAR(120) NOT NULL,
813 TRIGGER_NAME VARCHAR(200) NOT NULL,
814 TRIGGER_GROUP VARCHAR(200) NOT NULL,
815 REPEAT_COUNT BIGINT(7) NOT NULL,
816 REPEAT_INTERVAL BIGINT(12) NOT NULL,
817 TIMES_TRIGGERED BIGINT(10) NOT NULL,
818 PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
819 FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
820 REFERENCES FN_QZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
823 -- ----------------------------------------------------------
824 -- NAME: FN_QZ_CRON_TRIGGERS; TYPE: TABLE
825 -- ----------------------------------------------------------
826 create table fn_qz_cron_triggers (
827 SCHED_NAME VARCHAR(120) NOT NULL,
828 TRIGGER_NAME VARCHAR(200) NOT NULL,
829 TRIGGER_GROUP VARCHAR(200) NOT NULL,
830 CRON_EXPRESSION VARCHAR(120) NOT NULL,
831 TIME_ZONE_ID VARCHAR(80),
832 PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
833 FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
834 REFERENCES FN_QZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
837 -- ----------------------------------------------------------
838 -- NAME: FN_QZ_SIMPROP_TRIGGERS; TYPE: TABLE
839 -- ----------------------------------------------------------
840 create table fn_qz_simprop_triggers
842 SCHED_NAME VARCHAR(120) NOT NULL,
843 TRIGGER_NAME VARCHAR(200) NOT NULL,
844 TRIGGER_GROUP VARCHAR(200) NOT NULL,
845 STR_PROP_1 VARCHAR(512) NULL,
846 STR_PROP_2 VARCHAR(512) NULL,
847 STR_PROP_3 VARCHAR(512) NULL,
850 LONG_PROP_1 BIGINT NULL,
851 LONG_PROP_2 BIGINT NULL,
852 DEC_PROP_1 NUMERIC(13,4) NULL,
853 DEC_PROP_2 NUMERIC(13,4) NULL,
854 BOOL_PROP_1 VARCHAR(1) NULL,
855 BOOL_PROP_2 VARCHAR(1) NULL,
856 PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
857 FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
858 REFERENCES FN_QZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
861 -- ----------------------------------------------------------
862 -- NAME: FN_QZ_BLOB_TRIGGERS; TYPE: TABLE
863 -- ----------------------------------------------------------
864 create table fn_qz_blob_triggers (
865 SCHED_NAME VARCHAR(120) NOT NULL,
866 TRIGGER_NAME VARCHAR(200) NOT NULL,
867 TRIGGER_GROUP VARCHAR(200) NOT NULL,
869 PRIMARY KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP),
870 INDEX (SCHED_NAME,TRIGGER_NAME, TRIGGER_GROUP),
871 FOREIGN KEY (SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
872 REFERENCES FN_QZ_TRIGGERS(SCHED_NAME,TRIGGER_NAME,TRIGGER_GROUP)
875 -- ----------------------------------------------------------
876 -- NAME: FN_QZ_CALENDARS; TYPE: TABLE
877 -- ----------------------------------------------------------
878 create table fn_qz_calendars (
879 SCHED_NAME VARCHAR(120) NOT NULL,
880 CALENDAR_NAME VARCHAR(200) NOT NULL,
881 CALENDAR BLOB NOT NULL,
882 PRIMARY KEY (SCHED_NAME,CALENDAR_NAME)
885 -- ----------------------------------------------------------
886 -- NAME: FN_QZ_PAUSED_TRIGGER_GRPS; TYPE: TABLE
887 -- ----------------------------------------------------------
888 create table fn_qz_paused_trigger_grps (
889 SCHED_NAME VARCHAR(120) NOT NULL,
890 TRIGGER_GROUP VARCHAR(200) NOT NULL,
891 PRIMARY KEY (SCHED_NAME,TRIGGER_GROUP)
894 -- ----------------------------------------------------------
895 -- NAME: FN_QZ_FIRED_TRIGGERS; TYPE: TABLE
896 -- ----------------------------------------------------------
897 create table fn_qz_fired_triggers (
898 SCHED_NAME VARCHAR(120) NOT NULL,
899 ENTRY_ID VARCHAR(95) NOT NULL,
900 TRIGGER_NAME VARCHAR(200) NOT NULL,
901 TRIGGER_GROUP VARCHAR(200) NOT NULL,
902 INSTANCE_NAME VARCHAR(200) NOT NULL,
903 FIRED_TIME BIGINT(13) NOT NULL,
904 SCHED_TIME BIGINT(13) NOT NULL,
905 PRIORITY INTEGER NOT NULL,
906 STATE VARCHAR(16) NOT NULL,
907 JOB_NAME VARCHAR(200) NULL,
908 JOB_GROUP VARCHAR(200) NULL,
909 IS_NONCONCURRENT VARCHAR(1) NULL,
910 REQUESTS_RECOVERY VARCHAR(1) NULL,
911 PRIMARY KEY (SCHED_NAME,ENTRY_ID)
914 -- ----------------------------------------------------------
915 -- NAME: FN_QZ_SCHEDULER_STATE; TYPE: TABLE
916 -- ----------------------------------------------------------
917 create table fn_qz_scheduler_state (
918 SCHED_NAME VARCHAR(120) NOT NULL,
919 INSTANCE_NAME VARCHAR(200) NOT NULL,
920 LAST_CHECKIN_TIME BIGINT(13) NOT NULL,
921 CHECKIN_INTERVAL BIGINT(13) NOT NULL,
922 PRIMARY KEY (SCHED_NAME,INSTANCE_NAME)
925 -- ----------------------------------------------------------
926 -- NAME: FN_QZ_LOCKS; TYPE: TABLE
927 -- ----------------------------------------------------------
928 create table fn_qz_locks (
929 SCHED_NAME VARCHAR(120) NOT NULL,
930 LOCK_NAME VARCHAR(40) NOT NULL,
931 PRIMARY KEY (SCHED_NAME,LOCK_NAME)
935 -- name: rcloudinvocation; type: table
937 create table rcloudinvocation (
938 id varchar(128) not null primary key,
939 created timestamp not null,
940 userinfo varchar(2048) not null,
941 notebookid varchar(128) not null,
942 parameters varchar(2048) default null,
943 tokenreaddate timestamp null
947 -- name: rcloudnotebook; type: table
949 create table rcloudnotebook (
950 notebookname varchar(128) not null primary key,
951 notebookid varchar(128) not null
955 -- Name: fn_lu_message_location; Type: TABLE
958 CREATE TABLE fn_lu_message_location (
959 message_location_id numeric(11,0) NOT NULL,
960 message_location_descr character varying(30) NOT NULL
963 -- ------------------ CREATE VIEW SECTION
965 -- NAME: V_URL_ACCESS; TYPE: VIEW
967 CREATE VIEW v_url_access AS
968 SELECT DISTINCT M.ACTION AS URL,
971 WHERE (M.ACTION IS NOT NULL)
973 SELECT DISTINCT T.ACTION AS URL,
976 WHERE (T.ACTION IS NOT NULL)
978 SELECT R.RESTRICTED_URL AS URL,
980 FROM FN_RESTRICTED_URL R;
982 -- ------------------ ALTER TABLE ADD CONSTRAINT PRIMARY KEY SECTION
984 -- NAME: CR_FAVORITE_REPORTS_USER_IDREP_ID; TYPE: CONSTRAINT
986 alter table cr_favorite_reports
987 add constraint cr_favorite_reports_user_idrep_id primary key (user_id, rep_id);
989 -- NAME: CR_FOLDER_FOLDER_ID; TYPE: CONSTRAINT
991 alter table cr_folder
992 add constraint cr_folder_folder_id primary key (folder_id);
994 -- NAME: CR_FOLDER_ACCESS_FOLDER_ACCESS_ID; TYPE: CONSTRAINT
996 alter table cr_folder_access
997 add constraint cr_folder_access_folder_access_id primary key (folder_access_id);
999 -- NAME: CR_HIST_USER_MAP_HIST_IDUSER_ID; TYPE: CONSTRAINT
1001 alter table cr_hist_user_map
1002 add constraint cr_hist_user_map_hist_iduser_id primary key (hist_id, user_id);
1004 -- NAME: CR_LU_FILE_TYPE_LOOKUP_ID; TYPE: CONSTRAINT
1006 alter table cr_lu_file_type
1007 add constraint cr_lu_file_type_lookup_id primary key (lookup_id);
1009 -- NAME: CR_RAPTOR_ACTION_IMG_IMAGE_ID; TYPE: CONSTRAINT
1011 alter table cr_raptor_action_img
1012 add constraint cr_raptor_action_img_image_id primary key (image_id);
1014 -- NAME: CR_RAPTOR_PDF_IMG_IMAGE_ID; TYPE: CONSTRAINT
1016 alter table cr_raptor_pdf_img
1017 add constraint cr_raptor_pdf_img_image_id primary key (image_id);
1019 -- NAME: CR_REMOTE_SCHEMA_INFO_SCHEMA_PREFIX; TYPE: CONSTRAINT
1021 alter table cr_remote_schema_info
1022 add constraint cr_remote_schema_info_schema_prefix primary key (schema_prefix);
1024 -- NAME: CR_REPORT_REP_ID; TYPE: CONSTRAINT
1026 alter table cr_report
1027 add constraint cr_report_rep_id primary key (rep_id);
1029 -- NAME: CR_REPORT_ACCESS_REP_IDORDER_NO; TYPE: CONSTRAINT
1031 alter table cr_report_access
1032 add constraint cr_report_access_rep_idorder_no primary key (rep_id, order_no);
1034 -- NAME: CR_REPORT_EMAIL_SENT_LOG_LOG_ID; TYPE: CONSTRAINT
1036 alter table cr_report_email_sent_log
1037 add constraint cr_report_email_sent_log_log_id primary key (log_id);
1039 -- NAME: CR_REPORT_FILE_HISTORY_HIST_ID; TYPE: CONSTRAINT
1041 alter table cr_report_file_history
1042 add constraint cr_report_file_history_hist_id primary key (hist_id);
1044 -- NAME: CR_REPORT_SCHEDULE_SCHEDULE_ID; TYPE: CONSTRAINT
1046 alter table cr_report_schedule
1047 add constraint cr_report_schedule_schedule_id primary key (schedule_id);
1049 -- NAME: CR_REPORT_SCHEDULE_USERS_SCHEDULE_IDREP_IDUSER_IDORDER_NO; TYPE: CONSTRAINT
1051 alter table cr_report_schedule_users
1052 add constraint cr_report_schedule_users_schedule_idrep_iduser_idorder_no primary key (schedule_id, rep_id, user_id, order_no);
1054 -- NAME: CR_REPORT_TEMPLATE_MAP_REPORT_ID; TYPE: CONSTRAINT
1056 alter table cr_report_template_map
1057 add constraint cr_report_template_map_report_id primary key (report_id);
1059 -- NAME: CR_TABLE_ROLE_TABLE_NAMEROLE_ID; TYPE: CONSTRAINT
1061 alter table cr_table_role
1062 add constraint cr_table_role_table_namerole_id primary key (table_name, role_id);
1064 -- NAME: CR_TABLE_SOURCE_TABLE_NAME; TYPE: CONSTRAINT
1066 alter table cr_table_source
1067 add constraint cr_table_source_table_name primary key (table_name);
1069 -- NAME: FN_AUDIT_ACTION_AUDIT_ACTION_ID; TYPE: CONSTRAINT
1071 alter table fn_audit_action
1072 add constraint fn_audit_action_audit_action_id primary key (audit_action_id);
1074 -- NAME: FN_CHAT_LOGS_CHAT_LOG_ID; TYPE: CONSTRAINT
1076 alter table fn_chat_logs
1077 add constraint fn_chat_logs_chat_log_id primary key (chat_log_id);
1079 -- NAME: FN_CHAT_ROOM_CHAT_ROOM_ID; TYPE: CONSTRAINT
1081 alter table fn_chat_room
1082 add constraint fn_chat_room_chat_room_id primary key (chat_room_id);
1084 -- NAME: FN_CHAT_USERS_ID; TYPE: CONSTRAINT
1086 alter table fn_chat_users
1087 add constraint fn_chat_users_id primary key (id);
1089 -- NAME: FN_LU_ALERT_METHOD_ALERT_METHOD_CD; TYPE: CONSTRAINT
1091 alter table fn_lu_alert_method
1092 add constraint fn_lu_alert_method_alert_method_cd primary key (alert_method_cd);
1094 -- NAME: FN_LU_BROADCAST_SITE_BROADCAST_SITE_CD; TYPE: CONSTRAINT
1096 alter table fn_lu_broadcast_site
1097 add constraint fn_lu_broadcast_site_broadcast_site_cd primary key (broadcast_site_cd);
1099 -- NAME: FN_LU_PRIORITY_PRIORITY_ID; TYPE: CONSTRAINT
1101 alter table fn_lu_priority
1102 add constraint fn_lu_priority_priority_id primary key (priority_id);
1104 -- NAME: FN_LU_ROLE_TYPE_ROLE_TYPE_ID; TYPE: CONSTRAINT
1106 alter table fn_lu_role_type
1107 add constraint fn_lu_role_type_role_type_id primary key (role_type_id);
1109 -- NAME: FN_LU_TAB_SET_TAB_SET_CD; TYPE: CONSTRAINT
1111 alter table fn_lu_tab_set
1112 add constraint fn_lu_tab_set_tab_set_cd primary key (tab_set_cd);
1114 -- NAME: FN_LU_TIMEZONE_TIMEZONE_ID; TYPE: CONSTRAINT
1116 alter table fn_lu_timezone
1117 add constraint fn_lu_timezone_timezone_id primary key (timezone_id);
1119 -- NAME: FN_ORG_ORG_ID; TYPE: CONSTRAINT
1122 add constraint fn_org_org_id primary key (org_id);
1124 -- NAME: FN_RESTRICTED_URL_RESTRICTED_URLFUNCTION_CD; TYPE: CONSTRAINT
1126 alter table fn_restricted_url
1127 add constraint fn_restricted_url_restricted_urlfunction_cd primary key (restricted_url, function_cd);
1129 -- NAME: FN_ROLE_COMPOSITE_PARENT_ROLE_IDCHILD_ROLE_ID; TYPE: CONSTRAINT
1131 alter table fn_role_composite
1132 add constraint fn_role_composite_parent_role_idchild_role_id primary key (parent_role_id, child_role_id);
1134 -- NAME: FN_ROLE_FUNCTION_ROLE_IDFUNCTION_CD; TYPE: CONSTRAINT
1136 alter table fn_role_function
1137 add constraint fn_role_function_role_idfunction_cd primary key (role_id, function_cd);
1139 -- NAME: FN_TAB_TAB_CD; TYPE: CONSTRAINT
1142 add constraint fn_tab_tab_cd primary key (tab_cd);
1144 -- NAME: FN_TAB_SELECTED_SELECTED_TAB_CDTAB_URI; TYPE: CONSTRAINT
1146 alter table fn_tab_selected
1147 add constraint fn_tab_selected_selected_tab_cdtab_uri primary key (selected_tab_cd, tab_uri);
1149 -- NAME: FN_USER_PSEUDO_ROLE_PSEUDO_ROLE_IDUSER_ID; TYPE: CONSTRAINT
1151 alter table fn_user_pseudo_role
1152 add constraint fn_user_pseudo_role_pseudo_role_iduser_id primary key (pseudo_role_id, user_id);
1154 -- NAME: FN_USER_ROLE_USER_IDROLE_ID; TYPE: CONSTRAINT
1156 alter table fn_user_role
1157 add constraint fn_user_role_user_idrole_id primary key (user_id, role_id, app_id);
1159 -- Name: fn_lu_message_location_MESSAGE_LOCATION_ID; Type: CONSTRAINT
1162 ALTER TABLE fn_lu_message_location
1163 ADD CONSTRAINT fn_lu_message_location_MESSAGE_LOCATION_ID PRIMARY KEY (message_location_id);
1165 -- ------------------ CREATE INDEX SECTION
1167 -- NAME: CR_REPORT_CREATE_IDPUBLIC_YNTITLE; TYPE: INDEX
1169 create index cr_report_create_idpublic_yntitle using btree on cr_report (create_id, public_yn, title);
1171 -- NAME: CR_TABLE_JOIN_DEST_TABLE_NAME; TYPE: INDEX
1173 create index cr_table_join_dest_table_name using btree on cr_table_join (dest_table_name);
1175 -- NAME: CR_TABLE_JOIN_SRC_TABLE_NAME; TYPE: INDEX
1177 create index cr_table_join_src_table_name using btree on cr_table_join (src_table_name);
1179 -- NAME: FN_AUDIT_LOG_ACTIVITY_CD; TYPE: INDEX
1181 create index fn_audit_log_activity_cd using btree on fn_audit_log (activity_cd);
1183 -- NAME: FN_AUDIT_LOG_USER_ID; TYPE: INDEX
1185 create index fn_audit_log_user_id using btree on fn_audit_log (user_id);
1187 -- NAME: FN_ORG_ACCESS_CD; TYPE: INDEX
1189 create index fn_org_access_cd using btree on fn_org (access_cd);
1191 -- NAME: FN_ROLE_FUNCTION_FUNCTION_CD; TYPE: INDEX
1193 create index fn_role_function_function_cd using btree on fn_role_function (function_cd);
1195 -- NAME: FN_ROLE_FUNCTION_ROLE_ID; TYPE: INDEX
1197 create index fn_role_function_role_id using btree on fn_role_function (role_id);
1199 -- NAME: FN_USER_ADDRESS_ID; TYPE: INDEX
1201 create index fn_user_address_id using btree on fn_user (address_id);
1203 -- NAME: FN_USER_ALERT_METHOD_CD; TYPE: INDEX
1205 create index fn_user_alert_method_cd using btree on fn_user (alert_method_cd);
1207 -- NAME: FN_USER_HRID; TYPE: INDEX
1209 create unique index fn_user_hrid using btree on fn_user (hrid);
1211 -- NAME: FN_USER_LOGIN_ID; TYPE: INDEX
1213 create unique index fn_user_login_id using btree on fn_user (login_id);
1215 -- NAME: FN_USER_ORG_ID; TYPE: INDEX
1217 create index fn_user_org_id using btree on fn_user (org_id);
1219 -- NAME: FN_USER_ROLE_ROLE_ID; TYPE: INDEX
1221 create index fn_user_role_role_id using btree on fn_user_role (role_id);
1223 -- NAME: FN_USER_ROLE_USER_ID; TYPE: INDEX
1225 create index fn_user_role_user_id using btree on fn_user_role (user_id);
1227 -- NAME: FK_FN_USER__REF_178_FN_APP_idx; TYPE: INDEX
1229 create index fk_fn_user__ref_178_fn_app_IDX on fn_user_role (app_id);
1231 -- ----------------------------------------------------------
1232 -- NAME: QUARTZ TYPE: INDEXES
1233 -- ----------------------------------------------------------
1234 create index idx_fn_qz_j_req_recovery on fn_qz_job_details(sched_name,requests_recovery);
1235 create index idx_fn_qz_j_grp on fn_qz_job_details(sched_name,job_group);
1236 create index idx_fn_qz_t_j on fn_qz_triggers(sched_name,job_name,job_group);
1237 create index idx_fn_qz_t_jg on fn_qz_triggers(sched_name,job_group);
1238 create index idx_fn_qz_t_c on fn_qz_triggers(sched_name,calendar_name);
1239 create index idx_fn_qz_t_g on fn_qz_triggers(sched_name,trigger_group);
1240 create index idx_fn_qz_t_state on fn_qz_triggers(sched_name,trigger_state);
1241 create index idx_fn_qz_t_n_state on fn_qz_triggers(sched_name,trigger_name,trigger_group,trigger_state);
1242 create index idx_fn_qz_t_n_g_state on fn_qz_triggers(sched_name,trigger_group,trigger_state);
1243 create index idx_fn_qz_t_next_fire_time on fn_qz_triggers(sched_name,next_fire_time);
1244 create index idx_fn_qz_t_nft_st on fn_qz_triggers(sched_name,trigger_state,next_fire_time);
1245 create index idx_fn_qz_t_nft_misfire on fn_qz_triggers(sched_name,misfire_instr,next_fire_time);
1246 create index idx_fn_qz_t_nft_st_misfire on fn_qz_triggers(sched_name,misfire_instr,next_fire_time,trigger_state);
1247 create index idx_fn_qz_t_nft_st_misfire_grp on fn_qz_triggers(sched_name,misfire_instr,next_fire_time,trigger_group,trigger_state);
1248 create index idx_fn_qz_ft_trig_inst_name on fn_qz_fired_triggers(sched_name,instance_name);
1249 create index idx_fn_qz_ft_inst_job_req_rcvry on fn_qz_fired_triggers(sched_name,instance_name,requests_recovery);
1250 create index idx_fn_qz_ft_j_g on fn_qz_fired_triggers(sched_name,job_name,job_group);
1251 create index idx_fn_qz_ft_jg on fn_qz_fired_triggers(sched_name,job_group);
1252 create index idx_fn_qz_ft_t_g on fn_qz_fired_triggers(sched_name,trigger_name,trigger_group);
1253 create index idx_fn_qz_ft_tg on fn_qz_fired_triggers(sched_name,trigger_group);
1255 -- ------------------ ALTER TABLE ADD CONSTRAINT FOREIGN KEY SECTION
1257 -- NAME: FK_FN_AUDIT_REF_205_FN_LU_AC; TYPE: CONSTRAINT
1259 alter table fn_audit_log
1260 add constraint fk_fn_audit_ref_205_fn_lu_ac foreign key (activity_cd) references fn_lu_activity(activity_cd);
1262 -- NAME: FK_FN_ROLE__REF_201_FN_FUNCT; TYPE: CONSTRAINT
1264 alter table fn_role_function
1265 add constraint fk_fn_role__ref_201_fn_funct foreign key (function_cd) references fn_function(function_cd);
1267 -- NAME: FK_FN_USER__REF_178_FN_APP; TYPE: FK CONSTRAINT
1269 alter table fn_user_role
1270 add constraint fk_fn_user__ref_178_fn_app foreign key (app_id) references fn_app(app_id);
1272 -- NAME: FK_CR_REPOR_REF_14707_CR_REPOR; TYPE: FK CONSTRAINT
1274 alter table cr_report_schedule
1275 add constraint fk_cr_repor_ref_14707_cr_repor foreign key (rep_id) references cr_report(rep_id);
1277 -- NAME: FK_CR_REPOR_REF_14716_CR_REPOR; TYPE: FK CONSTRAINT
1279 alter table cr_report_schedule_users
1280 add constraint fk_cr_repor_ref_14716_cr_repor foreign key (schedule_id) references cr_report_schedule(schedule_id);
1282 -- NAME: FK_CR_REPOR_REF_17645_CR_REPOR; TYPE: FK CONSTRAINT
1284 alter table cr_report_log
1285 add constraint fk_cr_repor_ref_17645_cr_repor foreign key (rep_id) references cr_report(rep_id);
1287 -- NAME: FK_CR_REPOR_REF_8550_CR_REPOR; TYPE: FK CONSTRAINT
1289 alter table cr_report_access
1290 add constraint fk_cr_repor_ref_8550_cr_repor foreign key (rep_id) references cr_report(rep_id);
1292 -- NAME: FK_CR_REPORT_REP_ID; TYPE: FK CONSTRAINT
1294 alter table cr_report_email_sent_log
1295 add constraint fk_cr_report_rep_id foreign key (rep_id) references cr_report(rep_id);
1297 -- NAME: FK_CR_TABLE_REF_311_CR_TAB; TYPE: FK CONSTRAINT
1299 alter table cr_table_join
1300 add constraint fk_cr_table_ref_311_cr_tab foreign key (src_table_name) references cr_table_source(table_name);
1302 -- NAME: FK_CR_TABLE_REF_315_CR_TAB; TYPE: FK CONSTRAINT
1304 alter table cr_table_join
1305 add constraint fk_cr_table_ref_315_cr_tab foreign key (dest_table_name) references cr_table_source(table_name);
1307 -- NAME: FK_CR_TABLE_REF_32384_CR_TABLE; TYPE: FK CONSTRAINT
1309 alter table cr_table_role
1310 add constraint fk_cr_table_ref_32384_cr_table foreign key (table_name) references cr_table_source(table_name);
1312 -- NAME: FK_FN_TAB_FUNCTION_CD; TYPE: FK CONSTRAINT
1315 add constraint fk_fn_tab_function_cd foreign key (function_cd) references fn_function(function_cd);
1317 -- NAME: FK_FN_TAB_SELECTED_TAB_CD; TYPE: FK CONSTRAINT
1319 alter table fn_tab_selected
1320 add constraint fk_fn_tab_selected_tab_cd foreign key (selected_tab_cd) references fn_tab(tab_cd);
1322 -- NAME: FK_FN_TAB_SET_CD; TYPE: FK CONSTRAINT
1325 add constraint fk_fn_tab_set_cd foreign key (tab_set_cd) references fn_lu_tab_set(tab_set_cd);
1327 -- NAME: FK_FN_USER_REF_110_FN_ORG; TYPE: FK CONSTRAINT
1330 add constraint fk_fn_user_ref_110_fn_org foreign key (org_id) references fn_org(org_id);
1332 -- NAME: FK_FN_USER_REF_123_FN_LU_AL; TYPE: FK CONSTRAINT
1335 add constraint fk_fn_user_ref_123_fn_lu_al foreign key (alert_method_cd) references fn_lu_alert_method(alert_method_cd);
1337 -- NAME: FK_FN_USER_REF_197_FN_USER; TYPE: FK CONSTRAINT
1340 add constraint fk_fn_user_ref_197_fn_user foreign key (manager_id) references fn_user(user_id);
1342 -- NAME: FK_FN_USER_REF_198_FN_USER; TYPE: FK CONSTRAINT
1345 add constraint fk_fn_user_ref_198_fn_user foreign key (created_id) references fn_user(user_id);
1347 -- NAME: FK_FN_USER_REF_199_FN_USER; TYPE: FK CONSTRAINT
1350 add constraint fk_fn_user_ref_199_fn_user foreign key (modified_id) references fn_user(user_id);
1352 -- NAME: FK_PARENT_KEY_CR_FOLDER; TYPE: FK CONSTRAINT
1354 alter table cr_folder
1355 add constraint fk_parent_key_cr_folder foreign key (parent_folder_id) references cr_folder(folder_id);
1357 -- NAME: FK_PSEUDO_ROLE_PSEUDO_ROLE_ID; TYPE: FK CONSTRAINT
1359 alter table fn_user_pseudo_role
1360 add constraint fk_pseudo_role_pseudo_role_id foreign key (pseudo_role_id) references fn_role(role_id);
1362 -- NAME: FK_PSEUDO_ROLE_USER_ID; TYPE: FK CONSTRAINT
1364 alter table fn_user_pseudo_role
1365 add constraint fk_pseudo_role_user_id foreign key (user_id) references fn_user(user_id);
1367 -- NAME: FK_TIMEZONE; TYPE: FK CONSTRAINT
1370 add constraint fk_timezone foreign key (timezone) references fn_lu_timezone(timezone_id);
1372 -- NAME: SYS_C0014614; TYPE: FK CONSTRAINT
1374 alter table cr_report_file_history
1375 add constraint sys_c0014614 foreign key (file_type_id) references cr_lu_file_type(lookup_id);
1377 -- NAME: SYS_C0014615; TYPE: FK CONSTRAINT
1379 alter table cr_report_file_history
1380 add constraint sys_c0014615 foreign key (rep_id) references cr_report(rep_id);
1382 -- NAME: SYS_C0014616; TYPE: FK CONSTRAINT
1384 alter table cr_hist_user_map
1385 add constraint sys_c0014616 foreign key (hist_id) references cr_report_file_history(hist_id);
1387 -- NAME: SYS_C0014617; TYPE: FK CONSTRAINT
1389 alter table cr_hist_user_map
1390 add constraint sys_c0014617 foreign key (user_id) references fn_user(user_id);