Differences between revisions 1 and 2
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

JAM (last edited 2012-02-16 11:09:59 by Primal Pappachan)