建表sql

CREATE TABLE "dmsbi"."dm_scm_dim_ioc_all_probe" (
  "id" int4 NOT NULL DEFAULT nextval('dm_scm_dim_ioc_all_probe_id_seq'::regclass),
  "topic" varchar COLLATE "pg_catalog"."default" DEFAULT NULL,
  "stage" varchar COLLATE "pg_catalog"."default" DEFAULT NULL,
  "probe_id" varchar COLLATE "pg_catalog"."default" DEFAULT NULL,
  "name" varchar COLLATE "pg_catalog"."default" DEFAULT NULL,
  "res1" varchar COLLATE "pg_catalog"."default" DEFAULT NULL,
  "res2" varchar COLLATE "pg_catalog"."default" DEFAULT NULL,
  CONSTRAINT "dm_scm_dim_ioc_all_probe_pkey" PRIMARY KEY ("id")
)
;

ALTER TABLE "dmsbi"."dm_scm_dim_ioc_all_probe" 
  OWNER TO "dmsbi";

COMMENT ON COLUMN "dmsbi"."dm_scm_dim_ioc_all_probe"."id" IS '主键id';
COMMENT ON COLUMN "dmsbi"."dm_scm_dim_ioc_all_probe"."probe_id" IS '探针id';
COMMENT ON COLUMN "dmsbi"."dm_scm_dim_ioc_all_probe"."name" IS '名称';
COMMENT ON COLUMN "dmsbi"."dm_scm_dim_ioc_all_probe"."res1" IS '备用字段1';
COMMENT ON COLUMN "dmsbi"."dm_scm_dim_ioc_all_probe"."res2" IS '备用字段2';


INSERT INTO "dmsbi"."dm_scm_dim_ioc_all_probe"("id", "topic", "stage", "probe_id", "name", "res1", "res2", "topic_id", "stage_id", "default") VALUES (20, '国家供应网络', '物流运作', 'overdue_not_received', '超期发未收', NULL, NULL, NULL, NULL, NULL);
INSERT INTO "dmsbi"."dm_scm_dim_ioc_all_probe"("id", "topic", "stage", "probe_id", "name", "res1", "res2", "topic_id", "stage_id", "default") VALUES (8, '客户订单交付', '需求管理', '8', '开票自动化率', NULL, NULL, 'ORDER_DELIVERY', 'DEMAND_MANAGEMENT', NULL);