database structure

db=> \d r_agrio;
                  Table "public.r_agrio"
   Column    |         Type          |     Modifiers
-------------+-----------------------+--------------------
 id          | numeric(38,0)         | not null -- sequential primary key
 tagid       | numeric(38,0)         | not null
 blockid     | numeric(38,0)         | not null
 rowdate     | character varying(15) | not null
 count       | numeric(38,0)         | not null default 0
 events      | numeric(38,0)         | not null default 0
 devents     | numeric(38,0)         | not null default 0
 duration    | numeric(38,0)         | not null default 0
 device_type | numeric(38,0)         | not null
 placement   | numeric(38,0)         | not null default 0
 unserved    | numeric(38,0)         | not null default 0
 unconfirmed | numeric(38,0)         | not null default 0
 version     | numeric(38,0)         | not null default 1
Indexes:
    "pk_r_agrio" PRIMARY KEY, btree (id)
    "u_r_agrio" UNIQUE, btree (tagid, blockid, rowdate, device_type, placement)
    "rowdate_r_agrio" btree (rowdate)
Referenced by:
    TABLE "r_brkiofaults" CONSTRAINT "fk_brkiofaults_agr" FOREIGN KEY (agrioid) REFERENCES r_agrio(id) ON DELETE CASCADE

MODIFIED FOR "BULK MERGE":

db=> \d r_agrio;
                  Table "public.r_agrio"
   Column       |         Type          |     Modifiers
----------------+-----------------------+--------------------
 id             | numeric(38,0)         | not null -- sequential primary key
 tagid          | numeric(38,0)         | not null
 blockid        | numeric(38,0)         | not null
 rowdate        | character varying(15) | not null
 count          | numeric(38,0)         | not null default 0
 events         | numeric(38,0)         | not null default 0
 devents        | numeric(38,0)         | not null default 0
 duration       | numeric(38,0)         | not null default 0
 device_type    | numeric(38,0)         | not null
 placement      | numeric(38,0)         | not null default 0
 unserved       | numeric(38,0)         | not null default 0
 unconfirmed    | numeric(38,0)         | not null default 0
 version        | numeric(38,0)         | not null default 1
 locked_version | numeric(38,0)         |
 main_id        | numeric(38,0)         |
 lock_code      | character varying(99) |
Indexes:
    "pk_r_agrio" PRIMARY KEY, btree (id)
    "u_r_agrio" UNIQUE, btree (tagid, blockid, rowdate, device_type, placement)
    "rowdate_r_agrio" btree (rowdate)
Referenced by:
    TABLE "r_brkiofaults" CONSTRAINT "fk_brkiofaults_agr" FOREIGN KEY (agrioid) REFERENCES r_agrio(id) ON DELETE CASCADE