public.structure¶

Description¶

Name	Type	Default	Nullable	Children
cd_id	integer	nextval('structure_cd_id_seq'::regclass)	false	public.saltsolvate
cd_structure	text		false
cd_smiles	varchar(1000)		true
cd_formula	varchar(100)		true
cd_sortable_formula	varchar(249)		true
cd_molweight	double precision		true
cd_hash	integer		false
cd_flags	varchar(20)		true
cd_timestamp	timestamp without time zone		false
cd_pre_calculated	smallint	0	false
cd_taut_hash	integer		false
cd_taut_frag_hash	varchar(1000)		true
cd_screen_descriptor	varchar(1000)		true
cd_fp1	integer		false
cd_fp2	integer		false
cd_fp3	integer		false
cd_fp4	integer		false
cd_fp5	integer		false
cd_fp6	integer		false
cd_fp7	integer		false
cd_fp8	integer		false
cd_fp9	integer		false
cd_fp10	integer		false
cd_fp11	integer		false
cd_fp12	integer		false
cd_fp13	integer		false
cd_fp14	integer		false
cd_fp15	integer		false
cd_fp16	integer		false
mwt	numeric(12,4)		true
mf	varchar(1000)		true
unknown	character(1)		false

Name	Type	Definition
structure_pkey	PRIMARY KEY	PRIMARY KEY (cd_id)

Name	Definition
structure_pkey	CREATE UNIQUE INDEX structure_pkey ON public.structure USING btree (cd_id)
structure_hx	CREATE INDEX structure_hx ON public.structure USING btree (cd_hash)
structure_fx	CREATE INDEX structure_fx ON public.structure USING btree (cd_sortable_formula)
structure_px	CREATE INDEX structure_px ON public.structure USING btree (cd_pre_calculated)
structure_thx	CREATE INDEX structure_thx ON public.structure USING btree (cd_taut_hash)

Generated by tbls