Paul Hollands

« Broke my GRUB | Main | Blojsom: A Java based blog system that implements the Atom API »

September 23, 2005

First crack at finance database LDS

-- phpMyAdmin SQL Dump
-- version 2.6.4-pl1
-- http://www.phpmyadmin.net
-- Host: localhost
-- Generation Time: Sep 23, 2005 at 08:32 PM
-- Server version: 3.23.56
-- PHP Version: 4.4.0
-- Database: `fwl_finance`
-- 
-- Table structure for table `category`
-- 
CREATE TABLE category (
  category_id int(10) NOT NULL auto_increment,
  category_label text NOT NULL,
  category_description text,
  category_is_parent tinyint(1) NOT NULL default '0',
  category_parent_id int(10) NOT NULL default '0',
  PRIMARY KEY  (category_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- 
-- Table structure for table `recipient`
-- 
CREATE TABLE recipient (
  recipient_id int(10) NOT NULL auto_increment,
  rec_organization_name text,
  rec_person_title enum('Mr','Mrs','Miss','Ms','Dr','Professor') NOT NULL default 'Dr',
  rec_person_first_name varchar(255) NOT NULL default '',
  rec_person_last_name varchar(255) NOT NULL default '',
  rec_contact_address text NOT NULL,
  rec_email varchar(255) NOT NULL default '',
  PRIMARY KEY  (recipient_id)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- 
-- Table structure for table `transaction`
-- 
CREATE TABLE transaction (
  trans_id int(10) NOT NULL auto_increment,
  trans_record_created_date timestamp(14) NOT NULL,
  trans_record_last_modified datetime NOT NULL default '0000-00-00 00:00:00',
  trans_date datetime NOT NULL default '0000-00-00 00:00:00',
  trans_category_id int(10) NOT NULL default '0',
  trans_amount_in int(10) NOT NULL default '0',
  trans_amount_out int(10) NOT NULL default '0',
  trans_payment_type enum('Invoice','FBA credit card','Cash','Cheque') NOT NULL default 'Invoice',
  trans_date_invoiced datetime default '0000-00-00 00:00:00',
  trans_date_paid datetime default '0000-00-00 00:00:00',
  trans_payment_recipient_id int(10) default '0',
  PRIMARY KEY  (trans_id),
  KEY trans_category_id (trans_category_id,trans_amount_in,trans_amount_out)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
-- 
-- Table structure for table `event`
-- 

CREATE TABLE `event` (
  `event_id` int(10) NOT NULL auto_increment,
  `event_title` text NOT NULL,
  `event_description` text NOT NULL,
  `event_start_date` date NOT NULL default '0000-00-00',
  `event_end_date` date NOT NULL default '0000-00-00',
  `event_record_created_date` timestamp(14) NOT NULL,
  `event_type` enum('meeting','conference','training','item purchase','hospitality') NOT NULL default 'meeting',
  PRIMARY KEY  (`event_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

Tags: MySQL

Posted by pj at September 23, 2005 08:33 PM