use mytools;
DROP TABLE IF EXISTS ar_mytools;
CREATE TABLE ar_mytools (cust_id INTEGER, po_id INTEGER, PURCH_DATE date, PAID_DATE date, PAST_30 date, PAST_60 date);

-- two rows indicate that cust_id 1000 paid for two purchase orders:
INSERT INTO ar_mytools VALUES (1000, 12500,'2021-12-01','2021-12-15',NULL, NULL);
INSERT INTO ar_mytools VALUES (1000, 12600,'2022-01-05','2022-01-10',NULL, NULL);
