T_REP_REQ

来源:互联网 发布:美国大学统计 知乎 编辑:程序博客网 时间:2024/06/01 23:33
-- Table: public."T_REP_REQ"


-- DROP TABLE public."T_REP_REQ";


CREATE TABLE public."T_REP_REQ"
(
    "ID" integer NOT NULL DEFAULT nextval('"T_REP_REQ_ID_seq"'::regclass),
    "REQ_USER" character(9) COLLATE pg_catalog."default" NOT NULL,
    "REQ_AT" timestamp with time zone NOT NULL,
    "REQ_STAT" integer NOT NULL DEFAULT 1,
    "PARAMS" character varying(256) COLLATE pg_catalog."default" NOT NULL,
    "FIN_AT" timestamp with time zone,
    "DL_AT" timestamp with time zone,
    CONSTRAINT "T_REP_REQ_pkey" PRIMARY KEY ("ID")
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;


ALTER TABLE public."T_REP_REQ"
    OWNER to postgres;


-- Index: req_at_idx


-- DROP INDEX public.req_at_idx;


CREATE INDEX req_at_idx
    ON public."T_REP_REQ" USING btree
    (REQ_AT)
    TABLESPACE pg_default;
原创粉丝点击