Schema privileges

-- Create the development schema
___ ___ ___;

-- Grant usage privilege on new schema to dev_team
___ ___ ON SCHEMA ___ TO ___;

-- Create a loan table in the development schema
___ ___ ___.___ (
	borrower_id INTEGER,
	bank_id INTEGER,
	approval_date DATE,
	program text NOT NULL,
	max_amount DECIMAL(9,2) NOT NULL,
	gross_approval DECIMAL(9, 2) NOT NULL,
	term_in_months SMALLINT NOT NULL,
	revolver_status BOOLEAN NOT NULL,
	bank_zip VARCHAR(10) NOT NULL,
	initial_interest_rate DECIMAL(4, 2) NOT NULL
);

-- Grant privileges on development schema
___ ___, ___, ___, ___ ON ALL TABLES IN SCHEMA ___ TO ___;