Add Supabase Integration about project-aqua HOT 2 OPEN

datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model User {
  user_id             Int                   @id @default(autoincrement())
  username            String
  email               String                @unique
  password            String
  role                String
  date_of_birth       DateTime
  contact_info        String?
  coached_teams       Team[]                @relation("TeamCoach")
  workouts            Workout[]
  athlete_teams       Athletes_Teams[]
  attendance          Attendance[]
  performance_metrics Performance_Metrics[]
  uploaded_files      Files[]
  event_results       Event_Results[]
  swimmer_events      Swimmers_Events[]
  sent_messages       Messages[]            @relation("MessageSender")
  received_messages   Messages[]            @relation("MessageRecipient")
}

model Team {
  team_id     Int              @id @default(autoincrement())
  team_name   String
  coach_id    Int
  description String?
  coach       User             @relation("TeamCoach", fields: [coach_id], references: [user_id])
  athletes    Athletes_Teams[]
  workouts    Workout[]
}

model Athletes_Teams {
  athlete_id Int
  team_id    Int
  join_date  DateTime?
  leave_date DateTime?
  athlete    User      @relation(fields: [athlete_id], references: [user_id])
  team       Team      @relation(fields: [team_id], references: [team_id])

  @@id([athlete_id, team_id])
}

model Workout {
  workout_id          Int                   @id @default(autoincrement())
  workout_name        String
  coach_id            Int
  team_id             Int?
  date                DateTime
  duration            String 
  description         String?
  coach               User                  @relation(fields: [coach_id], references: [user_id])
  team                Team?                 @relation(fields: [team_id], references: [team_id])
  performance_metrics Performance_Metrics[]
}

model Swim_Meet {
  meet_id       Int                @id @default(autoincrement())
  meet_name     String
  meet_date     DateTime
  location      String
  description   String?
  attendance    Attendance[]
  events        Swim_Meet_Events[]
  event_results Event_Results[]
}

model Attendance {
  attendance_id     Int       @id @default(autoincrement())
  athlete_id        Int
  meet_id           Int
  attendance_status String
  date              DateTime
  notes             String?
  athlete           User      @relation(fields: [athlete_id], references: [user_id])
  meet              Swim_Meet @relation(fields: [meet_id], references: [meet_id])
}

model Messages {
  message_id      Int       @id @default(autoincrement())
  sender_id       Int
  recipient_id    Int
  message_content String
  timestamp       DateTime  @default(now()) // Use `now()` to automatically set the message timestamp
  read_at         DateTime? // Nullable, set when the message is read
  deleted_at      DateTime? // Nullable, set when the message is 'deleted'
  sender          User      @relation("MessageSender", fields: [sender_id], references: [user_id])
  recipient       User      @relation("MessageRecipient", fields: [recipient_id], references: [user_id])

  @@index([sender_id])
  @@index([recipient_id])
}

model Performance_Metrics {
  performance_id Int      @id @default(autoincrement())
  athlete_id     Int
  workout_id     Int
  metric_type    String
  value          Float
  date           DateTime
  notes          String?
  athlete        User     @relation(fields: [athlete_id], references: [user_id])
  workout        Workout  @relation(fields: [workout_id], references: [workout_id])
}

model Files {
  file_id     Int      @id @default(autoincrement())
  file_name   String
  file_type   String
  file_size   BigInt
  file_url    String
  uploader_id Int
  upload_date DateTime
  description String?
  uploader    User     @relation(fields: [uploader_id], references: [user_id])
}

model Swim_Meet_Events {
  event_id        Int               @id @default(autoincrement())
  meet_id         Int
  event_name      String
  event_type      String
  event_distance  Int
  distance_unit   String
  event_gender    String?
  event_age_group String?
  meet            Swim_Meet         @relation(fields: [meet_id], references: [meet_id])
  swimmers        Swimmers_Events[]
  results         Event_Results[]
}

model Swimmers_Events {
  swimmer_event_id Int              @id @default(autoincrement())
  event_id         Int
  athlete_id       Int
  swim_time        String 
  event            Swim_Meet_Events @relation(fields: [event_id], references: [event_id])
  athlete          User             @relation(fields: [athlete_id], references: [user_id])
}

model Event_Results {
  result_id     Int              @id @default(autoincrement())
  meet_id       Int
  event_id      Int
  athlete_id    Int
  time_result   String 
  placement     Int
  points_earned Int
  meet          Swim_Meet        @relation(fields: [meet_id], references: [meet_id])
  event         Swim_Meet_Events @relation(fields: [event_id], references: [event_id])
  athlete       User             @relation(fields: [athlete_id], references: [user_id])
}