如何设计一个日志表(笔记)

最新推荐文章于 2025-10-08 14:28:32 发布

原创最新推荐文章于 2025-10-08 14:28:32 发布 · 4k 阅读

5 ·

CC 4.0 BY-SA版权

MySQL 专栏收录该内容

12 篇文章

订阅专栏

本文详细探讨了如何设计一个高效、易于维护的日志表，包括字段选择、数据类型、索引策略以及日志级别的考虑，旨在帮助开发者实现稳定可靠的应用日志记录系统。

CREATE TABLE "public"."scrm_wechat_request_log" (
"id" int8 DEFAULT nextval('scrm_wechat_request_log_id_seq'::regclass) NOT NULL,
"log_type" int2 DEFAULT 0,
"server_port" int2 DEFAULT 0,
"server_name" varchar(64) COLLATE "default" DEFAULT ''::character varying,
"server_ip" varchar(200) COLLATE "default" DEFAULT NULL::character varying,
"request_param" varchar(500) COLLATE "default" DEFAULT NULL::character varying,
"request_interface" varchar(64) COLLATE "default" DEFAULT NULL::character varying,
"request_timestamp" int8,
"request_time" int4,
"request_type" varchar(64) COLLATE "default" DEFAULT ''::character varying,
"request_result" int2 DEFAULT 0,
"response_interface" varchar(500) COLLATE "default" DEFAULT NULL::character varying,
"response_result" varchar(500) COLLATE "default" DEFAULT NULL::character varying,
CONSTRAINT "scrm_wechat_request_log_pkey" PRIMARY KEY ("id")
)
WITH (OIDS=FALSE)
;

ALTER TABLE "public"."scrm_wechat_request_log" OWNER TO "postgres";

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."log_type" IS '日志类型：0=客户端日志（调用者），1=服务端日志（被调用者）';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."server_port" IS '服务器端口号';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."server_name" IS '服务器名称';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."server_ip" IS '服务器IP';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."request_param" IS '请求参数';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."request_interface" IS '请求接口(调用服务的接口)';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."request_timestamp" IS '请求时间戳';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."request_time" IS '请求所用时间';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."request_type" IS '请求类型';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."request_result" IS '请求结果：0=成功，1=失败';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."response_interface" IS '响应接口(提供服务的接口)';

COMMENT ON COLUMN "public"."scrm_wechat_request_log"."response_result" IS '接口响应内容';





CREATE SEQUENCE scrm_wechat_request_log_id_seq
 INCREMENT 1
  MINVALUE 1
  MAXVALUE 9223372036854775807
  START 1
  CACHE 1;


alter table scrm_wechat_request_log alter column id set default nextval('scrm_wechat_request_log_id_seq');