--包装增加装备一些特有的字段
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "stock_order_id" int8,
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "start_metre" numeric(18,6),
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "end_metre" numeric(18,6),
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "product_standard" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "reel_number" varchar COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "packing_inspection" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "cap_integrity_inspection" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "packing_manner" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "cylinder_number" numeric(18,6),
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "routine_reel_number" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "lettering" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "certification_mark_type" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "certification_mark_number" numeric(18,6),
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "reel_weight" numeric(18,6),
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "reel_type" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "warehouse_packaging" ADD COLUMN  "metre" numeric(18,6),

COMMENT ON COLUMN "public"."warehouse_packaging"."stock_order_id" IS '客户订单预留id';

COMMENT ON COLUMN "public"."warehouse_packaging"."start_metre" IS '起始米标';

COMMENT ON COLUMN "public"."warehouse_packaging"."end_metre" IS '结束米标';

COMMENT ON COLUMN "public"."warehouse_packaging"."product_standard" IS '产品标准';

COMMENT ON COLUMN "public"."warehouse_packaging"."reel_number" IS '盘号';

COMMENT ON COLUMN "public"."warehouse_packaging"."packing_inspection" IS '包装检查';

COMMENT ON COLUMN "public"."warehouse_packaging"."cap_integrity_inspection" IS '封帽的完整性';

COMMENT ON COLUMN "public"."warehouse_packaging"."packing_manner" IS '包装方式';

COMMENT ON COLUMN "public"."warehouse_packaging"."cylinder_number" IS '打圈个数';

COMMENT ON COLUMN "public"."warehouse_packaging"."routine_reel_number" IS '出厂盘号';

COMMENT ON COLUMN "public"."warehouse_packaging"."lettering" IS '印字';

COMMENT ON COLUMN "public"."warehouse_packaging"."certification_mark_type" IS '认证标志类型';

COMMENT ON COLUMN "public"."warehouse_packaging"."certification_mark_number" IS '认证标志数量';

COMMENT ON COLUMN "public"."warehouse_packaging"."reel_weight" IS '盘重';

COMMENT ON COLUMN "public"."warehouse_packaging"."reel_type" IS '盘具类型';

COMMENT ON COLUMN "public"."warehouse_packaging"."metre" IS '米标';
--包装的人员表
CREATE TABLE "public"."warehouse_packaging_staff" (
  "id" int8 NOT NULL DEFAULT nextval('warehouse_packaging_staff_id_seq'::regclass),
  "staff_id" int8,
  "packaging_id" int8,
  CONSTRAINT "warehouse_packaging_staff_pkey" PRIMARY KEY ("id")
)
;

ALTER TABLE "public"."warehouse_packaging_staff"
  OWNER TO "postgres";

COMMENT ON COLUMN "public"."warehouse_packaging_staff"."id" IS 'id';

COMMENT ON COLUMN "public"."warehouse_packaging_staff"."staff_id" IS '人员id';

COMMENT ON COLUMN "public"."warehouse_packaging_staff"."packaging_id" IS '包装id';

COMMENT ON TABLE "public"."warehouse_packaging_staff" IS '包装的人员表';

--客户订单增加装备一些特有的字段
  ALTER TABLE "plan_customer_order" ADD COLUMN  "volt_age_class" varchar(255) COLLATE "pg_catalog"."default",
  ALTER TABLE "plan_customer_order" ADD COLUMN "outer_color" varchar(255) COLLATE "pg_catalog"."default",
  COMMENT ON COLUMN "public"."plan_customer_order"."volt_age_class" IS '电压等级';
  COMMENT ON COLUMN "public"."plan_customer_order"."outer_color" IS '外护颜色';