users:
  conflict_target: canvas_user_id
  report_columns:
    canvas_user_id:
      database_column_name: canvas_user_id
      type: integer
    user_id:
      database_column_name: sis_id
      type: string
    email:
      database_column_name: email
      type: string
    first_name:
      database_column_name: first_name
      type: string
    last_name:
      database_column_name: last_name
      type: string
    full_name:
      database_column_name: full_name
      type: string
    sortable_name:
      database_column_name: sortable_name
      type: string
    status:
      database_column_name: status
      type: string
    login_id:
      database_column_name: login_id
      type: string

accounts:
  conflict_target: canvas_account_id
  report_columns:
    canvas_account_id:
      database_column_name: canvas_account_id
      type: integer
    account_id:
      database_column_name: account_id
      type: string
    canvas_parent_id:
      database_column_name: canvas_parent_id
      type: integer
    parent_account_id:
      database_column_name: parent_account_id
      type: string
    name:
      database_column_name: name
      type: string
    status:
      database_column_name: status
      type: string

courses:
  conflict_target: canvas_course_id
  report_columns:
    canvas_course_id:
      database_column_name: canvas_course_id
      type: integer
    course_id:
      database_column_name: sis_id
      type: string
    short_name:
      database_column_name: short_name
      type: string
    long_name:
      database_column_name: long_name
      type: string
    canvas_account_id:
      database_column_name: canvas_account_id
      type: integer
    canvas_term_id:
      database_column_name: canvas_term_id
      type: integer
    term_id:
      database_column_name: term_sis_id
      type: string
    start_date:
      database_column_name: start_date
      type: datetime
    end_date:
      database_column_name: end_date
      type: datetime
    status:
      database_column_name: status
      type: integer

enrollments:
  conflict_target: canvas_enrollment_id
  report_columns:
    canvas_enrollment_id:
      database_column_name: canvas_enrollment_id
      type: integer
    canvas_course_id:
      database_column_name: canvas_course_id
      type: integer
    course_id:
      database_column_name: course_sis_id
      type: string
    canvas_user_id:
      database_column_name: canvas_user_id
      type: integer
    user_id:
      database_column_name: user_sis_id
      type: string
    role:
      database_column_name: role
      type: string
    role_id:
      database_column_name: role_id
      type: integer
    canvas_section_id:
      database_column_name: canvas_section_id
      type: integer
    section_id:
      database_column_name: section_sis_id
      type: string
    status:
      database_column_name: status
      type: string
    base_role_type:
      database_column_name: base_role_type
      type: string

sections:
  conflict_target: canvas_section_id
  report_columns:
    canvas_section_id:
      database_column_name: canvas_section_id
      type: integer
    section_id:
      database_column_name: sis_id
      type: string
    canvas_course_id:
      database_column_name: canvas_course_id
      type: integer
    name:
      database_column_name: name
      type: string
    status:
      database_column_name: status
      type: string
    start_date:
      database_column_name: start_date
      type: datetime
    end_date:
      database_column_name: end_date
      type: datetime

xlist:
  conflict_target: canvas_section_id
  report_columns:
    canvas_section_id:
      database_column_name: canvas_section_id
      type: integer
    canvas_nonxlist_course_id:
      database_column_name: canvas_nonxlist_course_id
      type: integer

assignments:
  conflict_target: id
  report_columns:
    id:
      database_column_name: :canvas_assignment_id
      type: integer
    title:
      database_column_name: title
      type: string
    description:
      database_column_name: description
      type: text
    due_at:
      database_column_name: due_at
      type: datetime
    unlock_at:
      database_column_name: unlock_at
      type: datetime
    lock_at:
      database_column_name: lock_at
      type: datetime
    points_possible:
      database_column_name: points_possible
      type: integer
    min_score:
      database_column_name: min_score
      type: integer
    max_score:
      database_column_name: max_score
      type: integer
    mastery_score:
      database_column_name: mastery_score
      type: integer
    grading_type:
      database_column_name: grading_type
      type: string
    submission_types:
      database_column_name: submission_types
      type: string
    workflow_state:
      database_column_name: workflow_state
      type: string
    context_id:
      database_column_name: context_id
      type: integer
    context_type:
      database_column_name: context_type
      type: string
    assignment_group_id:
      database_column_name: canvas_assignment_group_id
      type: integer
    grading_scheme_id:
      database_column_name: grading_scheme_id
      type: integer
    grading_standard_id:
      database_column_name: grading_standard_id
      type: integer

submissions:
  conflict_target: submission_id
  report_columns:
    submission_id:
      database_column_name: :canvas_submission_id
      type: integer
    canvas_user_id:
      database_column_name: :canvas_user_id
      type: integer
    canvas_course_id:
      database_column_name: :canvas_course_id
      type: integer
    assignment_id:
      database_column_name: :canvas_assignment_id
      type: integer
    submission_date:
      database_column_name: submitted_at
      type: datetime
    graded_date:
      database_column_name: graded_at
      type: datetime
    score:
      database_column_name: score
      type: integer
    points_possible:
      database_column_name: points_possible
      type: integer
    excused:
      database_column_name: excused
      type: boolean
    workflow_state:
      database_column_name: workflow_state
      type: string

assignment_groups:
  conflict_target: id
  report_columns:
    id:
      database_column_name: :canvas_assignment_group_id
      type: integer
    canvas_course_id:
      database_column_name: :canvas_course_id
      type: integer
    name:
      database_column_name: :name
      type: string
    rules:
      database_column_name: :rules
      type: string
    position:
      database_column_name: :position
      type: integer
    group_weight:
      database_column_name: :group_weight
      type: string
    workflow_state:
      database_column_name: :workflow_state
      type: string
    created_at:
      database_column_name: canvas_created_at
      type: datetime
    updated_at:
      database_column_name: canvas_updated_at
      type: datetime

context_modules:
  conflict_target: canvas_context_module_id
  report_columns:
    canvas_context_module_id:
      database_column_name: canvas_context_module_id
      type: integer
    canvas_context_id:
      database_column_name: canvas_context_id
      type: integer
    canvas_context_type:
      database_column_name: canvas_context_type
      type: string
    position:
      database_column_name: position
      type: integer
    name:
      database_column_name: name
      type: string
    workflow_state:
      database_column_name: workflow_state
      type: string
    deleted_at:
      database_column_name: deleted_at
      type: datetime

context_module_items:
  conflict_target: canvas_context_module_item_id
  report_columns:
    canvas_context_module_item_id:
      database_column_name: canvas_context_module_item_id
      type: integer
    context_module_id:
      database_column_name: canvas_context_module_id
      type: integer
    position:
      database_column_name: position
      type: integer
    content_type:
      database_column_name: content_type
      type: string
    content_id:
      database_column_name: content_id
      type: integer
    workflow_state:
      database_column_name: workflow_state
      type: string
    assignment_id:
      database_column_name: canvas_assignment_id
      type: integer