asd

Tables (4)

availability_time

  • availability_time_id — binary(16) — Primary key — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • day_of_week — tinyint — NOT NULL
  • end_at — time(6) — NOT NULL
  • start_at — time(6) — NOT NULL
  • tutor_id — binary(16) — Foreign key → tutor.tutor_id

lesson

  • lesson_id — binary(16) — Primary key — NOT NULL
  • created_at — datetime(6)
  • modified_at — datetime(6)
  • end_at — datetime(6) — NOT NULL
  • is_finish — bit(1) — NOT NULL
  • lesson_duration — enum('FULL_TIME','HALF') — NOT NULL
  • start_at — datetime(6) — NOT NULL
  • student_id — binary(16) — NOT NULL
  • tutor_id — binary(16) — NOT NULL

student

  • student_id — binary(16) — Primary key — NOT NULL
  • name — varchar(255)
  • profile_url — varchar(255)
  • created_at — timestamp
  • modified_at — timestamp

tutor

  • tutor_id — binary(16) — Primary key — NOT NULL
  • name — varchar(255)
  • profile_url — varchar(255)
  • created_at — timestamp
  • modified_at — timestamp
  • school_name — varchar(255)
  • job — varchar(255)