CREATE SEQUENCE t_obs_id_seq INCREMENT 1 MINVALUE 1 MAXVALUE 2147483647 START 1 CACHE 1;

CREATE TABLE "public"."t_obs" (
    "id" integer DEFAULT nextval('t_obs_id_seq') NOT NULL,
    "obs_x" integer NOT NULL,
    "job_name" text NOT NULL,
    CONSTRAINT "t_obs_pkey" PRIMARY KEY ("id")
) WITH (oids = false);

INSERT INTO "t_obs" ("id", "obs_x", "job_name") VALUES
(1,	1,	'mbi'),
(2,	1,	'sls2d'),
(3,	2,	'MCI'),
(4,	3,	'IFS'),
(5,	4,	'CPIC'),
(6,	5,	'HSTDM');