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