IDEAFES

Tables (3)

badmintonMatch (Untitled)

  • match_id (PK) — Long — Primary key — NOT NULL
  • place (Field2) — Place
  • zone (Field) — Int
  • matchDate (Field3) — LocalDate
  • courtType (Field4) — CourtType
  • status (Field6) — MatchStatus
  • createdAt (Field7) — LocalDateTime
  • host_id (FK) — Long — Foreign key → users.id — NOT NULL

basketballMatch (Untitled3)

  • match_id (PK) — Long — Primary key — NOT NULL
  • place (Field) — Place
  • zone (Field2) — Int
  • matchDate (Field3) — LocalDate
  • courtType (Field4) — CourtType
  • status (Field5) — MatchStatus
  • createdAt (Field6) — LocalDateTime
  • host_id (FK) — Long — Foreign key → users.id — NOT NULL

users (Untitled2)

  • id (PK) — Long — Primary key — NOT NULL
  • datagsm_id (Field) — Long
  • name (Field2) — String
  • student_number (Field3) — String
  • role (Field4) — Role
  • refreshToken (Field5) — String
  • ban_until (Field6) — LocalDateTime