###############################################################################################
# IMPORTANT: 
#	- Conventions depending of SUFFIX and PREFIX (<PREFIX>*<SUFFIX>) are not supported #
#	- Conventions are case sensitive
###############################################################################################

##########
# FORMAT #
##########
#conventions = <convention1>,... - your conventions "," comma separated

###########
#Example: #
###########
#conventions = KEY_,chave,_id_internal,_KEY



##################
# FK Conventions #
##################
conventions = KEY_,chave,_id_internal,_KEY


#################################################################
#Corrections													#
#Format:		 												#
#<tableName>.corrections = <FOREIGN_KEY_NAME> = <TABLE_NAME>	#
#################################################################
STUDENT_CURRICULAR_PLAN.corrections = KEY_EMPLOYEE = ass_FUNCIONARIO, KEY_SECUNDARY_BRANCH = BRANCH, KEY_SPECIALIZATION_BRANCH = BRANCH
ass_FUNCIONARIO.corrections = chavePessoa = PERSON, chaveHorarioActual = ass_HORARIO
ass_HORARIO.corrections = chaveHorarioTipo = ass_HORARIO_TIPO, chaveFuncionario = ass_FUNCIONARIO
MASTER_DEGREE_PROOF_VERSION.corrections = KEY_EMPLOYEE = ass_FUNCIONARIO
MASTER_DEGREE_THESIS_DATA_VERSION.corrections = KEY_EMPLOYEE = ass_FUNCIONARIO
SECTION.corrections = KEY_SUPERIOR_SECTION = SECTION
ENROLMENT.corrections = KEY_CURRICULAR_COURSE_FOR_OPTION = CURRICULAR_COURSE
GRATUITY_VALUES.corrections = KEY_EMPLOYEE = ass_FUNCIONARIO
GRATUITY_SITUATION.corrections = KEY_EMPLOYEE = ass_FUNCIONARIO, KEY_GRATUITY = GRATUITY_VALUES
PAYMENT_PHASE.corrections = KEY_GRATUITY = GRATUITY_VALUES
ENROLMENT_EVALUATION.corrections = KEY_EMPLOYEE = ass_FUNCIONARIO
STUDENT.corrections = KEY_REGISTRATION_YEAR = EXECUTION_YEAR
EXECUTION_PERIOD.corrections = KEY_PREVIOUS_EXECUTION_PERIOD = EXECUTION_PERIOD
EQUIVALENT_ENROLMENT_FOR_ENROLMENT_EQUIVALENCE.corrections = KEY_EQUIVALENT_ENROLMENT = ENROLMENT
GRATUITY_TRANSACTION.corrections = KEY_RESPONSIBLE_PERSON = PERSON
INSURANCE_TRANSACTION.corrections = KEY_RESPONSIBLE_PERSON = PERSON