Table

licensecourses

Each row links a course to a license, representing which courses are entitled under each license.

statusgroupRedshift

Each row links a course to a license, representing which courses are entitled under each license.

Full schema

Yes, this table includes a statusgroup column. See Status Group for details.

Column names and types come from the Redshift analytics schema. SchemaSpy is authoritative for nullability, defaults, keys, and relationships.

select
  t.clientid,
  t.licenseid,
  t.courseid
from licensecourses as t
limit 100