CREATE TABLE "public"."substance" (
  "id" int4 NOT NULL DEFAULT nextval('substance_id_seq'::regclass),
  "source" text COLLATE "pg_catalog"."default" NOT NULL,
  "substance_id" text COLLATE "pg_catalog"."default" NOT NULL,
  "substance_version" text COLLATE "pg_catalog"."default",
  "compound_id_type" text COLLATE "pg_catalog"."default",
  "ext_datasource_url" text COLLATE "pg_catalog"."default",
  "ext_substance_url" text COLLATE "pg_catalog"."default",
  "cid_associations" text COLLATE "pg_catalog"."default",
  "coordinate_type" text COLLATE "pg_catalog"."default",
  "total_charge" text COLLATE "pg_catalog"."default",
  "bondannotations" text COLLATE "pg_catalog"."default",
  "substance_synonym" text COLLATE "pg_catalog"."default",
  "substance_comment" text COLLATE "pg_catalog"."default",
  "pubmed_id" text COLLATE "pg_catalog"."default",
  "ext_datasource_regid" text COLLATE "pg_catalog"."default",
  "conformer_id" text COLLATE "pg_catalog"."default",
  "generic_registry_name" text COLLATE "pg_catalog"."default",
  "ext_datasource_name" text COLLATE "pg_catalog"."default",
  "xref_ext_id" text COLLATE "pg_catalog"."default",
  "can_smiles" text COLLATE "pg_catalog"."default",
  "iso_smiles" text COLLATE "pg_catalog"."default",
  "moltext" text COLLATE "pg_catalog"."default",
  "create_date" timestamp(6),
  "modify_date" timestamp(6),
  CONSTRAINT "substance_pkey" PRIMARY KEY ("id")
)
;

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

CREATE INDEX "substance_generic_registry_name_idx" ON "public"."substance" USING hash (
  "generic_registry_name" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops"
);

CREATE UNIQUE INDEX "substance_source_substance_id" ON "public"."substance" USING btree (
  "source" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST,
  "substance_id" COLLATE "pg_catalog"."default" "pg_catalog"."text_ops" ASC NULLS LAST
);


CREATE TABLE [dbo].[FromatModels] (
  [fmid] int  IDENTITY(1,1) NOT NULL,
  [fmCode] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [UnitName] varchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [purityS] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [brand] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [Fromat] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [InvNum] float(53)  NULL,
  [Mark] nvarchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [price] float(53)  NULL,
  [Delivery] varchar(300) COLLATE Chinese_PRC_CI_AS  NULL,
  [uping] int DEFAULT ((1)) NULL,
  [uptimes] timestamp  NOT NULL,
  [fmupDate] datetime  NULL,
  [upCreator] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [priceDate] date  NULL,
  [cinvCode] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [costPrice] float(53)  NULL,
  CONSTRAINT [PK__FromatMo__3471ED916C190EBB] PRIMARY KEY CLUSTERED ([fmid])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
GO

ALTER TABLE [dbo].[FromatModels] SET (LOCK_ESCALATION = TABLE)