Re: Is there a bitfield type field in oracle?
Date: Wed, 30 Jan 2008 09:53:21 -0800 (PST)
Message-ID: <62713846-3bb1-47b9-9eda-6d15bf06770d@m34g2000hsb.googlegroups.com>
Hello Dean,
sorry, a bitmap typ doesn't exist. Solution 1) not realy a good idea
(sorry 2008 have 366 days).
Solution 3) looks like a relational database. Go one step more.
REF_TBL_TRAIN (ID, NAME) reference table for all trains
(1,'TRAIN A')
(2,'TRAIN B')
(3,'TRAIN C')
REF_TBL_WEEK (ID,WEEK) reference table for all weeks in
the year (54 entries for one year)
(1,'Week 1') ... (52,'Week 52')
REF_TBL_DAY_WEEK (ID,RUNNING_DAY) reference table to specify the
days a train is running (create only combinations you need)
(1,'YYYYYYY'), (2,'YYYYYYN') or something more simpler.
The table TRAIN_HELP(ID_TRAIN,ID_WEEK,ID_TBL_WEEK) contains 3 values
for the 3 reference tables. If there is no entry use a good default
value.
Most trains will run monday till friday. A better solutions for
holidays is the next step.
Best regards
thomas
Received on Wed Jan 30 2008 - 11:53:21 CST