Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- ----------------------------
- -- Table structure for auditlog_log
- -- ----------------------------
- DROP TABLE IF EXISTS "public"."auditlog_log";
- CREATE TABLE "public"."auditlog_log" (
- "id" int4 NOT NULL,
- "name" varchar(64) COLLATE "pg_catalog"."default",
- "model_id" int4,
- "res_id" int4,
- "user_id" int4,
- "method" varchar(64) COLLATE "pg_catalog"."default",
- "http_session_id" int4,
- "http_request_id" int4,
- "log_type" varchar COLLATE "pg_catalog"."default",
- "create_uid" int4,
- "create_date" timestamp(6),
- "write_uid" int4,
- "write_date" timestamp(6)
- )
- ;
- COMMENT ON COLUMN "public"."auditlog_log"."name" IS 'Resource Name';
- COMMENT ON COLUMN "public"."auditlog_log"."model_id" IS 'Model';
- COMMENT ON COLUMN "public"."auditlog_log"."res_id" IS 'Resource ID';
- COMMENT ON COLUMN "public"."auditlog_log"."user_id" IS 'User';
- COMMENT ON COLUMN "public"."auditlog_log"."method" IS 'Method';
- COMMENT ON COLUMN "public"."auditlog_log"."http_session_id" IS 'Session';
- COMMENT ON COLUMN "public"."auditlog_log"."http_request_id" IS 'HTTP Request';
- COMMENT ON COLUMN "public"."auditlog_log"."log_type" IS 'Type';
- COMMENT ON COLUMN "public"."auditlog_log"."create_uid" IS 'Created by';
- COMMENT ON COLUMN "public"."auditlog_log"."create_date" IS 'Created on';
- COMMENT ON COLUMN "public"."auditlog_log"."write_uid" IS 'Last Updated by';
- COMMENT ON COLUMN "public"."auditlog_log"."write_date" IS 'Last Updated on';
- COMMENT ON TABLE "public"."auditlog_log" IS 'Auditlog - Log';
- -- ----------------------------
- -- Primary Key structure for table auditlog_log
- -- ----------------------------
- ALTER TABLE "public"."auditlog_log" ADD CONSTRAINT "auditlog_log_pkey" PRIMARY KEY ("id");
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement