63 lines
2.6 KiB
SQL
63 lines
2.6 KiB
SQL
/*
|
|
Navicat Premium Data Transfer
|
|
|
|
Source Server : 115.238.53.59
|
|
Source Server Type : PostgreSQL
|
|
Source Server Version : 120012
|
|
Source Host : 115.238.53.59:5432
|
|
Source Catalog : xiuosiot
|
|
Source Schema : public
|
|
|
|
Target Server Type : PostgreSQL
|
|
Target Server Version : 120012
|
|
File Encoding : 65001
|
|
|
|
Date: 19/10/2022 10:34:58
|
|
*/
|
|
|
|
DROP SEQUENCE IF EXISTS "public"."seq_request_log_info";
|
|
CREATE SEQUENCE "public"."seq_request_log_info"
|
|
INCREMENT 1
|
|
MINVALUE 1
|
|
MAXVALUE 2147483647
|
|
START 1
|
|
CACHE 1;
|
|
ALTER SEQUENCE "public"."seq_request_log_info" OWNER TO "xiuosiot";
|
|
-- ----------------------------
|
|
-- Table structure for request_log_info
|
|
-- ----------------------------
|
|
DROP TABLE IF EXISTS "public"."request_log_info";
|
|
CREATE TABLE "public"."request_log_info" (
|
|
"id" int4 NOT NULL DEFAULT nextval('seq_request_log_info'::regclass),
|
|
"classname" varchar(32) COLLATE "pg_catalog"."default",
|
|
"methodname" varchar(32) COLLATE "pg_catalog"."default",
|
|
"requestparam" varchar(32) COLLATE "pg_catalog"."default",
|
|
"requestip" varchar(32) COLLATE "pg_catalog"."default",
|
|
"requestresult" varchar(255) COLLATE "pg_catalog"."default",
|
|
"requestheader" varchar(64) COLLATE "pg_catalog"."default",
|
|
"requesturl" varchar(64) COLLATE "pg_catalog"."default",
|
|
"requesttime" timestamp(6),
|
|
"processtime" varchar(64) COLLATE "pg_catalog"."default",
|
|
"requesttype" varchar(4) COLLATE "pg_catalog"."default",
|
|
"org" varchar(32) COLLATE "pg_catalog"."default"
|
|
)
|
|
;
|
|
COMMENT ON COLUMN "public"."request_log_info"."id" IS '主键id ';
|
|
COMMENT ON COLUMN "public"."request_log_info"."classname" IS '类名';
|
|
COMMENT ON COLUMN "public"."request_log_info"."methodname" IS '方法名';
|
|
COMMENT ON COLUMN "public"."request_log_info"."requestparam" IS '请求参数
|
|
请求参数';
|
|
COMMENT ON COLUMN "public"."request_log_info"."requestip" IS '请求ip';
|
|
COMMENT ON COLUMN "public"."request_log_info"."requestresult" IS '请求结果';
|
|
COMMENT ON COLUMN "public"."request_log_info"."requestheader" IS '请求头';
|
|
COMMENT ON COLUMN "public"."request_log_info"."requesturl" IS '请求url';
|
|
COMMENT ON COLUMN "public"."request_log_info"."requesttime" IS '请求时间';
|
|
COMMENT ON COLUMN "public"."request_log_info"."processtime" IS '请求耗时';
|
|
COMMENT ON COLUMN "public"."request_log_info"."requesttype" IS '请求方式';
|
|
COMMENT ON COLUMN "public"."request_log_info"."org" IS '所属公司';
|
|
|
|
-- ----------------------------
|
|
-- Primary Key structure for table request_log_info
|
|
-- ----------------------------
|
|
ALTER TABLE "public"."request_log_info" ADD CONSTRAINT "request_log_info_pkey" PRIMARY KEY ("id");
|