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);
标签:scm,dm,建表,probe,sql,NULL,ioc,id From: https://www.cnblogs.com/mingruifeng/p/16949905.html