homethings/migrations/20230423211500_add_thing_notification_table.sql

-- +goose Up
CREATE TABLE thing_notification
(
    thing_id          INT PRIMARY KEY,
    notification_date TIMESTAMP NOT NULL,
    created_at        TIMESTAMP NOT NULL DEFAULT NOW(),
    updated_at        TIMESTAMP NOT NULL DEFAULT NOW(),
    CONSTRAINT fk_thing_notification_thing_id FOREIGN KEY (thing_id) REFERENCES thing (id)
);

-- +goose Down
DROP TABLE thing_notification;