CREATE DATABASE /*!32312 IF NOT EXISTS*/`projects` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `projects`;

CREATE TABLE `test` (
  `id` int(11) NOT NULL auto_increment,
  `fk_item` varchar(64) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `item_payment` (
  `id` int(11) NOT NULL auto_increment,
  `text` varchar(64) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `item_status` (
  `id` int(11) NOT NULL auto_increment,
  `status` varchar(64) default NULL,
  `order` int(11) default NULL,
  `class` varchar(8) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

CREATE TABLE `items` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(256) default NULL,
  `approx_cost` float default NULL,
  `fk_item_payment` int(11) default NULL,
  `fk_item_status` int(11) default NULL,
  `project_fk` int(11) default NULL,
  `fk_staff` int(11) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1491 DEFAULT CHARSET=latin1;

CREATE TABLE `projects` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(64) default NULL,
  `fk_sales` int(11) default NULL COMMENT 'This is the sales manager, dbd:fk-to:staff',
  `fk_project_manager` int(11) default NULL COMMENT 'xxx dbd:fk-to:staff xxx',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;

CREATE TABLE `staff` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(200) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=939 DEFAULT CHARSET=latin1;

Test: MySQL - MyISAM

Tests:

fk_table_name
table_name_fk
COMMENT 'stuff dbd:fk-to:staff other stuff'