dic.ddl.sql 2.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384
  1. ##数据字典表
  2. # 字典类型
  3. create table dic_dt_type
  4. (
  5. id varchar(20) not null primary key ,
  6. group_code varchar(20) null,
  7. type varchar(40) not null,
  8. name varchar(40) not null,
  9. description varchar(200) null,
  10. status int not null,
  11. create_time timestamp null,
  12. create_by varchar(40) null,
  13. update_time timestamp null,
  14. update_by varchar(40) null,
  15. remark varchar(200) null
  16. );
  17. # 字典数据
  18. create table dic_dt_data
  19. (
  20. id varchar(20) not null primary key ,
  21. dict_type_id varchar(20) not null,
  22. parent_id varchar(20) null,
  23. type varchar(40) not null,
  24. code varchar(40) not null,
  25. label varchar(40) not null,
  26. status int not null,
  27. create_time timestamp null,
  28. create_by varchar(40) null,
  29. update_time timestamp null,
  30. update_by varchar(40) null,
  31. remark varchar(200) null
  32. );
  33. # 字典数据映射
  34. create table dic_dt_data_map
  35. (
  36. id varchar(20) not null primary key ,
  37. dict_data_id varchar(20) not null,
  38. type varchar(40) not null,
  39. group_code varchar(20) not null,
  40. target_code varchar(20) not null,
  41. label varchar(40) not null,
  42. code varchar(40) not null,
  43. status int not null,
  44. create_time timestamp null,
  45. create_by varchar(40) null,
  46. update_time timestamp null,
  47. update_by varchar(40) null,
  48. remark varchar(200) null
  49. );
  50. # 知识库类型
  51. create table dic_kl_type
  52. (
  53. id varchar(20) not null primary key ,
  54. code varchar(40) not null,
  55. name varchar(40) not null,
  56. description varchar(500) null,
  57. status int not null,
  58. create_time timestamp null,
  59. create_by varchar(40) null,
  60. update_time timestamp null,
  61. update_by varchar(40) null,
  62. remark varchar(200) null
  63. );
  64. # 知识库数据
  65. create table dic_kl_data
  66. (
  67. id varchar(20) not null primary key ,
  68. kl_type_code varchar(20) not null,
  69. kl_type_name varchar(40) not null,
  70. parent_id varchar(20) null,
  71. code varchar(40) not null,
  72. label varchar(40) not null,
  73. value varchar(500) null,
  74. status int not null,
  75. create_time timestamp null,
  76. create_by varchar(40) null,
  77. update_time timestamp null,
  78. update_by varchar(40) null,
  79. remark varchar(200) null
  80. );