Postgres 16

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE budget_usages (
    advertiser_id VARCHAR NOT NULL,
    marketplace_id VARCHAR NOT NULL,
    budget_scope_id BIGINT NOT NULL,
    budget DECIMAL(10, 2) NOT NULL,
    budget_usage_percentage DECIMAL(5, 2) NOT NULL,
    usage_updated_timestamp TIMESTAMP WITHOUT TIME ZONE NOT NULL,
    CONSTRAINT pk_budget_usages PRIMARY KEY (advertiser_id, marketplace_id, budget_scope_id, usage_updated_timestamp)
);

INSERT INTO budget_usages (advertiser_id, marketplace_id, budget_scope_id, budget, budget_usage_percentage, usage_updated_timestamp)
VALUES 
('adv123', 'mkt123', 1, 1000, 25.00, '2024-01-01 7:00'),
('adv123', 'mkt123', 1, 1000, 30.00, '2024-01-01 10:00'),
('adv123', 'mkt123', 2, 3000, 45.00, '2024-01-01 8:00'),
('adv123', 'mkt123', 2, 3000, 60.00, '2024-01-01 12:00'),
('adv123', 'mkt123', 2, 3000, 100.00, '2024-01-01 15:00'),
('adv123', 'mkt123', 2, 6000, 50.00, '2024-01-01 16:00'),
('adv123', 'mkt123', 2, 6000, 100.00, '2024-01-01 23:00'),
('adv123', 'mkt123', 1, 1000, 10.00, '2024-01-02 07:00'),
('adv123', 'mkt123', 2, 6000, 10.00, '2024-01-02 08:00');

SELECT * FROM budget_usages

CREATE TABLE

INSERT 0 9

advertiser_id	marketplace_id	budget_scope_id	budget	budget_usage_percentage	usage_updated_timestamp
adv123	mkt123	1	1000.00	25.00	2024-01-01 07:00:00
adv123	mkt123	1	1000.00	30.00	2024-01-01 10:00:00
adv123	mkt123	2	3000.00	45.00	2024-01-01 08:00:00
adv123	mkt123	2	3000.00	60.00	2024-01-01 12:00:00
adv123	mkt123	2	3000.00	100.00	2024-01-01 15:00:00
adv123	mkt123	2	6000.00	50.00	2024-01-01 16:00:00
adv123	mkt123	2	6000.00	100.00	2024-01-01 23:00:00
adv123	mkt123	1	1000.00	10.00	2024-01-02 07:00:00
adv123	mkt123	2	6000.00	10.00	2024-01-02 08:00:00

SELECT 9