CREATE TABLE AUCTION_TBL (
	auction_id INT NOT NULL GENERATE ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1),
	ref_foreclosure_id INT,
	auction_status VARCHAR(50),
	file_claim_amount DECIMAL(20,2) WITH DEFAULT 0,
	date_forwarded DATE,
	date_forwarded_remarks VARCHAR(100),
	date_filed DATE,
	date_filed_remarks VARCHAR(100),
	ejf_number INT,
	rtc VARCHAR(50),
	PRIMARY KEY(auction_id),
	FOREIGN KEY(ref_foreclosure_id) REFERENCES FORECLOSURE_TBL(foreclosure_id)
);