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