1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28
| CREATE TABLE "t_log" ( "id" SERIAL NOT NULL, "operate_class" VARCHAR(64) NULL DEFAULT NULL, "operate_method" VARCHAR(64) NULL DEFAULT NULL, "request_params" JSON NULL DEFAULT NULL, "response_result" JSON NULL DEFAULT NULL, "description" VARCHAR(500) NOT NULL, "result" VARCHAR(50) NOT NULL, "operator_id" VARCHAR(64) NOT NULL, "operator_name" VARCHAR(64) NOT NULL, "client_ip" VARCHAR(100) NOT NULL, "operate_date" TIMESTAMP NOT NULL DEFAULT pg_systimestamp() ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY ("id") ) COMMENT='业务日志表' ; COMMENT ON COLUMN "t_log"."id" IS '业务日志ID'; COMMENT ON COLUMN "t_log"."operate_class" IS '操作的接口类名'; COMMENT ON COLUMN "t_log"."operate_method" IS '操作的方法名'; COMMENT ON COLUMN "t_log"."request_params" IS '请求参数'; COMMENT ON COLUMN "t_log"."response_result" IS '返回参数'; COMMENT ON COLUMN "t_log"."description" IS '操作说明'; COMMENT ON COLUMN "t_log"."result" IS '操作结果'; COMMENT ON COLUMN "t_log"."operator_id" IS '操作人id'; COMMENT ON COLUMN "t_log"."operator_name" IS '操作人名称'; COMMENT ON COLUMN "t_log"."client_ip" IS '客户端IP'; COMMENT ON COLUMN "t_log"."operate_date" IS '操作时间';
|