[6] in Project_DB
Project DB Design meeting.
daemon@ATHENA.MIT.EDU (Bill Cattey On the Road)
Fri Jan 24 16:38:33 1997
Date: Fri, 24 Jan 97 15:30:50 EST
From: wdc@MIT.EDU (Bill Cattey On the Road)
To: project-db@MIT.EDU
Cc: miki@MIT.EDU, brlewis@MIT.EDU, mbarker@MIT.EDU, wdc@MIT.EDU
Information:
The pl/SQL code is stored in /mit/project-db/src/pl-sql
html is in src/html
schema is in src/schema
The schema, the entity relation diagram, and the requirements document
were not quite in sync. The schema will change to reflect the
requirements. The ERD will get simpler.
There was some confusion about the "Project Leader" and "Team Leader".
There should be two different groups of people, but currently the schema
has one group of people called by two different names in different
places.
There are top-level html files that can be changed if we need to improve
their design. (/var/https/htdocs/*)
The lion's share of html is generated inside of pl/SQL stored
procedures. This complicates the process of changing things.
The pl/SQL procedures were organized by who has access permitted to
perform the functions. But some functions landed in the wrong access
group. For example all data is supposed to be visible to all, but some
show_ routines are restricted.
The system should permit access if you do not have a certificate, but
this ability is currently not working. We are investigating enabling
this access, but we don't know how to do it yet.
----
Things to change in the design:
Documents that exist for a project are currently not displayed on the
project page. They should.
Separate pages for:
Ideas -- view ideas; view an idea; submit a new idea; delete an
idea; submit comment. Note: Idea manager is postponed until project
page up.
Projects -- view projects; view a project; submit a new project.
Maintenance
Make projects summary page be the first page people see.
CHanges to summary page:
add Search button
add Add project button-- if possible conditional on
director/leader status
Add go to IS home page button
Changes to project display page
add modify button -- if possible conditional
add button to show project documents
add button to show team
Multiple project creation web forms consolidated into one.
Submit status display adds:
button to create another project
button to go back to summary page. (DONE)?
Modify screen is the same form as create, with the fields filled in from
the db allowing the user to modify all.
FUTURE:
second summary page for archives
----
Action items
* wdc check in with tjm and ganderso to see if db should be tracking
ideas. Note: ideas submitted would be visible to all.
* miki and wdc point at front page.
* miki to enable all access on sun-tzu databace pieces.
* miki will put all src under RCS
* miki will show brlewis a form that constructs a select button from a
selection out of a database.
* miki will put brlewis into ops-5 klogin
* brlewis will look at existing html and pl/SQL with an eye to making
changes called out above for UI.
* miki and bruce will meet every two days for 10 mins at 3:50 for
checkin on status.
* wdc & mbarker will investigate approvals for UI workflow review.
* wdc & miki will revise status page.
Development db shown to be very bumpy.
suntzu will get development stuff rolled in periodically.
* wdc, in one week will see about announcing the db to ILEAD.
* wdc verify that miki and brlewis on project-db.
and that it is NOT a public list.
