1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32
|
CREATE TABLE `purchase_orders` (
`id` char(36) NOT NULL,
`related_invoice_id` varchar(50) default NULL,
`supplier_id` varchar(50) default NULL,
`supplier_contact_id` varchar(50) default NULL,
`prefix` varchar(14) default NULL,
`po_number` int(11) NOT NULL,
`date_entered` datetime NOT NULL,
`date_modified` datetime NOT NULL,
`modified_user_id` char(36) NOT NULL default '',
`assigned_user_id` char(36) default NULL,
`created_by` char(36) default NULL,
`deleted` tinyint(1) NOT NULL default '0',
`cancelled` tinyint(1) NOT NULL default '0',
`name` varchar(100) default NULL,
`due_date` date NOT NULL,
`currency_id` char(36) default NULL,
`exchange_rate` double default NULL,
`shipping_provider_id` char(36) default NULL,
`description` text,
`amount` double NOT NULL,
`amount_usdollar` double default NULL,
`amount_due` double NOT NULL,
`amount_due_usdollar` double default NULL,
`terms` varchar(25) NOT NULL,
`tax_information` varchar(150) default NULL,
`show_components` varchar(40) default '',
PRIMARY KEY (`id`),
KEY `idx_purchase_orders_number` (`po_number`),
KEY `idx_purchase_orders_name` (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8; |
Partager