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

/* Client - clientAddress*/

INSERT INTO params (object_id, attr_id, text_value) VALUES (101, 1, 'Sumy');

INSERT INTO params (object_id, attr_id, text_value) VALUES (102, 1, 'Sumy');

INSERT INTO params (object_id, attr_id, text_value) VALUES (103, 1, 'Sumy');

INSERT INTO params (object_id, attr_id, text_value) VALUES (104, 1, 'Sumy');

INSERT INTO params (object_id, attr_id, text_value) VALUES (105, 1, 'Sumy');

INSERT INTO params (object_id, attr_id, text_value) VALUES (106, 1, 'Sumy');

INSERT INTO params (object_id, attr_id, text_value) VALUES (107, 1, 'Sumy');

INSERT INTO params (object_id, attr_id, text_value) VALUES (108, 1, 'Sumy');

INSERT INTO params (object_id, attr_id, text_value) VALUES (109, 1, 'Sumy');

/* Client - clientPhone*/

INSERT INTO params (object_id, attr_id, number_value) VALUES (101, 2, 0661283733);

INSERT INTO params (object_id, attr_id, number_value) VALUES (102, 2, 0668373312);

INSERT INTO params (object_id, attr_id, number_value) VALUES (103, 2, 0661283153);

INSERT INTO params (object_id, attr_id, number_value) VALUES (104, 2, 0951283733);

INSERT INTO params (object_id, attr_id, number_value) VALUES (105, 2, 0661123733);

INSERT INTO params (object_id, attr_id, number_value) VALUES (106, 2, 0631283733);

INSERT INTO params (object_id, attr_id, number_value) VALUES (107, 2, 0981283733);

INSERT INTO params (object_id, attr_id, number_value) VALUES (108, 2, 0641283733);

INSERT INTO params (object_id, attr_id, number_value) VALUES (109, 2, 0681283733);

/* Product - price*/

INSERT INTO params (object_id, attr_id, number_value) VALUES (10001, 3, 14.20);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10002, 3, 12.20);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10003, 3, 54.18);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10004, 3, 13.99);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10005, 3, 74.10);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10006, 3, 10.50);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10007, 3, 11.50);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10008, 3, 18.95);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10009, 3, 01.40);

/* Product - quantity*/

INSERT INTO params (object_id, attr_id, number_value) VALUES (10001, 4, 91);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10002, 4, 82);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10003, 4, 73);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10004, 4, 64);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10005, 4, 55);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10006, 4, 46);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10007, 4, 37);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10008, 4, 28);

INSERT INTO params (object_id, attr_id, number_value) VALUES (10009, 4, 19);

/* Sell - workerID*/

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

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

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000003, 5, 4);

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

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

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

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

INSERT INTO params (object_id, attr_id, number_value) VALUES (1000008, 5, 3);

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

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

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

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

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