The grade_event Table

Sep 16, 2009 Author: MYSQL Expert

The grade_event table has this definition:

CREATE TABLE grade_event
(
date DATE NOT NULL,
category ENUM('T','Q') NOT NULL,
event_id INT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY (event_id)
) ENGINE = InnoDB;



To create the grade_event table, type that CREATE TABLE statement into mysql or execute
the following command:

% mysql sampdb < create_grade_event.sql

The date column holds a standard MySQL DATE value, in 'CCYY-MM-DD’ (year-first)
format.
category represents score category. Like sex in the student table, category is an
enumeration column.The allowable values are 'T' and 'Q', representing “test” and
“quiz.”
event_id is an AUTO_INCREMENT column that is defined as a PRIMARY KEY, similar to
student_id in the student table. Using AUTO_INCREMENT enables us to generate unique
event ID values easily.As with the student_id column in the student table, the particular
values are less important than that they be unique.
All the columns are defined as NOT NULL because none of them can be missing.

tags: grade event Table

views 4086
  1. Add New Comment