[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.