lulazz
Posts: 29
|
| Posted: 02/01/2008, 8:46 AM |
|
Hi,
I need to write an app where I can book rooms for an hospital.
On paper it seems a lot easier than hotel room booking since I only have the male/female distinction and all rooms are 2 beds.
The problem is that I have no idea where to start, I have never worked on resource booking and I do not have a clue on how to design the DB.
Do you know if there are similar apps that I can have a look at?
Or if you have done something similar can you please point me in the right direction?
Thanks
Lulazz
|
 |
 |
ckroon
Posts: 869
|
| Posted: 02/01/2008, 9:20 AM |
|
Wow. That's a whole lot to cover in one post :)
It all starts with what data you need to collect and display.
I always start with my tables.
Open an excel spreadsheet and type in the header row: naming the data you want to collect.
Table: room_main
room_mainid
room_number
room_bed_no1
room_bed_no2
room_bed1_open // Y/N
room_bed2_open // Y/N
room_floor
room_other_info1//special equipment, etc
room_other_info2
Table: beds_main
beds_mainid
beds_bedno
beds_patientid
beds_date_in
beds_time_in
beds_date_out
beds_time_out
table:patients_main
patients_mainid
patients_firstname
patients_lastname
The above setup is a rushed sketch of what you could do, but you get the idea
I set it up to be based on Bed reservation and not the room.
Each bed number is unique and you can tell what room it's in and if its occupied or not.
Grids can display by rooms according to Where room_bed1_open = Y or rooms_bed1_open = Y
Make sense?
_________________
Walter Kempees...you are dearly missed. |
|
|
|
lulazz
Posts: 29
|
| Posted: 02/01/2008, 10:52 AM |
|
Hi,
thanks for the reply.
I need to understand how to add the time information, e.g. I think I need to build an agenda for each of the beds, but I don't know how to do it
Thanks
Lulazz
|
|
|
|
ignitesystems
Posts: 7
|
| Posted: 02/07/2008, 5:54 AM |
|
Lulazz, you need to define your business rules properly before you get your hands dirty. I always start with the data model so that we can understand the 'shape' of our business logic.
I.e.
BEDS - Table:
bed_id
bed_occupied (yes / no)
or
BEDS - Table:
bed_id
bed occupied until date
You may have a durations table with predefined hospital stays i.e. Days, Weeks, Months of bed occupation expected........
But for something as critical as a hospital booking system I would recommend you bring an experienced developer on board. 
|
|
|
|
|
