DB Design suggestions - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

DB Design suggestions

Author

Topic

dshea
Starting Member

3 Posts

Posted - 2005-03-23 : 18:54:40

Hello everyone,

I'm currently creating a basic scheduling app that registers patient tests and am trying to create a simple, yet flexible design.
Depending on which tests are choosen, the patient is moved through various authorization forms before the appointment is offically registered.

Specifics: A patient chooses one or more tests from a registration.aspx page (insert -> TestStatus_tbl) and then selects an available time(dtAppointment) on the Schedule.aspx page.

What I would like next is for the appropriate authorization form(in the flow of things) to be retrieved and updated upon completion. If each test had only one unique associated authorization form, I have no problem implementing this. Where I get confused is that some tests have multiple authorization forms, some have one and only one and others share the same form.

I can sort of hack my way through this with code, but it seems excessive, and modifications updates would be troublesome.

I've provided the tables below:

Appointment_tbl
intApptID
strAlias
dtAppointment
blnDirty

TestStatus
intTestStatusID
intTestID
intApptID
intFrmSubmitCnt (This is my hack to account for multiple forms)
dtTestCompleted

Test_tbl
intTestID
strName

Forms_tbl
intFormID
intTestID
strWebPage

Any insights or comments are welcome.

Thanks,

dave

jsmith8858
Dr. Cross Join

7423 Posts

Posted - 2005-03-23 : 19:18:18

Whatever you do, do NOT prefix the column names with the datatypes. Or end the table names with "_tbl".

- Jeff