Pondit ER diagram

pondIT_erd

Table user_types{
  id int [pk, not null, unique]
  type text
  description text
  created_at timestamp
  updated_at timestamp
}

Table users{
  id int [pk, not null, unique]
  user_type_id int [not null, ref: > user_types.id]
  first_name text
  last_name text
  email text
  phone text
  dp_url text
  created_at timestamp
  updated_at timestamp
}

Table teachers{
  id int [pk, not null, unique]
  user_id int [not null, ref: > users.id]
  profile_video_url text
}

Table teaching_experience{
  id int [pk, not null, unique]
  teacher_id int [not null, ref: > teachers.id]
  topic text
  description text
  year_from timestamp
  year_to timestamp
  created_at timestamp
  updated_at timestamp
}

Table teacher_schedule{
  id int [pk, not null, unique]
  teacher_id int [not null, ref: > teachers.id]
  time_from timestamp
  time_to timestamp
  created_at timestamp
  updated_at timestamp
}

Table language_proficiency{
  id int [pk, not null, unique]
  user_id int [not null, ref: > users.id]
  language text
  description text
  certificate text
  certificate_image_url text
  is_varified boolean
  created_at timestamp
  updated_at timestamp
}

Table education{
  id int [pk, not null, unique]
  user_id int [not null, ref: > users.id]
  degree text
  institution_name text
  certificate text
  certificate_image_url text
  education_year timestamp
  is_varified boolean
  created_at timestamp
  updated_at timestamp
}

Init commit