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