<?xml version="1.0" encoding="UTF-8"?>
<definition xmlns="http://www.xmlportletfactory.org/xml/xmlportletfactory" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.xmlportletfactory.org/xml/xmlportletfactory xmlportletfactory.xsd">
	<commonData>
        <client>School</client>
		<projectName>coursesExample</projectName>
        <version>1</version>
	</commonData>
	<applications>
		<application>
			<classDef>
				<name>Courses</name>
				<title>Courses Table Maintenance</title>
				<mode>
					<add>true</add>
					<delete>true</delete>
					<modify>true</modify>
					<browse>true</browse>
				</mode>
			</classDef>
			<fileDef>
				<name>courses</name>
				<fields>
					<field>
						<name>courseId</name>
						<title>Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>courseName</name>
						<title>Course Name</title>
						<type>
							<varchar>
								<length>30</length>	
								<filter>true</filter>
								<order>true</order>
							</varchar>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>courseActive</name>
						<title>Is Active</title>
						<type>
							<boolean></boolean>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>false</required>
					</field>
				</fields>
			</fileDef>
			<detailFiles>
				<detailFile>
					<connectionFieldName>courseId</connectionFieldName>
					<connectionTitle>Students - Course</connectionTitle>
					<detailFileClassName>Students</detailFileClassName>
				</detailFile>
				<detailFile>
					<connectionFieldName>courseId</connectionFieldName>
					<connectionTitle>Holidays - Course</connectionTitle>
					<detailFileClassName>Holidays</detailFileClassName>
				</detailFile>
				<detailFile>
					<connectionFieldName>courseId</connectionFieldName>
					<connectionTitle>CourseSubjects - Course</connectionTitle>
					<detailFileClassName>CourseSubjects</detailFileClassName>
				</detailFile>
			</detailFiles>			
		</application>

		<application>
			<classDef>
				<name>Students</name>
				<title>Students Table Maintenance</title>
				<mode>
					<add>true</add>
					<delete>true</delete>
					<modify>true</modify>
					<browse>true</browse>
				</mode>
			</classDef>
			<fileDef>
				<name>students</name>
				<fields>
					<field>
						<name>studentId</name>
						<title>Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>courseId</name>
						<title>Course Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>false</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>studentName</name>
						<title>Name</title>
						<type>
							<varchar>
								<length>30</length>	
								<filter>true</filter>
								<order>true</order>
							</varchar>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>classroomId</name>
						<title>Classroom</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>false</showFieldInView>
						<required>true</required>
						<validation>
							<className>Classrooms</className>
							<fieldName>classroomId</fieldName>
							<orderByField>classroomName</orderByField>
						</validation>            
					</field>
					<field>
						<name>studentPhoto</name>
						<title>Photo</title>
						<type>
							<image></image>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>false</required>
					</field>
				</fields>
			</fileDef>
			<detailFiles>
				<detailFile>
					<connectionFieldName>studentId</connectionFieldName>
					<connectionTitle>Comments - Student</connectionTitle>
					<detailFileClassName>Comments</detailFileClassName>
				</detailFile>
			</detailFiles>			
		</application>
		
		<application>
			<classDef>
				<name>Classrooms</name>
				<title>Classrooms</title>
				<mode>
					<add>true</add>
					<delete>true</delete>
					<modify>true</modify>
					<browse>true</browse>
				</mode>
			</classDef>
			<fileDef>
				<name>classrooms</name>
				<fields>
					<field>
						<name>classroomId</name>
						<title>Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>classroomName</name>
						<title>Name</title>
						<type>
							<varchar>
								<length>30</length>	
								<filter>true</filter>
								<order>true</order>
							</varchar>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
				</fields>
			</fileDef>
		</application>

		<application>
			<classDef>
				<name>Comments</name>
				<title>Student Comments</title>
				<mode>
					<add>true</add>
					<delete>true</delete>
					<modify>true</modify>
					<browse>true</browse>
				</mode>
			</classDef>
			<fileDef>
				<name>comments</name>
				<fields>
					<field>
						<name>commentId</name>
						<title>Comment Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>studentId</name>
						<title>Student Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>false</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>comment</name>
						<title>Comment</title>
						<type>
							<text></text>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>false</required>
					</field>
				</fields>
			</fileDef>
		</application>		
		
		<application>
			<classDef>
				<name>CourseSubjects</name>
				<title>Course Subjects</title>
				<mode>
					<add>true</add>
					<delete>true</delete>
					<modify>true</modify>
					<browse>true</browse>
				</mode>
			</classDef>
			<fileDef>
				<name>courseSubjects</name>
				<fields>
					<field>
						<name>courseSubjectId</name>
						<title>Course Subject Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>courseId</name>
						<title>Course Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>false</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>subjectId</name>
						<title>Subject Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<validation>
							<className>Subjects</className>
							<fieldName>subjectId</fieldName>
							<orderByField>subjectName</orderByField>
						</validation>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>teacherId</name>
						<title>Teacher Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<validation>
							<className>Teachers</className>
							<fieldName>teacherId</fieldName>
							<orderByField>teacherName</orderByField>
						</validation>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
				</fields>
			</fileDef>
		</application>
		
		<application>
			<classDef>
				<name>Subjects</name>
				<title>Subjects</title>
				<mode>
					<add>true</add>
					<delete>true</delete>
					<modify>true</modify>
					<browse>true</browse>
				</mode>
			</classDef>
			<fileDef>
				<name>subjects</name>
				<fields>
					<field>
						<name>subjectId</name>
						<title>Subject Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>subjectName</name>
						<title>Subject Name</title>
						<type>
							<varchar>
								<length>30</length>	
								<filter>true</filter>
								<order>true</order>
							</varchar>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
				</fields>
			</fileDef>
		</application>
			
		<application>
			<classDef>
				<name>Teachers</name>
				<title>Teachers</title>
				<mode>
					<add>true</add>
					<delete>true</delete>
					<modify>true</modify>
					<browse>true</browse>
				</mode>
			</classDef>
			<fileDef>
				<name>teachers</name>
				<fields>
					<field>
						<name>teacherId</name>
						<title>Teacher Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>teacherName</name>
						<title>Teacher Name</title>
						<type>
							<varchar>
								<length>30</length>	
								<filter>true</filter>
								<order>true</order>
							</varchar>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
				</fields>
			</fileDef>
		</application>

		<application>
			<classDef>
				<name>Holidays</name>
				<title>Course Holidays</title>
				<mode>
					<add>true</add>
					<delete>true</delete>
					<modify>true</modify>
					<browse>true</browse>
				</mode>
			</classDef>
			<fileDef>
				<name>holidays</name>
				<fields>
					<field>
						<name>holidayId</name>
						<title>Holiday Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>courseId</name>
						<title>Course Id</title>
						<type>
							<long>
								<length>5</length>
								<signed>false</signed>
								<nullable>false</nullable>
								<order>true</order>
							</long>
						</type>
						<showFieldInView>false</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>holidayName</name>
						<title>Holiday Name</title>
						<type>
							<varchar>
								<length>30</length>	
								<filter>true</filter>
								<order>true</order>
							</varchar>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
					<field>
						<name>holidayDate</name>
						<title>Date</title>
						<type>
							<date>
								<order>true</order>
							</date>
						</type>
						<showFieldInView>true</showFieldInView>
						<required>true</required>
					</field>
				</fields>
			</fileDef>
		</application>
				
	</applications>
</definition>