pgsql建表语句,并设置自增主键code
注意:1.建表时字段最好使用英文,字段不得使用大写字母和空格,可以使用一些第三方建表工具建表。
2.一定加表的说明
COMMENT ON TABLE "xlbigdata_ods"."o_dcp_013" IS '客户授信资料登记填报表';
建表示范(自己记录使用)
DROP TABLE IF EXISTS "xlbigdata_ods"."o_dcp_012";
CREATE TABLE "xlbigdata_ods"."o_dcp_012" (
"code" SERIAL NOT NULL,
"division" varchar(255) COLLATE "pg_catalog"."default",
"cvalue" numeric(17,2),
"backtime" date NOT NULL,
"mailingtime" date NOT NULL,
"mailinggnum" varchar(255) COLLATE "pg_catalog"."default",
...
PRIMARY KEY ("code")
);
COMMENT ON COLUMN "xlbigdata_ods"."o_dcp_012"."code" IS '序号主键';
...
COMMENT ON TABLE "xlbigdata_ods"."o_dcp_012" IS '销售合同登记填报表';
DROP TABLE IF EXISTS "xlbigdata_ods"."o_dcp_013";
CREATE TABLE "xlbigdata_ods"."o_dcp_013" (
"客户名称" varchar(255) COLLATE "pg_catalog"."default" DEFAULT ''::character varying,
"个人担保签署时间" timestamp(2),
"实缴资金万元" numeric(35,8) DEFAULT 0,
"注册年份" timestamp(2)
);
COMMENT ON TABLE "xlbigdata_ods"."o_dcp_013" IS '客户授信资料登记填报表';
...