state_demo2=# \d subtest;
                      Table "public.subtest"
       Column       |            Type             |   Modifiers
--------------------+-----------------------------+---------------
 id                 | uuid                        | not null
 subtest_type_id    | smallint                    | not null
 name               | text                        |
 parent_id          | uuid                        |
 create_date        | timestamp without time zone | default now()
 administered_date  | timestamp without time zone |
 modified_date      | timestamp without time zone |
 deleted_date       | timestamp without time zone |
 annual_high_stakes | boolean                     |
Indexes:
    "subtest_pkey1" PRIMARY KEY, btree (id)
Foreign-key constraints:
    "subtest_subtest_type_id_fkey" FOREIGN KEY (subtest_type_id) REFERENCES subtest_type(id)



                 id                  |              parent_id               |                   name
--------------------------------------+--------------------------------------+-------------------------------------------
 2a65b066-386c-11e0-b6cc-60f64591c4a2 |                                      | Illinois ISAT - Reading, Math and Writing
 e696b230-10e0-11df-80f4-1a7fbecf21f7 | 2a65b066-386c-11e0-b6cc-60f64591c4a2 | Math Explanation 2
 e6982d22-10e0-11df-80f4-1a7fbecf21f7 | 2a65b066-386c-11e0-b6cc-60f64591c4a2 | Math Scale Score
 e6a23a38-10e0-11df-80f4-1a7fbecf21f7 | 2a65b066-386c-11e0-b6cc-60f64591c4a2 | Math Knowledge 1
 e6a35a58-10e0-11df-80f4-1a7fbecf21f7 | 2a65b066-386c-11e0-b6cc-60f64591c4a2 | Reading Scale Score
 e6ab4f92-10e0-11df-80f4-1a7fbecf21f7 | 2a65b066-386c-11e0-b6cc-60f64591c4a2 | Math Knowledge 2
 e6ac5acc-10e0-11df-80f4-1a7fbecf21f7 | 2a65b066-386c-11e0-b6cc-60f64591c4a2 | Reading Essay 1
 e6ad6318-10e0-11df-80f4-1a7fbecf21f7 | 2a65b066-386c-11e0-b6cc-60f64591c4a2 | Reading Essay 2