Bonjour ,

j'ai recuperer ce code sql d'une creation de table, cependant je ne vois pas ou fait la reference au clé etrangere... normalement il y a un foreign key quelque part la je sais pas.
Code : Sélectionner tout - Visualiser dans une fenêtre à part
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;