gistfile1.txt

group: medical 

DOCTOR = {
    Name:string, Doctorssn:number, Location:string
    "Dr. Donnatella Moss", 601,"Stockholm, Sweden"
    "Dr. Bruno Gianelli", 603,"Stalingrad, Russia"
    "Dr. Rose Landingham", 604,"Frankfurt, Germany"
    "Dr. Toby Ziegler", 605,"Bergen, Norway"
    "Dr. Toby Ziegler", 605,"Bodø, Norway"
    "Dr. E. Livden", 607,"København, Denmark"
    "Dr. N. Neil", 609,"Sussex, UK"
}

DRUG = {
    Name:string, PatentNo:number, Manufacturer:number, GenericName:string, Cost:number
    "Nasonex", 473,1,"Mometasone",80
    "Livostin", 014,2,"Levokabastin",215
    "Aerius", 030,1,"Desloratadin",49
    "Paracet", 575,3,"Paracetamol",46
    "Glucophage", 374,4,"Metformin",67
    "Xylocain", 153,5,"Lidokain",144
    "Flutide Nasal", 133,5,"Flutikason",34
}

MANUFACTURER = {
    CompanyNo:number, Name:string, CEOName:string, CEOssn:number, Location:string    
    1,"MSD","Jebediah Bartlet",123,"Boston, MA, USA"
    2,"McNeil","Joshua Lyman",134,"Berlin, Germany"
    3,"Weifa","Samuel Seaborn",151,"Bergen, Norway"
    4,"Merck","Claudia Jean Craig",174,""
    5,"Sanus","Will Baily",188,""
}

PATIENT = {
    SSN:number, Name:string, GP:number, RecordNo:number
    123,"Jebediah Bartlet",601,001
    134,"Joshua Lyman",601,002
    145,"Leo McGarry",603,003
    151,"Samuel Seaborn",604,004
    174,"Claudia Jean Craig",605,005
    190,"Aaron Sorkin",605,006
    233,"Jonas G. Drange",607,007
    304,"Eli Attie",607,008
    594,"Pal Perry",609,009
}

PRESCRIPTION = {
    PrescNo:number, DoctorID:number, PatientID:number, IssueDate:number, ExpDate:number, Collected:boolean, Drug:number
    1,601,123,20121201,20121205,true,473
    2,604,151,20121112,20130301,true,374
    3,605,190,20121103,20130301,false,153
    3,602,174,20121103,20130301,true,153
    5,605,123,20121103,20130301,false,113
    6,606,174,20121103,20130301,true,575
    7,605,233,20121103,20130301,true,113
    8,607,233,20121103,20130301,true,030
    9,609,233,20121201,20121205,false,030
    10,604,233,20141201,20151205,true,113
    11,605,233,20141201,20151205,false,575
    12,604,233,20141201,20151205,false,113
    13,605,190,20121103,20130301,false,133
}