remax-backend-rs/migrations/1_property.sql

10 lines
247 B
MySQL
Raw Permalink Normal View History

2023-03-09 17:45:16 +00:00
CREATE TABLE IF NOT EXISTS "property" (
id UUID PRIMARY KEY,
title VARCHAR NOT NULL,
description VARCHAR NOT NULL,
agent_id UUID NOT NULL,
state BYTEA NOT NULL,
time_created TIMESTAMPTZ NOT NULL,
last_updated TIMESTAMPTZ NOT NULL
);