表操作

-- ----------------------------
-- Table structure for "public"."tbName"
-- ----------------------------
DROP TABLE "public"."tbName";
CREATE TABLE "public"."tbName" (
"hospitalcode" varchar(200) NOT NULL,
"hospitalname" varchar(200),
"sectioncode" varchar(200) NOT NULL,
"sectionname" varchar(200),
"amount" float8 DEFAULT 0,
"status" int4 DEFAULT 0,
"extjson" jsonb,
)
WITH (OIDS=FALSE)

;
/*
COMMENT ON TABLE "public"."tbName" IS '上架计划明细表';
COMMENT ON COLUMN "public"."tbName"."hospitalcode" IS '院区编码';
COMMENT ON COLUMN "public"."tbName"."hospitalname" IS '院区名称';
COMMENT ON COLUMN "public"."tbName"."sectioncode" IS '科室编码';
COMMENT ON COLUMN "public"."tbName"."sectionname" IS '科室名称';
*/

-- ----------------------------
-- Primary Key structure for table "public"."tbName"
-- ----------------------------
ALTER TABLE "public"."tbName" ADD PRIMARY KEY ("hospitalcode","sectioncode"); --添加复合主键

 

转载于:https://www.cnblogs.com/SunXiaoLin/p/11098528.html