A custom database table that can be added to the Machform database to enable 1 to many relationships between lookup fields (dropdown, checkboxes, radio)

ap_custom_link.sql

/*
Author: Ano Tisam
Description: A custom database table that can be added to the Machform database to enable 1 to many relationships between lookup fields (dropdown, checkboxes, radio)
Date: 2015-03-09 16:31:51
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for ap_custom_link
-- ----------------------------
DROP TABLE IF EXISTS `ap_custom_link`;
CREATE TABLE `ap_custom_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_form` int(11) DEFAULT NULL,
  `parent_element` int(11) DEFAULT NULL,
  `child_form` int(11) DEFAULT NULL,
  `child_element` int(255) DEFAULT NULL,
  `notes` varchar(255) DEFAULT NULL,
  `date_created` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `date_updated` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `ip_address` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
SET FOREIGN_KEY_CHECKS=1;