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