cms.sql 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537
  1. /* Create Tables */
  2. -- 文章表
  3. CREATE TABLE js_cms_article
  4. (
  5. id varchar(64) NOT NULL,
  6. category_code varchar(64) NOT NULL,
  7. module_type varchar(50),
  8. title varchar(255) NOT NULL,
  9. href varchar(1000),
  10. color varchar(50),
  11. image varchar(1000),
  12. keywords varchar(500),
  13. description varchar(500),
  14. weight decimal(10) DEFAULT 0,
  15. weight_date timestamp,
  16. source char(1),
  17. copyfrom varchar(255),
  18. hits decimal(20) DEFAULT 0,
  19. hits_plus numeric(10),
  20. hits_minus numeric(10),
  21. word_count numeric(10),
  22. custom_content_view varchar(255),
  23. view_config varchar(1000),
  24. status char(1) DEFAULT '0' NOT NULL,
  25. create_by varchar(64) NOT NULL,
  26. create_date timestamp NOT NULL,
  27. update_by varchar(64) NOT NULL,
  28. update_date timestamp NOT NULL,
  29. remarks varchar(500),
  30. corp_code varchar(64) DEFAULT '0' NOT NULL,
  31. corp_name varchar(100) DEFAULT 'JeeSite' NOT NULL,
  32. PRIMARY KEY (id)
  33. ) WITHOUT OIDS;
  34. -- 文章详情表
  35. CREATE TABLE js_cms_article_data
  36. (
  37. id varchar(64) NOT NULL,
  38. content text,
  39. relation varchar(1000),
  40. is_can_comment char(1),
  41. extend_s1 varchar(500),
  42. extend_s2 varchar(500),
  43. extend_s3 varchar(500),
  44. extend_s4 varchar(500),
  45. extend_s5 varchar(500),
  46. extend_s6 varchar(500),
  47. extend_s7 varchar(500),
  48. extend_s8 varchar(500),
  49. extend_i1 decimal(19),
  50. extend_i2 decimal(19),
  51. extend_i3 decimal(19),
  52. extend_i4 decimal(19),
  53. extend_f1 decimal(19,4),
  54. extend_f2 decimal(19,4),
  55. extend_f3 decimal(19,4),
  56. extend_f4 decimal(19,4),
  57. extend_d1 timestamp,
  58. extend_d2 timestamp,
  59. extend_d3 timestamp,
  60. extend_d4 timestamp,
  61. PRIMARY KEY (id)
  62. ) WITHOUT OIDS;
  63. -- 文章推荐位
  64. CREATE TABLE js_cms_article_posid
  65. (
  66. article_id varchar(64) NOT NULL,
  67. postid char(1) NOT NULL
  68. ) WITHOUT OIDS;
  69. -- 文章与标签关系
  70. CREATE TABLE js_cms_article_tag
  71. (
  72. article_id varchar(64) NOT NULL,
  73. tag_name varchar(200) NOT NULL
  74. ) WITHOUT OIDS;
  75. -- 栏目表
  76. CREATE TABLE js_cms_category
  77. (
  78. category_code varchar(64) NOT NULL,
  79. parent_code varchar(64) NOT NULL,
  80. parent_codes varchar(767) NOT NULL,
  81. tree_sort decimal(10) NOT NULL,
  82. tree_sorts varchar(767) NOT NULL,
  83. tree_leaf char(1) NOT NULL,
  84. tree_level decimal(4) NOT NULL,
  85. tree_names varchar(767) NOT NULL,
  86. category_name varchar(100) NOT NULL,
  87. site_code varchar(64) NOT NULL,
  88. module_type varchar(50),
  89. image varchar(255),
  90. href varchar(255),
  91. target varchar(20),
  92. keywords varchar(500),
  93. description varchar(500),
  94. in_menu char(1),
  95. in_list char(1),
  96. show_modes char(1),
  97. is_need_audit char(1),
  98. is_can_comment char(1),
  99. custom_list_view varchar(255),
  100. custom_content_view varchar(255),
  101. view_config varchar(1000),
  102. status char(1) DEFAULT '0' NOT NULL,
  103. create_by varchar(64) NOT NULL,
  104. create_date timestamp NOT NULL,
  105. update_by varchar(64) NOT NULL,
  106. update_date timestamp NOT NULL,
  107. remarks varchar(500),
  108. extend_s1 varchar(500),
  109. extend_s2 varchar(500),
  110. extend_s3 varchar(500),
  111. extend_s4 varchar(500),
  112. extend_s5 varchar(500),
  113. extend_s6 varchar(500),
  114. extend_s7 varchar(500),
  115. extend_s8 varchar(500),
  116. extend_i1 decimal(19),
  117. extend_i2 decimal(19),
  118. extend_i3 decimal(19),
  119. extend_i4 decimal(19),
  120. extend_f1 decimal(19,4),
  121. extend_f2 decimal(19,4),
  122. extend_f3 decimal(19,4),
  123. extend_f4 decimal(19,4),
  124. extend_d1 timestamp,
  125. extend_d2 timestamp,
  126. extend_d3 timestamp,
  127. extend_d4 timestamp,
  128. PRIMARY KEY (category_code)
  129. ) WITHOUT OIDS;
  130. -- 栏目与角色关联表
  131. CREATE TABLE js_cms_category_role
  132. (
  133. category_code varchar(64) NOT NULL,
  134. role_code varchar(64) NOT NULL,
  135. ctrl_type varchar(32),
  136. PRIMARY KEY (category_code, role_code)
  137. ) WITHOUT OIDS;
  138. -- 文章评论表
  139. CREATE TABLE js_cms_comment
  140. (
  141. id varchar(64) NOT NULL,
  142. category_code varchar(64) NOT NULL,
  143. article_id varchar(64) NOT NULL,
  144. parent_id varchar(64),
  145. article_title varchar(255) NOT NULL,
  146. content varchar(255) NOT NULL,
  147. name varchar(50),
  148. ip varchar(100),
  149. create_by varchar(64),
  150. create_date timestamp NOT NULL,
  151. audit_user_code varchar(64),
  152. audit_date timestamp,
  153. audit_comment varchar(200),
  154. hits_plus numeric(10),
  155. hits_minus numeric(10),
  156. status char(1) NOT NULL,
  157. corp_code varchar(64) DEFAULT '0' NOT NULL,
  158. corp_name varchar(100) DEFAULT 'JeeSite' NOT NULL,
  159. PRIMARY KEY (id)
  160. ) WITHOUT OIDS;
  161. -- 留言板表
  162. CREATE TABLE js_cms_guestbook
  163. (
  164. id varchar(64) NOT NULL,
  165. type char(1) NOT NULL,
  166. content varchar(255) NOT NULL,
  167. name varchar(100) NOT NULL,
  168. email varchar(100) NOT NULL,
  169. phone varchar(100) NOT NULL,
  170. workunit varchar(100) NOT NULL,
  171. ip varchar(100) NOT NULL,
  172. create_by varchar(64),
  173. create_date timestamp,
  174. re_user_code varchar(64),
  175. re_date timestamp,
  176. re_content varchar(100),
  177. status char(1) NOT NULL,
  178. corp_code varchar(64) DEFAULT '0' NOT NULL,
  179. corp_name varchar(100) DEFAULT 'JeeSite' NOT NULL,
  180. PRIMARY KEY (id)
  181. ) WITHOUT OIDS;
  182. -- 内容举报表
  183. CREATE TABLE js_cms_report
  184. (
  185. id varchar(64) NOT NULL,
  186. report_source char(1),
  187. report_content varchar(500),
  188. report_url varchar(1000),
  189. report_type char(1),
  190. report_cause varchar(500),
  191. PRIMARY KEY (id)
  192. ) WITHOUT OIDS;
  193. -- 站点表
  194. CREATE TABLE js_cms_site
  195. (
  196. site_code varchar(64) NOT NULL,
  197. site_name varchar(100) NOT NULL,
  198. site_sort decimal(10),
  199. title varchar(100) NOT NULL,
  200. logo varchar(1000),
  201. domain varchar(500),
  202. keywords varchar(500),
  203. description varchar(500),
  204. theme varchar(500),
  205. copyright varchar(1000),
  206. custom_index_view varchar(500),
  207. status char(1) DEFAULT '0' NOT NULL,
  208. create_by varchar(64) NOT NULL,
  209. create_date timestamp NOT NULL,
  210. update_by varchar(64) NOT NULL,
  211. update_date timestamp NOT NULL,
  212. remarks varchar(500),
  213. PRIMARY KEY (site_code)
  214. ) WITHOUT OIDS;
  215. -- 内容标签
  216. CREATE TABLE js_cms_tag
  217. (
  218. tag_name varchar(200) NOT NULL,
  219. clicknum numeric(10) NOT NULL,
  220. PRIMARY KEY (tag_name)
  221. ) WITHOUT OIDS;
  222. -- 访问日志表
  223. CREATE TABLE js_cms_visit_log
  224. (
  225. id varchar(64) NOT NULL,
  226. request_url varchar(1000),
  227. request_url_host varchar(128),
  228. source_referer varchar(1000),
  229. source_referer_host varchar(128),
  230. source_type char(1),
  231. search_engine varchar(200),
  232. search_word varchar(200),
  233. remote_addr varchar(50),
  234. user_agent varchar(500),
  235. user_language varchar(32),
  236. user_screen_size varchar(32),
  237. user_device varchar(32),
  238. user_os_name varchar(32),
  239. user_browser varchar(32),
  240. user_browser_version varchar(16),
  241. unique_visit_id varchar(64),
  242. visit_date char(8),
  243. visit_time timestamp,
  244. is_new_visit char(1),
  245. first_visit_time decimal(20),
  246. prev_remain_time decimal(20),
  247. total_remain_time decimal(20),
  248. site_code varchar(64),
  249. site_name varchar(100),
  250. category_code varchar(64),
  251. category_name varchar(100),
  252. content_id varchar(64),
  253. content_title varchar(255),
  254. visit_user_code varchar(100),
  255. visit_user_name varchar(100),
  256. corp_code varchar(64) DEFAULT '0' NOT NULL,
  257. corp_name varchar(100) DEFAULT 'JeeSite' NOT NULL,
  258. PRIMARY KEY (id)
  259. ) WITHOUT OIDS;
  260. /* Create Indexes */
  261. CREATE INDEX idx_cms_article_cb ON js_cms_article (create_by);
  262. CREATE INDEX idx_cms_article_cc ON js_cms_article (category_code);
  263. CREATE INDEX idx_cms_article_corp_code ON js_cms_article (corp_code);
  264. CREATE INDEX idx_cms_article_status ON js_cms_article (status);
  265. CREATE INDEX idx_cms_article_ud ON js_cms_article (update_date);
  266. CREATE INDEX idx_cms_article_weight ON js_cms_article (weight);
  267. CREATE INDEX idx_cms_category_pc ON js_cms_category (parent_code);
  268. CREATE INDEX idx_cms_category_ts ON js_cms_category (tree_sort);
  269. CREATE INDEX idx_cms_category_status ON js_cms_category (status);
  270. CREATE INDEX idx_cms_category_tss ON js_cms_category (tree_sorts);
  271. CREATE INDEX idx_cms_comment_catc ON js_cms_comment (category_code);
  272. CREATE INDEX idx_cms_comment_ai ON js_cms_comment (article_id);
  273. CREATE INDEX idx_cms_comment_cc ON js_cms_comment (corp_code);
  274. CREATE INDEX idx_cms_comment_status ON js_cms_comment (status);
  275. CREATE INDEX idx_cms_guestbook_cc ON js_cms_guestbook (corp_code);
  276. CREATE INDEX idx_cms_guestbook_status ON js_cms_guestbook (status);
  277. CREATE INDEX idx_cms_guestbook_type ON js_cms_guestbook (type);
  278. CREATE INDEX idx_cms_site_status ON js_cms_site (status);
  279. CREATE INDEX cms_visit_log_cc ON js_cms_visit_log (category_code);
  280. CREATE INDEX cms_visit_log_ci ON js_cms_visit_log (content_id);
  281. CREATE INDEX cms_visit_log_fvt ON js_cms_visit_log (first_visit_time);
  282. CREATE INDEX cms_visit_log_inv ON js_cms_visit_log (is_new_visit);
  283. CREATE INDEX cms_visit_log_ra ON js_cms_visit_log (remote_addr);
  284. CREATE INDEX cms_visit_log_sc ON js_cms_visit_log (site_code);
  285. CREATE INDEX cms_visit_log_uvid ON js_cms_visit_log (unique_visit_id);
  286. CREATE INDEX cms_visit_log_vd ON js_cms_visit_log (visit_date);
  287. CREATE INDEX cms_visit_log_vt ON js_cms_visit_log (visit_time);
  288. CREATE INDEX idx_cms_visit_log_corpc ON js_cms_visit_log (corp_code);
  289. /* Comments */
  290. COMMENT ON TABLE js_cms_article IS '文章表';
  291. COMMENT ON COLUMN js_cms_article.id IS '编号';
  292. COMMENT ON COLUMN js_cms_article.category_code IS '栏目编码';
  293. COMMENT ON COLUMN js_cms_article.module_type IS '模块类型';
  294. COMMENT ON COLUMN js_cms_article.title IS '内容标题';
  295. COMMENT ON COLUMN js_cms_article.href IS '外部链接';
  296. COMMENT ON COLUMN js_cms_article.color IS '标题颜色';
  297. COMMENT ON COLUMN js_cms_article.image IS '内容图片';
  298. COMMENT ON COLUMN js_cms_article.keywords IS '关键字';
  299. COMMENT ON COLUMN js_cms_article.description IS '描述';
  300. COMMENT ON COLUMN js_cms_article.weight IS '权重,越大越靠前';
  301. COMMENT ON COLUMN js_cms_article.weight_date IS '权重期限';
  302. COMMENT ON COLUMN js_cms_article.source IS '来源(转载/原创)';
  303. COMMENT ON COLUMN js_cms_article.copyfrom IS '文章来源出处';
  304. COMMENT ON COLUMN js_cms_article.hits IS '点击数';
  305. COMMENT ON COLUMN js_cms_article.hits_plus IS '支持数';
  306. COMMENT ON COLUMN js_cms_article.hits_minus IS '反对数';
  307. COMMENT ON COLUMN js_cms_article.word_count IS '字数(不包含html)';
  308. COMMENT ON COLUMN js_cms_article.custom_content_view IS '自定义内容视图';
  309. COMMENT ON COLUMN js_cms_article.view_config IS '视图配置';
  310. COMMENT ON COLUMN js_cms_article.status IS '状态(0正常 1删除 2停用)';
  311. COMMENT ON COLUMN js_cms_article.create_by IS '创建者';
  312. COMMENT ON COLUMN js_cms_article.create_date IS '创建时间';
  313. COMMENT ON COLUMN js_cms_article.update_by IS '更新者';
  314. COMMENT ON COLUMN js_cms_article.update_date IS '更新时间';
  315. COMMENT ON COLUMN js_cms_article.remarks IS '备注信息';
  316. COMMENT ON COLUMN js_cms_article.corp_code IS '租户代码';
  317. COMMENT ON COLUMN js_cms_article.corp_name IS '租户名称';
  318. COMMENT ON TABLE js_cms_article_data IS '文章详情表';
  319. COMMENT ON COLUMN js_cms_article_data.id IS '编号';
  320. COMMENT ON COLUMN js_cms_article_data.content IS '文章内容';
  321. COMMENT ON COLUMN js_cms_article_data.relation IS '相关文章';
  322. COMMENT ON COLUMN js_cms_article_data.is_can_comment IS '是否允许评论';
  323. COMMENT ON COLUMN js_cms_article_data.extend_s1 IS '扩展 String 1';
  324. COMMENT ON COLUMN js_cms_article_data.extend_s2 IS '扩展 String 2';
  325. COMMENT ON COLUMN js_cms_article_data.extend_s3 IS '扩展 String 3';
  326. COMMENT ON COLUMN js_cms_article_data.extend_s4 IS '扩展 String 4';
  327. COMMENT ON COLUMN js_cms_article_data.extend_s5 IS '扩展 String 5';
  328. COMMENT ON COLUMN js_cms_article_data.extend_s6 IS '扩展 String 6';
  329. COMMENT ON COLUMN js_cms_article_data.extend_s7 IS '扩展 String 7';
  330. COMMENT ON COLUMN js_cms_article_data.extend_s8 IS '扩展 String 8';
  331. COMMENT ON COLUMN js_cms_article_data.extend_i1 IS '扩展 Integer 1';
  332. COMMENT ON COLUMN js_cms_article_data.extend_i2 IS '扩展 Integer 2';
  333. COMMENT ON COLUMN js_cms_article_data.extend_i3 IS '扩展 Integer 3';
  334. COMMENT ON COLUMN js_cms_article_data.extend_i4 IS '扩展 Integer 4';
  335. COMMENT ON COLUMN js_cms_article_data.extend_f1 IS '扩展 Float 1';
  336. COMMENT ON COLUMN js_cms_article_data.extend_f2 IS '扩展 Float 2';
  337. COMMENT ON COLUMN js_cms_article_data.extend_f3 IS '扩展 Float 3';
  338. COMMENT ON COLUMN js_cms_article_data.extend_f4 IS '扩展 Float 4';
  339. COMMENT ON COLUMN js_cms_article_data.extend_d1 IS '扩展 Date 1';
  340. COMMENT ON COLUMN js_cms_article_data.extend_d2 IS '扩展 Date 2';
  341. COMMENT ON COLUMN js_cms_article_data.extend_d3 IS '扩展 Date 3';
  342. COMMENT ON COLUMN js_cms_article_data.extend_d4 IS '扩展 Date 4';
  343. COMMENT ON TABLE js_cms_article_posid IS '文章推荐位';
  344. COMMENT ON COLUMN js_cms_article_posid.article_id IS '内容编号';
  345. COMMENT ON COLUMN js_cms_article_posid.postid IS '推荐位置(1轮播图 2首页推荐 3栏目页面)';
  346. COMMENT ON TABLE js_cms_article_tag IS '文章与标签关系';
  347. COMMENT ON COLUMN js_cms_article_tag.article_id IS '内容编号';
  348. COMMENT ON COLUMN js_cms_article_tag.tag_name IS '标签名称';
  349. COMMENT ON TABLE js_cms_category IS '栏目表';
  350. COMMENT ON COLUMN js_cms_category.category_code IS '栏目编码';
  351. COMMENT ON COLUMN js_cms_category.parent_code IS '父级编号';
  352. COMMENT ON COLUMN js_cms_category.parent_codes IS '所有父级编号';
  353. COMMENT ON COLUMN js_cms_category.tree_sort IS '排序号(升序)';
  354. COMMENT ON COLUMN js_cms_category.tree_sorts IS '所有排序号';
  355. COMMENT ON COLUMN js_cms_category.tree_leaf IS '是否最末级';
  356. COMMENT ON COLUMN js_cms_category.tree_level IS '层次级别';
  357. COMMENT ON COLUMN js_cms_category.tree_names IS '全节点名';
  358. COMMENT ON COLUMN js_cms_category.category_name IS '栏目名称';
  359. COMMENT ON COLUMN js_cms_category.site_code IS '站点编码';
  360. COMMENT ON COLUMN js_cms_category.module_type IS '模块类型';
  361. COMMENT ON COLUMN js_cms_category.image IS '栏目图片';
  362. COMMENT ON COLUMN js_cms_category.href IS '链接';
  363. COMMENT ON COLUMN js_cms_category.target IS '目标';
  364. COMMENT ON COLUMN js_cms_category.keywords IS '关键字';
  365. COMMENT ON COLUMN js_cms_category.description IS '描述';
  366. COMMENT ON COLUMN js_cms_category.in_menu IS '是否在导航中显示';
  367. COMMENT ON COLUMN js_cms_category.in_list IS '是否在分类页中显示列表';
  368. COMMENT ON COLUMN js_cms_category.show_modes IS '展现模式';
  369. COMMENT ON COLUMN js_cms_category.is_need_audit IS '是否需要审核';
  370. COMMENT ON COLUMN js_cms_category.is_can_comment IS '是否允许评论';
  371. COMMENT ON COLUMN js_cms_category.custom_list_view IS '自定义列表视图';
  372. COMMENT ON COLUMN js_cms_category.custom_content_view IS '自定义内容视图';
  373. COMMENT ON COLUMN js_cms_category.view_config IS '视图配置';
  374. COMMENT ON COLUMN js_cms_category.status IS '状态(0正常 1删除 2停用)';
  375. COMMENT ON COLUMN js_cms_category.create_by IS '创建者';
  376. COMMENT ON COLUMN js_cms_category.create_date IS '创建时间';
  377. COMMENT ON COLUMN js_cms_category.update_by IS '更新者';
  378. COMMENT ON COLUMN js_cms_category.update_date IS '更新时间';
  379. COMMENT ON COLUMN js_cms_category.remarks IS '备注信息';
  380. COMMENT ON COLUMN js_cms_category.extend_s1 IS '扩展 String 1';
  381. COMMENT ON COLUMN js_cms_category.extend_s2 IS '扩展 String 2';
  382. COMMENT ON COLUMN js_cms_category.extend_s3 IS '扩展 String 3';
  383. COMMENT ON COLUMN js_cms_category.extend_s4 IS '扩展 String 4';
  384. COMMENT ON COLUMN js_cms_category.extend_s5 IS '扩展 String 5';
  385. COMMENT ON COLUMN js_cms_category.extend_s6 IS '扩展 String 6';
  386. COMMENT ON COLUMN js_cms_category.extend_s7 IS '扩展 String 7';
  387. COMMENT ON COLUMN js_cms_category.extend_s8 IS '扩展 String 8';
  388. COMMENT ON COLUMN js_cms_category.extend_i1 IS '扩展 Integer 1';
  389. COMMENT ON COLUMN js_cms_category.extend_i2 IS '扩展 Integer 2';
  390. COMMENT ON COLUMN js_cms_category.extend_i3 IS '扩展 Integer 3';
  391. COMMENT ON COLUMN js_cms_category.extend_i4 IS '扩展 Integer 4';
  392. COMMENT ON COLUMN js_cms_category.extend_f1 IS '扩展 Float 1';
  393. COMMENT ON COLUMN js_cms_category.extend_f2 IS '扩展 Float 2';
  394. COMMENT ON COLUMN js_cms_category.extend_f3 IS '扩展 Float 3';
  395. COMMENT ON COLUMN js_cms_category.extend_f4 IS '扩展 Float 4';
  396. COMMENT ON COLUMN js_cms_category.extend_d1 IS '扩展 Date 1';
  397. COMMENT ON COLUMN js_cms_category.extend_d2 IS '扩展 Date 2';
  398. COMMENT ON COLUMN js_cms_category.extend_d3 IS '扩展 Date 3';
  399. COMMENT ON COLUMN js_cms_category.extend_d4 IS '扩展 Date 4';
  400. COMMENT ON TABLE js_cms_category_role IS '栏目与角色关联表';
  401. COMMENT ON COLUMN js_cms_category_role.category_code IS '栏目编码';
  402. COMMENT ON COLUMN js_cms_category_role.role_code IS '角色编码';
  403. COMMENT ON COLUMN js_cms_category_role.ctrl_type IS '控制类型(view查看、edit编辑)';
  404. COMMENT ON TABLE js_cms_comment IS '文章评论表';
  405. COMMENT ON COLUMN js_cms_comment.id IS '编号';
  406. COMMENT ON COLUMN js_cms_comment.category_code IS '栏目编码';
  407. COMMENT ON COLUMN js_cms_comment.article_id IS '内容编号';
  408. COMMENT ON COLUMN js_cms_comment.parent_id IS '父级评论';
  409. COMMENT ON COLUMN js_cms_comment.article_title IS '内容标题';
  410. COMMENT ON COLUMN js_cms_comment.content IS '评论内容';
  411. COMMENT ON COLUMN js_cms_comment.name IS '评论姓名';
  412. COMMENT ON COLUMN js_cms_comment.ip IS '评论IP';
  413. COMMENT ON COLUMN js_cms_comment.create_by IS '创建者';
  414. COMMENT ON COLUMN js_cms_comment.create_date IS '创建时间';
  415. COMMENT ON COLUMN js_cms_comment.audit_user_code IS '审核人';
  416. COMMENT ON COLUMN js_cms_comment.audit_date IS '审核时间';
  417. COMMENT ON COLUMN js_cms_comment.audit_comment IS '审核意见';
  418. COMMENT ON COLUMN js_cms_comment.hits_plus IS '支持数';
  419. COMMENT ON COLUMN js_cms_comment.hits_minus IS '反对数';
  420. COMMENT ON COLUMN js_cms_comment.status IS '状态(0正常 1删除 2停用)';
  421. COMMENT ON COLUMN js_cms_comment.corp_code IS '租户代码';
  422. COMMENT ON COLUMN js_cms_comment.corp_name IS '租户名称';
  423. COMMENT ON TABLE js_cms_guestbook IS '留言板表';
  424. COMMENT ON COLUMN js_cms_guestbook.id IS '编号';
  425. COMMENT ON COLUMN js_cms_guestbook.type IS '留言分类';
  426. COMMENT ON COLUMN js_cms_guestbook.content IS '留言内容';
  427. COMMENT ON COLUMN js_cms_guestbook.name IS '姓名';
  428. COMMENT ON COLUMN js_cms_guestbook.email IS '邮箱';
  429. COMMENT ON COLUMN js_cms_guestbook.phone IS '电话';
  430. COMMENT ON COLUMN js_cms_guestbook.workunit IS '单位';
  431. COMMENT ON COLUMN js_cms_guestbook.ip IS 'IP';
  432. COMMENT ON COLUMN js_cms_guestbook.create_by IS '创建者';
  433. COMMENT ON COLUMN js_cms_guestbook.create_date IS '创建时间';
  434. COMMENT ON COLUMN js_cms_guestbook.re_user_code IS '回复人';
  435. COMMENT ON COLUMN js_cms_guestbook.re_date IS '回复时间';
  436. COMMENT ON COLUMN js_cms_guestbook.re_content IS '回复内容';
  437. COMMENT ON COLUMN js_cms_guestbook.status IS '状态(0正常 1删除 2停用)';
  438. COMMENT ON COLUMN js_cms_guestbook.corp_code IS '租户代码';
  439. COMMENT ON COLUMN js_cms_guestbook.corp_name IS '租户名称';
  440. COMMENT ON TABLE js_cms_report IS '内容举报表';
  441. COMMENT ON COLUMN js_cms_report.id IS '编号';
  442. COMMENT ON COLUMN js_cms_report.report_source IS '举报来源(1文章、2评论)';
  443. COMMENT ON COLUMN js_cms_report.report_content IS '举报内容(文章标题 评论内容)';
  444. COMMENT ON COLUMN js_cms_report.report_url IS '举报的URL';
  445. COMMENT ON COLUMN js_cms_report.report_type IS '举报类型(色情 政治...)';
  446. COMMENT ON COLUMN js_cms_report.report_cause IS '举报原因';
  447. COMMENT ON TABLE js_cms_site IS '站点表';
  448. COMMENT ON COLUMN js_cms_site.site_code IS '站点编码';
  449. COMMENT ON COLUMN js_cms_site.site_name IS '站点名称';
  450. COMMENT ON COLUMN js_cms_site.site_sort IS '站点排序号';
  451. COMMENT ON COLUMN js_cms_site.title IS '站点标题';
  452. COMMENT ON COLUMN js_cms_site.logo IS '站点Logo';
  453. COMMENT ON COLUMN js_cms_site.domain IS '站点域名';
  454. COMMENT ON COLUMN js_cms_site.keywords IS '关键字';
  455. COMMENT ON COLUMN js_cms_site.description IS '描述';
  456. COMMENT ON COLUMN js_cms_site.theme IS '主题';
  457. COMMENT ON COLUMN js_cms_site.copyright IS '版权信息';
  458. COMMENT ON COLUMN js_cms_site.custom_index_view IS '自定义站点首页视图';
  459. COMMENT ON COLUMN js_cms_site.status IS '状态(0正常 1删除 2停用)';
  460. COMMENT ON COLUMN js_cms_site.create_by IS '创建者';
  461. COMMENT ON COLUMN js_cms_site.create_date IS '创建时间';
  462. COMMENT ON COLUMN js_cms_site.update_by IS '更新者';
  463. COMMENT ON COLUMN js_cms_site.update_date IS '更新时间';
  464. COMMENT ON COLUMN js_cms_site.remarks IS '备注信息';
  465. COMMENT ON TABLE js_cms_tag IS '内容标签';
  466. COMMENT ON COLUMN js_cms_tag.tag_name IS '标签名称';
  467. COMMENT ON COLUMN js_cms_tag.clicknum IS '点击次数';
  468. COMMENT ON TABLE js_cms_visit_log IS '访问日志表';
  469. COMMENT ON COLUMN js_cms_visit_log.id IS '编号';
  470. COMMENT ON COLUMN js_cms_visit_log.request_url IS '请求的URL地址';
  471. COMMENT ON COLUMN js_cms_visit_log.request_url_host IS '受访域名';
  472. COMMENT ON COLUMN js_cms_visit_log.source_referer IS '来源页面/上一个页面';
  473. COMMENT ON COLUMN js_cms_visit_log.source_referer_host IS '来源域名';
  474. COMMENT ON COLUMN js_cms_visit_log.source_type IS '访问来源类型(1直接访问 2搜索引擎 3外部链接 4内部访问)';
  475. COMMENT ON COLUMN js_cms_visit_log.search_engine IS '使用的搜索引擎';
  476. COMMENT ON COLUMN js_cms_visit_log.search_word IS '搜索的关键词';
  477. COMMENT ON COLUMN js_cms_visit_log.remote_addr IS '客户IP地址';
  478. COMMENT ON COLUMN js_cms_visit_log.user_agent IS '用户代理字符串';
  479. COMMENT ON COLUMN js_cms_visit_log.user_language IS '客户机语言';
  480. COMMENT ON COLUMN js_cms_visit_log.user_screen_size IS '客户机屏幕大小0x0';
  481. COMMENT ON COLUMN js_cms_visit_log.user_device IS '客户机设备类型(电脑、平板、手机、未知)';
  482. COMMENT ON COLUMN js_cms_visit_log.user_os_name IS '客户机操作系统';
  483. COMMENT ON COLUMN js_cms_visit_log.user_browser IS '客户机浏览器';
  484. COMMENT ON COLUMN js_cms_visit_log.user_browser_version IS '浏览器版本';
  485. COMMENT ON COLUMN js_cms_visit_log.unique_visit_id IS '唯一访问标识';
  486. COMMENT ON COLUMN js_cms_visit_log.visit_date IS '本次访问日期(年月日)';
  487. COMMENT ON COLUMN js_cms_visit_log.visit_time IS '本次访问时间';
  488. COMMENT ON COLUMN js_cms_visit_log.is_new_visit IS '是否新访问(30分内)';
  489. COMMENT ON COLUMN js_cms_visit_log.first_visit_time IS '首次访问时间戳(30分钟内)';
  490. COMMENT ON COLUMN js_cms_visit_log.prev_remain_time IS '上页面停留时间(秒)';
  491. COMMENT ON COLUMN js_cms_visit_log.total_remain_time IS '本次访问总停留时间(秒)';
  492. COMMENT ON COLUMN js_cms_visit_log.site_code IS '站点编码';
  493. COMMENT ON COLUMN js_cms_visit_log.site_name IS '站点名称';
  494. COMMENT ON COLUMN js_cms_visit_log.category_code IS '栏目编码';
  495. COMMENT ON COLUMN js_cms_visit_log.category_name IS '栏目名称';
  496. COMMENT ON COLUMN js_cms_visit_log.content_id IS '栏目内容编号';
  497. COMMENT ON COLUMN js_cms_visit_log.content_title IS '访问页面标题';
  498. COMMENT ON COLUMN js_cms_visit_log.visit_user_code IS '访问用户编码';
  499. COMMENT ON COLUMN js_cms_visit_log.visit_user_name IS '访问用户姓名';
  500. COMMENT ON COLUMN js_cms_visit_log.corp_code IS '租户代码';
  501. COMMENT ON COLUMN js_cms_visit_log.corp_name IS '租户名称';