openwheel.racing
An application that reminds you to water your plants
1CREATE TABLE IF NOT EXISTS plant_types (
2 id SERIAL PRIMARY KEY NOT NULL,
3 name VARCHAR(100) NOT NULL,
4 watering_frequency_in_minutes INT
5);
6
7CREATE TABLE IF NOT EXISTS plants (
8 id SERIAL PRIMARY KEY NOT NULL,
9 user_id UUID NOT NULL REFERENCES users(id) ON DELETE CASCADE,
10 name VARCHAR(200),
11 plant_type_id INT REFERENCES plant_types(id) ON DELETE SET NULL
12);