[BE] ERD

issue 75

// Use DBML to define your database structure
// Docs: https://dbml.dbdiagram.io/docs

Table pomodoro_room {
  id Integer [primary key]
  name String
  total_cycle Integer
  time_per_cycle Integer
}

Table participant_code {
  id Integer [primary key]
  pomodoro_room_id Integer
  code String 
}

Table member {
  id Integer [primary key]
  nickname String 
}

Table pomodoro_progress {
  id Integer [primary key]
  pomodoro_room_id Integer
  member_id Integer 
  current_cycle Integer
  pomodoro_status String 
  is_done boolean
} 

Table pomodoro_content {
  id Integer [primary key]
  pomodoro_progress_id Integer
  cycle Integer
  plan JSON
  retrospect JSON
}

Ref fk_pariticpant_code_to_pomodoro_room: participant_code.pomodoro_room_id - pomodoro_room.id

Ref fk_pomodoro_progress_to_member: pomodoro_progress.member_id > member.id
Ref fk_pomodoro_progress_to_pomodoro: pomodoro_progress.pomodoro_room_id > pomodoro_room.id

Ref fk_pomodoro_progress_to_pomodoro_content: pomodoro_progress.id < pomodoro_content.pomodoro_progress_id