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_epsdk
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_epsdk
32 -- ----------------------------------------------------------------------------
33 CREATE SCHEMA IF NOT EXISTS `vid_openecomp_epsdk` ;
35 USE vid_openecomp_epsdk;
36 -- ----------------------------------------------------------------------------
37 -- Table vid_openecomp_epsdk.cr_favorite_reports
38 -- ----------------------------------------------------------------------------
39 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_filehist_log
48 -- ----------------------------------------------------------------------------
49 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_folder
59 -- ----------------------------------------------------------------------------
60 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_folder` (`FOLDER_ID`))
74 DEFAULT CHARACTER SET = utf8;
76 -- ----------------------------------------------------------------------------
77 -- Table vid_openecomp_epsdk.cr_folder_access
78 -- ----------------------------------------------------------------------------
79 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_hist_user_map
92 -- ----------------------------------------------------------------------------
93 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_report_file_history` (`HIST_ID`),
101 CONSTRAINT `SYS_C0014617`
102 FOREIGN KEY (`USER_ID`)
103 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
105 DEFAULT CHARACTER SET = utf8;
107 -- ----------------------------------------------------------------------------
108 -- Table vid_openecomp_epsdk.cr_lu_file_type
109 -- ----------------------------------------------------------------------------
110 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_raptor_action_img
121 -- ----------------------------------------------------------------------------
122 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_raptor_pdf_img
131 -- ----------------------------------------------------------------------------
132 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_remote_schema_info
141 -- ----------------------------------------------------------------------------
142 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_report
152 -- ----------------------------------------------------------------------------
153 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_report_access
176 -- ----------------------------------------------------------------------------
177 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_report` (`REP_ID`))
188 DEFAULT CHARACTER SET = utf8;
190 -- ----------------------------------------------------------------------------
191 -- Table vid_openecomp_epsdk.cr_report_dwnld_log
192 -- ----------------------------------------------------------------------------
193 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_report_email_sent_log
205 -- ----------------------------------------------------------------------------
206 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_report` (`REP_ID`))
221 DEFAULT CHARACTER SET = utf8;
223 -- ----------------------------------------------------------------------------
224 -- Table vid_openecomp_epsdk.cr_report_file_history
225 -- ----------------------------------------------------------------------------
226 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_lu_file_type` (`LOOKUP_ID`),
249 CONSTRAINT `SYS_C0014615`
250 FOREIGN KEY (`REP_ID`)
251 REFERENCES `vid_openecomp_epsdk`.`cr_report` (`REP_ID`))
253 DEFAULT CHARACTER SET = utf8;
255 -- ----------------------------------------------------------------------------
256 -- Table vid_openecomp_epsdk.cr_report_log
257 -- ----------------------------------------------------------------------------
258 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_report` (`REP_ID`))
270 DEFAULT CHARACTER SET = utf8;
272 -- ----------------------------------------------------------------------------
273 -- Table vid_openecomp_epsdk.cr_report_schedule
274 -- ----------------------------------------------------------------------------
275 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_report` (`REP_ID`))
300 DEFAULT CHARACTER SET = utf8;
302 -- ----------------------------------------------------------------------------
303 -- Table vid_openecomp_epsdk.cr_report_schedule_users
304 -- ----------------------------------------------------------------------------
305 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_report_schedule` (`SCHEDULE_ID`))
316 DEFAULT CHARACTER SET = utf8;
318 -- ----------------------------------------------------------------------------
319 -- Table vid_openecomp_epsdk.cr_report_template_map
320 -- ----------------------------------------------------------------------------
321 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_schedule_activity_log
330 -- ----------------------------------------------------------------------------
331 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk.cr_table_join
341 -- ----------------------------------------------------------------------------
342 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_table_source` (`TABLE_NAME`),
351 CONSTRAINT `FK_CR_TABLE_REF_315_CR_TAB`
352 FOREIGN KEY (`DEST_TABLE_NAME`)
353 REFERENCES `vid_openecomp_epsdk`.`cr_table_source` (`TABLE_NAME`))
355 DEFAULT CHARACTER SET = utf8;
357 -- ----------------------------------------------------------------------------
358 -- Table vid_openecomp_epsdk.cr_table_role
359 -- ----------------------------------------------------------------------------
360 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_epsdk`.`cr_table_source` (`TABLE_NAME`))
368 DEFAULT CHARACTER SET = utf8;
370 -- ----------------------------------------------------------------------------
371 -- Table vid_openecomp_epsdk.cr_table_source
372 -- ----------------------------------------------------------------------------
373 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`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_portal.fn_app
387 -- ----------------------------------------------------------------------------
388 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_app` (
389 `APP_ID` INT(11) NOT NULL AUTO_INCREMENT,
390 `APP_NAME` VARCHAR(100) NOT NULL DEFAULT '?',
391 `APP_IMAGE_URL` VARCHAR(256) NULL DEFAULT NULL,
392 `APP_DESCRIPTION` VARCHAR(512) NULL DEFAULT NULL,
393 `APP_NOTES` VARCHAR(4096) NULL DEFAULT NULL,
394 `APP_URL` VARCHAR(256) NULL DEFAULT NULL,
395 `APP_ALTERNATE_URL` VARCHAR(256) NULL DEFAULT NULL,
396 `APP_REST_ENDPOINT` VARCHAR(2000) NULL DEFAULT NULL,
397 `ML_APP_NAME` VARCHAR(50) NOT NULL DEFAULT '?',
398 `ML_APP_ADMIN_ID` VARCHAR(7) NOT NULL DEFAULT '?',
399 `MOTS_ID` INT(11) NULL DEFAULT NULL,
400 `APP_PASSWORD` VARCHAR(256) NOT NULL DEFAULT '?',
401 `OPEN` CHAR(1) NULL DEFAULT 'N',
402 `ENABLED` CHAR(1) NULL DEFAULT 'Y',
403 `THUMBNAIL` MEDIUMBLOB NULL DEFAULT NULL,
404 `APP_USERNAME` VARCHAR(50) NULL DEFAULT NULL,
405 `UEB_KEY` VARCHAR(256) NULL DEFAULT NULL,
406 `UEB_SECRET` VARCHAR(256) NULL DEFAULT NULL,
407 `UEB_TOPIC_NAME` VARCHAR(256) NULL DEFAULT NULL,
408 PRIMARY KEY (`APP_ID`))
411 DEFAULT CHARACTER SET = utf8;
413 -- ----------------------------------------------------------------------------
414 -- Table vid_openecomp_epsdk.fn_app_mme_cpu
415 -- ----------------------------------------------------------------------------
416 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_app_mme_cpu` (
417 `MME` VARCHAR(200) NULL DEFAULT NULL,
418 `YEARMONTH` INT(11) NULL DEFAULT NULL,
419 `SCTP_CPU` INT(11) NULL DEFAULT NULL,
420 `AP_CPU` INT(11) NULL DEFAULT NULL,
421 `DP_CPU` INT(11) NULL DEFAULT NULL,
422 `ROUTER_CPU` INT(11) NULL DEFAULT NULL,
423 `PEB_CPU` INT(11) NULL DEFAULT NULL,
424 `SAU` INT(11) NULL DEFAULT NULL)
426 DEFAULT CHARACTER SET = utf8;
428 -- ----------------------------------------------------------------------------
429 -- Table vid_openecomp_epsdk.fn_audit_action
430 -- ----------------------------------------------------------------------------
431 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_action` (
432 `AUDIT_ACTION_ID` INT(11) NOT NULL,
433 `CLASS_NAME` VARCHAR(500) NOT NULL,
434 `METHOD_NAME` VARCHAR(50) NOT NULL,
435 `AUDIT_ACTION_CD` VARCHAR(20) NOT NULL,
436 `AUDIT_ACTION_DESC` VARCHAR(200) NULL DEFAULT NULL,
437 `ACTIVE_YN` VARCHAR(1) NULL DEFAULT NULL,
438 PRIMARY KEY (`AUDIT_ACTION_ID`))
440 DEFAULT CHARACTER SET = utf8;
442 -- ----------------------------------------------------------------------------
443 -- Table vid_openecomp_epsdk.fn_audit_action_log
444 -- ----------------------------------------------------------------------------
445 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_action_log` (
446 `AUDIT_LOG_ID` INT(11) NOT NULL AUTO_INCREMENT,
447 `AUDIT_ACTION_CD` VARCHAR(200) NULL DEFAULT NULL,
448 `ACTION_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
449 `USER_ID` DECIMAL(11,0) NULL DEFAULT NULL,
450 `CLASS_NAME` VARCHAR(100) NULL DEFAULT NULL,
451 `METHOD_NAME` VARCHAR(50) NULL DEFAULT NULL,
452 `SUCCESS_MSG` VARCHAR(20) NULL DEFAULT NULL,
453 `ERROR_MSG` VARCHAR(500) NULL DEFAULT NULL,
454 PRIMARY KEY (`AUDIT_LOG_ID`))
456 DEFAULT CHARACTER SET = utf8;
458 -- ----------------------------------------------------------------------------
459 -- Table vid_openecomp_epsdk.fn_audit_log
460 -- ----------------------------------------------------------------------------
461 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_audit_log` (
462 `LOG_ID` INT(11) NOT NULL AUTO_INCREMENT,
463 `USER_ID` INT(11) NOT NULL,
464 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
465 `AUDIT_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
466 `COMMENTS` VARCHAR(1000) NULL DEFAULT NULL,
467 `AFFECTED_RECORD_ID_BK` VARCHAR(500) NULL DEFAULT NULL,
468 `AFFECTED_RECORD_ID` VARCHAR(4000) NULL DEFAULT NULL,
469 PRIMARY KEY (`LOG_ID`),
470 INDEX `FN_AUDIT_LOG_ACTIVITY_CD` (`ACTIVITY_CD` ASC),
471 INDEX `FN_AUDIT_LOG_USER_ID` (`USER_ID` ASC),
472 CONSTRAINT `FK_FN_AUDIT_REF_205_FN_LU_AC`
473 FOREIGN KEY (`ACTIVITY_CD`)
474 REFERENCES `vid_openecomp_epsdk`.`fn_lu_activity` (`ACTIVITY_CD`),
475 CONSTRAINT `FK_FN_AUDIT_REF_209_FN_USER`
476 FOREIGN KEY (`USER_ID`)
477 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
479 DEFAULT CHARACTER SET = utf8;
481 -- ----------------------------------------------------------------------------
482 -- Table vid_openecomp_epsdk.fn_broadcast_message
483 -- ----------------------------------------------------------------------------
484 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_broadcast_message` (
485 `MESSAGE_ID` INT(11) NOT NULL AUTO_INCREMENT,
486 `MESSAGE_TEXT` VARCHAR(1000) NOT NULL,
487 `MESSAGE_LOCATION_ID` DECIMAL(11,0) NOT NULL,
488 `BROADCAST_START_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
489 `BROADCAST_END_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
490 `ACTIVE_YN` CHAR(1) NOT NULL DEFAULT 'Y',
491 `SORT_ORDER` DECIMAL(4,0) NOT NULL,
492 `BROADCAST_SITE_CD` VARCHAR(50) NULL DEFAULT NULL,
493 PRIMARY KEY (`MESSAGE_ID`))
495 DEFAULT CHARACTER SET = utf8;
497 -- ----------------------------------------------------------------------------
498 -- Table vid_openecomp_epsdk.fn_chat_logs
499 -- ----------------------------------------------------------------------------
500 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_logs` (
501 `CHAT_LOG_ID` INT(11) NOT NULL,
502 `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL,
503 `USER_ID` INT(11) NULL DEFAULT NULL,
504 `MESSAGE` VARCHAR(1000) NULL DEFAULT NULL,
505 `MESSAGE_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
506 PRIMARY KEY (`CHAT_LOG_ID`))
508 DEFAULT CHARACTER SET = utf8;
510 -- ----------------------------------------------------------------------------
511 -- Table vid_openecomp_epsdk.fn_chat_room
512 -- ----------------------------------------------------------------------------
513 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_room` (
514 `CHAT_ROOM_ID` INT(11) NOT NULL,
515 `NAME` VARCHAR(50) NOT NULL,
516 `DESCRIPTION` VARCHAR(500) NULL DEFAULT NULL,
517 `OWNER_ID` INT(11) NULL DEFAULT NULL,
518 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
519 `UPDATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
520 PRIMARY KEY (`CHAT_ROOM_ID`))
522 DEFAULT CHARACTER SET = utf8;
524 -- ----------------------------------------------------------------------------
525 -- Table vid_openecomp_epsdk.fn_chat_users
526 -- ----------------------------------------------------------------------------
527 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_chat_users` (
528 `CHAT_ROOM_ID` INT(11) NULL DEFAULT NULL,
529 `USER_ID` INT(11) NULL DEFAULT NULL,
530 `LAST_ACTIVITY_DATE_TIME` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
531 `CHAT_STATUS` VARCHAR(20) NULL DEFAULT NULL,
532 `ID` INT(11) NOT NULL,
535 DEFAULT CHARACTER SET = utf8;
537 -- ----------------------------------------------------------------------------
538 -- Table vid_openecomp_epsdk.fn_datasource
539 -- ----------------------------------------------------------------------------
540 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_datasource` (
541 `ID` INT(11) NOT NULL AUTO_INCREMENT,
542 `NAME` VARCHAR(50) NULL DEFAULT NULL,
543 `DRIVER_NAME` VARCHAR(256) NULL DEFAULT NULL,
544 `SERVER` VARCHAR(256) NULL DEFAULT NULL,
545 `PORT` INT(11) NULL DEFAULT NULL,
546 `USER_NAME` VARCHAR(256) NULL DEFAULT NULL,
547 `PASSWORD` VARCHAR(256) NULL DEFAULT NULL,
548 `URL` VARCHAR(256) NULL DEFAULT NULL,
549 `MIN_POOL_SIZE` INT(11) NULL DEFAULT NULL,
550 `MAX_POOL_SIZE` INT(11) NULL DEFAULT NULL,
551 `ADAPTER_ID` INT(11) NULL DEFAULT NULL,
552 `DS_TYPE` VARCHAR(20) NULL DEFAULT NULL,
556 DEFAULT CHARACTER SET = utf8;
558 -- ----------------------------------------------------------------------------
559 -- Table vid_openecomp_epsdk.fn_function
560 -- ----------------------------------------------------------------------------
561 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_function` (
562 `FUNCTION_CD` VARCHAR(30) NOT NULL,
563 `FUNCTION_NAME` VARCHAR(50) NOT NULL,
564 `type` VARCHAR(20) NOT NULL,
565 `action` VARCHAR(20) NOT NULL,
566 PRIMARY KEY (`FUNCTION_CD`),
567 CONSTRAINT `function` UNIQUE (FUNCTION_CD,TYPE,ACTION))
569 DEFAULT CHARACTER SET = utf8;
571 -- ----------------------------------------------------------------------------
572 -- Table vid_openecomp_epsdk.fn_license
573 -- ----------------------------------------------------------------------------
574 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license` (
575 `id` DECIMAL(11,0) NOT NULL,
576 `app_id` DECIMAL(11,0) NOT NULL,
577 `ip_address` VARCHAR(100) NOT NULL,
578 `quantum_version_id` DECIMAL(11,0) NOT NULL,
579 `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
580 `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
581 `created_id` DECIMAL(11,0) NULL DEFAULT NULL,
582 `modified_id` DECIMAL(11,0) NULL DEFAULT NULL,
583 `end_date` TIMESTAMP NOT NULL DEFAULT '2036-01-19 03:14:07',
585 INDEX `fn_license_r02` (`quantum_version_id` ASC),
586 CONSTRAINT `fn_license_r02`
587 FOREIGN KEY (`quantum_version_id`)
588 REFERENCES `vid_openecomp_epsdk`.`fn_license_version` (`id`))
590 DEFAULT CHARACTER SET = utf8;
592 -- ----------------------------------------------------------------------------
593 -- Table vid_openecomp_epsdk.fn_license_app
594 -- ----------------------------------------------------------------------------
595 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_app` (
596 `id` DECIMAL(11,0) NOT NULL,
597 `app_name` VARCHAR(100) NOT NULL,
598 `ctxt_name` VARCHAR(100) NULL DEFAULT NULL,
599 INDEX `fn_license_app_ID` (`id` ASC))
601 DEFAULT CHARACTER SET = utf8;
603 -- ----------------------------------------------------------------------------
604 -- Table vid_openecomp_epsdk.fn_license_contact
605 -- ----------------------------------------------------------------------------
606 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_contact` (
607 `id` INT(11) NOT NULL,
608 `license_id` INT(11) NULL DEFAULT NULL,
609 `sbcid` VARCHAR(20) NULL DEFAULT NULL,
612 DEFAULT CHARACTER SET = utf8;
614 -- ----------------------------------------------------------------------------
615 -- Table vid_openecomp_epsdk.fn_license_history
616 -- ----------------------------------------------------------------------------
617 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_history` (
618 `license_id` DECIMAL(11,0) NULL DEFAULT NULL,
619 `app_id` DECIMAL(11,0) NULL DEFAULT NULL,
620 `ip_address` VARCHAR(100) NULL DEFAULT NULL,
621 `quantum_version_id` DECIMAL(11,0) NULL DEFAULT NULL,
622 `created_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
623 `modified_date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
624 `created_id` DECIMAL(11,0) NULL DEFAULT NULL,
625 `modified_id` DECIMAL(11,0) NULL DEFAULT NULL,
626 `id` DECIMAL(11,0) NOT NULL,
629 DEFAULT CHARACTER SET = utf8;
631 -- ----------------------------------------------------------------------------
632 -- Table vid_openecomp_epsdk.fn_license_version
633 -- ----------------------------------------------------------------------------
634 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_license_version` (
635 `id` DECIMAL(11,0) NOT NULL,
636 `quantum_version` VARCHAR(25) NULL DEFAULT NULL,
639 DEFAULT CHARACTER SET = utf8;
641 -- ----------------------------------------------------------------------------
642 -- Table vid_openecomp_epsdk.fn_lu_activity
643 -- ----------------------------------------------------------------------------
644 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_activity` (
645 `ACTIVITY_CD` VARCHAR(50) NOT NULL,
646 `ACTIVITY` VARCHAR(50) NOT NULL,
647 PRIMARY KEY (`ACTIVITY_CD`))
649 DEFAULT CHARACTER SET = utf8;
651 -- ----------------------------------------------------------------------------
652 -- Table vid_openecomp_epsdk.fn_lu_alert_method
653 -- ----------------------------------------------------------------------------
654 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_alert_method` (
655 `ALERT_METHOD_CD` VARCHAR(10) NOT NULL,
656 `ALERT_METHOD` VARCHAR(50) NOT NULL,
657 PRIMARY KEY (`ALERT_METHOD_CD`))
659 DEFAULT CHARACTER SET = utf8;
661 -- ----------------------------------------------------------------------------
662 -- Table vid_openecomp_epsdk.fn_lu_broadcast_site
663 -- ----------------------------------------------------------------------------
664 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_broadcast_site` (
665 `BROADCAST_SITE_CD` VARCHAR(50) NOT NULL,
666 `BROADCAST_SITE_DESCR` VARCHAR(100) NULL DEFAULT NULL,
667 PRIMARY KEY (`BROADCAST_SITE_CD`))
669 DEFAULT CHARACTER SET = utf8;
671 -- ----------------------------------------------------------------------------
672 -- Table vid_openecomp_epsdk.fn_lu_call_times
673 -- ----------------------------------------------------------------------------
674 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_call_times` (
675 `CALL_TIME_ID` DECIMAL(10,0) NOT NULL,
676 `CALL_TIME_AMOUNT` DECIMAL(10,0) NOT NULL,
677 `CALL_TIME_DISPLAY` VARCHAR(50) NOT NULL,
678 PRIMARY KEY (`CALL_TIME_ID`))
680 DEFAULT CHARACTER SET = utf8;
682 -- ----------------------------------------------------------------------------
683 -- Table vid_openecomp_epsdk.fn_lu_city
684 -- ----------------------------------------------------------------------------
685 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_city` (
686 `CITY_CD` VARCHAR(2) NOT NULL,
687 `CITY` VARCHAR(100) NOT NULL,
688 `STATE_CD` VARCHAR(2) NOT NULL,
689 PRIMARY KEY (`CITY_CD`, `STATE_CD`))
691 DEFAULT CHARACTER SET = utf8;
693 -- ----------------------------------------------------------------------------
694 -- Table vid_openecomp_epsdk.fn_lu_country
695 -- ----------------------------------------------------------------------------
696 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_country` (
697 `COUNTRY_CD` VARCHAR(3) NOT NULL,
698 `COUNTRY` VARCHAR(100) NOT NULL,
699 `FULL_NAME` VARCHAR(100) NULL DEFAULT NULL,
700 `WEBPHONE_COUNTRY_LABEL` VARCHAR(30) NULL DEFAULT NULL,
701 PRIMARY KEY (`COUNTRY_CD`))
703 DEFAULT CHARACTER SET = utf8;
705 -- ----------------------------------------------------------------------------
706 -- Table vid_openecomp_epsdk.fn_lu_menu_set
707 -- ----------------------------------------------------------------------------
708 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_menu_set` (
709 `MENU_SET_CD` VARCHAR(10) NOT NULL,
710 `MENU_SET_NAME` VARCHAR(50) NOT NULL,
711 PRIMARY KEY (`MENU_SET_CD`))
713 DEFAULT CHARACTER SET = utf8;
715 -- ----------------------------------------------------------------------------
716 -- Table vid_openecomp_epsdk.fn_lu_priority
717 -- ----------------------------------------------------------------------------
718 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_priority` (
719 `PRIORITY_ID` DECIMAL(11,0) NOT NULL,
720 `PRIORITY` VARCHAR(50) NOT NULL,
721 `ACTIVE_YN` CHAR(1) NOT NULL,
722 `SORT_ORDER` DECIMAL(5,0) NULL DEFAULT NULL,
723 PRIMARY KEY (`PRIORITY_ID`))
725 DEFAULT CHARACTER SET = utf8;
727 -- ----------------------------------------------------------------------------
728 -- Table vid_openecomp_epsdk.fn_lu_role_type
729 -- ----------------------------------------------------------------------------
730 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_role_type` (
731 `ROLE_TYPE_ID` DECIMAL(11,0) NOT NULL,
732 `ROLE_TYPE` VARCHAR(50) NOT NULL,
733 PRIMARY KEY (`ROLE_TYPE_ID`))
735 DEFAULT CHARACTER SET = utf8;
737 -- ----------------------------------------------------------------------------
738 -- Table vid_openecomp_epsdk.fn_lu_state
739 -- ----------------------------------------------------------------------------
740 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_state` (
741 `STATE_CD` VARCHAR(2) NOT NULL,
742 `STATE` VARCHAR(100) NOT NULL,
743 PRIMARY KEY (`STATE_CD`))
745 DEFAULT CHARACTER SET = utf8;
747 -- ----------------------------------------------------------------------------
748 -- Table vid_openecomp_epsdk.fn_lu_tab_set
749 -- ----------------------------------------------------------------------------
750 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_tab_set` (
751 `TAB_SET_CD` VARCHAR(30) NOT NULL,
752 `TAB_SET_NAME` VARCHAR(50) NOT NULL,
753 PRIMARY KEY (`TAB_SET_CD`))
755 DEFAULT CHARACTER SET = utf8;
757 -- ----------------------------------------------------------------------------
758 -- Table vid_openecomp_epsdk.fn_lu_timezone
759 -- ----------------------------------------------------------------------------
760 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_lu_timezone` (
761 `TIMEZONE_ID` INT(11) NOT NULL,
762 `TIMEZONE_NAME` VARCHAR(100) NOT NULL,
763 `TIMEZONE_VALUE` VARCHAR(100) NOT NULL,
764 PRIMARY KEY (`TIMEZONE_ID`))
766 DEFAULT CHARACTER SET = utf8;
768 -- ----------------------------------------------------------------------------
769 -- Table vid_openecomp_epsdk.fn_menu
770 -- ----------------------------------------------------------------------------
771 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_menu` (
772 `MENU_ID` INT(11) NOT NULL AUTO_INCREMENT,
773 `LABEL` VARCHAR(100) NULL DEFAULT NULL,
774 `PARENT_ID` INT(11) NULL DEFAULT NULL,
775 `SORT_ORDER` DECIMAL(4,0) NULL DEFAULT NULL,
776 `ACTION` VARCHAR(200) NULL DEFAULT NULL,
777 `FUNCTION_CD` VARCHAR(30) NULL DEFAULT NULL,
778 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
779 `SERVLET` VARCHAR(50) NULL DEFAULT NULL,
780 `QUERY_STRING` VARCHAR(200) NULL DEFAULT NULL,
781 `EXTERNAL_URL` VARCHAR(200) NULL DEFAULT NULL,
782 `TARGET` VARCHAR(25) NULL DEFAULT NULL,
783 `MENU_SET_CD` VARCHAR(10) NULL DEFAULT 'APP',
784 `SEPARATOR_YN` CHAR(1) NULL DEFAULT 'N',
785 `IMAGE_SRC` VARCHAR(100) NULL DEFAULT NULL,
786 PRIMARY KEY (`MENU_ID`),
787 INDEX `FK_FN_MENU_REF_196_FN_MENU` (`PARENT_ID` ASC),
788 INDEX `FK_FN_MENU_MENU_SET_CD` (`MENU_SET_CD` ASC),
789 INDEX `FN_MENU_FUNCTION_CD` (`FUNCTION_CD` ASC),
790 CONSTRAINT `FK_FN_MENU_MENU_SET_CD`
791 FOREIGN KEY (`MENU_SET_CD`)
792 REFERENCES `vid_openecomp_epsdk`.`fn_lu_menu_set` (`MENU_SET_CD`),
793 CONSTRAINT `FK_FN_MENU_REF_196_FN_MENU`
794 FOREIGN KEY (`PARENT_ID`)
795 REFERENCES `vid_openecomp_epsdk`.`fn_menu` (`MENU_ID`),
796 CONSTRAINT `FK_FN_MENU_REF_223_FN_FUNCT`
797 FOREIGN KEY (`FUNCTION_CD`)
798 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
800 AUTO_INCREMENT = 150029
801 DEFAULT CHARACTER SET = utf8;
803 -- ----------------------------------------------------------------------------
804 -- Table vid_openecomp_epsdk.fn_org
805 -- ----------------------------------------------------------------------------
806 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_org` (
807 `ORG_ID` INT(11) NOT NULL,
808 `ORG_NAME` VARCHAR(50) NOT NULL,
809 `ACCESS_CD` VARCHAR(10) NULL DEFAULT NULL,
810 PRIMARY KEY (`ORG_ID`),
811 INDEX `FN_ORG_ACCESS_CD` (`ACCESS_CD` ASC))
813 DEFAULT CHARACTER SET = utf8;
815 -- ----------------------------------------------------------------------------
816 -- Table vid_openecomp_epsdk.fn_qz_blob_triggers
817 -- ----------------------------------------------------------------------------
818 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_blob_triggers` (
819 `SCHED_NAME` VARCHAR(120) NOT NULL,
820 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
821 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
822 `BLOB_DATA` BLOB NULL DEFAULT NULL,
823 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
824 INDEX `SCHED_NAME` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
825 CONSTRAINT `fn_qz_blob_triggers_ibfk_1`
826 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
827 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
829 DEFAULT CHARACTER SET = utf8;
831 -- ----------------------------------------------------------------------------
832 -- Table vid_openecomp_epsdk.fn_qz_calendars
833 -- ----------------------------------------------------------------------------
834 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_calendars` (
835 `SCHED_NAME` VARCHAR(120) NOT NULL,
836 `CALENDAR_NAME` VARCHAR(200) NOT NULL,
837 `CALENDAR` BLOB NOT NULL,
838 PRIMARY KEY (`SCHED_NAME`, `CALENDAR_NAME`))
840 DEFAULT CHARACTER SET = utf8;
842 -- ----------------------------------------------------------------------------
843 -- Table vid_openecomp_epsdk.fn_qz_cron_triggers
844 -- ----------------------------------------------------------------------------
845 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_cron_triggers` (
846 `SCHED_NAME` VARCHAR(120) NOT NULL,
847 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
848 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
849 `CRON_EXPRESSION` VARCHAR(120) NOT NULL,
850 `TIME_ZONE_ID` VARCHAR(80) NULL DEFAULT NULL,
851 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
852 CONSTRAINT `fn_qz_cron_triggers_ibfk_1`
853 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
854 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
856 DEFAULT CHARACTER SET = utf8;
858 -- ----------------------------------------------------------------------------
859 -- Table vid_openecomp_epsdk.fn_qz_fired_triggers
860 -- ----------------------------------------------------------------------------
861 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_fired_triggers` (
862 `SCHED_NAME` VARCHAR(120) NOT NULL,
863 `ENTRY_ID` VARCHAR(95) NOT NULL,
864 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
865 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
866 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
867 `FIRED_TIME` BIGINT(13) NOT NULL,
868 `SCHED_TIME` BIGINT(13) NOT NULL,
869 `PRIORITY` INT(11) NOT NULL,
870 `STATE` VARCHAR(16) NOT NULL,
871 `JOB_NAME` VARCHAR(200) NULL DEFAULT NULL,
872 `JOB_GROUP` VARCHAR(200) NULL DEFAULT NULL,
873 `IS_NONCONCURRENT` VARCHAR(1) NULL DEFAULT NULL,
874 `REQUESTS_RECOVERY` VARCHAR(1) NULL DEFAULT NULL,
875 PRIMARY KEY (`SCHED_NAME`, `ENTRY_ID`),
876 INDEX `IDX_FN_QZ_FT_TRIG_INST_NAME` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC),
877 INDEX `IDX_FN_QZ_FT_INST_JOB_REQ_RCVRY` (`SCHED_NAME` ASC, `INSTANCE_NAME` ASC, `REQUESTS_RECOVERY` ASC),
878 INDEX `IDX_FN_QZ_FT_J_G` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
879 INDEX `IDX_FN_QZ_FT_JG` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
880 INDEX `IDX_FN_QZ_FT_T_G` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC),
881 INDEX `IDX_FN_QZ_FT_TG` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC))
883 DEFAULT CHARACTER SET = utf8;
885 -- ----------------------------------------------------------------------------
886 -- Table vid_openecomp_epsdk.fn_qz_job_details
887 -- ----------------------------------------------------------------------------
888 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_job_details` (
889 `SCHED_NAME` VARCHAR(120) NOT NULL,
890 `JOB_NAME` VARCHAR(200) NOT NULL,
891 `JOB_GROUP` VARCHAR(200) NOT NULL,
892 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
893 `JOB_CLASS_NAME` VARCHAR(250) NOT NULL,
894 `IS_DURABLE` VARCHAR(1) NOT NULL,
895 `IS_NONCONCURRENT` VARCHAR(1) NOT NULL,
896 `IS_UPDATE_DATA` VARCHAR(1) NOT NULL,
897 `REQUESTS_RECOVERY` VARCHAR(1) NOT NULL,
898 `JOB_DATA` BLOB NULL DEFAULT NULL,
899 PRIMARY KEY (`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`),
900 INDEX `IDX_FN_QZ_J_REQ_RECOVERY` (`SCHED_NAME` ASC, `REQUESTS_RECOVERY` ASC),
901 INDEX `IDX_FN_QZ_J_GRP` (`SCHED_NAME` ASC, `JOB_GROUP` ASC))
903 DEFAULT CHARACTER SET = utf8;
905 -- ----------------------------------------------------------------------------
906 -- Table vid_openecomp_epsdk.fn_qz_locks
907 -- ----------------------------------------------------------------------------
908 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_locks` (
909 `SCHED_NAME` VARCHAR(120) NOT NULL,
910 `LOCK_NAME` VARCHAR(40) NOT NULL,
911 PRIMARY KEY (`SCHED_NAME`, `LOCK_NAME`))
913 DEFAULT CHARACTER SET = utf8;
915 -- ----------------------------------------------------------------------------
916 -- Table vid_openecomp_epsdk.fn_qz_paused_trigger_grps
917 -- ----------------------------------------------------------------------------
918 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_paused_trigger_grps` (
919 `SCHED_NAME` VARCHAR(120) NOT NULL,
920 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
921 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_GROUP`))
923 DEFAULT CHARACTER SET = utf8;
925 -- ----------------------------------------------------------------------------
926 -- Table vid_openecomp_epsdk.fn_qz_scheduler_state
927 -- ----------------------------------------------------------------------------
928 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_scheduler_state` (
929 `SCHED_NAME` VARCHAR(120) NOT NULL,
930 `INSTANCE_NAME` VARCHAR(200) NOT NULL,
931 `LAST_CHECKIN_TIME` BIGINT(13) NOT NULL,
932 `CHECKIN_INTERVAL` BIGINT(13) NOT NULL,
933 PRIMARY KEY (`SCHED_NAME`, `INSTANCE_NAME`))
935 DEFAULT CHARACTER SET = utf8;
937 -- ----------------------------------------------------------------------------
938 -- Table vid_openecomp_epsdk.fn_qz_simple_triggers
939 -- ----------------------------------------------------------------------------
940 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_simple_triggers` (
941 `SCHED_NAME` VARCHAR(120) NOT NULL,
942 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
943 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
944 `REPEAT_COUNT` BIGINT(7) NOT NULL,
945 `REPEAT_INTERVAL` BIGINT(12) NOT NULL,
946 `TIMES_TRIGGERED` BIGINT(10) NOT NULL,
947 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
948 CONSTRAINT `fn_qz_simple_triggers_ibfk_1`
949 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
950 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
952 DEFAULT CHARACTER SET = utf8;
954 -- ----------------------------------------------------------------------------
955 -- Table vid_openecomp_epsdk.fn_qz_simprop_triggers
956 -- ----------------------------------------------------------------------------
957 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_simprop_triggers` (
958 `SCHED_NAME` VARCHAR(120) NOT NULL,
959 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
960 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
961 `STR_PROP_1` VARCHAR(512) NULL DEFAULT NULL,
962 `STR_PROP_2` VARCHAR(512) NULL DEFAULT NULL,
963 `STR_PROP_3` VARCHAR(512) NULL DEFAULT NULL,
964 `INT_PROP_1` INT(11) NULL DEFAULT NULL,
965 `INT_PROP_2` INT(11) NULL DEFAULT NULL,
966 `LONG_PROP_1` BIGINT(20) NULL DEFAULT NULL,
967 `LONG_PROP_2` BIGINT(20) NULL DEFAULT NULL,
968 `DEC_PROP_1` DECIMAL(13,4) NULL DEFAULT NULL,
969 `DEC_PROP_2` DECIMAL(13,4) NULL DEFAULT NULL,
970 `BOOL_PROP_1` VARCHAR(1) NULL DEFAULT NULL,
971 `BOOL_PROP_2` VARCHAR(1) NULL DEFAULT NULL,
972 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
973 CONSTRAINT `fn_qz_simprop_triggers_ibfk_1`
974 FOREIGN KEY (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`)
975 REFERENCES `vid_openecomp_epsdk`.`fn_qz_triggers` (`SCHED_NAME` , `TRIGGER_NAME` , `TRIGGER_GROUP`))
977 DEFAULT CHARACTER SET = utf8;
979 -- ----------------------------------------------------------------------------
980 -- Table vid_openecomp_epsdk.fn_qz_triggers
981 -- ----------------------------------------------------------------------------
982 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_qz_triggers` (
983 `SCHED_NAME` VARCHAR(120) NOT NULL,
984 `TRIGGER_NAME` VARCHAR(200) NOT NULL,
985 `TRIGGER_GROUP` VARCHAR(200) NOT NULL,
986 `JOB_NAME` VARCHAR(200) NOT NULL,
987 `JOB_GROUP` VARCHAR(200) NOT NULL,
988 `DESCRIPTION` VARCHAR(250) NULL DEFAULT NULL,
989 `NEXT_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
990 `PREV_FIRE_TIME` BIGINT(13) NULL DEFAULT NULL,
991 `PRIORITY` INT(11) NULL DEFAULT NULL,
992 `TRIGGER_STATE` VARCHAR(16) NOT NULL,
993 `TRIGGER_TYPE` VARCHAR(8) NOT NULL,
994 `START_TIME` BIGINT(13) NOT NULL,
995 `END_TIME` BIGINT(13) NULL DEFAULT NULL,
996 `CALENDAR_NAME` VARCHAR(200) NULL DEFAULT NULL,
997 `MISFIRE_INSTR` SMALLINT(2) NULL DEFAULT NULL,
998 `JOB_DATA` BLOB NULL DEFAULT NULL,
999 PRIMARY KEY (`SCHED_NAME`, `TRIGGER_NAME`, `TRIGGER_GROUP`),
1000 INDEX `IDX_FN_QZ_T_J` (`SCHED_NAME` ASC, `JOB_NAME` ASC, `JOB_GROUP` ASC),
1001 INDEX `IDX_FN_QZ_T_JG` (`SCHED_NAME` ASC, `JOB_GROUP` ASC),
1002 INDEX `IDX_FN_QZ_T_C` (`SCHED_NAME` ASC, `CALENDAR_NAME` ASC),
1003 INDEX `IDX_FN_QZ_T_G` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC),
1004 INDEX `IDX_FN_QZ_T_STATE` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC),
1005 INDEX `IDX_FN_QZ_T_N_STATE` (`SCHED_NAME` ASC, `TRIGGER_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
1006 INDEX `IDX_FN_QZ_T_N_G_STATE` (`SCHED_NAME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
1007 INDEX `IDX_FN_QZ_T_NEXT_FIRE_TIME` (`SCHED_NAME` ASC, `NEXT_FIRE_TIME` ASC),
1008 INDEX `IDX_FN_QZ_T_NFT_ST` (`SCHED_NAME` ASC, `TRIGGER_STATE` ASC, `NEXT_FIRE_TIME` ASC),
1009 INDEX `IDX_FN_QZ_T_NFT_MISFIRE` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC),
1010 INDEX `IDX_FN_QZ_T_NFT_ST_MISFIRE` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_STATE` ASC),
1011 INDEX `IDX_FN_QZ_T_NFT_ST_MISFIRE_GRP` (`SCHED_NAME` ASC, `MISFIRE_INSTR` ASC, `NEXT_FIRE_TIME` ASC, `TRIGGER_GROUP` ASC, `TRIGGER_STATE` ASC),
1012 CONSTRAINT `fn_qz_triggers_ibfk_1`
1013 FOREIGN KEY (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`)
1014 REFERENCES `vid_openecomp_epsdk`.`fn_qz_job_details` (`SCHED_NAME` , `JOB_NAME` , `JOB_GROUP`))
1016 DEFAULT CHARACTER SET = utf8;
1018 -- ----------------------------------------------------------------------------
1019 -- Table vid_openecomp_epsdk.fn_restricted_url
1020 -- ----------------------------------------------------------------------------
1021 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_restricted_url` (
1022 `RESTRICTED_URL` VARCHAR(250) NOT NULL,
1023 `FUNCTION_CD` VARCHAR(30) NOT NULL,
1024 PRIMARY KEY (`RESTRICTED_URL`, `FUNCTION_CD`),
1025 INDEX `FK_RESTRICTED_URL_FUNCTION_CD` (`FUNCTION_CD` ASC),
1026 CONSTRAINT `FK_RESTRICTED_URL_FUNCTION_CD`
1027 FOREIGN KEY (`FUNCTION_CD`)
1028 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
1030 DEFAULT CHARACTER SET = utf8;
1032 -- ----------------------------------------------------------------------------
1033 -- Table vid_openecomp_epsdk.fn_role
1034 -- ----------------------------------------------------------------------------
1035 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role` (
1036 `ROLE_ID` INT(11) NOT NULL AUTO_INCREMENT,
1037 `ROLE_NAME` VARCHAR(255) NOT NULL,
1038 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
1039 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
1040 PRIMARY KEY (`ROLE_ID`))
1043 DEFAULT CHARACTER SET = utf8;
1045 ALTER TABLE `vid_openecomp_epsdk`.`fn_role` MODIFY `ROLE_NAME` VARCHAR (255);
1048 -- ----------------------------------------------------------------------------
1049 -- Table vid_openecomp_epsdk.fn_role_composite
1050 -- ----------------------------------------------------------------------------
1051 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role_composite` (
1052 `PARENT_ROLE_ID` INT(11) NOT NULL,
1053 `CHILD_ROLE_ID` INT(11) NOT NULL,
1054 PRIMARY KEY (`PARENT_ROLE_ID`, `CHILD_ROLE_ID`),
1055 INDEX `FK_FN_ROLE_COMPOSITE_CHILD` (`CHILD_ROLE_ID` ASC),
1056 CONSTRAINT `FK_FN_ROLE_COMPOSITE_CHILD`
1057 FOREIGN KEY (`CHILD_ROLE_ID`)
1058 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
1059 CONSTRAINT `FK_FN_ROLE_COMPOSITE_PARENT`
1060 FOREIGN KEY (`PARENT_ROLE_ID`)
1061 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`))
1063 DEFAULT CHARACTER SET = utf8;
1065 -- ----------------------------------------------------------------------------
1066 -- Table vid_openecomp_epsdk.fn_role_function
1067 -- ----------------------------------------------------------------------------
1068 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_role_function` (
1069 `ROLE_ID` INT(11) NOT NULL,
1070 `FUNCTION_CD` VARCHAR(30) NOT NULL,
1071 PRIMARY KEY (`ROLE_ID`, `FUNCTION_CD`),
1072 INDEX `FN_ROLE_FUNCTION_FUNCTION_CD` (`FUNCTION_CD` ASC),
1073 INDEX `FN_ROLE_FUNCTION_ROLE_ID` (`ROLE_ID` ASC),
1074 CONSTRAINT `FK_FN_ROLE__REF_198_FN_ROLE`
1075 FOREIGN KEY (`ROLE_ID`)
1076 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
1077 CONSTRAINT `FK_FN_ROLE__REF_201_FN_FUNCT`
1078 FOREIGN KEY (`FUNCTION_CD`)
1079 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`))
1081 DEFAULT CHARACTER SET = utf8;
1083 -- ----------------------------------------------------------------------------
1084 -- Table vid_openecomp_epsdk.fn_schedule_workflows
1085 -- ----------------------------------------------------------------------------
1086 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_schedule_workflows` (
1087 `id_schedule_workflows` BIGINT(25) NOT NULL AUTO_INCREMENT,
1088 `workflow_server_url` VARCHAR(45) NULL DEFAULT NULL,
1089 `workflow_key` VARCHAR(45) NOT NULL,
1090 `workflow_arguments` VARCHAR(45) NULL DEFAULT NULL,
1091 `startDateTimeCron` VARCHAR(45) NULL DEFAULT NULL,
1092 `endDateTime` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1093 `start_date_time` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1094 `recurrence` VARCHAR(45) NULL DEFAULT NULL,
1095 PRIMARY KEY (`id_schedule_workflows`))
1097 DEFAULT CHARACTER SET = utf8;
1099 -- ----------------------------------------------------------------------------
1100 -- Table vid_openecomp_epsdk.fn_tab
1101 -- ----------------------------------------------------------------------------
1102 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_tab` (
1103 `TAB_CD` VARCHAR(30) NOT NULL,
1104 `TAB_NAME` VARCHAR(50) NOT NULL,
1105 `TAB_DESCR` VARCHAR(100) NULL DEFAULT NULL,
1106 `ACTION` VARCHAR(100) NOT NULL,
1107 `FUNCTION_CD` VARCHAR(30) NOT NULL,
1108 `ACTIVE_YN` CHAR(1) NOT NULL,
1109 `SORT_ORDER` DECIMAL(11,0) NOT NULL,
1110 `PARENT_TAB_CD` VARCHAR(30) NULL DEFAULT NULL,
1111 `TAB_SET_CD` VARCHAR(30) NULL DEFAULT NULL,
1112 PRIMARY KEY (`TAB_CD`),
1113 INDEX `FK_FN_TAB_FUNCTION_CD` (`FUNCTION_CD` ASC),
1114 INDEX `FK_FN_TAB_SET_CD` (`TAB_SET_CD` ASC),
1115 CONSTRAINT `FK_FN_TAB_FUNCTION_CD`
1116 FOREIGN KEY (`FUNCTION_CD`)
1117 REFERENCES `vid_openecomp_epsdk`.`fn_function` (`FUNCTION_CD`),
1118 CONSTRAINT `FK_FN_TAB_SET_CD`
1119 FOREIGN KEY (`TAB_SET_CD`)
1120 REFERENCES `vid_openecomp_epsdk`.`fn_lu_tab_set` (`TAB_SET_CD`))
1122 DEFAULT CHARACTER SET = utf8;
1124 -- ----------------------------------------------------------------------------
1125 -- Table vid_openecomp_epsdk.fn_tab_selected
1126 -- ----------------------------------------------------------------------------
1127 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_tab_selected` (
1128 `SELECTED_TAB_CD` VARCHAR(30) NOT NULL,
1129 `TAB_URI` VARCHAR(40) NOT NULL,
1130 PRIMARY KEY (`SELECTED_TAB_CD`, `TAB_URI`),
1131 CONSTRAINT `FK_FN_TAB_SELECTED_TAB_CD`
1132 FOREIGN KEY (`SELECTED_TAB_CD`)
1133 REFERENCES `vid_openecomp_epsdk`.`fn_tab` (`TAB_CD`))
1135 DEFAULT CHARACTER SET = utf8;
1137 -- ----------------------------------------------------------------------------
1138 -- Table vid_openecomp_epsdk.fn_user
1139 -- ----------------------------------------------------------------------------
1140 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user` (
1141 `USER_ID` INT(11) NOT NULL AUTO_INCREMENT,
1142 `ORG_ID` INT(11) NULL DEFAULT NULL,
1143 `MANAGER_ID` INT(11) NULL DEFAULT NULL,
1144 `FIRST_NAME` VARCHAR(50) NULL DEFAULT NULL,
1145 `MIDDLE_NAME` VARCHAR(50) NULL DEFAULT NULL,
1146 `LAST_NAME` VARCHAR(50) NULL DEFAULT NULL,
1147 `PHONE` VARCHAR(25) NULL DEFAULT NULL,
1148 `FAX` VARCHAR(25) NULL DEFAULT NULL,
1149 `CELLULAR` VARCHAR(25) NULL DEFAULT NULL,
1150 `EMAIL` VARCHAR(50) NULL DEFAULT NULL,
1151 `ADDRESS_ID` DECIMAL(11,0) NULL DEFAULT NULL,
1152 `ALERT_METHOD_CD` VARCHAR(10) NULL DEFAULT NULL,
1153 `HRID` VARCHAR(20) NULL DEFAULT NULL,
1154 `ORG_USER_ID` VARCHAR(20) NULL DEFAULT NULL,
1155 `ORG_CODE` VARCHAR(30) NULL DEFAULT NULL,
1156 `LOGIN_ID` VARCHAR(25) NULL DEFAULT NULL,
1157 `LOGIN_PWD` VARCHAR(25) NULL DEFAULT NULL,
1158 `LAST_LOGIN_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1159 `ACTIVE_YN` VARCHAR(1) NOT NULL DEFAULT 'Y',
1160 `CREATED_ID` INT(11) NULL DEFAULT NULL,
1161 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1162 `MODIFIED_ID` INT(11) NULL DEFAULT NULL,
1163 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1164 `IS_INTERNAL_YN` CHAR(1) NOT NULL DEFAULT 'N',
1165 `ADDRESS_LINE_1` VARCHAR(100) NULL DEFAULT NULL,
1166 `ADDRESS_LINE_2` VARCHAR(100) NULL DEFAULT NULL,
1167 `CITY` VARCHAR(50) NULL DEFAULT NULL,
1168 `STATE_CD` VARCHAR(3) NULL DEFAULT NULL,
1169 `ZIP_CODE` VARCHAR(11) NULL DEFAULT NULL,
1170 `COUNTRY_CD` VARCHAR(3) NULL DEFAULT NULL,
1171 `LOCATION_CLLI` VARCHAR(8) NULL DEFAULT NULL,
1172 `ORG_MANAGER_USERID` VARCHAR(20) NULL DEFAULT NULL,
1173 `COMPANY` VARCHAR(100) NULL DEFAULT NULL,
1174 `DEPARTMENT_NAME` VARCHAR(100) NULL DEFAULT NULL,
1175 `JOB_TITLE` VARCHAR(100) NULL DEFAULT NULL,
1176 `TIMEZONE` INT(11) NULL DEFAULT NULL,
1177 `DEPARTMENT` VARCHAR(25) NULL DEFAULT NULL,
1178 `BUSINESS_UNIT` VARCHAR(25) NULL DEFAULT NULL,
1179 `BUSINESS_UNIT_NAME` VARCHAR(100) NULL DEFAULT NULL,
1180 `COST_CENTER` VARCHAR(25) NULL DEFAULT NULL,
1181 `FIN_LOC_CODE` VARCHAR(10) NULL DEFAULT NULL,
1182 `SILO_STATUS` VARCHAR(10) NULL DEFAULT NULL,
1183 PRIMARY KEY (`USER_ID`),
1184 UNIQUE INDEX `FN_USER_HRID` (`HRID` ASC),
1185 UNIQUE INDEX `FN_USER_LOGIN_ID` (`LOGIN_ID` ASC),
1186 INDEX `FN_USER_ADDRESS_ID` (`ADDRESS_ID` ASC),
1187 INDEX `FN_USER_ALERT_METHOD_CD` (`ALERT_METHOD_CD` ASC),
1188 INDEX `FN_USER_ORG_ID` (`ORG_ID` ASC),
1189 INDEX `FK_FN_USER_REF_197_FN_USER` (`MANAGER_ID` ASC),
1190 INDEX `FK_FN_USER_REF_198_FN_USER` (`CREATED_ID` ASC),
1191 INDEX `FK_FN_USER_REF_199_FN_USER` (`MODIFIED_ID` ASC),
1192 INDEX `FK_TIMEZONE` (`TIMEZONE` ASC),
1193 CONSTRAINT `FK_FN_USER_REF_110_FN_ORG`
1194 FOREIGN KEY (`ORG_ID`)
1195 REFERENCES `vid_openecomp_epsdk`.`fn_org` (`ORG_ID`),
1196 CONSTRAINT `FK_FN_USER_REF_123_FN_LU_AL`
1197 FOREIGN KEY (`ALERT_METHOD_CD`)
1198 REFERENCES `vid_openecomp_epsdk`.`fn_lu_alert_method` (`ALERT_METHOD_CD`),
1199 CONSTRAINT `FK_FN_USER_REF_197_FN_USER`
1200 FOREIGN KEY (`MANAGER_ID`)
1201 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
1202 CONSTRAINT `FK_FN_USER_REF_198_FN_USER`
1203 FOREIGN KEY (`CREATED_ID`)
1204 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
1205 CONSTRAINT `FK_FN_USER_REF_199_FN_USER`
1206 FOREIGN KEY (`MODIFIED_ID`)
1207 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
1208 CONSTRAINT `FK_TIMEZONE`
1209 FOREIGN KEY (`TIMEZONE`)
1210 REFERENCES `vid_openecomp_epsdk`.`fn_lu_timezone` (`TIMEZONE_ID`))
1213 DEFAULT CHARACTER SET = utf8;
1216 -- ----------------------------------------------------------------------------
1217 -- Table vid_openecomp_epsdk.fn_user_pseudo_role
1218 -- ----------------------------------------------------------------------------
1219 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user_pseudo_role` (
1220 `PSEUDO_ROLE_ID` INT(11) NOT NULL,
1221 `USER_ID` INT(11) NOT NULL,
1222 PRIMARY KEY (`PSEUDO_ROLE_ID`, `USER_ID`),
1223 INDEX `FK_PSEUDO_ROLE_USER_ID` (`USER_ID` ASC),
1224 CONSTRAINT `FK_PSEUDO_ROLE_PSEUDO_ROLE_ID`
1225 FOREIGN KEY (`PSEUDO_ROLE_ID`)
1226 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
1227 CONSTRAINT `FK_PSEUDO_ROLE_USER_ID`
1228 FOREIGN KEY (`USER_ID`)
1229 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`))
1231 DEFAULT CHARACTER SET = utf8;
1233 -- ----------------------------------------------------------------------------
1234 -- Table vid_openecomp_epsdk.fn_user_role
1235 -- ----------------------------------------------------------------------------
1236 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_user_role` (
1237 `USER_ID` INT(10) NOT NULL,
1238 `ROLE_ID` INT(10) NOT NULL,
1239 `PRIORITY` DECIMAL(4,0) NULL DEFAULT NULL,
1240 `APP_ID` INT(11) NOT NULL DEFAULT '1',
1241 PRIMARY KEY (`USER_ID`, `ROLE_ID`, `APP_ID`),
1242 INDEX `FN_USER_ROLE_ROLE_ID` (`ROLE_ID` ASC),
1243 INDEX `FN_USER_ROLE_USER_ID` (`USER_ID` ASC),
1244 INDEX `FK_FN_USER__REF_178_FN_APP_idx` (`APP_ID` ASC),
1245 CONSTRAINT `FK_FN_USER__REF_172_FN_USER`
1246 FOREIGN KEY (`USER_ID`)
1247 REFERENCES `vid_openecomp_epsdk`.`fn_user` (`USER_ID`),
1248 CONSTRAINT `FK_FN_USER__REF_175_FN_ROLE`
1249 FOREIGN KEY (`ROLE_ID`)
1250 REFERENCES `vid_openecomp_epsdk`.`fn_role` (`ROLE_ID`),
1251 CONSTRAINT `FK_FN_USER__REF_178_FN_APP`
1252 FOREIGN KEY (`APP_ID`)
1253 REFERENCES `vid_openecomp_epsdk`.`fn_app` (`APP_ID`))
1255 DEFAULT CHARACTER SET = utf8;
1257 -- ----------------------------------------------------------------------------
1258 -- Table vid_openecomp_epsdk.fn_workflow
1259 -- ----------------------------------------------------------------------------
1260 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_workflow` (
1261 `id` MEDIUMINT(9) NOT NULL AUTO_INCREMENT,
1262 `name` VARCHAR(20) NOT NULL,
1263 `description` VARCHAR(500) NULL DEFAULT NULL,
1264 `run_link` VARCHAR(300) NULL DEFAULT NULL,
1265 `suspend_link` VARCHAR(300) NULL DEFAULT NULL,
1266 `modified_link` VARCHAR(300) NULL DEFAULT NULL,
1267 `active_yn` VARCHAR(300) NULL DEFAULT NULL,
1268 `created` VARCHAR(300) NULL DEFAULT NULL,
1269 `created_by` INT(11) NULL DEFAULT NULL,
1270 `modified` VARCHAR(300) NULL DEFAULT NULL,
1271 `modified_by` INT(11) NULL DEFAULT NULL,
1272 `workflow_key` VARCHAR(50) NULL DEFAULT NULL,
1274 UNIQUE INDEX `name` (`name` ASC))
1276 DEFAULT CHARACTER SET = utf8;
1278 -- ----------------------------------------------------------------------------
1279 -- Table vid_openecomp_epsdk.fn_xmltype
1280 -- ----------------------------------------------------------------------------
1281 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`fn_xmltype` (
1282 `ID` DECIMAL(10,0) NOT NULL,
1283 `XML_DOCUMENT` TEXT NULL DEFAULT NULL,
1284 UNIQUE INDEX `FN_XMLTYPE_ID` (`ID` ASC))
1286 DEFAULT CHARACTER SET = utf8;
1288 -- ----------------------------------------------------------------------------
1289 -- Table vid_openecomp_epsdk.schema_info
1290 -- ----------------------------------------------------------------------------
1291 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`schema_info` (
1292 `SCHEMA_ID` VARCHAR(25) NOT NULL,
1293 `SCHEMA_DESC` VARCHAR(75) NOT NULL,
1294 `DATASOURCE_TYPE` VARCHAR(100) NULL DEFAULT NULL,
1295 `CONNECTION_URL` VARCHAR(200) NOT NULL,
1296 `USER_NAME` VARCHAR(45) NOT NULL,
1297 `PASSWORD` VARCHAR(45) NULL DEFAULT NULL,
1298 `DRIVER_CLASS` VARCHAR(100) NOT NULL,
1299 `MIN_POOL_SIZE` INT(11) NOT NULL,
1300 `MAX_POOL_SIZE` INT(11) NOT NULL,
1301 `IDLE_CONNECTION_TEST_PERIOD` INT(11) NOT NULL)
1303 DEFAULT CHARACTER SET = utf8;
1304 -- ----------------------------------------------------------------------------
1305 -- Table vid_openecomp_epsdk.vid_vnf
1306 -- ----------------------------------------------------------------------------
1308 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_vnf` (
1309 `VNF_DB_ID` int(11) NOT NULL AUTO_INCREMENT,
1310 `VNF_APP_UUID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1311 `VNF_APP_INVARIANT_UUID` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
1312 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1313 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1314 PRIMARY KEY (`VNF_DB_ID`),
1315 UNIQUE KEY `vid_vnf_VNF_ID_uindex` (`VNF_APP_UUID`,`VNF_APP_INVARIANT_UUID`)
1316 ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
1318 -- ----------------------------------------------------------------------------
1319 -- Table vid_openecomp_epsdk.vid_workflow
1320 -- ----------------------------------------------------------------------------
1322 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_workflow` (
1323 `WORKFLOW_DB_ID` int(11) NOT NULL AUTO_INCREMENT,
1324 `WORKFLOW_APP_NAME` varchar(50) COLLATE utf8_bin NOT NULL,
1325 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1326 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1327 PRIMARY KEY (`WORKFLOW_DB_ID`),
1328 UNIQUE KEY `vid_workflow_workflow_uuid_uindex` (`WORKFLOW_APP_NAME`),
1329 UNIQUE KEY `vid_workflow_WORKFLOW_ID_uindex` (`WORKFLOW_DB_ID`)
1330 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1332 -- ----------------------------------------------------------------------------
1333 -- Table vid_openecomp_epsdk.vid_vnf_workflow
1334 -- ----------------------------------------------------------------------------
1337 CREATE TABLE IF NOT EXISTS `vid_openecomp_epsdk`.`vid_vnf_workflow` (
1338 `VNF_DB_ID` int(11) NOT NULL,
1339 `WORKFLOW_DB_ID` int(11) NOT NULL,
1340 KEY `vid_vnf_workflow_vid_vnf_VND_ID_fk` (`VNF_DB_ID`),
1341 KEY `vid_vnf_workflow_vid_workflow_WORKFLOW_ID_fk` (`WORKFLOW_DB_ID`),
1342 CONSTRAINT `vid_vnf_workflow_vid_vnf_VND_ID_fk` FOREIGN KEY (`VNF_DB_ID`) REFERENCES `vid_vnf` (`VNF_DB_ID`),
1343 CONSTRAINT `vid_vnf_workflow_vid_workflow_WORKFLOW_ID_fk` FOREIGN KEY (`WORKFLOW_DB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_workflow` (`WORKFLOW_DB_ID`)
1344 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1347 -- ----------------------------------------------------------------------------
1348 -- Table vid_openecomp_epsdk.vid_category_parameter
1349 -- ----------------------------------------------------------------------------
1352 CREATE TABLE IF NOT EXISTS `vid_category_parameter` (
1353 `CATEGORY_ID` INT(11) NOT NULL AUTO_INCREMENT,
1354 `NAME` VARCHAR(255) NULL COLLATE 'utf8_bin',
1355 `ID_SUPPORTED` TINYINT(1) NOT NULL DEFAULT '0',
1356 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1357 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1358 PRIMARY KEY (`CATEGORY_ID`)
1359 ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=5;
1361 -------------------------------------------------------------------------------
1363 ALTER TABLE `vid_category_parameter`
1364 ADD COLUMN if not exists `FAMILY` ENUM('PARAMETER_STANDARDIZATION','TENANT_ISOLATION') NOT NULL DEFAULT 'PARAMETER_STANDARDIZATION' AFTER `ID_SUPPORTED`;
1365 -- ----------------------------------------------------------------------------
1366 -- Table vid_openecomp_epsdk.vid_category_parameter
1367 -- ----------------------------------------------------------------------------
1368 CREATE TABLE IF NOT EXISTS `vid_category_parameter_option` (
1369 `CATEGORY_OPT_DB_ID` INT(11) NOT NULL AUTO_INCREMENT,
1370 `CATEGORY_OPT_APP_ID` VARCHAR(50) NOT NULL COLLATE 'utf8_bin',
1371 `NAME` VARCHAR(50) NULL COLLATE 'utf8_bin',
1372 `CATEGORY_ID` INT(11) NOT NULL DEFAULT '0',
1373 `CREATED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1374 `MODIFIED_DATE` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1375 PRIMARY KEY (`CATEGORY_OPT_DB_ID`),
1376 UNIQUE INDEX `APP_ID_CATEGORY_UNIQUE` (`CATEGORY_ID`, `CATEGORY_OPT_APP_ID`),
1377 UNIQUE INDEX `NAME_CATEGORY_UNIQUE` (`CATEGORY_ID`, `NAME`),
1378 CONSTRAINT `FK_OWNING_ENTITY_OPTIONS_TO_OE` FOREIGN KEY (`CATEGORY_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_category_parameter` (`CATEGORY_ID`)
1379 ) COLLATE='utf8_bin' ENGINE=InnoDB AUTO_INCREMENT=25;
1381 CREATE TABLE IF NOT EXISTS `vid_job` (
1382 `JOB_ID` BINARY(16) NOT NULL PRIMARY KEY,
1383 `CREATED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1384 `MODIFIED_DATE` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
1385 `JOB_STATUS` VARCHAR(50) NULL COLLATE 'utf8_bin',
1386 `JOB_TYPE` VARCHAR(50) NULL COLLATE 'utf8_bin',
1387 `JOB_DATA` MEDIUMTEXT NULL COLLATE 'utf8_bin',
1388 `PARENT_JOB_ID` BINARY(16) NULL,
1389 `TAKEN_BY` VARCHAR(100) NULL COLLATE 'utf8_bin',
1390 CONSTRAINT `FK_OWNING_VID_JOB_PARENT` FOREIGN KEY (`PARENT_JOB_ID`) REFERENCES `vid_openecomp_epsdk`.`vid_job` (`JOB_ID`)
1391 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
1393 ALTER TABLE `vid_job`
1394 ADD COLUMN if NOT EXISTS `TAKEN_BY` VARCHAR (100) COLLATE 'utf8_bin';
1395 -- ----------------------------------------------------------------------------
1396 -- View vid_openecomp_epsdk.v_url_access
1397 -- ----------------------------------------------------------------------------
1398 CREATE OR REPLACE ALGORITHM=UNDEFINED SQL SECURITY DEFINER VIEW `v_url_access` AS select distinct `m`.`ACTION` AS `URL`,`m`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_menu` `m` where (`m`.`ACTION` is not null) union select distinct `t`.`ACTION` AS `URL`,`t`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_tab` `t` where (`t`.`ACTION` is not null) union select `r`.`RESTRICTED_URL` AS `URL`,`r`.`FUNCTION_CD` AS `FUNCTION_CD` from `fn_restricted_url` `r`;
1399 SET FOREIGN_KEY_CHECKS = 1;