public.structure_markush

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
cd_id	integer	nextval('structure_markush_cd_id_seq'::regclass)	false	public.structure_markush_md_mscr
cd_structure	text		false
cd_markush	bytea		true
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
cd_fp17	integer		false
cd_fp18	integer		false
cd_fp19	integer		false
cd_fp20	integer		false
cd_fp21	integer		false
cd_fp22	integer		false
cd_fp23	integer		false
cd_fp24	integer		false
cd_fp25	integer		false
cd_fp26	integer		false
cd_fp27	integer		false
cd_fp28	integer		false
cd_fp29	integer		false
cd_fp30	integer		false
cd_fp31	integer		false
cd_fp32	integer		false
cd_fp33	integer		false
cd_fp34	integer		false
cd_fp35	integer		false
cd_fp36	integer		false
cd_fp37	integer		false
cd_fp38	integer		false
cd_fp39	integer		false
cd_fp40	integer		false
cd_fp41	integer		false
cd_fp42	integer		false
cd_fp43	integer		false
cd_fp44	integer		false
cd_fp45	integer		false
cd_fp46	integer		false
cd_fp47	integer		false
cd_fp48	integer		false
cd_fp49	integer		false
cd_fp50	integer		false
cd_fp51	integer		false
cd_fp52	integer		false
cd_fp53	integer		false
cd_fp54	integer		false
cd_fp55	integer		false
cd_fp56	integer		false
cd_fp57	integer		false
cd_fp58	integer		false
cd_fp59	integer		false
cd_fp60	integer		false
cd_fp61	integer		false
cd_fp62	integer		false
cd_fp63	integer		false
cd_fp64	integer		false
cd_fp65	integer		false
cd_fp66	integer		false
cd_fp67	integer		false
cd_fp68	integer		false
cd_fp69	integer		false
cd_fp70	integer		false
cd_fp71	integer		false
cd_fp72	integer		false
cd_fp73	integer		false
cd_fp74	integer		false
cd_fp75	integer		false
cd_fp76	integer		false
cd_fp77	integer		false
cd_fp78	integer		false
cd_fp79	integer		false
cd_fp80	integer		false
cd_fp81	integer		false
cd_fp82	integer		false
cd_fp83	integer		false
cd_fp84	integer		false
cd_fp85	integer		false
cd_fp86	integer		false
cd_fp87	integer		false
cd_fp88	integer		false
cd_fp89	integer		false
cd_fp90	integer		false
cd_fp91	integer		false
cd_fp92	integer		false
cd_fp93	integer		false
cd_fp94	integer		false
cd_fp95	integer		false
cd_fp96	integer		false
cd_fp97	integer		false
cd_fp98	integer		false
cd_fp99	integer		false
cd_fp100	integer		false
cd_fp101	integer		false
cd_fp102	integer		false
cd_fp103	integer		false
cd_fp104	integer		false
cd_fp105	integer		false
cd_fp106	integer		false
cd_fp107	integer		false
cd_fp108	integer		false
cd_fp109	integer		false
cd_fp110	integer		false
cd_fp111	integer		false
cd_fp112	integer		false
cd_fp113	integer		false
cd_fp114	integer		false
cd_fp115	integer		false
cd_fp116	integer		false
cd_fp117	integer		false
cd_fp118	integer		false
cd_fp119	integer		false
cd_fp120	integer		false
cd_fp121	integer		false
cd_fp122	integer		false
cd_fp123	integer		false
cd_fp124	integer		false
cd_fp125	integer		false
cd_fp126	integer		false
cd_fp127	integer		false
cd_fp128	integer		false
mwt	numeric(12,4)		true
mf	varchar(1000)		true
unknown	character(1)		false

Constraints

Name	Type	Definition
structure_markush_pkey	PRIMARY KEY	PRIMARY KEY (cd_id)

Indexes

Name	Definition
structure_markush_pkey	CREATE UNIQUE INDEX structure_markush_pkey ON public.structure_markush USING btree (cd_id)
structure_markush_hx	CREATE INDEX structure_markush_hx ON public.structure_markush USING btree (cd_hash)
structure_markush_fx	CREATE INDEX structure_markush_fx ON public.structure_markush USING btree (cd_sortable_formula)
structure_markush_px	CREATE INDEX structure_markush_px ON public.structure_markush USING btree (cd_pre_calculated)
structure_markush_thx	CREATE INDEX structure_markush_thx ON public.structure_markush USING btree (cd_taut_hash)

Relations

---

Generated by tbls