Repository navigation
Expand file tree
/
Copy pathframework.oracle.sql
More file actions
2829 lines (2209 loc) · 92.3 KB
/
Copy pathframework.oracle.sql
File metadata and controls
2829 lines (2209 loc) · 92.3 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
/*==============================================================*/
/* DBMS name: ORACLE Version 11g */
/* Created on: 2015/9/24 15:50:49 */
/*==============================================================*/
create sequence SEQ_ACCOUNT
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_ADMIN
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_AREA
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_ATTACHMENTS
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_ATTR
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_ATTR_VALUE
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_CHANGE_NOTIF_REDIS
increment by 1
start with 1
maxvalue 99999999999
minvalue 1
cache 20;
create sequence SEQ_CONFIG_ITEM
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_CONFIG_ITEM_PARAM
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_CRON_TRIGGER
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_MESSAGE_BOX
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_MESSAGE_HISTORY
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_MESSAGE_TEMPLATE
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_OPERATE_LOG
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle;
create sequence SEQ_OPERATOR
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
cache 20;
create sequence SEQ_RECEIVE_BOX
increment by 1
start with 1000
maxvalue 999999999999
minvalue 1
cache 20;
create sequence SEQ_REDIS_REFRESH_RULE
increment by 1
start with 1
maxvalue 99999999999
minvalue 1
cache 20;
create sequence SEQ_RESOURCE_ID
increment by 1
start with 1000
maxvalue 99999999999
minvalue 20
nocycle
cache 20;
create sequence SEQ_ROLE
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence SEQ_SIMPLE_TRIGGER
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence S_CONFIG_ITEM_PARAM_VALUE
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence S_SEND_RECORD
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
create sequence S_TASK
increment by 1
start with 1000
maxvalue 99999999999
minvalue 1
nocycle
cache 20;
/*==============================================================*/
/* Table: ACCOUNT */
/*==============================================================*/
create table ACCOUNT
(
ACCOUNT_ID NUMBER(8) not null,
ACCOUNT_VALUE VARCHAR2(120) not null,
ACCOUNT_TYPE VARCHAR2(2) not null,
OPERATOR_ID NUMBER(8) not null,
CREATE_TIME DATE not null,
STATE CHAR(1) not null,
STATE_TIME DATE not null,
EXT1 VARCHAR2(120),
EXT2 VARCHAR2(120),
constraint PK_ACCOUNT primary key (ACCOUNT_ID)
);
comment on column ACCOUNT.ACCOUNT_ID is
'账号标识';
comment on column ACCOUNT.ACCOUNT_VALUE is
'账号值';
comment on column ACCOUNT.ACCOUNT_TYPE is
'账号类型';
comment on column ACCOUNT.OPERATOR_ID is
'操作员标识';
comment on column ACCOUNT.CREATE_TIME is
'创建时间';
comment on column ACCOUNT.STATE is
'状态';
comment on column ACCOUNT.STATE_TIME is
'状态更新时间';
comment on column ACCOUNT.EXT1 is
'扩展属性1';
comment on column ACCOUNT.EXT2 is
'扩展属性2';
/*==============================================================*/
/* Table: ADMIN */
/*==============================================================*/
create table ADMIN
(
ADMIN_ID NUMBER(6) not null,
ADMIN_NAME VARCHAR2(60) not null,
HEAD_IMG NUMBER(10),
GENER CHAR(1),
CREATED_TIME DATE not null,
STATE CHAR(1) not null,
STATE_DATE DATE not null,
EMAIL VARCHAR2(120),
PHONE VARCHAR2(20),
OPERATOR_ID NUMBER(8),
ADDRESS VARCHAR2(255),
constraint PK_ADMIN primary key (ADMIN_ID)
);
comment on column ADMIN.ADMIN_ID is
'管理员标识';
comment on column ADMIN.ADMIN_NAME is
'管理员名称';
comment on column ADMIN.CREATED_TIME is
'创建日期';
comment on column ADMIN.STATE is
'状态';
comment on column ADMIN.STATE_DATE is
'状态日期';
comment on column ADMIN.EMAIL is
'电子邮件';
comment on column ADMIN.PHONE is
'电话';
comment on column ADMIN.OPERATOR_ID is
'操作员标识';
comment on column ADMIN.ADDRESS is
'地址';
/*==============================================================*/
/* Table: ADMIN_ATTR */
/*==============================================================*/
create table ADMIN_ATTR
(
ADMIN_ID NUMBER(8) not null,
ATTR_ID NUMBER(4) not null,
VALUE VARCHAR2(120),
CREATE_TIME DATE not null,
constraint PK_ADMIN_ATTR primary key (ADMIN_ID, ATTR_ID)
);
comment on column ADMIN_ATTR.ADMIN_ID is
'管理员标识';
comment on column ADMIN_ATTR.ATTR_ID is
'属性标识';
comment on column ADMIN_ATTR.VALUE is
'属性值';
comment on column ADMIN_ATTR.CREATE_TIME is
'创建时间';
/*==============================================================*/
/* Table: ADMIN_ATTR_HISTORY */
/*==============================================================*/
create table ADMIN_ATTR_HISTORY
(
ADMIN_ID NUMBER(8) not null,
ATTR_ID NUMBER(4) not null,
SEQ NUMBER(4) not null,
VALUE VARCHAR2(120),
CREATE_TIME DATE not null,
UPDATE_TIME DATE not null,
UPDATE_OPRATOR_ID NUMBER(8),
constraint PK_ADMIN_ATTR_HISTORY primary key (ADMIN_ID, ATTR_ID, SEQ)
);
comment on column ADMIN_ATTR_HISTORY.ADMIN_ID is
'管理员标识';
comment on column ADMIN_ATTR_HISTORY.ATTR_ID is
'属性标识';
comment on column ADMIN_ATTR_HISTORY.SEQ is
'序列';
comment on column ADMIN_ATTR_HISTORY.VALUE is
'属性值';
comment on column ADMIN_ATTR_HISTORY.CREATE_TIME is
'创建时间';
comment on column ADMIN_ATTR_HISTORY.UPDATE_TIME is
'修改时间';
comment on column ADMIN_ATTR_HISTORY.UPDATE_OPRATOR_ID is
'修改人标识';
/*==============================================================*/
/* Table: ADMIN_HISTORY */
/*==============================================================*/
create table ADMIN_HISTORY
(
ADMIN_ID NUMBER(6) not null,
SEQ NUMBER(4) not null,
ADMIN_NAME VARCHAR2(60) not null,
CREATED_TIME DATE not null,
STATE CHAR(1) not null,
STATE_DATE DATE not null,
EMAIL VARCHAR2(120),
PHONE VARCHAR2(20),
ADDRESS VARCHAR2(255),
UPDATE_TIME DATE not null,
UPDATE_OPERATOR_ID NUMBER(8),
constraint PK_ADMIN_HISTORY primary key (ADMIN_ID, SEQ)
);
comment on column ADMIN_HISTORY.ADMIN_ID is
'管理员标识';
comment on column ADMIN_HISTORY.SEQ is
'序列';
comment on column ADMIN_HISTORY.ADMIN_NAME is
'管理员名称';
comment on column ADMIN_HISTORY.CREATED_TIME is
'创建日期';
comment on column ADMIN_HISTORY.STATE is
'状态';
comment on column ADMIN_HISTORY.STATE_DATE is
'状态日期';
comment on column ADMIN_HISTORY.EMAIL is
'电子邮件';
comment on column ADMIN_HISTORY.PHONE is
'电话';
comment on column ADMIN_HISTORY.ADDRESS is
'地址';
comment on column ADMIN_HISTORY.UPDATE_TIME is
'修改时间';
comment on column ADMIN_HISTORY.UPDATE_OPERATOR_ID is
'修改人标识';
/*==============================================================*/
/* Table: AREA */
/*==============================================================*/
create table AREA
(
AREA_ID NUMBER(10) not null,
PARENT_AREA_ID NUMBER(10),
AREA_TYPE CHAR(1) not null,
AREA_NAME VARCHAR2(20) not null,
AREA_CODE VARCHAR2(10),
REMARK VARCHAR2(120),
constraint PK_AREA primary key (AREA_ID)
);
comment on column AREA.AREA_ID is
'区域标识';
comment on column AREA.PARENT_AREA_ID is
'父区域标识';
comment on column AREA.AREA_TYPE is
'区域类型';
comment on column AREA.AREA_NAME is
'区域名称';
comment on column AREA.AREA_CODE is
'区域编码';
comment on column AREA.REMARK is
'备注';
/*==============================================================*/
/* Table: AREA_RANGE */
/*==============================================================*/
create table AREA_RANGE
(
AREA_ID NUMBER(10) not null,
SEQ NUMBER(6) not null,
LONGITUDE VARCHAR2(20) not null,
LATITUDE VARCHAR2(20) not null,
constraint PK_AREA_RANGE primary key (AREA_ID, SEQ)
);
comment on column AREA_RANGE.AREA_ID is
'区域标识';
comment on column AREA_RANGE.SEQ is
'序列';
comment on column AREA_RANGE.LONGITUDE is
'经度';
comment on column AREA_RANGE.LATITUDE is
'纬度';
/*==============================================================*/
/* Table: ATTACHMENTS */
/*==============================================================*/
create table ATTACHMENTS
(
ATTACHMENTS_ID NUMBER(10) not null,
ATTACHMENTS_TYPE VARCHAR2(20) not null,
ATTACHMENTS_NAME VARCHAR2(60) not null,
IS_REMOTE CHAR(1) not null,
FILE_SIZE NUMBER(10),
FILE_PATH VARCHAR2(255) not null,
DOWNLOADS_NUM NUMBER(8) not null,
IS_PICTURE CHAR(1) not null,
IS_THUMB CHAR(1) not null,
THUMB_PATH VARCHAR2(255),
CREATE_TIME DATE not null,
EXP_TIME DATE,
UPDATE_TIME VARCHAR2(14),
constraint PK_ATTACHMENTS primary key (ATTACHMENTS_ID)
);
comment on column ATTACHMENTS.ATTACHMENTS_ID is
'附件标识';
comment on column ATTACHMENTS.ATTACHMENTS_TYPE is
'附件类型';
comment on column ATTACHMENTS.ATTACHMENTS_NAME is
'附件文件名';
comment on column ATTACHMENTS.IS_REMOTE is
'是否为远程文件';
comment on column ATTACHMENTS.FILE_SIZE is
'文件大小';
comment on column ATTACHMENTS.FILE_PATH is
'文件路径';
comment on column ATTACHMENTS.DOWNLOADS_NUM is
'下载次数';
comment on column ATTACHMENTS.IS_PICTURE is
'是否是图片';
comment on column ATTACHMENTS.IS_THUMB is
'是否生成缩略图';
comment on column ATTACHMENTS.THUMB_PATH is
'缩略图地址';
comment on column ATTACHMENTS.CREATE_TIME is
'创建时间';
comment on column ATTACHMENTS.EXP_TIME is
'失效时间';
comment on column ATTACHMENTS.UPDATE_TIME is
'更新时间';
/*==============================================================*/
/* Table: ATTR */
/*==============================================================*/
create table ATTR
(
ATTR_ID NUMBER(6) not null,
ATTR_NAME VARCHAR2(60) not null,
ATTR_TYPE CHAR(1) not null,
PARENT_ATTR_ID NUMBER(4),
ATTR_CODE VARCHAR2(120) not null,
VISIBLE CHAR(1) not null,
INSTANTIATABLE CHAR(1) not null,
DEFAULT_VALUE VARCHAR2(120),
INPUT_TYPE CHAR(1) not null,
DATA_TYPE CHAR(1) not null,
VALUE_SCRIPT VARCHAR2(2000),
constraint PK_ATTR primary key (ATTR_ID)
);
comment on column ATTR.ATTR_ID is
'属性标识';
comment on column ATTR.ATTR_NAME is
'名称';
comment on column ATTR.ATTR_TYPE is
'属性类型';
comment on column ATTR.PARENT_ATTR_ID is
'父属性标识';
comment on column ATTR.ATTR_CODE is
'属性代码';
comment on column ATTR.VISIBLE is
'是否可见';
comment on column ATTR.INSTANTIATABLE is
'是否可实例化';
comment on column ATTR.DEFAULT_VALUE is
'缺省值';
comment on column ATTR.INPUT_TYPE is
'输入方式';
comment on column ATTR.DATA_TYPE is
'数据类型';
comment on column ATTR.VALUE_SCRIPT is
'取值校验规则';
/*==============================================================*/
/* Table: ATTR_VALUE */
/*==============================================================*/
create table ATTR_VALUE
(
ATTR_ID NUMBER(6) not null,
ATTR_VALUE_ID NUMBER(6) not null,
VALUE_MARK VARCHAR2(60) not null,
VALUE VARCHAR2(120),
LINK_ATTR_ID NUMBER(6),
constraint PK_ATTR_VALUE primary key (ATTR_ID, ATTR_VALUE_ID)
);
comment on column ATTR_VALUE.ATTR_ID is
'属性标识';
comment on column ATTR_VALUE.ATTR_VALUE_ID is
'属性值标识';
comment on column ATTR_VALUE.VALUE_MARK is
'取值说明';
comment on column ATTR_VALUE.VALUE is
'取值';
comment on column ATTR_VALUE.LINK_ATTR_ID is
'联动属性标识';
/*==============================================================*/
/* Table: CHANGE_NOTIF_REDIS */
/*==============================================================*/
create table CHANGE_NOTIF_REDIS
(
CHANGE_NOTIF_ID NUMBER(12) not null,
TABLE_NAME VARCHAR(60) not null,
KEY_VALUE VARCHAR(60) not null,
CREATED_DATE DATE not null,
ACTION_TYPE CHAR(1),
constraint PK_CHANGE_NOTIF_REDIS primary key (CHANGE_NOTIF_ID)
);
comment on column CHANGE_NOTIF_REDIS.CHANGE_NOTIF_ID is
'主键';
comment on column CHANGE_NOTIF_REDIS.TABLE_NAME is
'更新记录名';
comment on column CHANGE_NOTIF_REDIS.KEY_VALUE is
'更新记录主键';
comment on column CHANGE_NOTIF_REDIS.CREATED_DATE is
'创建时间';
comment on column CHANGE_NOTIF_REDIS.ACTION_TYPE is
'操作类型 (A:新增 D:删除 M:修改)';
/*==============================================================*/
/* Table: CONFIG_ITEM */
/*==============================================================*/
create table CONFIG_ITEM
(
CONFIG_ITEM_ID NUMBER(6) not null,
MODULE_CODE VARCHAR2(10) not null,
DIRECTORY_CODE VARCHAR2(20) not null,
CONFIG_ITEM_CODE VARCHAR2(120) not null,
CONFIG_ITEM_NAME VARCHAR2(120) not null,
IS_VISIABLE CHAR(1) not null,
UPDATE_TIME DATE,
REMARK VARCHAR2(255),
constraint PK_CONFIG_ITEM primary key (CONFIG_ITEM_ID)
);
comment on column CONFIG_ITEM.CONFIG_ITEM_ID is
'配置项标识';
comment on column CONFIG_ITEM.MODULE_CODE is
'模块代码';
comment on column CONFIG_ITEM.DIRECTORY_CODE is
'目录代码';
comment on column CONFIG_ITEM.CONFIG_ITEM_CODE is
'配置项代码';
comment on column CONFIG_ITEM.CONFIG_ITEM_NAME is
'配置项名称';
comment on column CONFIG_ITEM.IS_VISIABLE is
'是否可见';
comment on column CONFIG_ITEM.UPDATE_TIME is
'更新时间';
comment on column CONFIG_ITEM.REMARK is
'备注';
/*==============================================================*/
/* Table: CONFIG_ITEM_HISTORY */
/*==============================================================*/
create table CONFIG_ITEM_HISTORY
(
CONFIG_ITEM_ID NUMBER(4) not null,
SEQ NUMBER(4) not null,
MODULE_CODE VARCHAR2(10) not null,
DIRECTORY_CODE VARCHAR2(10) not null,
CONFIG_ITEM_CODE VARCHAR2(120) not null,
CONFIG_ITEM_NAME VARCHAR2(120) not null,
IS_VISIABLE CHAR(1) not null,
UPDATE_TIME DATE not null,
REMARK VARCHAR2(255),
OPERATOR_ID NUMBER(8),
CHANNEL_ID NUMBER(4),
constraint PK_CONFIG_ITEM_HISTORY primary key (CONFIG_ITEM_ID, SEQ)
);
comment on column CONFIG_ITEM_HISTORY.CONFIG_ITEM_ID is
'配置项标识';
comment on column CONFIG_ITEM_HISTORY.SEQ is
'序列号';
comment on column CONFIG_ITEM_HISTORY.MODULE_CODE is
'模块代码';
comment on column CONFIG_ITEM_HISTORY.DIRECTORY_CODE is
'目录代码';
comment on column CONFIG_ITEM_HISTORY.CONFIG_ITEM_CODE is
'配置项代码';
comment on column CONFIG_ITEM_HISTORY.CONFIG_ITEM_NAME is
'配置项名称';
comment on column CONFIG_ITEM_HISTORY.IS_VISIABLE is
'是否可见';
comment on column CONFIG_ITEM_HISTORY.UPDATE_TIME is
'更新时间';
comment on column CONFIG_ITEM_HISTORY.REMARK is
'备注';
comment on column CONFIG_ITEM_HISTORY.OPERATOR_ID is
'操作员标识';
comment on column CONFIG_ITEM_HISTORY.CHANNEL_ID is
'渠道标识';
/*==============================================================*/
/* Table: CONFIG_ITEM_PARAM */
/*==============================================================*/
create table CONFIG_ITEM_PARAM
(
CONFIG_ITEM_ID NUMBER(6) not null,
PARAM_CODE VARCHAR2(120) not null,
PARAM_NAME VARCHAR2(120) not null,
PARAM_VALUE VARCHAR2(1000),
DEFAULT_PARAM_VALUE VARCHAR2(1000),
DATA_TYPE CHAR(1) not null,
INPUT_TYPE CHAR(1) not null,
VALUE_SCRIPT VARCHAR2(2000),
UPDATE_TIME DATE not null,
REMARK VARCHAR2(255),
constraint PK_CONFIG_ITEM_PARAM primary key (CONFIG_ITEM_ID, PARAM_CODE)
);
comment on column CONFIG_ITEM_PARAM.CONFIG_ITEM_ID is
'配置项标识';
comment on column CONFIG_ITEM_PARAM.PARAM_CODE is
'参数编码';
comment on column CONFIG_ITEM_PARAM.PARAM_NAME is
'参数名称';
comment on column CONFIG_ITEM_PARAM.PARAM_VALUE is
'参数取值';
comment on column CONFIG_ITEM_PARAM.DEFAULT_PARAM_VALUE is
'缺省值';
comment on column CONFIG_ITEM_PARAM.DATA_TYPE is
'数据类型';
comment on column CONFIG_ITEM_PARAM.INPUT_TYPE is
'输入方式';
comment on column CONFIG_ITEM_PARAM.VALUE_SCRIPT is
'取值校验规则';
comment on column CONFIG_ITEM_PARAM.UPDATE_TIME is
'更新时间';
comment on column CONFIG_ITEM_PARAM.REMARK is
'备注';
/*==============================================================*/
/* Table: CONFIG_ITEM_PARAM_HISTORY */
/*==============================================================*/
create table CONFIG_ITEM_PARAM_HISTORY
(
CONFIG_ITEM_ID NUMBER(4) not null,
PARAM_CODE VARCHAR2(120) not null,
SEQ NUMBER(4) not null,
PARAM_NAME VARCHAR2(120) not null,
PARAM_VALUE VARCHAR2(1000),
DEFAULT_PARAM_VALUE VARCHAR2(1000),
DATA_TYPE CHAR(1),
INPUT_TYPE CHAR(1),
VALUE_SCRIPT VARCHAR2(2000),
UPDATE_TIME DATE not null,
REMARK VARCHAR2(255),
OPERATOR_ID NUMBER(8),
CHANNEL_ID NUMBER(4),
constraint PK_CONFIG_ITEM_PARAM_HISTORY primary key (CONFIG_ITEM_ID, PARAM_CODE, SEQ)
);
comment on column CONFIG_ITEM_PARAM_HISTORY.CONFIG_ITEM_ID is
'配置项标识';
comment on column CONFIG_ITEM_PARAM_HISTORY.PARAM_CODE is
'参数编码';
comment on column CONFIG_ITEM_PARAM_HISTORY.SEQ is
'序列号';
comment on column CONFIG_ITEM_PARAM_HISTORY.PARAM_NAME is
'参数名称';
comment on column CONFIG_ITEM_PARAM_HISTORY.PARAM_VALUE is
'参数取值';
comment on column CONFIG_ITEM_PARAM_HISTORY.DEFAULT_PARAM_VALUE is
'缺省值';
comment on column CONFIG_ITEM_PARAM_HISTORY.DATA_TYPE is
'数据类型';
comment on column CONFIG_ITEM_PARAM_HISTORY.INPUT_TYPE is
'输入方式';
comment on column CONFIG_ITEM_PARAM_HISTORY.VALUE_SCRIPT is
'取值校验规则';
comment on column CONFIG_ITEM_PARAM_HISTORY.UPDATE_TIME is
'更新时间';
comment on column CONFIG_ITEM_PARAM_HISTORY.REMARK is
'备注';
comment on column CONFIG_ITEM_PARAM_HISTORY.OPERATOR_ID is
'操作员标识';
comment on column CONFIG_ITEM_PARAM_HISTORY.CHANNEL_ID is
'渠道标识';
/*==============================================================*/
/* Table: CONFIG_ITEM_PARAM_VALUE */
/*==============================================================*/
create table CONFIG_ITEM_PARAM_VALUE
(
PARAM_VALUE_ID NUMBER(4) not null,
CONFIG_ITEM_ID NUMBER(6) not null,
PARAM_CODE VARCHAR2(120) not null,
VALUE_MARK VARCHAR2(20) not null,
VALUE VARCHAR2(60),
constraint PK_CONFIG_ITEM_PARAM_VALUE primary key (PARAM_VALUE_ID)
);
comment on column CONFIG_ITEM_PARAM_VALUE.PARAM_VALUE_ID is
'参数取值标识';
comment on column CONFIG_ITEM_PARAM_VALUE.CONFIG_ITEM_ID is
'配置项标识';
comment on column CONFIG_ITEM_PARAM_VALUE.PARAM_CODE is
'参数编码';
comment on column CONFIG_ITEM_PARAM_VALUE.VALUE_MARK is
'取值说明';
comment on column CONFIG_ITEM_PARAM_VALUE.VALUE is
'取值';
/*==============================================================*/
/* Table: CONTACT_CHANNEL */
/*==============================================================*/
create table CONTACT_CHANNEL
(
CONTACT_CHANNEL_ID NUMBER(2) not null,
CHANNEL_TYPE CHAR(2) not null,
CONTACT_CHANNEL_NAME VARCHAR2(20) not null,
REMARK VARCHAR2(120),
constraint PK_CONTACT_CHANNEL primary key (CONTACT_CHANNEL_ID)
);
comment on column CONTACT_CHANNEL.CONTACT_CHANNEL_ID is
'接触渠道';
comment on column CONTACT_CHANNEL.CHANNEL_TYPE is
'渠道类型';
comment on column CONTACT_CHANNEL.CONTACT_CHANNEL_NAME is
'名称';
comment on column CONTACT_CHANNEL.REMARK is
'说明';
/*==============================================================*/
/* Table: CRON_TRIGGER */
/*==============================================================*/
create table CRON_TRIGGER
(
TRIGGER_ID NUMBER(8) not null,
TRIGGER_NAME VARCHAR2(60) not null,
CRON_EXPRESSION VARCHAR2(120) not null,
CREATE_TIME DATE not null,
OPERATOR_ID NUMBER(8),
constraint PK_CRON_TRIGGER primary key (TRIGGER_ID)
);
comment on column CRON_TRIGGER.TRIGGER_ID is
'触发器标识';
comment on column CRON_TRIGGER.TRIGGER_NAME is
'触发器名称';
comment on column CRON_TRIGGER.CRON_EXPRESSION is
'CRON表达式';
comment on column CRON_TRIGGER.CREATE_TIME is
'创建时间';
comment on column CRON_TRIGGER.OPERATOR_ID is
'创建人标识';
/*==============================================================*/
/* Table: CRON_TRIGGER_HISTORY */
/*==============================================================*/
create table CRON_TRIGGER_HISTORY
(
TRIGGER_ID NUMBER(8) not null,
SEQ NUMBER(4) not null,
TRIGGER_NAME VARCHAR2(60) not null,
CRON_EXPRESSION VARCHAR2(120) not null,
CREATE_TIME DATE not null,
OPERATOR_ID NUMBER(8),
UPDATE_TIME DATE not null,
UPDATE_OPERATOR_ID NUMBER(8),
constraint PK_CRON_TRIGGER_HISTORY primary key (TRIGGER_ID, SEQ)
);
comment on column CRON_TRIGGER_HISTORY.TRIGGER_ID is
'触发器标识';
comment on column CRON_TRIGGER_HISTORY.SEQ is
'序列号';
comment on column CRON_TRIGGER_HISTORY.TRIGGER_NAME is
'触发器名称';
comment on column CRON_TRIGGER_HISTORY.CRON_EXPRESSION is
'CRON表达式';
comment on column CRON_TRIGGER_HISTORY.CREATE_TIME is
'创建时间';
comment on column CRON_TRIGGER_HISTORY.OPERATOR_ID is
'创建人标识';
comment on column CRON_TRIGGER_HISTORY.UPDATE_TIME is
'修改时间';
comment on column CRON_TRIGGER_HISTORY.UPDATE_OPERATOR_ID is
'修改人标识';
/*==============================================================*/
/* Table: DICTIONARY */
/*==============================================================*/
create table DICTIONARY
(
DICT_CODE VARCHAR2(60) not null,
DICT_NAME VARCHAR2(60) not null,
REMARK VARCHAR2(120),
constraint PK_DICTIONARY primary key (DICT_CODE)
);
comment on table DICTIONARY is
'数据字典表';
comment on column DICTIONARY.DICT_CODE is
'字典代码';
comment on column DICTIONARY.DICT_NAME is
'字典名称';
comment on column DICTIONARY.REMARK is
'备注';
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('CHANNEL_TYPE', '渠道类型', '渠道类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('AREA_TYPE', '区域类型', '区域类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('DATA_TYPE', '数据类型', '数据类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('INPUT_TYPE', '输入方式', '输入方式');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('ATTR_TYPE', '属性类型', '属性类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('TASK_STATE', '任务状态', '任务状态');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('TRIGGER_TYPE', '触发器类型', '触发器类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('MESSAGE_TYPE', '消息类型', '消息类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('OPERATOR_TYPE', '操作员类型', '操作员类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('ACCOUNT_TYPE', '账号类型', '账号类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('RESOURCE_TYPE', '资源类型', '资源类型');
INSERT INTO DICTIONARY (DICT_CODE, DICT_NAME, REMARK) VALUES ('EVENT_TYPE', '事件类型', '事件类型');
/*==============================================================*/
/* Table: DICTIONARY_DATA */
/*==============================================================*/
create table DICTIONARY_DATA
(
DICT_DATA_ID NUMBER(6) not null,
DICT_CODE VARCHAR2(60) not null,
DICT_DATA_NAME VARCHAR2(60) not null,
DICT_DATA_VALUE VARCHAR2(8) not null,
IS_FIXED CHAR(1) not null,
IS_CANCEL CHAR(1),
constraint PK_DICTIONARY_DATA primary key (DICT_DATA_ID)
);
comment on table DICTIONARY_DATA is
'字典数据表';
comment on column DICTIONARY_DATA.DICT_DATA_ID is
'字典数据表标识';
comment on column DICTIONARY_DATA.DICT_CODE is
'字典代码';
comment on column DICTIONARY_DATA.DICT_DATA_NAME is
'字典数据名';
comment on column DICTIONARY_DATA.DICT_DATA_VALUE is
'字典数据值';