[Workman-svn] SF.net SVN: workman:[2] trunk

[<jm...@us...>]

Revision: 2
          http://workman.svn.sourceforge.net/workman/?rev=2&view=rev
Author:   jmsilva
Date:     2011-10-21 00:21:09 +0000 (Fri, 21 Oct 2011)
Log Message:
-----------
Basic database schema.

Added Paths:
-----------
    trunk/nha/
    trunk/nha/db.sql

Added: trunk/nha/db.sql
===================================================================
--- trunk/nha/db.sql	                        (rev 0)
+++ trunk/nha/db.sql	2011-10-21 00:21:09 UTC (rev 2)
@@ -0,0 +1,37 @@
+create table employers(
+	employer_name varchar(128) not null,
+	employer_hourly_rate float not null,
+	employer_rate_start_date date not null,
+	primary key(employer_name, employer_rate_start_date)
+);
+
+create table projects(
+	project_name varchar(128) not null, 
+	project_description varchar not null,
+	employer_name varchar(128) not null,
+	employer_rate_start_date date not null,
+	primary key(project_name),
+	foreign key(employer_name, employer_rate_start_date) references employers
+);
+
+create table sessions(
+	project_name varchar(128) not null,
+	session_start_time date not null,
+	session_end_time date not null,
+	session_description varchar not null,
+	primary key(project_name, session_start_time, session_end_time),
+	foreign key(project_name) references projects
+);
+
+/*
+create table tasks(
+	project_name varchar(128) not null,
+	task_name varchar(256) not null,
+	task_description varchar not null,
+	task_due_date date not null,
+	primary key(project_name, task_name),
+	foreign key(project_name) references projects	
+);
+	
+*/
+

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.