<<

NAME

Koha::Schema::Result::Course

TABLE: courses

ACCESSORS

course_id

  data_type: 'integer'
  is_auto_increment: 1
  is_nullable: 0

unique id for the course

department

  data_type: 'varchar'
  is_nullable: 1
  size: 80

the authorised value for the DEPARTMENT

course_number

  data_type: 'varchar'
  is_nullable: 1
  size: 255

the 'course number' assigned to a course

section

  data_type: 'varchar'
  is_nullable: 1
  size: 255

the 'section' of a course

course_name

  data_type: 'varchar'
  is_nullable: 1
  size: 255

the name of the course

term

  data_type: 'varchar'
  is_nullable: 1
  size: 80

the authorised value for the TERM

staff_note

  data_type: 'longtext'
  is_nullable: 1

the text of the staff only note

public_note

  data_type: 'longtext'
  is_nullable: 1

the text of the public / opac note

students_count

  data_type: 'varchar'
  is_nullable: 1
  size: 20

how many students will be taking this course/section

enabled

  data_type: 'enum'
  default_value: 'yes'
  extra: {list => ["yes","no"]}
  is_nullable: 0

determines whether the course is active

timestamp

  data_type: 'timestamp'
  datetime_undef_if_invalid: 1
  default_value: current_timestamp
  is_nullable: 0

PRIMARY KEY

• "course_id"

RELATIONS

course_instructors

Type: has_many

Related object: Koha::Schema::Result::CourseInstructor

course_reserves

Type: has_many

Related object: Koha::Schema::Result::CourseReserve

borrowernumbers

Type: many_to_many

Composing rels: "course_instructors" -> borrowernumber

<<