25 lines
994 B
SQL
25 lines
994 B
SQL
-- 1. Route Generation and API Usage
|
|
CREATE TABLE IF NOT EXISTS generated_routes (
|
|
id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
|
|
trip_id UUID REFERENCES trips(id) ON DELETE CASCADE,
|
|
user_id UUID REFERENCES auth.users(id),
|
|
preferences JSONB NOT NULL,
|
|
route_data JSONB NOT NULL,
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW(),
|
|
updated_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
|
|
);
|
|
|
|
CREATE TABLE IF NOT EXISTS api_usage (
|
|
id UUID PRIMARY KEY DEFAULT uuid_generate_v4(),
|
|
user_id UUID REFERENCES auth.users(id),
|
|
api_type TEXT NOT NULL,
|
|
endpoint TEXT NOT NULL,
|
|
request_count INTEGER DEFAULT 1,
|
|
created_at TIMESTAMP WITH TIME ZONE DEFAULT NOW()
|
|
);
|
|
|
|
CREATE INDEX IF NOT EXISTS idx_generated_routes_trip_id ON generated_routes(trip_id);
|
|
CREATE INDEX IF NOT EXISTS idx_generated_routes_user_id ON generated_routes(user_id);
|
|
CREATE INDEX IF NOT EXISTS idx_api_usage_user_id ON api_usage(user_id);
|
|
CREATE INDEX IF NOT EXISTS idx_api_usage_created_at ON api_usage(created_at);
|