test

Tables (4)

courses

  • uid — UUID
  • leader_uid — UUID
  • title — VARCHAR(255) — NOT NULL
  • summary — TEXT
  • subject — VARCHAR(100)
  • url — TEXT
  • photo_url — TEXT
  • age_min — INT
  • age_max — INT
  • duration_minutes — INT
  • price_per_meeting_cents — INT
  • format — VARCHAR(100)
  • delivery — VARCHAR(50)
  • is_available — BOOLEAN
  • published_at — TIMESTAMPTZ
  • language_of_instruction — VARCHAR(10)
  • curriculum — VARCHAR(255)
  • standards — VARCHAR(255)
  • created_at — TIMESTAMPTZ

leaders

  • uid — UUID
  • name — VARCHAR(255) — NOT NULL
  • photo_url — TEXT
  • average_star_rating — NUMERIC(3, 2)
  • review_count — INT
  • created_at — TIMESTAMPTZ

meetings

  • uid — UUID
  • section_uid — UUID
  • course_uid — UUID
  • start_time — TIMESTAMPTZ — NOT NULL
  • end_time — TIMESTAMPTZ — NOT NULL
  • day_of_week — INT — NOT NULL

sections

  • uid — UUID
  • course_uid — UUID
  • start_time — TIMESTAMPTZ
  • end_time — TIMESTAMPTZ
  • size_max — INT
  • filled_space_count — INT
  • created_at — TIMESTAMPTZ