Greenmate
Tables (4)
chats
- ID (id) — UUID — Primary key — NOT NULL
- role — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- createdAt — TIMESTAMP — NOT NULL
- ID (id2) — UUID — Foreign key → plants.ID — NOT NULL
plants
- ID (id) — UUID — Primary key — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- plant_type — VARCHAR(100) — NOT NULL
- planted_at — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- ID (id2) — UUID — Foreign key → users.ID — NOT NULL
users
- ID (id) — UUID — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
waterings
- ID (id) — UUID — Primary key — NOT NULL
- watered_at — TIMESTAMP — NOT NULL
- ID (id2) — UUID — Foreign key → plants.ID — NOT NULL