INSERT INTO k_payment
(payment_num, bill_num, payment_sum) VALUES(1, 7, 1000);
INSERT INTO k_payment
(payment_num, bill_num, payment_sum) VALUES(2, 7, 500);
INSERT INTO k_payment
(payment_num, bill_num, payment_sum) VALUES(1, 8, 1000);
Таблица "Товары/услуги" (или "Прайс-лист")
INSERT INTO k_price (price_name, price_sum)
VALUES('Материализация духов',1000);
INSERT INTO k_price (price_name, price_sum)
VALUES('Раздача слонов',100);
INSERT INTO k_price (price_name, price_sum)
VALUES('Слоновий бивень',3000);
INSERT INTO k_price (price_name, price_sum)
VALUES('Моржовый клык',1500);
INSERT INTO k_price (price_name, price_sum)
VALUES('Копыто Пегаса',5000);
Таблица "Протоколы счетов"
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(1, 1, 1, 1000);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(1, 2, 2, 1000);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(2, 3, 20, 100);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(3, 4, 2, 3000);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(1, 5, 1, 1000);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(2, 5, 10, 100);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(1, 6, 2, 1000);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(2, 6, 5, 100);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(4, 7, 1, 1500);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)
VALUES(1, 8, 1, 1000);
INSERT INTO k_protokol
(price_num, bill_num, kolvo, price_sum)