Have a look at the following output from the PostgreSQL console

    resultsdb=# \d result
                                       Table "public.result"
        Column     |            Type             |                      Modifiers
    ---------------+-----------------------------+-----------------------------------------------------
     id            | integer                     | not null default nextval('result_id_seq'::regclass)
     submit_time   | timestamp without time zone |
     outcome       | resultoutcome               |
    Indexes:
        "result_pkey" PRIMARY KEY, btree (id)
        "result_submit_time" btree (submit_time)
    Referenced by:
        TABLE "result_data" CONSTRAINT "result_data_result_id_fkey" FOREIGN KEY (result_id) REFERENCES result(id)

    resultsdb=# select * from result limit 3;
        id    |        submit_time         |     outcome
    ----------+----------------------------+------------------
     11718295 | 2017-01-18 04:03:26.13716  | PASSED
     11718296 | 2017-01-18 04:14:39.212402 | NEEDS_INSPECTION
     11718300 | 2017-01-18 09:01:13.29927  | PASSED
    (3 rows)


    resultsdb=# \d result_data
                           Table "public.result_data"
      Column   |  Type   |                        Modifiers
    -----------+---------+----------------------------------------------------------
     id        | integer | not null default nextval('result_data_id_seq'::regclass)
     result_id | integer |
     key       | text    |
     value     | text    |
    Indexes:
        "result_data_pkey" PRIMARY KEY, btree (id)
        "result_data_fk_result_id" btree (result_id)
        "result_data_idx_key_value" btree (key text_pattern_ops, value text_pattern_ops)
    Foreign-key constraints:
        "result_data_result_id_fkey" FOREIGN KEY (result_id) REFERENCES result(id)


    resultsdb=# select * from result_data where result_id in (11718295, 11718296, 11718300) order by id;
        id    | result_id | key  |          value
    ----------+-----------+------+--------------------------
     32910895 |  11718295 | item | webkitgtk4-2.14.3-1.fc25
     32910896 |  11718295 | type | koji_build
     32910897 |  11718296 | item | webkitgtk4-2.14.3-1.fc25
     32910898 |  11718296 | type | koji_build
     32910908 |  11718300 | item | libvpx-1.6.1-1.fc25
     32910909 |  11718300 | arch | i386
     32910910 |  11718300 | type | koji_build
    (7 rows)


* What can you say about the tables and their purpose and relationships?
* Create a SQL query that will select
 * all the Results where a `koji_build` type was tested.
 * all the Results for `libvpx-1.6.1-1.fc25` that ran on `x86_64` architecture.