[51] in iswork
Re: Initial review of DB schema
daemon@ATHENA.MIT.EDU (Tim McGovern)
Fri Apr 21 09:37:16 2000
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="============_-1255798263==_ma============"
Message-Id: <v04020a02b526093a685a@[18.152.1.21]>
In-Reply-To: <200004111637.MAA08841@gypsy.mit.edu>
Date: Fri, 21 Apr 2000 09:37:12 -0400
To: Michal N Lusztig <miki@MIT.EDU>
From: Tim McGovern <tjm@MIT.EDU>
Cc: iswork@MIT.EDU, thorne@MIT.EDU
--============_-1255798263==_ma============
Content-Type: text/plain; charset="us-ascii"
Here's the updates as I know of them right now. It reflects the decision
to remove detailed resource allocation information from the schema, to
simplify the strategy entity information, but does NOT reflect how to
provide the hooks into the SAP cost objects for accounting purposes.
practice
========
name: varchar(255) PK
index into responsible_person table
process
=======
name: varchar(255) PK
index into responsible_person table
itlt
====
index into responsible_person table
infosys
=======
index into responsible_person table
maintainers
===========
index into responsible_person table
status_values
=============
value: varchar(255) values ("Active", "Pending", "Completed",
"On Hold", "Terminated", "See Comment") PK
description: varchar(256)
activity_status_values
======================
value: varchar(255) values ("1", "2", "3", "4", "5") PK
description: varchar(256)
responsible_person
=================
MITid PK
name varchar (50)
kerberos varchar (50)
email: varchar (50)
Theme
=====
theme_id : char (2) PK
title : varchar (255)
short_description: varchar(255)
needs: varchar(1000)
strategic_goals: varchar(2000)
strategy
========
strategy_id: char(2) PK
name: varchar (255)
theme : index into theme table NOT NULL
responsible_person: index into responsible_person table
status: index into status_values
start_date: date NOT NULL
end_date: date
entered_date: date
entered_by: varchar(30)
modified_date: date
modified_by: varchar(30)
initiative
==========
initiative_id: char(2) PK
name: varchar (255) NOT NULL
description: varchar(2000)
justification: varchar(2000)
affected_org: varchar(1000)
budget: varchar(1000)
strategy : index into strategy table NOT NULL
customers: varchar(1000)
dependencies: varchar (2000)
perf_org: varchar (255)
resource_reqs: varchar(1000)
funding_sources: varchar (1000)
success_criteria: varchar(1000)
practice : index into table practice
status: index into status_values
priority: values("CD", "MD", "LA","NL")
responsible_person: index into responsible_person table
start_date: date NOT NULL
end_date: date
entered_date: date
entered_by: varchar(30)
modified_date: date
modified_by: varchar(30)
project
=======
project_id: number PK
start_date: date
end_date: date
initiative: index into initiative table NOT NULL
priority: values("high", "medium", "low")
status: index into status_values
name varchar(256) NOT NULL
description: varchar(2000)
justification: varchar(2000)
practice : index into table practice NOT NULL
customers: varchar(255)
notebook_url: varchar(512)
responsible_person: index into responsible_person table
entered_date: date
entered_by: varchar(30)
modified_date: date
modified_by: varchar(30)
activity
========
project_id: number PK
decommissioned_date: date
initiative: index into initiative table NOT NULL
status: index into activity_status_values NOT NULL
name varchar(256) NOT NULL
description: varchar(2000)
justification: varchar(2000)
practice : index into table practice NOT NULL
customers: varchar(255)
notebook_url: varchar(512)
responsible_person: index into responsible_person table
entered_date: date
entered_by: varchar(30)
modified_date: date
modified_by: varchar(30)
--============_-1255798263==_ma============
Content-Type: text/enriched; charset="us-ascii"
Here's the updates as I know of them right now. It reflects the
decision to remove detailed resource allocation information from the
schema, to simplify the strategy entity information, but does NOT
reflect how to provide the hooks into the SAP cost objects for
accounting purposes.
practice
========
name: varchar(255) PK
index into responsible_person table
process
=======
name: varchar(255) PK
index into responsible_person table
itlt
====
index into responsible_person table
infosys
=======
index into responsible_person table
maintainers
===========
index into responsible_person table
status_values
=============
value: varchar(255) values ("Active", "Pending", "Completed",
"On Hold", "Terminated", "See Comment") PK
description: varchar(256)
activity_status_values
======================
value: varchar(255) values ("1", "2", "3", "4", "5") PK
description: varchar(256)
responsible_person
=================
MITid PK
name varchar (50)
kerberos varchar (50)
email: varchar (50)
Theme
=====
theme_id : char (2) PK
title : varchar (255)
short_description: varchar(255)
needs: varchar(1000)
strategic_goals: varchar(2000)
strategy
========
strategy_id: char(2) PK
name: varchar (255)
theme : index into theme table NOT NULL
responsible_person: index into responsible_person table
status: index into status_values
start_date: date NOT NULL
end_date: date
entered_date: date
entered_by: varchar(30)
modified_date: date
modified_by: varchar(30)
initiative
==========
initiative_id: char(2) PK
name: varchar (255) NOT NULL
description: varchar(2000)
justification: varchar(2000)
affected_org: varchar(1000)
budget: varchar(1000)
strategy : index into strategy table NOT NULL
customers: varchar(1000)
dependencies: varchar (2000)
perf_org: varchar (255)
resource_reqs: varchar(1000)
funding_sources: varchar (1000)
success_criteria: varchar(1000)
practice : index into table practice
status: index into status_values
priority: values("CD", "MD", "LA","NL")
responsible_person: index into responsible_person table
start_date: date NOT NULL
end_date: date
entered_date: date
entered_by: varchar(30)
modified_date: date
modified_by: varchar(30)
project
=======
project_id: number PK
start_date: date
end_date: date
initiative: index into initiative table NOT NULL
priority: values("high", "medium", "low")
status: index into status_values
name varchar(256) NOT NULL
description: varchar(2000)
justification: varchar(2000)
practice : index into table practice NOT NULL
customers: varchar(255)
notebook_url: varchar(512)
responsible_person: index into responsible_person table
entered_date: date
entered_by: varchar(30)
modified_date: date
modified_by: varchar(30)
activity
========
project_id: number PK
decommissioned_date: date
initiative: index into initiative table NOT NULL
status: index into activity_status_values NOT NULL
name varchar(256) NOT NULL
description: varchar(2000)
justification: varchar(2000)
practice : index into table practice NOT NULL
customers: varchar(255)
notebook_url: varchar(512)
responsible_person: index into responsible_person table
entered_date: date
entered_by: varchar(30)
modified_date: date
modified_by: varchar(30)
--============_-1255798263==_ma============--
