plat.sql 3.6 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156
  1. drop table if exists bank_card_issuer_info;
  2. create table bank_card_issuer_info
  3. (
  4. bank_bin TEXT not null primary key,
  5. bank_name TEXT,
  6. card_type TEXT,
  7. flag INTEGER
  8. );
  9. drop table if exists case_info;
  10. create table case_info
  11. (
  12. -- 主键由应用侧雪花算法生成,不使用自增
  13. id BIGINT not null primary key,
  14. name TEXT,
  15. pwd TEXT,
  16. type TEXT,
  17. remark TEXT,
  18. db TEXT,
  19. db_Path TEXT,
  20. init INTEGER,
  21. create_time DATE
  22. );
  23. drop table if exists phone_isp;
  24. create table phone_isp
  25. (
  26. paragraph TEXT not null primary key,
  27. province TEXT,
  28. city TEXT,
  29. isp TEXT
  30. );
  31. drop table if exists system_info;
  32. create table system_info
  33. (
  34. machinecode TEXT,
  35. client_no TEXT,
  36. unit TEXT,
  37. phone TEXT,
  38. active_date_time DATE,
  39. authdatetime DATE,
  40. overdatetime DATE
  41. );
  42. drop table if exists table_field;
  43. create table table_field
  44. (
  45. -- 主键由应用侧雪花算法生成,不使用自增
  46. id BIGINT not null primary key,
  47. table_id INTEGER not null,
  48. field_name_cn TEXT,
  49. field_name_en TEXT,
  50. field_type TEXT,
  51. required INTEGER default 0 not null,
  52. field_len INTEGER default 0 not null,
  53. matched INTEGER,
  54. direction_conf TEXT,
  55. field_sort INTEGER
  56. );
  57. drop table if exists table_info;
  58. create table table_info
  59. (
  60. id INTEGER not null primary key,
  61. main_id INTEGER,
  62. table_name_cn TEXT,
  63. table_name_en TEXT,
  64. headers TEXT,
  65. classify TEXT,
  66. func_regex TEXT,
  67. line_no INTEGER default 0,
  68. has_inner INTEGER default 0,
  69. create_time DATE
  70. );
  71. DROP TABLE IF EXISTS `chat_message`;
  72. CREATE TABLE `chat_message`
  73. (
  74. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  75. `session_id` TEXT,
  76. `content` TEXT,
  77. `role` TEXT,
  78. `model_name` TEXT
  79. );
  80. DROP TABLE IF EXISTS `chat_session`;
  81. CREATE TABLE `chat_session`
  82. (
  83. `id` TEXT,
  84. `case_id` INTEGER,
  85. `session_title` TEXT,
  86. `session_content` TEXT,
  87. `conversation_id` TEXT
  88. );
  89. DROP TABLE IF EXISTS `chat_model`;
  90. CREATE TABLE `chat_model`
  91. (
  92. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  93. `category` TEXT,
  94. `model_name` TEXT,
  95. `provider_code` TEXT,
  96. `model_describe` TEXT,
  97. `model_dimension` INTEGER,
  98. `api_host` TEXT,
  99. `api_key` TEXT
  100. );
  101. DROP TABLE IF EXISTS `chat_provider`;
  102. CREATE TABLE `chat_provider`
  103. (
  104. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  105. `provider_name` TEXT,
  106. `provider_code` TEXT,
  107. `provider_icon` TEXT,
  108. `provider_desc` TEXT,
  109. `api_host` TEXT
  110. );
  111. DROP TABLE IF EXISTS `knowledge_attach`;
  112. CREATE TABLE `knowledge_attach`
  113. (
  114. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  115. `knowledge_id` INTEGER,
  116. `oss_id` INTEGER,
  117. `doc_id` TEXT,
  118. `name` TEXT,
  119. `type` TEXT
  120. );
  121. DROP TABLE IF EXISTS `knowledge_fragment`;
  122. CREATE TABLE `knowledge_fragment`
  123. (
  124. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  125. `idx` INTEGER,
  126. `doc_id` TEXT,
  127. `content` TEXT
  128. );
  129. DROP TABLE IF EXISTS `knowledge_info`;
  130. CREATE TABLE `knowledge_info`
  131. (
  132. `id` INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
  133. `name` TEXT,
  134. `share` INTEGER,
  135. `description` TEXT,
  136. `separator` TEXT,
  137. `overlap_char` INTEGER,
  138. `retrieve_limit` INTEGER,
  139. `text_block_size` INTEGER,
  140. `vector_model` TEXT,
  141. `embedding_model` TEXT
  142. );