Research Log of Web Science Students

Computer Science is not simply programming

Database Design

leave a comment »

Projectrix will make use of the following entities (3 main):
User (uid:number, username:string, password:string, firstname:string, lastname:string, middlename:string, emailaddress:string, address:text, country:string, zipcode:number, picture:image, datecreated:date, createdby:string, datemodified:date, modifiedby:string)
Project (pid:number, projectname:string, projectdesc:text, datecreated:date, createdby:string, datemodified:date, modifiedby:string)
Work (wid:number, uid:number, pid:number, datecreated:date, createdby:string, datemodified:date, modifiedby:string)
Rubric (rid:number, rubricname:string, rubricdesc:text, datecreated:date, createdby:string, datemodified:date, modifiedby:string)
Assessment (aid:number, wid:number, rid:number, datecreated:date, createdby:string, datemodified:date, modifiedby:string)
RTag (rtagid:number, rid:number, tag:text, datecreated:date, createdby:string, datemodified:date, modifiedby:string)
PTag (ptagid:number, pid:number, tag:text, datecreated:date, createdby:string, datemodified:date, modifiedby:string)

This was our initial database plan for Projectrix. While learning Java, Spring and Google App Engine, some of the entities here may be modified or may not be used anymore. We’ll see. =)

User (uid:number, username:string, password:string, firstname:string, lastname:string, middlename:string, emailaddress:string, address:text, country:string, zipcode:number, picture:image, datecreated:date, createdby:string, datemodified:date, modifiedby:string)

Project (pid:number, projectname:string, projectdesc:text, datecreated:date, createdby:string, datemodified:date, modifiedby:string)

Work (wid:number, uid:number, pid:number, datecreated:date, createdby:string, datemodified:date, modifiedby:string)

Rubric (rid:number, rubricname:string, rubricdesc:text, datecreated:date, createdby:string, datemodified:date, modifiedby:string)

Assessment (aid:number, wid:number, rid:number, datecreated:date, createdby:string, datemodified:date, modifiedby:string)

RTag (rtagid:number, rid:number, tag:text, datecreated:date, createdby:string, datemodified:date, modifiedby:string)

PTag (ptagid:number, pid:number, tag:text, datecreated:date, createdby:string, datemodified:date, modifiedby:string)

Advertisements

Written by Daniela

September 14, 2009 at 2:58 pm

Posted in ProjectriX

Tagged with ,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: