2 * ============LICENSE_START=======================================================
4 * ================================================================================
5 * Copyright (C) 2017 AT&T Intellectual Property. All rights reserved.
6 * ================================================================================
7 * Licensed under the Apache License, Version 2.0 (the "License");
8 * you may not use this file except in compliance with the License.
9 * You may obtain a copy of the License at
11 * http://www.apache.org/licenses/LICENSE-2.0
13 * Unless required by applicable law or agreed to in writing, software
14 * distributed under the License is distributed on an "AS IS" BASIS,
15 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
16 * See the License for the specific language governing permissions and
17 * limitations under the License.
18 * ============LICENSE_END=========================================================
20 -- ----------------------------------------------------------------------------
21 -- MySQL Workbench Migration
22 -- Migrated Schemata: vid_openecomp
23 -- Source Schemata: ecomp_sd
24 -- Created: Sun Nov 13 08:58:53 2016
25 -- Workbench Version: 6.3.6
26 -- ----------------------------------------------------------------------------
28 SET FOREIGN_KEY_CHECKS = 0;
30 -- ----------------------------------------------------------------------------
31 -- Schema vid_openecomp
32 -- ----------------------------------------------------------------------------
33 CREATE SCHEMA IF NOT EXISTS `vid_openecomp` ;
36 -- ----------------------------------------------------------------------------
37 -- Table vid_openecomp.cr_favorite_reports
38 -- ----------------------------------------------------------------------------
39 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_favorite_reports` (
40 `USER_ID` INT(11) NOT NULL,
41 `REP_ID` INT(11) NOT NULL,
42 PRIMARY KEY (`USER_ID`, `REP_ID`))
44 DEFAULT CHARACTER SET = utf8;
46 -- ----------------------------------------------------------------------------
47 -- Table vid_openecomp.cr_filehist_log
48 -- ----------------------------------------------------------------------------
49 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_filehist_log` (
50 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
51 `URL` VARCHAR(4000) NULL DEFAULT NULL,
52 `NOTES` VARCHAR(3500) NULL DEFAULT NULL,
53 `RUN_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
55 DEFAULT CHARACTER SET = utf8;
57 -- ----------------------------------------------------------------------------
58 -- Table vid_openecomp.cr_folder
59 -- ----------------------------------------------------------------------------
60 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_folder` (
61 `FOLDER_ID` INT(11) NOT NULL,
62 `FOLDER_NAME` VARCHAR(50) NOT NULL,
63 `DESCR` VARCHAR(500) NULL DEFAULT NULL,
64 `CREATE_ID` INT(11) NOT NULL,
65 `CREATE_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
66 `PARENT_FOLDER_ID` INT(11) NULL DEFAULT NULL,
67 `PUBLIC_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
68 PRIMARY KEY (`FOLDER_ID`),
69 INDEX `fk_parent_key_cr_folder` (`PARENT_FOLDER_ID` ASC),
70 CONSTRAINT `fk_parent_key_cr_folder`
71 FOREIGN KEY (`PARENT_FOLDER_ID`)
72 REFERENCES `vid_openecomp`.`cr_folder` (`FOLDER_ID`))
74 DEFAULT CHARACTER SET = utf8;
76 -- ----------------------------------------------------------------------------
77 -- Table vid_openecomp.cr_folder_access
78 -- ----------------------------------------------------------------------------
79 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_folder_access` (
80 `FOLDER_ACCESS_ID` DECIMAL(11,0) NOT NULL,
81 `FOLDER_ID` DECIMAL(11,0) NOT NULL,
82 `ORDER_NO` DECIMAL(11,0) NOT NULL,
83 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
84 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
85 `READ_ONLY_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
86 PRIMARY KEY (`FOLDER_ACCESS_ID`))
88 DEFAULT CHARACTER SET = utf8;
90 -- ----------------------------------------------------------------------------
91 -- Table vid_openecomp.cr_hist_user_map
92 -- ----------------------------------------------------------------------------
93 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_hist_user_map` (
94 `HIST_ID` INT(11) NOT NULL,
95 `USER_ID` INT(11) NOT NULL,
96 PRIMARY KEY (`HIST_ID`, `USER_ID`),
97 INDEX `sys_c0014617` (`USER_ID` ASC),
98 CONSTRAINT `sys_c0014616`
99 FOREIGN KEY (`HIST_ID`)
100 REFERENCES `vid_openecomp`.`cr_report_file_history` (`HIST_ID`),
101 CONSTRAINT `sys_c0014617`
102 FOREIGN KEY (`USER_ID`)
103 REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`))
105 DEFAULT CHARACTER SET = utf8;
107 -- ----------------------------------------------------------------------------
108 -- Table vid_openecomp.cr_lu_file_type
109 -- ----------------------------------------------------------------------------
110 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_lu_file_type` (
111 `LOOKUP_ID` DECIMAL(2,0) NOT NULL,
112 `LOOKUP_DESCR` VARCHAR(255) NOT NULL,
113 `ACTIVE_YN` CHAR(1) NULL DEFAULT 'Y',
114 `ERROR_CODE` DECIMAL(11,0) NULL DEFAULT NULL,
115 PRIMARY KEY (`LOOKUP_ID`))
117 DEFAULT CHARACTER SET = utf8;
119 -- ----------------------------------------------------------------------------
120 -- Table vid_openecomp.cr_raptor_action_img
121 -- ----------------------------------------------------------------------------
122 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_raptor_action_img` (
123 `IMAGE_ID` VARCHAR(100) NOT NULL,
124 `IMAGE_LOC` VARCHAR(400) NULL DEFAULT NULL,
125 PRIMARY KEY (`IMAGE_ID`))
127 DEFAULT CHARACTER SET = utf8;
129 -- ----------------------------------------------------------------------------
130 -- Table vid_openecomp.cr_raptor_pdf_img
131 -- ----------------------------------------------------------------------------
132 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_raptor_pdf_img` (
133 `IMAGE_ID` VARCHAR(100) NOT NULL,
134 `IMAGE_LOC` VARCHAR(400) NULL DEFAULT NULL,
135 PRIMARY KEY (`IMAGE_ID`))
137 DEFAULT CHARACTER SET = utf8;
139 -- ----------------------------------------------------------------------------
140 -- Table vid_openecomp.cr_remote_schema_info
141 -- ----------------------------------------------------------------------------
142 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_remote_schema_info` (
143 `SCHEMA_PREFIX` VARCHAR(5) NOT NULL,
144 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
145 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
146 PRIMARY KEY (`SCHEMA_PREFIX`))
148 DEFAULT CHARACTER SET = utf8;
150 -- ----------------------------------------------------------------------------
151 -- Table vid_openecomp.cr_report
152 -- ----------------------------------------------------------------------------
153 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report` (
154 `REP_ID` DECIMAL(11,0) NOT NULL,
155 `TITLE` VARCHAR(100) NOT NULL,
156 `DESCR` VARCHAR(255) NULL DEFAULT NULL,
157 `PUBLIC_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
158 `REPORT_XML` TEXT NULL DEFAULT NULL,
159 `CREATE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
160 `CREATE_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
161 `MAINT_ID` DECIMAL(11,0) NULL DEFAULT NULL,
162 `MAINT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
163 `MENU_ID` VARCHAR(500) NULL DEFAULT NULL,
164 `MENU_APPROVED_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
165 `OWNER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
166 `FOLDER_ID` INT(11) NULL DEFAULT '0',
167 `DASHBOARD_TYPE_YN` VARCHAR(1) NULL DEFAULT 'N',
168 `DASHBOARD_YN` VARCHAR(1) NULL DEFAULT 'N',
169 PRIMARY KEY (`REP_ID`),
170 INDEX `cr_report_create_idpublic_yntitle` (`CREATE_ID` ASC, `PUBLIC_YN` ASC, `TITLE` ASC))
172 DEFAULT CHARACTER SET = utf8;
174 -- ----------------------------------------------------------------------------
175 -- Table vid_openecomp.cr_report_access
176 -- ----------------------------------------------------------------------------
177 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_access` (
178 `REP_ID` DECIMAL(11,0) NOT NULL,
179 `ORDER_NO` DECIMAL(11,0) NOT NULL,
180 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
181 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
182 `READ_ONLY_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
183 PRIMARY KEY (`REP_ID`, `ORDER_NO`),
184 CONSTRAINT `fk_cr_repor_ref_8550_cr_repor`
185 FOREIGN KEY (`REP_ID`)
186 REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`))
188 DEFAULT CHARACTER SET = utf8;
190 -- ----------------------------------------------------------------------------
191 -- Table vid_openecomp.cr_report_dwnld_log
192 -- ----------------------------------------------------------------------------
193 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_dwnld_log` (
194 `USER_ID` DECIMAL(11,0) NOT NULL,
195 `REP_ID` INT(11) NOT NULL,
196 `FILE_NAME` VARCHAR(100) NOT NULL,
197 `DWNLD_START_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
198 `RECORD_READY_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
199 `FILTER_PARAMS` VARCHAR(2000) NULL DEFAULT NULL)
201 DEFAULT CHARACTER SET = utf8;
203 -- ----------------------------------------------------------------------------
204 -- Table vid_openecomp.cr_report_email_sent_log
205 -- ----------------------------------------------------------------------------
206 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_email_sent_log` (
207 `LOG_ID` INT(11) NOT NULL,
208 `SCHEDULE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
209 `GEN_KEY` VARCHAR(25) NOT NULL,
210 `REP_ID` DECIMAL(11,0) NOT NULL,
211 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
212 `SENT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
213 `ACCESS_FLAG` VARCHAR(1) NOT NULL DEFAULT 'Y',
214 `TOUCH_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
215 PRIMARY KEY (`LOG_ID`),
216 INDEX `fk_cr_report_rep_id` (`REP_ID` ASC),
217 CONSTRAINT `fk_cr_report_rep_id`
218 FOREIGN KEY (`REP_ID`)
219 REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`))
221 DEFAULT CHARACTER SET = utf8;
223 -- ----------------------------------------------------------------------------
224 -- Table vid_openecomp.cr_report_file_history
225 -- ----------------------------------------------------------------------------
226 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_file_history` (
227 `HIST_ID` INT(11) NOT NULL,
228 `SCHED_USER_ID` DECIMAL(11,0) NOT NULL,
229 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
230 `USER_ID` DECIMAL(11,0) NOT NULL,
231 `REP_ID` DECIMAL(11,0) NULL DEFAULT NULL,
232 `RUN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
233 `RECURRENCE` VARCHAR(50) NULL DEFAULT NULL,
234 `FILE_TYPE_ID` DECIMAL(2,0) NULL DEFAULT NULL,
235 `FILE_NAME` VARCHAR(80) NULL DEFAULT NULL,
236 `FILE_BLOB` BLOB NULL DEFAULT NULL,
237 `FILE_SIZE` DECIMAL(11,0) NULL DEFAULT NULL,
238 `RAPTOR_URL` VARCHAR(4000) NULL DEFAULT NULL,
239 `ERROR_YN` CHAR(1) NULL DEFAULT 'N',
240 `ERROR_CODE` DECIMAL(11,0) NULL DEFAULT NULL,
241 `DELETED_YN` CHAR(1) NULL DEFAULT 'N',
242 `DELETED_BY` DECIMAL(38,0) NULL DEFAULT NULL,
243 PRIMARY KEY (`HIST_ID`),
244 INDEX `sys_c0014614` (`FILE_TYPE_ID` ASC),
245 INDEX `sys_c0014615` (`REP_ID` ASC),
246 CONSTRAINT `sys_c0014614`
247 FOREIGN KEY (`FILE_TYPE_ID`)
248 REFERENCES `vid_openecomp`.`cr_lu_file_type` (`LOOKUP_ID`),
249 CONSTRAINT `sys_c0014615`
250 FOREIGN KEY (`REP_ID`)
251 REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`))
253 DEFAULT CHARACTER SET = utf8;
255 -- ----------------------------------------------------------------------------
256 -- Table vid_openecomp.cr_report_log
257 -- ----------------------------------------------------------------------------
258 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_log` (
259 `REP_ID` DECIMAL(11,0) NOT NULL,
260 `LOG_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
261 `USER_ID` DECIMAL(11,0) NOT NULL,
262 `ACTION` VARCHAR(2000) NOT NULL,
263 `ACTION_VALUE` VARCHAR(50) NULL DEFAULT NULL,
264 `FORM_FIELDS` VARCHAR(4000) NULL DEFAULT NULL,
265 INDEX `fk_cr_repor_ref_17645_cr_repor` (`REP_ID` ASC),
266 CONSTRAINT `fk_cr_repor_ref_17645_cr_repor`
267 FOREIGN KEY (`REP_ID`)
268 REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`))
270 DEFAULT CHARACTER SET = utf8;
272 -- ----------------------------------------------------------------------------
273 -- Table vid_openecomp.cr_report_schedule
274 -- ----------------------------------------------------------------------------
275 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_schedule` (
276 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
277 `SCHED_USER_ID` DECIMAL(11,0) NOT NULL,
278 `REP_ID` DECIMAL(11,0) NOT NULL,
279 `ENABLED_YN` VARCHAR(1) NOT NULL,
280 `START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
281 `END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
282 `RUN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
283 `RECURRENCE` VARCHAR(50) NULL DEFAULT NULL,
284 `CONDITIONAL_YN` VARCHAR(1) NOT NULL,
285 `CONDITION_SQL` VARCHAR(4000) NULL DEFAULT NULL,
286 `NOTIFY_TYPE` INT(11) NULL DEFAULT '0',
287 `MAX_ROW` INT(11) NULL DEFAULT '1000',
288 `INITIAL_FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
289 `PROCESSED_FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
290 `FORMFIELDS` VARCHAR(3500) NULL DEFAULT NULL,
291 `CONDITION_LARGE_SQL` TEXT NULL DEFAULT NULL,
292 `ENCRYPT_YN` CHAR(1) NULL DEFAULT 'N',
293 `ATTACHMENT_YN` CHAR(1) NULL DEFAULT 'Y',
294 PRIMARY KEY (`SCHEDULE_ID`),
295 INDEX `fk_cr_repor_ref_14707_cr_repor` (`REP_ID` ASC),
296 CONSTRAINT `fk_cr_repor_ref_14707_cr_repor`
297 FOREIGN KEY (`REP_ID`)
298 REFERENCES `vid_openecomp`.`cr_report` (`REP_ID`))
300 DEFAULT CHARACTER SET = utf8;
302 -- ----------------------------------------------------------------------------
303 -- Table vid_openecomp.cr_report_schedule_users
304 -- ----------------------------------------------------------------------------
305 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_schedule_users` (
306 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
307 `REP_ID` DECIMAL(11,0) NOT NULL,
308 `USER_ID` DECIMAL(11,0) NOT NULL,
309 `ROLE_ID` DECIMAL(11,0) NULL DEFAULT NULL,
310 `ORDER_NO` DECIMAL(11,0) NOT NULL,
311 PRIMARY KEY (`SCHEDULE_ID`, `REP_ID`, `USER_ID`, `ORDER_NO`),
312 CONSTRAINT `fk_cr_repor_ref_14716_cr_repor`
313 FOREIGN KEY (`SCHEDULE_ID`)
314 REFERENCES `vid_openecomp`.`cr_report_schedule` (`SCHEDULE_ID`))
316 DEFAULT CHARACTER SET = utf8;
318 -- ----------------------------------------------------------------------------
319 -- Table vid_openecomp.cr_report_template_map
320 -- ----------------------------------------------------------------------------
321 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_report_template_map` (
322 `REPORT_ID` INT(11) NOT NULL,
323 `TEMPLATE_FILE` VARCHAR(200) NULL DEFAULT NULL,
324 PRIMARY KEY (`REPORT_ID`))
326 DEFAULT CHARACTER SET = utf8;
328 -- ----------------------------------------------------------------------------
329 -- Table vid_openecomp.cr_schedule_activity_log
330 -- ----------------------------------------------------------------------------
331 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_schedule_activity_log` (
332 `SCHEDULE_ID` DECIMAL(11,0) NOT NULL,
333 `URL` VARCHAR(4000) NULL DEFAULT NULL,
334 `NOTES` VARCHAR(2000) NULL DEFAULT NULL,
335 `RUN_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP)
337 DEFAULT CHARACTER SET = utf8;
339 -- ----------------------------------------------------------------------------
340 -- Table vid_openecomp.cr_table_join
341 -- ----------------------------------------------------------------------------
342 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_table_join` (
343 `SRC_TABLE_NAME` VARCHAR(30) NOT NULL,
344 `DEST_TABLE_NAME` VARCHAR(30) NOT NULL,
345 `JOIN_EXPR` VARCHAR(500) NOT NULL,
346 INDEX `cr_table_join_dest_table_name` (`DEST_TABLE_NAME` ASC),
347 INDEX `cr_table_join_src_table_name` (`SRC_TABLE_NAME` ASC),
348 CONSTRAINT `fk_cr_table_ref_311_cr_tab`
349 FOREIGN KEY (`SRC_TABLE_NAME`)
350 REFERENCES `vid_openecomp`.`cr_table_source` (`TABLE_NAME`),
351 CONSTRAINT `fk_cr_table_ref_315_cr_tab`
352 FOREIGN KEY (`DEST_TABLE_NAME`)
353 REFERENCES `vid_openecomp`.`cr_table_source` (`TABLE_NAME`))
355 DEFAULT CHARACTER SET = utf8;
357 -- ----------------------------------------------------------------------------
358 -- Table vid_openecomp.cr_table_role
359 -- ----------------------------------------------------------------------------
360 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_table_role` (
361 `TABLE_NAME` VARCHAR(30) NOT NULL,
362 `ROLE_ID` DECIMAL(11,0) NOT NULL,
363 PRIMARY KEY (`TABLE_NAME`, `ROLE_ID`),
364 CONSTRAINT `fk_cr_table_ref_32384_cr_table`
365 FOREIGN KEY (`TABLE_NAME`)
366 REFERENCES `vid_openecomp`.`cr_table_source` (`TABLE_NAME`))
368 DEFAULT CHARACTER SET = utf8;
370 -- ----------------------------------------------------------------------------
371 -- Table vid_openecomp.cr_table_source
372 -- ----------------------------------------------------------------------------
373 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`cr_table_source` (
374 `TABLE_NAME` VARCHAR(30) NOT NULL,
375 `DISPLAY_NAME` VARCHAR(30) NOT NULL,
376 `PK_FIELDS` VARCHAR(200) NULL DEFAULT NULL,
377 `WEB_VIEW_ACTION` VARCHAR(50) NULL DEFAULT NULL,
378 `LARGE_DATA_SOURCE_YN` VARCHAR(1) NOT NULL DEFAULT 'N',
379 `FILTER_SQL` VARCHAR(4000) NULL DEFAULT NULL,
380 `SOURCE_DB` VARCHAR(50) NULL DEFAULT NULL,
381 PRIMARY KEY (`TABLE_NAME`))
383 DEFAULT CHARACTER SET = utf8;
385 -- ----------------------------------------------------------------------------
386 -- Table vid_openecomp.demo_bar_chart
387 -- ----------------------------------------------------------------------------
388 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_bar_chart` (
389 `label` VARCHAR(20) NULL DEFAULT NULL,
390 `value` DECIMAL(25,15) NULL DEFAULT NULL)
392 DEFAULT CHARACTER SET = utf8;
394 -- ----------------------------------------------------------------------------
395 -- Table vid_openecomp.demo_bar_chart_inter
396 -- ----------------------------------------------------------------------------
397 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_bar_chart_inter` (
398 `spam_date` DATE NULL DEFAULT NULL,
399 `num_rpt_sources` DECIMAL(10,0) NULL DEFAULT NULL,
400 `num_det_sources` DECIMAL(10,0) NULL DEFAULT NULL)
402 DEFAULT CHARACTER SET = utf8;
404 -- ----------------------------------------------------------------------------
405 -- Table vid_openecomp.demo_line_chart
406 -- ----------------------------------------------------------------------------
407 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_line_chart` (
408 `series` VARCHAR(20) NULL DEFAULT NULL,
409 `log_date` DATE NULL DEFAULT NULL,
410 `data_value` DECIMAL(10,5) NULL DEFAULT NULL)
412 DEFAULT CHARACTER SET = utf8;
414 -- ----------------------------------------------------------------------------
415 -- Table vid_openecomp.demo_pie_chart
416 -- ----------------------------------------------------------------------------
417 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_pie_chart` (
418 `legend` VARCHAR(20) NULL DEFAULT NULL,
419 `data_value` DECIMAL(10,5) NULL DEFAULT NULL)
421 DEFAULT CHARACTER SET = utf8;
423 -- ----------------------------------------------------------------------------
424 -- Table vid_openecomp.demo_scatter_chart
425 -- ----------------------------------------------------------------------------
426 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_scatter_chart` (
427 `rainfall` DECIMAL(10,2) NULL DEFAULT NULL,
428 `key_value` VARCHAR(20) NULL DEFAULT NULL,
429 `measurements` DECIMAL(10,2) NULL DEFAULT NULL)
431 DEFAULT CHARACTER SET = utf8;
433 -- ----------------------------------------------------------------------------
434 -- Table vid_openecomp.demo_scatter_plot
435 -- ----------------------------------------------------------------------------
436 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_scatter_plot` (
437 `SERIES` VARCHAR(20) NULL DEFAULT NULL,
438 `VALUEX` DECIMAL(25,15) NULL DEFAULT NULL,
439 `VALUEY` DECIMAL(25,15) NULL DEFAULT NULL)
441 DEFAULT CHARACTER SET = utf8;
443 -- ----------------------------------------------------------------------------
444 -- Table vid_openecomp.demo_util_chart
445 -- ----------------------------------------------------------------------------
446 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`demo_util_chart` (
447 `traffic_date` DATE NULL DEFAULT NULL,
448 `util_perc` DECIMAL(10,5) NULL DEFAULT NULL)
450 DEFAULT CHARACTER SET = utf8;
452 -- ----------------------------------------------------------------------------
453 -- Table vid_openecomp.fn_app
454 -- ----------------------------------------------------------------------------
455 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_app` (
456 `APP_ID` INT(11) NOT NULL AUTO_INCREMENT,
457 `APP_NAME` VARCHAR(100) NOT NULL DEFAULT '?',
458 `APP_IMAGE_URL` VARCHAR(256) NULL DEFAULT NULL,
459 `APP_DESCRIPTION` VARCHAR(512) NULL DEFAULT NULL,
460 `APP_NOTES` VARCHAR(4096) NULL DEFAULT NULL,
461 `APP_URL` VARCHAR(256) NULL DEFAULT NULL,
462 `APP_ALTERNATE_URL` VARCHAR(256) NULL DEFAULT NULL,
463 `APP_REST_ENDPOINT` VARCHAR(2000) NULL DEFAULT NULL,
464 `ML_APP_NAME` VARCHAR(50) NOT NULL DEFAULT '?',
465 `ML_APP_ADMIN_ID` VARCHAR(7) NOT NULL DEFAULT '?',
466 `MOTS_ID` INT(11) NULL DEFAULT NULL,
467 `APP_PASSWORD` VARCHAR(256) NOT NULL DEFAULT '?',
468 `OPEN` CHAR(1) NULL DEFAULT 'N',
469 `ENABLED` CHAR(1) NULL DEFAULT 'Y',
470 `THUMBNAIL` MEDIUMBLOB NULL DEFAULT NULL,
471 `APP_USERNAME` VARCHAR(50) NULL DEFAULT NULL,
472 `UEB_KEY` VARCHAR(256) NULL DEFAULT NULL,
473 `UEB_SECRET` VARCHAR(256) NULL DEFAULT NULL,
474 `UEB_TOPIC_NAME` VARCHAR(256) NULL DEFAULT NULL,
475 PRIMARY KEY (`APP_ID`))
478 DEFAULT CHARACTER SET = utf8;
480 -- ----------------------------------------------------------------------------
481 -- Table vid_openecomp.fn_audit_action
482 -- ----------------------------------------------------------------------------
483 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_audit_action` (
484 `AUDIT_ACTION_ID` INT(11) NOT NULL,
485 `CLASS_NAME` VARCHAR(500) NOT NULL,
486 `METHOD_NAME` VARCHAR(50) NOT NULL,
487 `AUDIT_ACTION_CD` VARCHAR(20) NOT NULL,
488 `AUDIT_ACTION_DESC` VARCHAR(200) NULL DEFAULT NULL,
489 `ACTIVE_YN` VARCHAR(1) NULL DEFAULT NULL,
490 PRIMARY KEY (`AUDIT_ACTION_ID`))
492 DEFAULT CHARACTER SET = utf8;
494 -- ----------------------------------------------------------------------------
495 -- Table vid_openecomp.fn_audit_action_log
496 -- ----------------------------------------------------------------------------
497 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_audit_action_log` (
498 `AUDIT_LOG_ID` INT(11) NOT NULL AUTO_INCREMENT,
499 `AUDIT_ACTION_CD` VARCHAR(200) NULL DEFAULT NULL,
500 `ACTION_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
501 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
502 `CLASS_NAME` VARCHAR(100) NULL DEFAULT NULL,
503 `METHOD_NAME` VARCHAR(50) NULL DEFAULT NULL,
504 `SUCCESS_MSG` VARCHAR(20) NULL DEFAULT NULL,
505 `ERROR_MSG` VARCHAR(500) NULL DEFAULT NULL,
506 PRIMARY KEY (`AUDIT_LOG_ID`))
508 DEFAULT CHARACTER SET = utf8;
510 -- ----------------------------------------------------------------------------
511 -- Table vid_openecomp.fn_audit_log
512 -- ----------------------------------------------------------------------------
513 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_audit_log` (
514 `LOG_ID` INT(11) NOT NULL AUTO_INCREMENT,
515 `USER_ID` INT(11) NOT NULL,
516 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
517 `AUDIT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
518 `COMMENTS` VARCHAR(1000) NULL DEFAULT NULL,
519 `AFFECTED_RECORD_ID_BK` VARCHAR(500) NULL DEFAULT NULL,
520 `AFFECTED_RECORD_ID` VARCHAR(4000) NULL DEFAULT NULL,
521 PRIMARY KEY (`LOG_ID`),
522 INDEX `fn_audit_log_activity_cd` (`ACTIVITY_CD` ASC),
523 INDEX `fn_audit_log_user_id` (`USER_ID` ASC),
524 CONSTRAINT `FK_FN_AUDIT_REF_209_FN_USER`
525 FOREIGN KEY (`USER_ID`)
526 REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`),
527 CONSTRAINT `fk_fn_audit_ref_205_fn_lu_ac`
528 FOREIGN KEY (`ACTIVITY_CD`)
529 REFERENCES `vid_openecomp`.`fn_lu_activity` (`ACTIVITY_CD`))
531 DEFAULT CHARACTER SET = utf8;
533 -- ----------------------------------------------------------------------------
534 -- Table vid_openecomp.fn_broadcast_message
535 -- ----------------------------------------------------------------------------
536 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_broadcast_message` (
537 `MESSAGE_ID` INT(11) NOT NULL AUTO_INCREMENT,
538 `MESSAGE_TEXT` VARCHAR(1000) NOT NULL,
539 `MESSAGE_LOCATION_ID` DECIMAL(11,0) NOT NULL,
540 `BROADCAST_START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
541 `BROADCAST_END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
542 `ACTIVE_YN` CHAR(1) NOT NULL DEFAULT 'Y',
543 `SORT_ORDER` DECIMAL(4,0) NOT NULL,
544 `BROADCAST_SITE_CD` VARCHAR(50) NULL DEFAULT NULL,
545 PRIMARY KEY (`MESSAGE_ID`))
547 DEFAULT CHARACTER SET = utf8;
549 -- ----------------------------------------------------------------------------
550 -- Table vid_openecomp.fn_chat_logs
551 -- ----------------------------------------------------------------------------
552 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_chat_logs` (
553 `CHAT_LOG_ID` INT(11) NOT NULL,
554 `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL,
555 `USER_ID` INT(11) NULL DEFAULT NULL,
556 `MESSAGE` VARCHAR(1000) NULL DEFAULT NULL,
557 `MESSAGE_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
558 PRIMARY KEY (`CHAT_LOG_ID`))
560 DEFAULT CHARACTER SET = utf8;
562 -- ----------------------------------------------------------------------------
563 -- Table vid_openecomp.fn_chat_room
564 -- ----------------------------------------------------------------------------
565 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_chat_room` (
566 `CHAT_ROOM_ID` INT(11) NOT NULL,
567 `NAME` VARCHAR(50) NOT NULL,
568 `DESCRIPTION` VARCHAR(500) NULL DEFAULT NULL,
569 `OWNER_ID` INT(11) NULL DEFAULT NULL,
570 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
571 `UPDATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
572 PRIMARY KEY (`CHAT_ROOM_ID`))
574 DEFAULT CHARACTER SET = utf8;
576 -- ----------------------------------------------------------------------------
577 -- Table vid_openecomp.fn_chat_users
578 -- ----------------------------------------------------------------------------
579 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_chat_users` (
580 `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL,
581 `USER_ID` INT(11) NULL DEFAULT NULL,
582 `LAST_ACTIVITY_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
583 `CHAT_STATUS` VARCHAR(20) NULL DEFAULT NULL,
584 `ID` INT(11) NOT NULL,
587 DEFAULT CHARACTER SET = utf8;
589 -- ----------------------------------------------------------------------------
590 -- Table vid_openecomp.fn_datasource
591 -- ----------------------------------------------------------------------------
592 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_datasource` (
593 `ID` INT(11) NOT NULL AUTO_INCREMENT,
594 `NAME` VARCHAR(50) NULL DEFAULT NULL,
595 `DRIVER_NAME` VARCHAR(256) NULL DEFAULT NULL,
596 `SERVER` VARCHAR(256) NULL DEFAULT NULL,
597 `PORT` INT(11) NULL DEFAULT NULL,
598 `USER_NAME` VARCHAR(256) NULL DEFAULT NULL,
599 `PASSWORD` VARCHAR(256) NULL DEFAULT NULL,
600 `URL` VARCHAR(256) NULL DEFAULT NULL,
601 `MIN_POOL_SIZE` INT(11) NULL DEFAULT NULL,
602 `MAX_POOL_SIZE` INT(11) NULL DEFAULT NULL,
603 `ADAPTER_ID` INT(11) NULL DEFAULT NULL,
604 `DS_TYPE` VARCHAR(20) NULL DEFAULT NULL,
607 DEFAULT CHARACTER SET = utf8;
609 -- ----------------------------------------------------------------------------
610 -- Table vid_openecomp.fn_function
611 -- ----------------------------------------------------------------------------
612 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_function` (
613 `FUNCTION_CD` VARCHAR(30) NOT NULL,
614 `FUNCTION_NAME` VARCHAR(50) NOT NULL,
615 PRIMARY KEY (`FUNCTION_CD`))
617 DEFAULT CHARACTER SET = utf8;
619 -- ----------------------------------------------------------------------------
620 -- Table vid_openecomp.fn_lu_activity
621 -- ----------------------------------------------------------------------------
622 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_activity` (
623 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
624 `ACTIVITY` VARCHAR(50) NOT NULL,
625 PRIMARY KEY (`ACTIVITY_CD`))
627 DEFAULT CHARACTER SET = utf8;
629 -- ----------------------------------------------------------------------------
630 -- Table vid_openecomp.fn_lu_alert_method
631 -- ----------------------------------------------------------------------------
632 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_alert_method` (
633 `ALERT_METHOD_CD` VARCHAR(10) NOT NULL,
634 `ALERT_METHOD` VARCHAR(50) NOT NULL,
635 PRIMARY KEY (`ALERT_METHOD_CD`))
637 DEFAULT CHARACTER SET = utf8;
639 -- ----------------------------------------------------------------------------
640 -- Table vid_openecomp.fn_lu_broadcast_site
641 -- ----------------------------------------------------------------------------
642 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_broadcast_site` (
643 `BROADCAST_SITE_CD` VARCHAR(50) NOT NULL,
644 `BROADCAST_SITE_DESCR` VARCHAR(100) NULL DEFAULT NULL,
645 PRIMARY KEY (`BROADCAST_SITE_CD`))
647 DEFAULT CHARACTER SET = utf8;
649 -- ----------------------------------------------------------------------------
650 -- Table vid_openecomp.fn_lu_menu_set
651 -- ----------------------------------------------------------------------------
652 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_menu_set` (
653 `MENU_SET_CD` VARCHAR(10) NOT NULL,
654 `MENU_SET_NAME` VARCHAR(50) NOT NULL,
655 PRIMARY KEY (`MENU_SET_CD`))
657 DEFAULT CHARACTER SET = utf8;
659 -- ----------------------------------------------------------------------------
660 -- Table vid_openecomp.fn_lu_message_location
661 -- ----------------------------------------------------------------------------
662 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_message_location` (
663 `message_location_id` DECIMAL(11,0) NOT NULL,
664 `message_location_descr` VARCHAR(30) NOT NULL,
665 PRIMARY KEY (`message_location_id`))
667 DEFAULT CHARACTER SET = utf8;
669 -- ----------------------------------------------------------------------------
670 -- Table vid_openecomp.fn_lu_priority
671 -- ----------------------------------------------------------------------------
672 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_priority` (
673 `PRIORITY_ID` DECIMAL(11,0) NOT NULL,
674 `PRIORITY` VARCHAR(50) NOT NULL,
675 `ACTIVE_YN` CHAR(1) NOT NULL,
676 `SORT_ORDER` DECIMAL(5,0) NULL DEFAULT NULL,
677 PRIMARY KEY (`PRIORITY_ID`))
679 DEFAULT CHARACTER SET = utf8;
681 -- ----------------------------------------------------------------------------
682 -- Table vid_openecomp.fn_lu_role_type
683 -- ----------------------------------------------------------------------------
684 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_role_type` (
685 `ROLE_TYPE_ID` DECIMAL(11,0) NOT NULL,
686 `ROLE_TYPE` VARCHAR(50) NOT NULL,
687 PRIMARY KEY (`ROLE_TYPE_ID`))
689 DEFAULT CHARACTER SET = utf8;
691 -- ----------------------------------------------------------------------------
692 -- Table vid_openecomp.fn_lu_tab_set
693 -- ----------------------------------------------------------------------------
694 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_tab_set` (
695 `TAB_SET_CD` VARCHAR(30) NOT NULL,
696 `TAB_SET_NAME` VARCHAR(50) NOT NULL,
697 PRIMARY KEY (`TAB_SET_CD`))
699 DEFAULT CHARACTER SET = utf8;
701 -- ----------------------------------------------------------------------------
702 -- Table vid_openecomp.fn_lu_timezone
703 -- ----------------------------------------------------------------------------
704 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_lu_timezone` (
705 `TIMEZONE_ID` INT(11) NOT NULL,
706 `TIMEZONE_NAME` VARCHAR(100) NOT NULL,
707 `TIMEZONE_VALUE` VARCHAR(100) NOT NULL,
708 PRIMARY KEY (`TIMEZONE_ID`))
710 DEFAULT CHARACTER SET = utf8;
712 -- ----------------------------------------------------------------------------
713 -- Table vid_openecomp.fn_menu
714 -- ----------------------------------------------------------------------------
715 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_menu` (
716 `MENU_ID` INT(11) NOT NULL AUTO_INCREMENT,
717 `LABEL` VARCHAR(100) NULL DEFAULT NULL,
718 `PARENT_ID` INT(11) NULL DEFAULT NULL,
719 `SORT_ORDER` DECIMAL(4,0) NULL DEFAULT NULL,
720 `ACTION` VARCHAR(200) NULL DEFAULT NULL,
721 `FUNCTION_CD` VARCHAR(30) NULL DEFAULT NULL,
722 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
723 `SERVLET` VARCHAR(50) NULL DEFAULT NULL,
724 `QUERY_STRING` VARCHAR(200) NULL DEFAULT NULL,
725 `EXTERNAL_URL` VARCHAR(200) NULL DEFAULT NULL,
726 `TARGET` VARCHAR(25) NULL DEFAULT NULL,
727 `MENU_SET_CD` VARCHAR(10) NULL DEFAULT 'APP',
728 `SEPARATOR_YN` CHAR(1) NULL DEFAULT 'N',
729 `IMAGE_SRC` VARCHAR(100) NULL DEFAULT NULL,
730 PRIMARY KEY (`MENU_ID`),
731 INDEX `FK_FN_MENU_REF_196_FN_MENU` (`PARENT_ID` ASC),
732 INDEX `FK_FN_MENU_MENU_SET_CD` (`MENU_SET_CD` ASC),
733 INDEX `fn_menu_function_cd` (`FUNCTION_CD` ASC),
734 CONSTRAINT `FK_FN_MENU_MENU_SET_CD`
735 FOREIGN KEY (`MENU_SET_CD`)
736 REFERENCES `vid_openecomp`.`fn_lu_menu_set` (`MENU_SET_CD`),
737 CONSTRAINT `FK_FN_MENU_REF_196_FN_MENU`
738 FOREIGN KEY (`PARENT_ID`)
739 REFERENCES `vid_openecomp`.`fn_menu` (`MENU_ID`),
740 CONSTRAINT `FK_FN_MENU_REF_223_FN_FUNCT`
741 FOREIGN KEY (`FUNCTION_CD`)
742 REFERENCES `vid_openecomp`.`fn_function` (`FUNCTION_CD`))
744 AUTO_INCREMENT = 150039
745 DEFAULT CHARACTER SET = utf8;
747 -- ----------------------------------------------------------------------------
748 -- Table vid_openecomp.fn_org
749 -- ----------------------------------------------------------------------------
750 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_org` (
751 `ORG_ID` INT(11) NOT NULL,
752 `ORG_NAME` VARCHAR(50) NOT NULL,
753 `ACCESS_CD` VARCHAR(10) NULL DEFAULT NULL,
754 PRIMARY KEY (`ORG_ID`),
755 INDEX `fn_org_access_cd` (`ACCESS_CD` ASC))
757 DEFAULT CHARACTER SET = utf8;
759 -- ----------------------------------------------------------------------------
760 -- Table vid_openecomp.fn_qz_blob_triggers
761 -- ----------------------------------------------------------------------------
762 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_blob_triggers` (
763 `SCHED_NAME` VARCHAR(120) NOT NULL,
764 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
765 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
766 `BLOB_DATA` BLOB NULL DEFAULT NULL,
767 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
768 INDEX `SCHED_NAME` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
769 CONSTRAINT `fn_qz_blob_triggers_ibfk_1`
770 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
771 REFERENCES `vid_openecomp`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
773 DEFAULT CHARACTER SET = utf8;
775 -- ----------------------------------------------------------------------------
776 -- Table vid_openecomp.fn_qz_calendars
777 -- ----------------------------------------------------------------------------
778 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_calendars` (
779 `SCHED_NAME` VARCHAR(120) NOT NULL,
780 `CALENDAR_NAME` VARCHAR(200) NOT NULL,
781 `CALENDAR` BLOB NOT NULL,
782 PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`))
784 DEFAULT CHARACTER SET = utf8;
786 -- ----------------------------------------------------------------------------
787 -- Table vid_openecomp.fn_qz_cron_triggers
788 -- ----------------------------------------------------------------------------
789 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_cron_triggers` (
790 `SCHED_NAME` VARCHAR(120) NOT NULL,
791 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
792 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
793 `CRON_EXPRESSION` VARCHAR(120) NOT NULL,
794 `TIME_ZONE_ID` VARCHAR(80) NULL DEFAULT NULL,
795 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
796 CONSTRAINT `fn_qz_cron_triggers_ibfk_1`
797 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
798 REFERENCES `vid_openecomp`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
800 DEFAULT CHARACTER SET = utf8;
802 -- ----------------------------------------------------------------------------
803 -- Table vid_openecomp.fn_qz_fired_triggers
804 -- ----------------------------------------------------------------------------
805 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_fired_triggers` (
806 `SCHED_NAME` VARCHAR(120) NOT NULL,
807 `ENTRY_ID` VARCHAR(95) NOT NULL,
808 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
809 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
810 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
811 `FIRED_TIME` BIGINT(13) NOT NULL,
812 `SCHED_TIME` BIGINT(13) NOT NULL,
813 `PRIORITY` INT(11) NOT NULL,
814 `STATE` VARCHAR(16) NOT NULL,
815 `JOB_NAME` VARCHAR(200) NULL DEFAULT NULL,
816 `JOB_GROUP` VARCHAR(200) NULL DEFAULT NULL,
817 `IS_NONCONCURRENT` VARCHAR(1) NULL DEFAULT NULL,
818 `REQUESTS_RECOVERY` VARCHAR(1) NULL DEFAULT NULL,
819 PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`),
820 INDEX `idx_fn_qz_ft_trig_inst_name` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC),
821 INDEX `idx_fn_qz_ft_inst_job_req_rcvry` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC),
822 INDEX `idx_fn_qz_ft_j_g` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
823 INDEX `idx_fn_qz_ft_jg` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
824 INDEX `idx_fn_qz_ft_t_g` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
825 INDEX `idx_fn_qz_ft_tg` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC))
827 DEFAULT CHARACTER SET = utf8;
829 -- ----------------------------------------------------------------------------
830 -- Table vid_openecomp.fn_qz_job_details
831 -- ----------------------------------------------------------------------------
832 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_job_details` (
833 `SCHED_NAME` VARCHAR(120) NOT NULL,
834 `JOB_NAME` VARCHAR(200) NOT NULL,
835 `JOB_GROUP` VARCHAR(200) NOT NULL,
836 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
837 `JOB_CLASS_NAME` VARCHAR(250) NOT NULL,
838 `IS_DURABLE` VARCHAR(1) NOT NULL,
839 `IS_NONCONCURRENT` VARCHAR(1) NOT NULL,
840 `IS_UPDATE_DATA` VARCHAR(1) NOT NULL,
841 `REQUESTS_RECOVERY` VARCHAR(1) NOT NULL,
842 `JOB_DATA` BLOB NULL DEFAULT NULL,
843 PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`),
844 INDEX `idx_fn_qz_j_req_recovery` (`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC),
845 INDEX `idx_fn_qz_j_grp` (`SCHED_NAME` ASC, `JOB_GROUP` ASC))
847 DEFAULT CHARACTER SET = utf8;
849 -- ----------------------------------------------------------------------------
850 -- Table vid_openecomp.fn_qz_locks
851 -- ----------------------------------------------------------------------------
852 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_locks` (
853 `SCHED_NAME` VARCHAR(120) NOT NULL,
854 `LOCK_NAME` VARCHAR(40) NOT NULL,
855 PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`))
857 DEFAULT CHARACTER SET = utf8;
859 -- ----------------------------------------------------------------------------
860 -- Table vid_openecomp.fn_qz_paused_trigger_grps
861 -- ----------------------------------------------------------------------------
862 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_paused_trigger_grps` (
863 `SCHED_NAME` VARCHAR(120) NOT NULL,
864 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
865 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`))
867 DEFAULT CHARACTER SET = utf8;
869 -- ----------------------------------------------------------------------------
870 -- Table vid_openecomp.fn_qz_scheduler_state
871 -- ----------------------------------------------------------------------------
872 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_scheduler_state` (
873 `SCHED_NAME` VARCHAR(120) NOT NULL,
874 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
875 `LAST_CHECKIN_TIME` BIGINT(13) NOT NULL,
876 `CHECKIN_INTERVAL` BIGINT(13) NOT NULL,
877 PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`))
879 DEFAULT CHARACTER SET = utf8;
881 -- ----------------------------------------------------------------------------
882 -- Table vid_openecomp.fn_qz_simple_triggers
883 -- ----------------------------------------------------------------------------
884 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_simple_triggers` (
885 `SCHED_NAME` VARCHAR(120) NOT NULL,
886 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
887 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
888 `REPEAT_COUNT` BIGINT(7) NOT NULL,
889 `REPEAT_INTERVAL` BIGINT(12) NOT NULL,
890 `TIMES_TRIGGERED` BIGINT(10) NOT NULL,
891 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
892 CONSTRAINT `fn_qz_simple_triggers_ibfk_1`
893 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
894 REFERENCES `vid_openecomp`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
896 DEFAULT CHARACTER SET = utf8;
898 -- ----------------------------------------------------------------------------
899 -- Table vid_openecomp.fn_qz_simprop_triggers
900 -- ----------------------------------------------------------------------------
901 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_simprop_triggers` (
902 `SCHED_NAME` VARCHAR(120) NOT NULL,
903 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
904 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
905 `STR_PROP_1` VARCHAR(512) NULL DEFAULT NULL,
906 `STR_PROP_2` VARCHAR(512) NULL DEFAULT NULL,
907 `STR_PROP_3` VARCHAR(512) NULL DEFAULT NULL,
908 `INT_PROP_1` INT(11) NULL DEFAULT NULL,
909 `INT_PROP_2` INT(11) NULL DEFAULT NULL,
910 `LONG_PROP_1` BIGINT(20) NULL DEFAULT NULL,
911 `LONG_PROP_2` BIGINT(20) NULL DEFAULT NULL,
912 `DEC_PROP_1` DECIMAL(13,4) NULL DEFAULT NULL,
913 `DEC_PROP_2` DECIMAL(13,4) NULL DEFAULT NULL,
914 `BOOL_PROP_1` VARCHAR(1) NULL DEFAULT NULL,
915 `BOOL_PROP_2` VARCHAR(1) NULL DEFAULT NULL,
916 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
917 CONSTRAINT `fn_qz_simprop_triggers_ibfk_1`
918 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
919 REFERENCES `vid_openecomp`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
921 DEFAULT CHARACTER SET = utf8;
923 -- ----------------------------------------------------------------------------
924 -- Table vid_openecomp.fn_qz_triggers
925 -- ----------------------------------------------------------------------------
926 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_qz_triggers` (
927 `SCHED_NAME` VARCHAR(120) NOT NULL,
928 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
929 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
930 `JOB_NAME` VARCHAR(200) NOT NULL,
931 `JOB_GROUP` VARCHAR(200) NOT NULL,
932 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
933 `NEXT_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
934 `PREV_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
935 `PRIORITY` INT(11) NULL DEFAULT NULL,
936 `TRIGGER_STATE` VARCHAR(16) NOT NULL,
937 `TRIGGER_TYPE` VARCHAR(8) NOT NULL,
938 `START_TIME` BIGINT(13) NOT NULL,
939 `END_TIME` BIGINT(13) NULL DEFAULT NULL,
940 `CALENDAR_NAME` VARCHAR(200) NULL DEFAULT NULL,
941 `MISFIRE_INSTR` SMALLINT(2) NULL DEFAULT NULL,
942 `JOB_DATA` BLOB NULL DEFAULT NULL,
943 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
944 INDEX `idx_fn_qz_t_j` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
945 INDEX `idx_fn_qz_t_jg` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
946 INDEX `idx_fn_qz_t_c` (`SCHED_NAME` ASC, `CALENDAR_NAME` ASC),
947 INDEX `idx_fn_qz_t_g` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC),
948 INDEX `idx_fn_qz_t_state` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC),
949 INDEX `idx_fn_qz_t_n_state` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
950 INDEX `idx_fn_qz_t_n_g_state` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
951 INDEX `idx_fn_qz_t_next_fire_time` (`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC),
952 INDEX `idx_fn_qz_t_nft_st` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC),
953 INDEX `idx_fn_qz_t_nft_misfire` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC),
954 INDEX `idx_fn_qz_t_nft_st_misfire` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC),
955 INDEX `idx_fn_qz_t_nft_st_misfire_grp` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_GROUP` ASC,
957 `TRIGGER_STATE` ASC),
958 CONSTRAINT `fn_qz_triggers_ibfk_1`
959 FOREIGN KEY (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`)
960 REFERENCES `vid_openecomp`.`fn_qz_job_details` (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`))
962 DEFAULT CHARACTER SET = utf8;
964 -- ----------------------------------------------------------------------------
965 -- Table vid_openecomp.fn_restricted_url
966 -- ----------------------------------------------------------------------------
967 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_restricted_url` (
968 `RESTRICTED_URL` VARCHAR(250) NOT NULL,
969 `FUNCTION_CD` VARCHAR(30) NOT NULL,
970 PRIMARY KEY (`RESTRICTED_URL`, `FUNCTION_CD`),
971 INDEX `fk_restricted_url_function_cd` (`FUNCTION_CD` ASC),
972 CONSTRAINT `fk_restricted_url_function_cd`
973 FOREIGN KEY (`FUNCTION_CD`)
974 REFERENCES `vid_openecomp`.`fn_function` (`FUNCTION_CD`))
976 DEFAULT CHARACTER SET = utf8;
978 -- ----------------------------------------------------------------------------
979 -- Table vid_openecomp.fn_role
980 -- ----------------------------------------------------------------------------
981 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_role` (
982 `ROLE_ID` INT(11) NOT NULL AUTO_INCREMENT,
983 `ROLE_NAME` VARCHAR(50) NOT NULL,
984 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
985 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
986 PRIMARY KEY (`ROLE_ID`))
989 DEFAULT CHARACTER SET = utf8;
991 -- ----------------------------------------------------------------------------
992 -- Table vid_openecomp.fn_role_composite
993 -- ----------------------------------------------------------------------------
994 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_role_composite` (
995 `PARENT_ROLE_ID` INT(11) NOT NULL,
996 `CHILD_ROLE_ID` INT(11) NOT NULL,
997 PRIMARY KEY (`PARENT_ROLE_ID`, `CHILD_ROLE_ID`),
998 INDEX `FK_FN_ROLE_COMPOSITE_CHILD` (`CHILD_ROLE_ID` ASC),
999 CONSTRAINT `FK_FN_ROLE_COMPOSITE_CHILD`
1000 FOREIGN KEY (`CHILD_ROLE_ID`)
1001 REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`),
1002 CONSTRAINT `FK_FN_ROLE_COMPOSITE_PARENT`
1003 FOREIGN KEY (`PARENT_ROLE_ID`)
1004 REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`))
1006 DEFAULT CHARACTER SET = utf8;
1008 -- ----------------------------------------------------------------------------
1009 -- Table vid_openecomp.fn_role_function
1010 -- ----------------------------------------------------------------------------
1011 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_role_function` (
1012 `ROLE_ID` INT(11) NOT NULL,
1013 `FUNCTION_CD` VARCHAR(30) NOT NULL,
1014 PRIMARY KEY (`ROLE_ID`, `FUNCTION_CD`),
1015 INDEX `fn_role_function_function_cd` (`FUNCTION_CD` ASC),
1016 INDEX `fn_role_function_role_id` (`ROLE_ID` ASC),
1017 CONSTRAINT `FK_FN_ROLE__REF_198_FN_ROLE`
1018 FOREIGN KEY (`ROLE_ID`)
1019 REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`),
1020 CONSTRAINT `fk_fn_role__ref_201_fn_funct`
1021 FOREIGN KEY (`FUNCTION_CD`)
1022 REFERENCES `vid_openecomp`.`fn_function` (`FUNCTION_CD`))
1024 DEFAULT CHARACTER SET = utf8;
1026 -- ----------------------------------------------------------------------------
1027 -- Table vid_openecomp.fn_schedule_workflows
1028 -- ----------------------------------------------------------------------------
1029 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_schedule_workflows` (
1030 `id_schedule_workflows` BIGINT(25) NOT NULL AUTO_INCREMENT,
1031 `workflow_server_url` VARCHAR(45) NULL DEFAULT NULL,
1032 `workflow_key` VARCHAR(45) NOT NULL,
1033 `workflow_arguments` VARCHAR(45) NULL DEFAULT NULL,
1034 `startDateTimeCron` VARCHAR(45) NULL DEFAULT NULL,
1035 `endDateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1036 `start_date_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1037 `recurrence` VARCHAR(45) NULL DEFAULT NULL,
1038 PRIMARY KEY (`id_schedule_workflows`))
1040 DEFAULT CHARACTER SET = utf8;
1042 -- ----------------------------------------------------------------------------
1043 -- Table vid_openecomp.fn_tab
1044 -- ----------------------------------------------------------------------------
1045 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_tab` (
1046 `TAB_CD` VARCHAR(30) NOT NULL,
1047 `TAB_NAME` VARCHAR(50) NOT NULL,
1048 `TAB_DESCR` VARCHAR(100) NULL DEFAULT NULL,
1049 `ACTION` VARCHAR(100) NOT NULL,
1050 `FUNCTION_CD` VARCHAR(30) NOT NULL,
1051 `ACTIVE_YN` CHAR(1) NOT NULL,
1052 `SORT_ORDER` DECIMAL(11,0) NOT NULL,
1053 `PARENT_TAB_CD` VARCHAR(30) NULL DEFAULT NULL,
1054 `TAB_SET_CD` VARCHAR(30) NULL DEFAULT NULL,
1055 PRIMARY KEY (`TAB_CD`),
1056 INDEX `fk_fn_tab_function_cd` (`FUNCTION_CD` ASC),
1057 INDEX `fk_fn_tab_set_cd` (`TAB_SET_CD` ASC),
1058 CONSTRAINT `fk_fn_tab_function_cd`
1059 FOREIGN KEY (`FUNCTION_CD`)
1060 REFERENCES `vid_openecomp`.`fn_function` (`FUNCTION_CD`),
1061 CONSTRAINT `fk_fn_tab_set_cd`
1062 FOREIGN KEY (`TAB_SET_CD`)
1063 REFERENCES `vid_openecomp`.`fn_lu_tab_set` (`TAB_SET_CD`))
1065 DEFAULT CHARACTER SET = utf8;
1067 -- ----------------------------------------------------------------------------
1068 -- Table vid_openecomp.fn_tab_selected
1069 -- ----------------------------------------------------------------------------
1070 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_tab_selected` (
1071 `SELECTED_TAB_CD` VARCHAR(30) NOT NULL,
1072 `TAB_URI` VARCHAR(40) NOT NULL,
1073 PRIMARY KEY (`SELECTED_TAB_CD`, `TAB_URI`),
1074 CONSTRAINT `fk_fn_tab_selected_tab_cd`
1075 FOREIGN KEY (`SELECTED_TAB_CD`)
1076 REFERENCES `vid_openecomp`.`fn_tab` (`TAB_CD`))
1078 DEFAULT CHARACTER SET = utf8;
1080 -- ----------------------------------------------------------------------------
1081 -- Table vid_openecomp.fn_user
1082 -- ----------------------------------------------------------------------------
1083 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_user` (
1084 `USER_ID` INT(11) NOT NULL AUTO_INCREMENT,
1085 `ORG_ID` INT(11) NULL DEFAULT NULL,
1086 `MANAGER_ID` INT(11) NULL DEFAULT NULL,
1087 `FIRST_NAME` VARCHAR(25) NULL DEFAULT NULL,
1088 `MIDDLE_NAME` VARCHAR(25) NULL DEFAULT NULL,
1089 `LAST_NAME` VARCHAR(25) NULL DEFAULT NULL,
1090 `PHONE` VARCHAR(25) NULL DEFAULT NULL,
1091 `FAX` VARCHAR(25) NULL DEFAULT NULL,
1092 `CELLULAR` VARCHAR(25) NULL DEFAULT NULL,
1093 `EMAIL` VARCHAR(50) NULL DEFAULT NULL,
1094 `ADDRESS_ID` DECIMAL(11,0) NULL DEFAULT NULL,
1095 `ALERT_METHOD_CD` VARCHAR(10) NULL DEFAULT NULL,
1096 `HRID` VARCHAR(20) NULL DEFAULT NULL,
1097 `ORG_USER_ID` VARCHAR(20) NULL DEFAULT NULL,
1098 `ORG_CODE` VARCHAR(30) NULL DEFAULT NULL,
1099 `LOGIN_ID` VARCHAR(25) NULL DEFAULT NULL,
1100 `LOGIN_PWD` VARCHAR(25) NULL DEFAULT NULL,
1101 `LAST_LOGIN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1102 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
1103 `CREATED_ID` INT(11) NULL DEFAULT NULL,
1104 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1105 `MODIFIED_ID` INT(11) NULL DEFAULT NULL,
1106 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1107 `IS_INTERNAL_YN` CHAR(1) NOT NULL DEFAULT 'N',
1108 `ADDRESS_LINE_1` VARCHAR(100) NULL DEFAULT NULL,
1109 `ADDRESS_LINE_2` VARCHAR(100) NULL DEFAULT NULL,
1110 `CITY` VARCHAR(50) NULL DEFAULT NULL,
1111 `STATE_CD` VARCHAR(3) NULL DEFAULT NULL,
1112 `ZIP_CODE` VARCHAR(11) NULL DEFAULT NULL,
1113 `COUNTRY_CD` VARCHAR(3) NULL DEFAULT NULL,
1114 `LOCATION_CLLI` VARCHAR(8) NULL DEFAULT NULL,
1115 `ORG_MANAGER_USERID` VARCHAR(20) NULL DEFAULT NULL,
1116 `COMPANY` VARCHAR(100) NULL DEFAULT NULL,
1117 `DEPARTMENT_NAME` VARCHAR(100) NULL DEFAULT NULL,
1118 `JOB_TITLE` VARCHAR(100) NULL DEFAULT NULL,
1119 `TIMEZONE` INT(11) NULL DEFAULT NULL,
1120 `DEPARTMENT` VARCHAR(25) NULL DEFAULT NULL,
1121 `BUSINESS_UNIT` VARCHAR(25) NULL DEFAULT NULL,
1122 `BUSINESS_UNIT_NAME` VARCHAR(100) NULL DEFAULT NULL,
1123 `COST_CENTER` VARCHAR(25) NULL DEFAULT NULL,
1124 `FIN_LOC_CODE` VARCHAR(10) NULL DEFAULT NULL,
1125 `SILO_STATUS` VARCHAR(10) NULL DEFAULT NULL,
1126 PRIMARY KEY (`USER_ID`),
1127 UNIQUE INDEX `fn_user_hrid` (`HRID` ASC),
1128 UNIQUE INDEX `fn_user_login_id` (`LOGIN_ID` ASC),
1129 INDEX `fn_user_address_id` (`ADDRESS_ID` ASC),
1130 INDEX `fn_user_alert_method_cd` (`ALERT_METHOD_CD` ASC),
1131 INDEX `fn_user_org_id` (`ORG_ID` ASC),
1132 INDEX `fk_fn_user_ref_197_fn_user` (`MANAGER_ID` ASC),
1133 INDEX `fk_fn_user_ref_198_fn_user` (`CREATED_ID` ASC),
1134 INDEX `fk_fn_user_ref_199_fn_user` (`MODIFIED_ID` ASC),
1135 INDEX `fk_timezone` (`TIMEZONE` ASC),
1136 CONSTRAINT `fk_fn_user_ref_110_fn_org`
1137 FOREIGN KEY (`ORG_ID`)
1138 REFERENCES `vid_openecomp`.`fn_org` (`ORG_ID`),
1139 CONSTRAINT `fk_fn_user_ref_123_fn_lu_al`
1140 FOREIGN KEY (`ALERT_METHOD_CD`)
1141 REFERENCES `vid_openecomp`.`fn_lu_alert_method` (`ALERT_METHOD_CD`),
1142 CONSTRAINT `fk_fn_user_ref_197_fn_user`
1143 FOREIGN KEY (`MANAGER_ID`)
1144 REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`),
1145 CONSTRAINT `fk_fn_user_ref_198_fn_user`
1146 FOREIGN KEY (`CREATED_ID`)
1147 REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`),
1148 CONSTRAINT `fk_fn_user_ref_199_fn_user`
1149 FOREIGN KEY (`MODIFIED_ID`)
1150 REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`),
1151 CONSTRAINT `fk_timezone`
1152 FOREIGN KEY (`TIMEZONE`)
1153 REFERENCES `vid_openecomp`.`fn_lu_timezone` (`TIMEZONE_ID`))
1156 DEFAULT CHARACTER SET = utf8;
1158 -- ----------------------------------------------------------------------------
1159 -- Table vid_openecomp.fn_user_pseudo_role
1160 -- ----------------------------------------------------------------------------
1161 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_user_pseudo_role` (
1162 `PSEUDO_ROLE_ID` INT(11) NOT NULL,
1163 `USER_ID` INT(11) NOT NULL,
1164 PRIMARY KEY (`PSEUDO_ROLE_ID`, `USER_ID`),
1165 INDEX `fk_pseudo_role_user_id` (`USER_ID` ASC),
1166 CONSTRAINT `fk_pseudo_role_pseudo_role_id`
1167 FOREIGN KEY (`PSEUDO_ROLE_ID`)
1168 REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`),
1169 CONSTRAINT `fk_pseudo_role_user_id`
1170 FOREIGN KEY (`USER_ID`)
1171 REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`))
1173 DEFAULT CHARACTER SET = utf8;
1175 -- ----------------------------------------------------------------------------
1176 -- Table vid_openecomp.fn_user_role
1177 -- ----------------------------------------------------------------------------
1178 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_user_role` (
1179 `USER_ID` INT(10) NOT NULL,
1180 `ROLE_ID` INT(10) NOT NULL,
1181 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
1182 `APP_ID` INT(11) NOT NULL DEFAULT '1',
1183 PRIMARY KEY (`USER_ID`, `ROLE_ID`, `APP_ID`),
1184 INDEX `fn_user_role_role_id` (`ROLE_ID` ASC),
1185 INDEX `fn_user_role_user_id` (`USER_ID` ASC),
1186 INDEX `fk_fn_user__ref_178_fn_app_IDX` (`APP_ID` ASC),
1187 CONSTRAINT `FK_FN_USER__REF_172_FN_USER`
1188 FOREIGN KEY (`USER_ID`)
1189 REFERENCES `vid_openecomp`.`fn_user` (`USER_ID`),
1190 CONSTRAINT `FK_FN_USER__REF_175_FN_ROLE`
1191 FOREIGN KEY (`ROLE_ID`)
1192 REFERENCES `vid_openecomp`.`fn_role` (`ROLE_ID`),
1193 CONSTRAINT `fk_fn_user__ref_178_fn_app`
1194 FOREIGN KEY (`APP_ID`)
1195 REFERENCES `vid_openecomp`.`fn_app` (`APP_ID`))
1197 DEFAULT CHARACTER SET = utf8;
1199 -- ----------------------------------------------------------------------------
1200 -- Table vid_openecomp.fn_workflow
1201 -- ----------------------------------------------------------------------------
1202 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`fn_workflow` (
1203 `id` MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
1204 `name` VARCHAR(20) NOT NULL,
1205 `description` VARCHAR(500) NULL DEFAULT NULL,
1206 `run_link` VARCHAR(300) NULL DEFAULT NULL,
1207 `suspend_link` VARCHAR(300) NULL DEFAULT NULL,
1208 `modified_link` VARCHAR(300) NULL DEFAULT NULL,
1209 `active_yn` VARCHAR(300) NULL DEFAULT NULL,
1210 `created` VARCHAR(300) NULL DEFAULT NULL,
1211 `created_by` INT(11) NULL DEFAULT NULL,
1212 `modified` VARCHAR(300) NULL DEFAULT NULL,
1213 `modified_by` INT(11) NULL DEFAULT NULL,
1214 `workflow_key` VARCHAR(50) NULL DEFAULT NULL,
1216 UNIQUE INDEX `name` (`name` ASC))
1218 DEFAULT CHARACTER SET = utf8;
1220 -- ----------------------------------------------------------------------------
1221 -- Table vid_openecomp.rcloudinvocation
1222 -- ----------------------------------------------------------------------------
1223 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`rcloudinvocation` (
1224 `id` VARCHAR(128) NOT NULL,
1225 `created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1226 `userinfo` VARCHAR(2048) NOT NULL,
1227 `notebookid` VARCHAR(128) NOT NULL,
1228 `parameters` VARCHAR(2048) NULL DEFAULT NULL,
1229 `tokenreaddate` TIMESTAMP NULL DEFAULT NULL,
1232 DEFAULT CHARACTER SET = utf8;
1234 -- ----------------------------------------------------------------------------
1235 -- Table vid_openecomp.rcloudnotebook
1236 -- ----------------------------------------------------------------------------
1237 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`rcloudnotebook` (
1238 `notebookname` VARCHAR(128) NOT NULL,
1239 `notebookid` VARCHAR(128) NOT NULL,
1240 PRIMARY KEY (`notebookname`))
1242 DEFAULT CHARACTER SET = utf8;
1244 -- ----------------------------------------------------------------------------
1245 -- Table vid_openecomp.schema_info
1246 -- ----------------------------------------------------------------------------
1247 CREATE TABLE IF NOT EXISTS `vid_openecomp`.`schema_info` (
1248 `SCHEMA_ID` VARCHAR(25) NOT NULL,
1249 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
1250 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
1251 `CONNECTION_URL` VARCHAR(200) NOT NULL,
1252 `USER_NAME` VARCHAR(45) NOT NULL,
1253 `PASSWORD` VARCHAR(45) NULL DEFAULT NULL,
1254 `DRIVER_CLASS` VARCHAR(100) NOT NULL,
1255 `MIN_POOL_SIZE` INT(11) NOT NULL,
1256 `MAX_POOL_SIZE` INT(11) NOT NULL,
1257 `IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL)
1259 DEFAULT CHARACTER SET = utf8;
1261 -- ----------------------------------------------------------------------------
1262 -- View vid_openecomp.v_url_access
1263 -- ----------------------------------------------------------------------------
1264 CREATE OR REPLACE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `v_url_access` AS select distinct `m`.`ACTION` AS
1266 `URL`,`m`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_menu` `m` where (`m`.`ACTION` is not null) union select distinct
1268 `t`.`ACTION` AS `URL`,`t`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_tab` `t` where (`t`.`ACTION` is not null) union select
1270 `r`.`RESTRICTED_URL` AS `URL`,`r`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_restricted_url` `r`;
1271 SET FOREIGN_KEY_CHECKS = 1;