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
);