S
Simba
Being a newbie to access, I have been given a task of creating a db for the
patient management and tracking. This DB will have around 50 patients per
year. It will contain the history of patient's contact info, pediatrician,
case manager,Genetic center info, Insurance info and so on. I have created
the tables. pls review them and suggest me your ideas to improve the DB, as
mine maynot be best.
tblPatients
RegID - PK
PatientID,FirstName,LastName,DOB,Gender,Hospital,MA,CaseStatus,Diagnosis,Address,City,Zip,county,MFirstName(mom),MLastName,MAddress,MCity,MState,MZip,MHomePhone,MCellPhone,MWorkPhone,FFirstName(Father),FLastName,FAddress,FCity,FState,FZip,FHomePhone,FcellPhone,CurrentPed,FormerPed,GenCenter,Geneticist,CaseManager,CaseManagement
tblPediatrician_1 and also tblPediatrician_2
PedID-PK,LastName,FirstName,MI, Practicie,Address,City,State,Zip,Phone,Fax
tblGenCenter
center_Id-PK,Name,Address,City,state,zip,phone,Fax
tblGencounselor
CounselorID-PK,FName,LName,Phone,Pager,Fax
tblCaseMgr
MgrID-Pk,FName,LName,Phone,Pager,Fax
tblCaseMgmt
MgmtId-Pk,Name, address,........
tblInsurance
InsuranceID-Pk,Type,AgencyName,ContactFName,ContactLName,phone,fax,insuranceName,policyno,CS_Phone
tblInsuranceType
InsuranceType-ID-Pk,RegID,InsuranceID
tblGuardian
guardianId-pk,Refdate,type,fName,LName,address,state,city,zip,hPhone,Cphone,wphone
tblpatientguardian
patguardianID-Pk
Regid
GuardianID
patient management and tracking. This DB will have around 50 patients per
year. It will contain the history of patient's contact info, pediatrician,
case manager,Genetic center info, Insurance info and so on. I have created
the tables. pls review them and suggest me your ideas to improve the DB, as
mine maynot be best.
tblPatients
RegID - PK
PatientID,FirstName,LastName,DOB,Gender,Hospital,MA,CaseStatus,Diagnosis,Address,City,Zip,county,MFirstName(mom),MLastName,MAddress,MCity,MState,MZip,MHomePhone,MCellPhone,MWorkPhone,FFirstName(Father),FLastName,FAddress,FCity,FState,FZip,FHomePhone,FcellPhone,CurrentPed,FormerPed,GenCenter,Geneticist,CaseManager,CaseManagement
tblPediatrician_1 and also tblPediatrician_2
PedID-PK,LastName,FirstName,MI, Practicie,Address,City,State,Zip,Phone,Fax
tblGenCenter
center_Id-PK,Name,Address,City,state,zip,phone,Fax
tblGencounselor
CounselorID-PK,FName,LName,Phone,Pager,Fax
tblCaseMgr
MgrID-Pk,FName,LName,Phone,Pager,Fax
tblCaseMgmt
MgmtId-Pk,Name, address,........
tblInsurance
InsuranceID-Pk,Type,AgencyName,ContactFName,ContactLName,phone,fax,insuranceName,policyno,CS_Phone
tblInsuranceType
InsuranceType-ID-Pk,RegID,InsuranceID
tblGuardian
guardianId-pk,Refdate,type,fName,LName,address,state,city,zip,hPhone,Cphone,wphone
tblpatientguardian
patguardianID-Pk
Regid
GuardianID