[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Karsten Hilbert
Subject: [Gnumed-devel] are we too freakin' ambitious ?
Date: Mon, 18 Nov 2002 00:01:37 +0100
User-agent: Mutt/

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)

# Table structure for table 'demographicaccessory'

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

# 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)

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

GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]