realtor-lp-backend/migrations/6_trackable.sql

9 lines
263 B
SQL

CREATE TABLE IF NOT EXISTS "trackable" (
id UUID PRIMARY KEY,
who_was UUID,
ip_address VARCHAR NOT NULL,
browser_width INTEGER NOT NULL,
browser_height INTEGER NOT NULL,
user_agent VARCHAR NOT NULL,
time_created TIMESTAMPTZ NOT NULL
);