Re: Primary/Uniqueness Problem

#1

Munu wrote:

Quote:

Hi All
I am going to design hospital database
I have a patient table tblpatient(patientid pk,name,age,................)
another table that is tblyearly(yearlyid ,patientid fk,isadmit,department,....
)
another table is tblxray(sr pk,yearlyid fk,..........,..........,.........)
another table is tblurulogy(sr pk,yearlyid fk, .......,........,........)
patientid is unique in patient table and yearlyid must be unique for a year
eg for year 2010 yearlyid starts from 1 and ending at something
and at 1st january 2011 yearly id must start from 1 and ending at something
so that previous record of patient
and form tblxray or tblurulogy patients previous record also needed
ho i design

suppose in yearly table yearlyid starts 1,2,3,4.........and ends at
something( at year 2010)
and in yearly table yearlyid starts 1,2,3,4........and ends at
something ( st year 2011)
if any body updates,or selects(loads yearly id based patient record in grid)
previous yearly id's record that is attached with another patient will be
loaded into grid .
and in case update
update tblxray set bodyregion='upper leg' where yearly id=4
then previous yearlyid data will also be updated

Can any body help me
I would REALLY appreciate any advice
cheers
Noor Anwar

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...-mseq/201008/1

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Primary/Uniqueness Problem

microsoft.public.sqlserver.mseq microsoft.public.sqlserver.mseq

Re: Primary/Uniqueness Problem - 08-31-2010 , 11:14 PM