⇤ ← Revision 1 as of 2012-02-16 11:01:22
566
Comment:
|
← Revision 2 as of 2012-02-16 11:09:59 ⇥
783
|
Deletions are marked like this. | Additions are marked like this. |
Line 11: | Line 11: |
|| || ID || Exam code || Option ID || || Description || Unique row ID || Subject code of the examination || The ID of Option(from the options table)|| || SQL Type || Integer || String || Integer || |
|| || ID || Exam code || Exam Name || Option ID || || Description || Unique row ID || Unique code of the examination || Subject name of the examination || The ID of Option(from the Options table) || || SQL Type || Integer || String || String || Integer || === Options table === || || ID || Option name || || Description || Unique row ID || Name of the stream/option|| || SQL Type || Integer || String || |
Content Tables
Student Table
|
ID |
created |
student_name |
DoB |
Exam ID |
Description |
Unique row ID |
The time when record was created |
Name of the student |
Date of Birth |
The ID of Examination(from the examination table) |
SQL Type |
Integer |
Datetime |
String |
Date |
Integer |
Examination Table
|
ID |
Exam code |
Exam Name |
Option ID |
Description |
Unique row ID |
Unique code of the examination |
Subject name of the examination |
The ID of Option(from the Options table) |
SQL Type |
Integer |
String |
String |
Integer |
Options table
|
ID |
Option name |
Description |
Unique row ID |
Name of the stream/option |
SQL Type |
Integer |
String |