... sequence: The sequence number that the field is displayed on the registration form is_customized: The flag that indicates the registration form is customized. 1 is customized, 0 is not. (We actually only needs 1 record for this flag. As I don't come up with a better place for it, leave it here for now.)
*Initial Data:*
INSERT INTO `customized_registration` VALUES (null, 0, 'Second Name', 0, 'Text', 30, 1, 1, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'Date of Birth', 0, 'Text', 30, 1, 2, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'Sex', 0, 'Text', 30, 1, 3, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'Street Address', 0, 'Text', 30, 1, 4, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'Postal/Zip Code', 0, 'Text', 30, 1, 5, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'City', 0, 'Text', 30, 1, 6, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'Province/State', 0, 'Text', 30, 1, 7, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'Coutry', 0, 'Text', 30, 1, 8, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'Telephone Number', 0, 'Text', 30, 1, 9, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'Web Site', 0, 'Text', 30, 1, 10, 0); INSERT INTO `customized_registration` VALUES (null, 0, 'List Courses to Enroll', 0, 'Text', 30, 1, 11, 0);
h4. *Table 2: customized_registration_data*
To keep data input by users on customized fields.
*Table Structure:*
CREATE TABLE `customized_registration_data` ( `customized_registration_data_id` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, `customized_registration_id` MEDIUMINT UNSIGNED NOT NULL default 0, `value` blob NOT NULL default '', PRIMARY KEY (`customized_registration_data_id`) );
*Fields Explanation:*
customized_registration_data_id: Primary key, auto increment customized_registration_id: Link to customized_registration.customized_registration_id value: value of the field with customized_registration.customized_registration_id
h2. Registration Form
h4. Sample Interface
!registration.JPG!\\ If "Courses to Enroll" is selected in "Customize Registration Form", a section "Courses to Enroll" will be displayed in registration form after section "Personal Information". This section lists all available courses. The user can select the courses he/she wants to enroll in. A save on registration form will do both registration and enrollment into selected courses for user. A shortcut "Check All" checkbox is provided to allow user to select all courses by one single click.
Another section "Additional Information" will be displayed after section "Courses to Enroll". It creates the fields of the types that are defined by the administrator. The values of the fields from the user are saved into table customized_registration_data. |