courseTableSlots property

Implementation

late final Shape32 courseTableSlots = Shape32(
  source: i0.VersionedView(
    entityName: 'course_table_slots',
    createViewStmt: 'CREATE VIEW IF NOT EXISTS course_table_slots (id,number,semester,name_zh,name_en,credits,hours,day_of_week,period,classroom_name_zh,classroom_name_en) AS SELECT t1.id AS id, t1.number AS number, t1.semester AS semester, COALESCE(t1.name_zh, t2.name_zh) AS name_zh, COALESCE(t1.name_en, t2.name_en) AS name_en, COALESCE(t1.credits, t2.credits) AS credits, COALESCE(t1.hours, t2.hours) AS hours, t0.day_of_week AS day_of_week, t0.period AS period, t3.name_zh AS classroom_name_zh, t3.name_en AS classroom_name_en FROM schedules AS t0 INNER JOIN course_offerings AS t1 ON t1.id = t0.course_offering LEFT OUTER JOIN courses AS t2 ON t2.code = t1.course_code LEFT OUTER JOIN classrooms AS t3 ON t3.id = t0.classroom WHERE t1.in_course_table = 1;',
    columns: [
      _column_112,
      _column_115,
      _column_114,
      _column_116,
      _column_117,
      _column_118,
      _column_119,
      _column_128,
      _column_129,
      _column_130,
      _column_131,
    ],
    attachedDatabase: database,
  ),
  alias: null,
);