Разработка базы данных из предметной области магазин, страница 6

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000014, 5, 1);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000015, 5, 7);

/* Sell - clientID*/

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000001, 6, 1);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000002, 6, 6);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000003, 6, 7);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000004, 6, 9);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000005, 6, 8);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000006, 6, 5);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000007, 6, 1);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000008, 6, 8);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000009, 6, 8);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000010, 6, 8);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000011, 6, 6);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000012, 6, 3);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000013, 6, 2);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000014, 6, 4);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000015, 6, 8);

/* Sell - sellQuantity*/

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000001, 7, 1);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000002, 7, 2);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000003, 7, 3);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000004, 7, 4);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000005, 7, 5);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000006, 7, 6);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000007, 7, 7);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000008, 7, 8);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000009, 7, 7);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000010, 7, 6);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000011, 7, 5);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000012, 7, 4);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000013, 7, 3);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000014, 7, 2);

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000015, 7, 1);

/* Sell - sellDate*/

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000001, 8, TO_DATE('11-02-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000002, 8, TO_DATE('12-02-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000003, 8, TO_DATE('18-02-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000004, 8, TO_DATE('24-02-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000005, 8, TO_DATE('04-03-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000006, 8, TO_DATE('11-03-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000007, 8, TO_DATE('11-03-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000008, 8, TO_DATE('19-03-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000009, 8, TO_DATE('21-03-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000010, 8, TO_DATE('26-03-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000011, 8, TO_DATE('01-04-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000012, 8, TO_DATE('15-04-2011','DD-MM-YYYY'));

INSERT INTO params (object_id, attr_id, date_value) VALUES (1000013, 8, TO_DATE('20-04-2011','DD-MM-YYYY'));