ForestGo

Tables (3)

Forestbook (Untitled2)

  • id (Key) — pk — Primary key — NOT NULL
  • name (Field)
  • fullname (Field2)
  • description (Field3)
  • type (Field4)
  • species (Field5)
  • habitat (Field6)
  • season (Field7)

Userbook (Untitled3)

  • id (Key) — pk — Primary key — NOT NULL
  • date (Field3) — datetime
  • image (Field4)
  • forestbook_id (Key2) — pk — Foreign key → Forestbook.id — NOT NULL
  • user_id (id) — pk — Foreign key → Users.id — NOT NULL

Users (Untitled)

  • id — pk — Primary key — NOT NULL
  • email — unique
  • name — unique
  • password — hash