Created
June 23, 2009 17:53
-
-
Save neerajsingh0101/134714 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| students | |
| ------- | |
| INT id | |
| STRING first_name | |
| STRING last_name | |
| STRING full_name | |
| STRING mother_name | |
| STRING father_name | |
| specializations ( fields in which one might major/minor ) | |
| --------------- | |
| INT id | |
| STRING name | |
| specialization_types | |
| ------ | |
| INT id | |
| ENUM name ( valid values are 'major', 'minor' ) | |
| student_specialization_info | |
| ------------------------- | |
| INT id | |
| INT student_id | |
| INT specialization_id | |
| INT specialization_type_id | |
| classes | |
| ------ | |
| INT id | |
| STRING name | |
| STRING professor | |
| INT classroom_number | |
| STRING classroom_building | |
| INT maximum_registration_count | |
| registrations | |
| -------------- | |
| INT id | |
| INT student_id | |
| INT class_id | |
| INT student_specialization_info_id | |
| BOOLEAN dropped | |
| contact_info | |
| ------------- | |
| INT id | |
| ENUM contact_type ( valid values are 'email', 'phone', 'address') | |
| STRING information | |
| BOOLEAN most_current |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment