[104] in iswork
Database design : Activity
daemon@ATHENA.MIT.EDU (Tim McGovern)
Thu Jul 13 11:41:28 2000
Message-ID: <396DE320.19677B4C@mit.edu>
Date: Thu, 13 Jul 2000 11:41:20 -0400
From: Tim McGovern <tjm@MIT.EDU>
Reply-To: tjm@MIT.EDU
MIME-Version: 1.0
To: iswork@mit.edu
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Here's what I propose we use for the Filemaker database.
It's based on the latest design from the Oracle work that Miki and I did.
If you see any rough edges due to my translation, let me know.
If you prefer to see this on the web:
http://web.mit.edu/is/delivery/iswork/dbschema.html
Tim
-----
Activity (Filemaker version)
Field name Field Type
activity_id number
decommissioned_date date
initiative RELATIONSHIP to initiative
status text values ("Active", "Pending", "Completed", "On Hold",
"Terminated", "See Comment"
name text [length 255]
description text [length 2000]
justification text [length 2000]
practice text values ("Academic", "Office", VDI Networking")
customers text [length 255]
notebook_url text [length 512]
responsible_person text [length 50]
cost object number
comment text [length 255]
entered_date date
entered_by text [length 50]
cost_object number
modified_date date
modified_by text [length 50]
-----
