A continuación explico a que escenarios pertenecen los registros:
INSERT INTO SPECIAL_DATE (id, special_date) VALUES (1, to_date('06-07-2021', 'DD-MM-YYYY'))
INSERT INTO PRODUCT (id, name, price) VALUES (1, 'cocina', 50000)
INSERT INTO PRODUCT (id, name, price) VALUES (2, 'heladera', 60000)
INSERT INTO PRODUCT (id, name, price) VALUES (3, 'microondas', 5000)
INSERT INTO PRODUCT (id, name, price) VALUES (4, 'lavarropas', 30000)
INSERT INTO PRODUCT (id, name, price) VALUES (5, 'secadordepelos', 4000)
INSERT INTO PRODUCT (id, name, price) VALUES (6, 'notebook', 100000)
INSERT INTO PRODUCT (id, name, price) VALUES (7, 'monitor', 15000)
INSERT INTO PRODUCT (id, name, price) VALUES (8, 'mouse', 1000)
INSERT INTO PRODUCT (id, name, price) VALUES (9, 'pavaelectrica', 3000)
INSERT INTO PRODUCT (id, name, price) VALUES (10, 'plancha', 3500)
INSERT INTO PRODUCT (id, name, price) VALUES (11, 'centrifugador', 20000)
-- El usuario que tenga este carrito se puede volver vip
INSERT INTO CART (id, status) VALUES (1, 110000)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (1, 1)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (1, 2)
-- El usuario que tenga este carrito compro exacto 4 productos
INSERT INTO CART (id, status) VALUES (2, 145000)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (2, 1)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (2, 2)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (2, 3)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (2, 4)
-- El usuario que tenga este carrito compro mas de 10 productos productos, y
-- segun sea vip o este en una fecha especial se le hará el descuento correspondiente
INSERT INTO CART (id, status) VALUES (3, 426500)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 1)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 2)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 3)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 4)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 5)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 6)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 7)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 8)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 9)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 10)
INSERT INTO CART_PRODUCT (cart_id, product_id) VALUES (3, 11)
-- compras que realizaron los usuarios
INSERT INTO PURCHASE (id, purchaseDate, total, user_id) VALUES (1, to_date('06-07-2021', 'DD-MM-YYYY'), 110000, 1)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (1, 1)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (1, 2)
INSERT INTO PURCHASE (id, purchaseDate, total, user_id) VALUES (2, to_date('06-07-2021', 'DD-MM-YYYY'), 145000, 2)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (2, 1)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (2, 2)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (2, 3)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (2, 4)
INSERT INTO PURCHASE (id, purchaseDate, total, user_id) VALUES (3, to_date('06-07-2021', 'DD-MM-YYYY'), 426500, 3)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 1)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 2)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 3)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 4)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 5)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 6)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 7)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 8)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 9)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 10)
INSERT INTO PURCHASE_PRODUCT (purchase_id, product_id) VALUES (3, 11)
-- El usuario es vip y compro mas de 10 productos
INSERT INTO USER (id, cart_id, vip, start_date_vip, end_date_vip, ) VALUES (1, 3, true, to_date('01-07-2021', 'DD-MM-YYYY'), null)
-- El usuario esta en fecha especial y compro mas de 10 productos
INSERT INTO USER (id, cart_id, vip, start_date_vip, end_date_vip) VALUES (2, 3, false, null, null)
-- El usuario compro exactamente 4 productos
INSERT INTO USER (id, cart_id, vip, start_date_vip, end_date_vip) VALUES (3, 2, false, null, null)
-- El usuario se volvio vip ya
INSERT INTO USER (id, cart_id, vip, start_date_vip, end_date_vip) VALUES (4, 1, false, null, null)