Time Mate

Tables (6)

meeting_results (Untitled5)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • room_id (FK) — room(id) NOT NULL
  • user_id (F) — users(id) NOT NULL
  • date (Field) — NOT NULL
  • available (Field2) — DEFAULT FALSE NOT NULL

reviews (Untitled6)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • room_id (FK) — room(id) NOT NULL
  • user_id (F) — users(id) NOT NULL
  • content (Field) — NOT NULL
  • sent_at (Field2) — NOT NULL

room (Untitled2)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • title (Field) — NOT NULL
  • room_code (Field2) — UNIQUE NOT NULL
  • is_closed (Field3) — DEFAULT FALSE NOT NULL
  • created_by (FK) — users(id) NOT NULL
  • created_at (Field4) — NOT NULL

room_participants (Untitled3)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • room_id (FK) — room(id) NOT NULL
  • user_id (F) — users(id) NOT NULL
  • is_creator (Field) — DEFAULT FALSE NOT NULL
  • joined_at (Field2) — NOT NULL

time_slots (Untitled4)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • room_id (FK) — room(id) NOT NULL
  • user_id (F) — users(id) NOT NULL
  • date (Field) — NOT NULL
  • available (Field2) — DEFAULT FALSE NOT NULL

users (Untitled)

  • id (PK) — NOT NULL — Primary key — NOT NULL
  • email (Field) — UNIQUE NOT NULL
  • password (Field2) — NOT NULL
  • name (Field3) — NOT NULL
  • created_at (Field4) — NOT NULL