dbinit.sql

PatientRunner 20 Source

-- *************************************************************************** --
--                                                                             --
-- PatientRunner                                                               --
--                                                                             --
-- Copyright (c) 2002-2005 IgD Software, LLC                                   --
--                                                                             --
-- This file may be distributed and/or modified under the terms of the GNU     --
-- General Public License (GPL) version 2 as published by the Free Software    --
-- Foundation and appearing at http://www.gnu.org/licenses/gpl.html.           --
--                                                                             --
-- *************************************************************************** --

-- This script was designed to be safe.  If a database already exists, it should
-- not be touched.

CREATE DATABASE if not exists patientrunner;
USE patientrunner;

--
-- Table structure for table `patients`
--

CREATE TABLE IF NOT EXISTS patients (
  patientid int(10) unsigned NOT NULL auto_increment,
  lastname varchar(80) default NULL,
  firstname varchar(80) default NULL,
  ssn varchar(14) default NULL,
  birthday datetime default NULL,
  sex tinyint(1) default NULL,
  rate varchar(20) default NULL,
  rank varchar(20) default NULL,
  service varchar(4) default NULL,
  paydate datetime default NULL,
  command varchar(80) default NULL,
  poc varchar(80) default NULL,
  status varchar(80) default NULL,
  allergies varchar(80) default NULL,
  lastseendatetime datetime default NULL,
  inactive tinyint(1) default NULL,
  author varchar(80) default NULL,
  PRIMARY KEY  (patientid)
) TYPE=MyISAM;

--
-- Table structure for table `notes`
--

CREATE TABLE IF NOT EXISTS notes (
  noteid int(10) unsigned NOT NULL auto_increment,
  patientid int(10) unsigned default NULL,
  description varchar(80) default NULL,
  notedatetime datetime default NULL,
  note blob,
  dictationpending tinyint(1) default NULL,
  pleasereview tinyint(1) default NULL,
  author varchar(80) default NULL,
  PRIMARY KEY  (noteid)
) TYPE=MyISAM;

--
-- Table structure for table `scales`
--

CREATE TABLE IF NOT EXISTS scales (
  scaleid int(10) unsigned NOT NULL auto_increment,
  patientid int(10) unsigned default NULL,
  description varchar(80) default NULL,
  scaledate datetime default NULL,
  result int(11) default NULL,
  author varchar(80) default NULL,
  PRIMARY KEY  (scaleid)
) TYPE=MyISAM;

--
-- Table structure for table `diagnoses`
--

CREATE TABLE IF NOT EXISTS diagnoses (
  diagnosisid int(10) unsigned NOT NULL auto_increment,
  patientid int(10) unsigned default NULL,
  diagnosis varchar(80) default NULL,
  startdate datetime default NULL,
  enddate datetime default NULL,
  resolved tinyint(1) default NULL,
  author varchar(80) default NULL,
  PRIMARY KEY  (diagnosisid)
) TYPE=MyISAM;

--
-- Table structure for table `medications`
--

CREATE TABLE IF NOT EXISTS medications (
  medicationid int(10) unsigned NOT NULL auto_increment,
  patientid int(10) unsigned default NULL,
  prescription varchar(80) default NULL,
  startdate datetime default NULL,
  enddate datetime default NULL,
  discontinued tinyint(1) default NULL,
  author varchar(80) default NULL,
  PRIMARY KEY  (medicationid)
) TYPE=MyISAM;

--
-- Table structure for table `templates`
--

CREATE TABLE IF NOT EXISTS templates (
  templateid int(10) unsigned NOT NULL auto_increment,
  description varchar(80) default NULL,
  template blob,
  author varchar(80) default NULL,
  PRIMARY KEY  (templateid)
) TYPE=MyISAM;