Datasheet

Figure 1-12
Groups
GroupID
GroupName
GroupDescription
LastUpdateDate
Not Null
Not Null
Null
Not Null
Char(36)
VarChar2(50)
Clob
Date
Users
UserID
LoginName
Password
FirstName
LastName
Email
Phone
Status
GroupID
RoleID
ManagerID
LastUpdateDate
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Not Null
Null
Not Null
Char(36)
VarChar2(15)
VarChar2(75)
VarChar2(30)
VarChar2(30)
VarChar2(50)
VarChar2(20)
Number(1)
Char(36)
Char(36)
Char(36)
Date
TimeSheets
TimeSheetID
UserID
WeekEndingDate
Submitted
ApprovalDate
ManagerID
LastUpdateDate
Not Null
Not Null
Not Null
Not Null
Null
Null
Not Null
Char(36)
Char(36)
Date
Number(1)
Date
Char(36)
Date
TimeSheetItems
TimeSheetItemID
TimeSheetID
ProjectID
Hours
TimeSheetDate
Not Null
Not Null
Not Null
Not Null
Not Null
Char(36)
Char(36)
Char(36)
Number(3)
Date
GroupProjects
GroupProjectID
GroupID
ProjectID
Not Null
Not Null
Not Null
Char(36)
Char(36)
Cha
r(36)
Roles
RoleID
RoleName
RoleDescription
Ranking
LastUpdateDate
Not Null
Not Null
Null
Not Null
Not Null
Char(36)
VarChar2(50)
Clob
Number(3)
Date
Projects
ProjectID
ProjectName
ProjectDescription
SequenceNumber
LastUpdateDate
Not Null
Not Null
Null
Not Null
Not Null
Char(36)
VarChar2(50)
Clob
Number(3)
Date
26
Chapter 1
04_58894x ch01.qxd 10/13/05 5:54 PM Page 26