effective_mobile_test_go_api/migrations/0001_create_subscriptions_table.up.sql
2025-10-31 17:54:29 +07:00

9 lines
216 B
SQL

CREATE TABLE IF NOT EXISTS subscriptions (
id SERIAL PRIMARY KEY,
service_name VARCHAR(255) NOT NULL,
price INTEGER NOT NULL,
user_id UUID NOT NULL,
start_date DATE NOT NULL,
end_date DATE
);