[Gnumed-devel] are we too freakin' ambitious ?

[Karsten Hilbert]

I thought I was shamelessly going to profit from our good
friends at McMasters (OSCAR).

Go figure !

(they are on MySQL ...)

(and, yes, I acknowledge and applaud their achievement)

#===================================================
#
# Table structure for table 'demographic'
#

CREATE TABLE demographic (
    demographic_no int(10) NOT NULL auto_increment,
    last_name varchar(30) NOT NULL default '',
    first_name varchar(30) NOT NULL default '',
    address varchar(60) default NULL,
    city varchar(20) default NULL,
    province varchar(20) default NULL,
    postal varchar(7) default NULL,
    phone varchar(20) default NULL,
    phone2 varchar(20) default NULL,
    year_of_birth varchar(4) default NULL,
    month_of_birth char(2) default NULL,
    date_of_birth char(2) default NULL,
    hin varchar(10) default NULL,
    ver char(3) default NULL,
    roster_status varchar(20) default NULL,
    patient_status varchar(20) default NULL,
    date_joined date default NULL,
    chart_no varchar(10) default NULL,
    provider_no varchar(250) default NULL,
    sex char(1) NOT NULL default '',
    end_date date default NULL,
    eff_date date default NULL,
    pcn_indicator varchar(20) default NULL,
    hc_type varchar(20) default NULL,
    hc_renew_date date default NULL,
    family_doctor varchar(80) default NULL,
    PRIMARY KEY  (demographic_no),
    KEY hin (hin),
    KEY name (last_name,first_name)
) TYPE=MyISAM;

#
# Table structure for table 'demographicaccessory'
#

CREATE TABLE demographicaccessory (
    demographic_no int(10) NOT NULL default '0',
    content text,
    PRIMARY KEY  (demographic_no)
) TYPE=MyISAM;

#
# Table structure for table 'demographiccust'
#

CREATE TABLE demographiccust (
    demographic_no int(10) NOT NULL default '0',
    cust1 varchar(255) default NULL,
    cust2 varchar(255) default NULL,
    cust3 varchar(255) default NULL,
    cust4 varchar(255) default NULL,
    content text,
    PRIMARY KEY  (demographic_no),
    KEY cust1 (cust1),
    KEY cust2 (cust2),
    KEY cust3 (cust3),
    KEY cust4 (cust4)
) TYPE=MyISAM;
#===================================================

And, no, I don't think we are !

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346