[Toolsdev] Update to page "Create New Session" and updates to schema



Hi,

I've updated the mockup of page "Create New Session" according to 
the latest revisions by trg.  View it here:

http://zydeco.netbusters.com/~olszowka/arisia_program/AddNewItems.
htm

The page implies some changes to the latest schema distributed by 
Jack:

Sessions table:

1) Remove column divisionid
2) Remove column proposer
3) Add column materials text
4) Add column servicenotes text

Replace SessionHasProperty and SessionProperies tables with 
following tables:

5) Table SessionFeatures
column featureid integer [primary key]
column featurename text

6) Table SessionHasFeature
column sessionid integer [primary key] (foreign key)
column featureid integer [primary key] (foreign key)

7) Table SessionServices
column serviceid integer [primarykey]
column servicename text

8) Table SessionHasService
column sessionid integer [primary key] (foreign key)
column serviceid integer [primary key] (foreign key)

Note, it will be too difficult to capture a text notes separately for each 
service on each session.  Instead, a single column, servicenotes, on 
the sessions table will capture any details about any services.







This archive was generated by a fusion of Pipermail (Mailman edition) and MHonArc.