Workout Matching Platform DB
Tables (5)
Applications (CopyOfCopyOfUntitled2)
- id — PREKEY — Primary key — NOT NULL
- user_id — INT
- post_id — INT
- status — ENUM('pending', 'accepted', 'rejected')
- sent_at — DATETIME
- applied_at — DATETIME
Messages (CopyOfUntitled2)
- id — PREKEY — Primary key — NOT NULL
- sender_id — INT
- receiver_id — INT
- message — TEXT
- sent_at — DATETIME
Posts (CopyOfUntitled)
- id — INT — Primary key — NOT NULL
- user_id — INT
- title — VARCHAR(100)
- content — TEXT
- sport — VARCHAR(50)
- location — DATE
- date — TIME
- max_people — INT
- current_people — INTAUIT
- created_at — DATETIME
- id (id2) — PREKEY — Foreign key → Users.id — NOT NULL
Schedules (Untitled2)
- id — PREKEY — Primary key — NOT NULL
- sender_id — INT
- receiver_id — INT
- message — TEXT
- sent_at — DATETIME
Users (Untitled)
- id — PREKEY — Primary key — NOT NULL
- email — VARCHAR(100)
- password — VARCHAR
- name — INT
- region — VARCHAR(50)
- sports — TEXT
- role — ENUM('user', 'coach')
- created_at — DATETIME