CREATE TABLE public.goods1 (
id int8 NOT NULL,
“name” varchar(64) NULL,
“storage” int4 NULL,
goodstype int4 DEFAULT 0 NOT NULL,
remark varchar(64) NULL,
target_value numeric(18, 6) NULL,
target_value_string varchar(64) NULL,
target_big numeric(18, 6) NULL,
network varchar(64) NULL,
worker_id int8 NULL,
sort int4 NULL,
count int4 NULL,
CONSTRAINT goods1_unique_id UNIQUE (id)
);
加上
COMMENT ON COLUMN public.goods1.“name” IS ‘货物名称’;
COMMENT ON TABLE public.goods1 IS ‘货物表1’;