#######################
# Destination Dataset #
#######################
destination.dataset = 

#######################
# Database Settings   #
#######################
db.driver = com.mysql.jdbc.Driver
db.url = jdbc:mysql://localhost/ciapl
db.user = root
db.pass =

################
# Table Format #
################
# table<number> = YOUR_TABLE_NAME 
# table<number>.columns = COLUMNS_TO_INCLUDE - comma "," separated, use * for all columns
# table<number>.whereCondition = WHERE_CLAUSE - where clause for your table, for example: ID_INTERNAL = 1
# table<number>.position = POSITION_IN_DATASET - not implemented for now, but could be needed in future



################################
# Tables to include in dataset #
################################
mainTable.name = STUDENT
mainTable.columns = *
mainTable.whereCondition = ID_INTERNAL > 1

manyToManyTables=STUDENT_CURRICULAR_PLAN,\
CURRICULAR_COURSE,CURRICULAR_COURSE_SCOPE,BRANCH,\
CURRICULAR_COURSE_GROUP,CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP,\
PERSON_ROLE,ENROLMENT,EXECUTION_DEGREE,PRECEDENCE,RESTRICTION,SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP,\
ENROLMENT_PERIOD,ORIENTATION_TEACHER,SHIFT_SCHOOL_CLASS,PROFESSORSHIP_SCHOOL_CLASS

STUDENT_CURRICULAR_PLAN.validReferences=STUDENT
CURRICULAR_COURSE.validReferences=DEGREE_CURRICULAR_PLAN
CURRICULAR_COURSE_SCOPE.validReferences=CURRICULAR_COURSE
BRANCH.validReferences=DEGREE_CURRICULAR_PLAN
CURRICULAR_COURSE_GROUP.validReferences=BRANCH
CURRICULAR_COURSE_CURRICULAR_COURSE_GROUP.validReferences=CURRICULAR_COURSE_GROUP
PERSON_ROLE.validReferences=PERSON
ENROLMENT.validReferences=STUDENT_CURRICULAR_PLAN
EXECUTION_DEGREE.validReferences=DEGREE_CURRICULAR_PLAN
PRECEDENCE.validReferences=CURRICULAR_COURSE
RESTRICTION.validReferences=PRECEDENCE
SCIENTIFIC_AREA_CURRICULAR_COURSE_GROUP.validReferences=CURRICULAR_COURSE_GROUP
ENROLMENT_PERIOD.validReferences=DEGREE_CURRICULAR_PLAN
ORIENTATION_TEACHER.validReferences=TEACHER
SHIFT_SCHOOL_CLASS.validReferences=SHIFT
PROFESSORSHIP_SCHOOL_CLASS.validReferences=SCHOOL_CLASS