EXPLICATIE COD – MAGAZIN ONLINE
STEFAN ALEXANDRU, 1230F

BAZA DE DATE

CREATE TABLE IF NOT EXISTS `adress` ( //Tabela cu adresele clientilor, cheia primara adress_id este folosita pentru `ADRESS_ID` int(11) NOT NULL AUTO_INCREMENT, //legatura cu tabela de clienti `STREET` varchar(255) NOT NULL, `NUMBER` varchar(255) NOT NULL, `BLOCK` varchar(255) DEFAULT NULL, `FLOOR` varchar(255) DEFAULT NULL, `APARTMENT` varchar(255) DEFAULT NULL, `ZIP` int(10) NOT NULL, `COUNTRY` varchar(50) NOT NULL, PRIMARY KEY (`ADRESS_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

//populam tabela de adrese

INSERT INTO `adress` (`ADRESS_ID`, `STREET`, `NUMBER`, `BLOCK`, `FLOOR`, `APARTMENT`, `ZIP`, `COUNTRY`) VALUES
(1, 'Str Brailei', '162', 'L2', '3', '55', 800078, 'Romania'),
(3, 'Ploii', '62', 'L3', '3', '50', 800078, 'Romania');

//in invoice sunt retinute comenzile plasate de fiecare client
--
-- Table structure for table `invoice`
--

CREATE TABLE IF NOT EXISTS `invoice` ( `invoice_id` int(5) NOT NULL AUTO_INCREMENT, `client_id` int(11) NOT NULL, `total` int(10) NOT NULL, `date` date NOT NULL, PRIMARY KEY (`invoice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

//se populeaza invoice

INSERT INTO `invoice` (`invoice_id`, `client_id`, `total`, `date`) VALUES
(1, 2, 300, '2013-05-01'),
(2, 4, 422, '2013-05-03'),
(3, 2, 3400, '2013-05-31');

-- --------------------------------------------------------

--
-- Table structure for table `order_invoice`
--

//in order_invoice este retinut fiecare articol din comanda. Fiecare comanda poate contine mai multe articole

CREATE TABLE IF NOT EXISTS `order_invoice` ( `order_id` int(5) NOT NULL AUTO_INCREMENT, `price_id` int(6) NOT NULL, `number_prod` int(3) NOT NULL, `invoice_id` int(5) NOT NULL, PRIMARY KEY