-
Notifications
You must be signed in to change notification settings - Fork 0
/
murky.sql
3354 lines (2549 loc) · 181 KB
/
murky.sql
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
--
-- PostgreSQL database dump
--
-- Dumped from database version 12.16 (Debian 12.16-1.pgdg120+1)
-- Dumped by pg_dump version 14.2
-- Started on 2024-01-13 21:23:59
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
DROP DATABASE "poem-solon";
--
-- TOC entry 3166 (class 1262 OID 16515)
-- Name: poem-solon; Type: DATABASE; Schema: -; Owner: -
--
CREATE DATABASE "poem-solon" WITH TEMPLATE = template0 ENCODING = 'UTF8' LOCALE = 'en_US.utf8';
\connect -reuse-previous=on "dbname='poem-solon'"
SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;
--
-- TOC entry 9 (class 2615 OID 16516)
-- Name: admin; Type: SCHEMA; Schema: -; Owner: -
--
CREATE SCHEMA admin;
SET default_tablespace = '';
SET default_table_access_method = heap;
--
-- TOC entry 204 (class 1259 OID 16517)
-- Name: gen_table; Type: TABLE; Schema: admin; Owner: -
--
CREATE TABLE admin.gen_table (
create_time timestamp without time zone,
update_time timestamp without time zone,
create_user bigint,
update_user bigint,
table_id bigint NOT NULL,
table_name character varying,
table_comment character varying,
sub_table_name character varying,
sub_table_fk_name character varying,
class_name character varying,
tpl_category smallint DEFAULT 0 NOT NULL,
package_name character varying,
module_name character varying,
business_name character varying,
function_name character varying,
function_author character varying,
gen_type character varying DEFAULT 0 NOT NULL,
gen_path character varying DEFAULT '/'::character varying NOT NULL,
options character varying,
remark character varying
);
--
-- TOC entry 3167 (class 0 OID 0)
-- Dependencies: 204
-- Name: TABLE gen_table; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON TABLE admin.gen_table IS '代码生成业务表';
--
-- TOC entry 3168 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.create_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.create_time IS '创建时间';
--
-- TOC entry 3169 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.update_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.update_time IS '修改时间';
--
-- TOC entry 3170 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.create_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.create_user IS '创建人';
--
-- TOC entry 3171 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.update_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.update_user IS '修改人';
--
-- TOC entry 3172 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.table_id; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.table_id IS '主键';
--
-- TOC entry 3173 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.table_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.table_name IS '表名称';
--
-- TOC entry 3174 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.table_comment; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.table_comment IS '表描述';
--
-- TOC entry 3175 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.sub_table_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.sub_table_name IS '关联子表的表名';
--
-- TOC entry 3176 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.sub_table_fk_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.sub_table_fk_name IS '子表关联的外键名';
--
-- TOC entry 3177 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.class_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.class_name IS '实体类名称';
--
-- TOC entry 3178 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.tpl_category; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.tpl_category IS '使用的模板（0:单表操作 1:树表操作）';
--
-- TOC entry 3179 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.package_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.package_name IS '生成包路径';
--
-- TOC entry 3180 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.module_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.module_name IS '生成模块名';
--
-- TOC entry 3181 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.business_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.business_name IS '生成业务名';
--
-- TOC entry 3182 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.function_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.function_name IS '生成功能名';
--
-- TOC entry 3183 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.function_author; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.function_author IS '生成功能作者';
--
-- TOC entry 3184 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.gen_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.gen_type IS '生成代码方式（0zip压缩包 1自定义路径）';
--
-- TOC entry 3185 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.gen_path; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.gen_path IS '生成路径（不填默认项目路径）';
--
-- TOC entry 3186 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.options; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.options IS '其它生成选项';
--
-- TOC entry 3187 (class 0 OID 0)
-- Dependencies: 204
-- Name: COLUMN gen_table.remark; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table.remark IS '备注';
--
-- TOC entry 205 (class 1259 OID 16526)
-- Name: gen_table_column; Type: TABLE; Schema: admin; Owner: -
--
CREATE TABLE admin.gen_table_column (
create_time timestamp without time zone,
update_time timestamp without time zone,
create_user bigint,
update_user bigint,
column_id bigint NOT NULL,
table_id character varying,
column_name character varying NOT NULL,
column_comment character varying,
column_type character varying,
java_type character varying,
java_field character varying,
pk smallint DEFAULT 0 NOT NULL,
increment smallint DEFAULT 0 NOT NULL,
required smallint DEFAULT 0 NOT NULL,
insert smallint DEFAULT 0 NOT NULL,
edit smallint DEFAULT 0 NOT NULL,
list smallint DEFAULT 0 NOT NULL,
query smallint DEFAULT 0 NOT NULL,
query_type smallint DEFAULT 0 NOT NULL,
html_type smallint DEFAULT 0 NOT NULL,
dict_type character varying,
sort smallint
);
--
-- TOC entry 3188 (class 0 OID 0)
-- Dependencies: 205
-- Name: TABLE gen_table_column; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON TABLE admin.gen_table_column IS '代码生成业务表字段';
--
-- TOC entry 3189 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.create_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.create_time IS '创建时间';
--
-- TOC entry 3190 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.update_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.update_time IS '修改时间';
--
-- TOC entry 3191 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.create_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.create_user IS '创建人';
--
-- TOC entry 3192 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.update_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.update_user IS '修改人';
--
-- TOC entry 3193 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.column_id; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.column_id IS '主键';
--
-- TOC entry 3194 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.table_id; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.table_id IS '归属表编号';
--
-- TOC entry 3195 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.column_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.column_name IS '列名称';
--
-- TOC entry 3196 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.column_comment; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.column_comment IS '列描述';
--
-- TOC entry 3197 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.column_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.column_type IS '列类型';
--
-- TOC entry 3198 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.java_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.java_type IS 'JAVA类型';
--
-- TOC entry 3199 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.java_field; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.java_field IS 'JAVA字段名';
--
-- TOC entry 3200 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.pk; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.pk IS '是否主键（0:否 1是）';
--
-- TOC entry 3201 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.increment; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.increment IS '是否自增（0:否 1:是）';
--
-- TOC entry 3202 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.required; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.required IS '是否必填（0:否 1:是）';
--
-- TOC entry 3203 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.insert; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.insert IS '是否为插入字段（0:否 1:是）';
--
-- TOC entry 3204 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.edit; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.edit IS '是否编辑字段（0:否 1:是）';
--
-- TOC entry 3205 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.list; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.list IS '是否编辑字段（0:否 1:是）';
--
-- TOC entry 3206 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.query; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.query IS '是否查询字段（0:否 1是）';
--
-- TOC entry 3207 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.query_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.query_type IS '查询方式（0:等于、1:不等于、2:大于、3:小于、4:范围 5:模糊搜索）';
--
-- TOC entry 3208 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.html_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.html_type IS '显示类型（0:文本框、1:文本域、2:下拉框、3:复选框、4:单选框、5:日期控件 6:图片上传控件 7:富文本）';
--
-- TOC entry 3209 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.dict_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.dict_type IS '字典类型';
--
-- TOC entry 3210 (class 0 OID 0)
-- Dependencies: 205
-- Name: COLUMN gen_table_column.sort; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.gen_table_column.sort IS '排序';
--
-- TOC entry 206 (class 1259 OID 16541)
-- Name: sys_dept; Type: TABLE; Schema: admin; Owner: -
--
CREATE TABLE admin.sys_dept (
create_time timestamp without time zone,
update_time timestamp without time zone,
create_user bigint,
update_user bigint,
id bigint NOT NULL,
dept_name character varying NOT NULL,
parent_id bigint DEFAULT 0 NOT NULL,
sort smallint DEFAULT 0 NOT NULL
);
--
-- TOC entry 3211 (class 0 OID 0)
-- Dependencies: 206
-- Name: COLUMN sys_dept.create_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept.create_time IS '创建时间';
--
-- TOC entry 3212 (class 0 OID 0)
-- Dependencies: 206
-- Name: COLUMN sys_dept.update_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept.update_time IS '修改时间';
--
-- TOC entry 3213 (class 0 OID 0)
-- Dependencies: 206
-- Name: COLUMN sys_dept.create_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept.create_user IS '创建人';
--
-- TOC entry 3214 (class 0 OID 0)
-- Dependencies: 206
-- Name: COLUMN sys_dept.update_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept.update_user IS '修改人';
--
-- TOC entry 3215 (class 0 OID 0)
-- Dependencies: 206
-- Name: COLUMN sys_dept.id; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept.id IS '主键';
--
-- TOC entry 3216 (class 0 OID 0)
-- Dependencies: 206
-- Name: COLUMN sys_dept.dept_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept.dept_name IS '部门名称';
--
-- TOC entry 3217 (class 0 OID 0)
-- Dependencies: 206
-- Name: COLUMN sys_dept.parent_id; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept.parent_id IS '上级部门';
--
-- TOC entry 3218 (class 0 OID 0)
-- Dependencies: 206
-- Name: COLUMN sys_dept.sort; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept.sort IS '排序';
--
-- TOC entry 207 (class 1259 OID 16549)
-- Name: sys_dept_ancestors; Type: TABLE; Schema: admin; Owner: -
--
CREATE TABLE admin.sys_dept_ancestors (
fk_dept_id bigint NOT NULL,
ancestors bigint NOT NULL
);
--
-- TOC entry 3219 (class 0 OID 0)
-- Dependencies: 207
-- Name: COLUMN sys_dept_ancestors.fk_dept_id; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept_ancestors.fk_dept_id IS '部门id';
--
-- TOC entry 3220 (class 0 OID 0)
-- Dependencies: 207
-- Name: COLUMN sys_dept_ancestors.ancestors; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dept_ancestors.ancestors IS '部门id的上级id和祖级id';
--
-- TOC entry 208 (class 1259 OID 16552)
-- Name: sys_dict_data; Type: TABLE; Schema: admin; Owner: -
--
CREATE TABLE admin.sys_dict_data (
create_time timestamp without time zone,
update_time timestamp without time zone,
create_user bigint,
update_user bigint,
dict_code bigint NOT NULL,
dict_sort smallint DEFAULT 0 NOT NULL,
dict_label character varying NOT NULL,
dict_value character varying NOT NULL,
dict_type character varying NOT NULL,
status smallint DEFAULT 0 NOT NULL,
remark character varying
);
--
-- TOC entry 3221 (class 0 OID 0)
-- Dependencies: 208
-- Name: TABLE sys_dict_data; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON TABLE admin.sys_dict_data IS '字典数据表';
--
-- TOC entry 3222 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.create_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.create_time IS '创建时间';
--
-- TOC entry 3223 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.update_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.update_time IS '修改时间';
--
-- TOC entry 3224 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.create_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.create_user IS '创建人';
--
-- TOC entry 3225 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.update_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.update_user IS '修改人';
--
-- TOC entry 3226 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.dict_code; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.dict_code IS '字典编码';
--
-- TOC entry 3227 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.dict_sort; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.dict_sort IS '字典排序';
--
-- TOC entry 3228 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.dict_label; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.dict_label IS '字典标签';
--
-- TOC entry 3229 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.dict_value; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.dict_value IS '字典值';
--
-- TOC entry 3230 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.dict_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.dict_type IS '字典类型';
--
-- TOC entry 3231 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.status; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.status IS '字典状态(0:正常 1:停用)';
--
-- TOC entry 3232 (class 0 OID 0)
-- Dependencies: 208
-- Name: COLUMN sys_dict_data.remark; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_data.remark IS '备注';
--
-- TOC entry 209 (class 1259 OID 16560)
-- Name: sys_dict_type; Type: TABLE; Schema: admin; Owner: -
--
CREATE TABLE admin.sys_dict_type (
create_time timestamp without time zone,
update_time timestamp without time zone,
create_user bigint,
update_user bigint,
id bigint NOT NULL,
dict_name character varying NOT NULL,
dict_type character varying NOT NULL,
status smallint DEFAULT 0 NOT NULL,
remark character varying
);
--
-- TOC entry 3233 (class 0 OID 0)
-- Dependencies: 209
-- Name: TABLE sys_dict_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON TABLE admin.sys_dict_type IS '字典类型';
--
-- TOC entry 3234 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN sys_dict_type.create_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_type.create_time IS '创建时间';
--
-- TOC entry 3235 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN sys_dict_type.update_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_type.update_time IS '修改时间';
--
-- TOC entry 3236 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN sys_dict_type.create_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_type.create_user IS '创建人';
--
-- TOC entry 3237 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN sys_dict_type.update_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_type.update_user IS '修改人';
--
-- TOC entry 3238 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN sys_dict_type.dict_name; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_type.dict_name IS '字典名称';
--
-- TOC entry 3239 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN sys_dict_type.dict_type; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_type.dict_type IS '字典类型';
--
-- TOC entry 3240 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN sys_dict_type.status; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_type.status IS '字典状态 0:正常 1:停用';
--
-- TOC entry 3241 (class 0 OID 0)
-- Dependencies: 209
-- Name: COLUMN sys_dict_type.remark; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_dict_type.remark IS '备注';
--
-- TOC entry 210 (class 1259 OID 16567)
-- Name: sys_i18n; Type: TABLE; Schema: admin; Owner: -
--
CREATE TABLE admin.sys_i18n (
id bigint NOT NULL,
i18n_key character varying NOT NULL,
i18n_value character varying NOT NULL,
language character varying NOT NULL,
i18n_tag character varying NOT NULL,
create_time timestamp without time zone,
update_time timestamp without time zone,
create_user bigint,
update_user bigint
);
--
-- TOC entry 3242 (class 0 OID 0)
-- Dependencies: 210
-- Name: TABLE sys_i18n; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON TABLE admin.sys_i18n IS 'i18n数据管理';
--
-- TOC entry 3243 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.id; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.id IS '主键';
--
-- TOC entry 3244 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.i18n_key; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.i18n_key IS 'i18n编码';
--
-- TOC entry 3245 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.i18n_value; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.i18n_value IS 'i18n值';
--
-- TOC entry 3246 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.language; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.language IS 'i18n地区编码(字典:i18n:language)';
--
-- TOC entry 3247 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.i18n_tag; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.i18n_tag IS 'i18n标签(字典:i18n:tag)';
--
-- TOC entry 3248 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.create_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.create_time IS '创建时间';
--
-- TOC entry 3249 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.update_time; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.update_time IS '修改时间';
--
-- TOC entry 3250 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.create_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.create_user IS '创建人';
--
-- TOC entry 3251 (class 0 OID 0)
-- Dependencies: 210
-- Name: COLUMN sys_i18n.update_user; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON COLUMN admin.sys_i18n.update_user IS '修改人';
--
-- TOC entry 211 (class 1259 OID 16573)
-- Name: sys_menu; Type: TABLE; Schema: admin; Owner: -
--
CREATE TABLE admin.sys_menu (
create_time timestamp without time zone,
update_time timestamp without time zone,
create_user bigint,
update_user bigint,
id bigint NOT NULL,
label character varying NOT NULL,
name character varying,
path character varying,
open_type smallint DEFAULT 1 NOT NULL,
auth character varying,
parent_id bigint DEFAULT 0,
type smallint,
sort smallint DEFAULT 0,
component character varying,
icon character varying,
is_cache smallint DEFAULT 0 NOT NULL,
is_display smallint DEFAULT 0 NOT NULL,
is_outside smallint DEFAULT 0 NOT NULL,
query character varying
);
--
-- TOC entry 3252 (class 0 OID 0)
-- Dependencies: 211
-- Name: TABLE sys_menu; Type: COMMENT; Schema: admin; Owner: -
--
COMMENT ON TABLE admin.sys_menu IS '菜单/权限表';