1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
|
DROP TABLE IF EXISTS transaction ;
CREATE TABLE transaction (
id_transaction int(4) NOT NULL auto_increment,
ref_buyer int(4) NOT NULL,
ref_seller int(4) NOT NULL,
date datetime NOT NULL,
price decimal(10,0) NOT NULL,
validate int(2) NOT NULL,
ref_article int(4) NOT NULL,
PRIMARY KEY (id_transaction),
FOREIGN KEY FK_TRANSACTION_BUYER (ref_buyer)
REFERENCES personne (id_personne),
FOREIGN KEY FK_TRANSACTION_SELLER (ref_seller)
REFERENCES personne (id_personne),
FOREIGN KEY FK_TRANSACTION_ARTICLE (ref_article)
REFERENCES article (id_article)
) TYPE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
