CREATE TABLE `Employee` (
	`employee_id ` int PRIMARY KEY,
	`employee_name` varchar(255),
	`ssn` varchar(255),
	`dob` date,
	`department ` varchar(255)
);
CREATE TABLE `Customer ` (
	`customer_id` int PRIMARY KEY,
	`customer_name ` varchar(255),
	`ssn ` varchar(255),
	`dob` date,
	`phone_number ` varchar(255),
	`address` varchar(255),
	`email` varchar(255)
);
CREATE TABLE `Transfer_In` (
	`transfer_id` int PRIMARY KEY,
	`transferin_date` datetime,
	`amount` varchar,
	`source_routing` varchar(255),
	`source_account` int,
	`destination_account` int
);
CREATE TABLE `Account ` (
	`account_number ` int PRIMARY KEY,
	`account_type ` varchar(255),
	`starting_balance ` varchar,
	`opening_balance ` datetime
);
CREATE TABLE `Transfer_Out` (
	`transferout_id` int,
	`transferout_date` datetime,
	`out_amount` varchar(255),
	`destination_routing` int,
	`destionation_account` int,
	`source_account` int
);
CREATE TABLE `Ownership` (
	`ownership_id` int PRIMARY KEY,
	`customer_id` int,
	`account_number` int
);
CREATE TABLE `Withdraw ` (
	`withdraw_time` datetime,
	`withdraw_id ` int PRIMARY KEY,
	`amount ` varchar,
	`account_number` int
);
CREATE TABLE `Deposit` (
	`deposit_id` int PRIMARY KEY,
	`deposit_time` datetime,
	`amount ` varchar,
	`account_number` int
);