Creating the project table

Back in Chapter 3, The TrackStar Application we talked about the basic data that represents a project, and in Chapter 4 we decided that we would use a MySQL relational database to build out the persistence layer of this application. Now we need to turn the idea of project content into a real database table.

We know projects need to have a name and a description. We are also going to keep some basic table auditing information on each table by tracking the time a record was created and updated as well as who created and updated the record. This is enough to get us started and meet the goals of this first iteration.

Based on these desired properties, here is how the project table looks:

CREATE TABLE tbl_project 
(
id INTEGER NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(128),
description TEXT,
create_time DATETIME,
create_user_id INTEGER,
update_time DATETIME,
update_user_id INTEGER
);

Covering third-party database administration tools is outside of the scope of...