Skip to content

Instantly share code, notes, and snippets.

View nurtdinovadf's full-sized avatar

Diliara Nurtdinova nurtdinovadf

View GitHub Profile
@nurtdinovadf
nurtdinovadf / 0. derived_aves table
Last active July 15, 2017 09:03
ITIS database queries
CREATE TABLE "public"."derived_aves" (
"complete_name" varchar(255),
"parent_tsn" int4 NOT NULL,
"rank_name" varchar(255) NOT NULL,
"tsn" int4 NOT NULL,
"rank_id" int4,
"level" int2,
"species" int4 NOT NULL,
"vernacular_names" json,
CONSTRAINT "derived_aves_pkey" PRIMARY KEY ("parent_tsn", "tsn", "species", "rank_name")