Onion SQL Schema

onion.sql

CREATE TABLE things_versioned (
    id integer not null,
    name varchar not null,
    version timestamp with time zone default now(),
    PRIMARY KEY (id, version)
)

CREATE VIEW things AS
    SELECT
        DISTINCT ON (id)
        id AS "id",
        name AS "name",
        version AS "updated_at"
    FROM things_versioned
    ORDER BY id ASC, version DESC