CREATE SCHEMA pov_data;

CREATE TABLE pov_data.immuta_fake_credit_card_transactions (
	id INT,
	customer_last_name VARCHAR(50),
	credit_card_number VARCHAR(50),
	transaction_location VARCHAR(50),
	transaction_time DATETIME,
	transaction_amount FLOAT,
	transaction_country VARCHAR(50)
);

CREATE TABLE pov_data.immuta_fake_hr_data (
	id INT,
	first_name VARCHAR(50),
	last_name VARCHAR(50),
	email VARCHAR(50),
	gender VARCHAR(50),
	race VARCHAR(50),
	ssn VARCHAR(50),
	dept VARCHAR(50),
	job VARCHAR(50),
	skills VARCHAR(50),
	salary INT,
	type VARCHAR(20)
);
