CREATE TABLE transactions(
	id VARCHAR(100) PRIMARY KEY,
	mdstoreid VARCHAR(100) references metadata(mdid) ON DELETE CASCADE NOT NULL,
	dateofcreation timestamp,
	refresh boolean
);

CREATE INDEX transactions_idx on transactions(mdstoreid);