CREATE DATABASE Bank;

USE Bank;

CREATE TABLE CreditMoneyInfos
(
card_number CHAR(19) PRIMARY KEY,
credit_amount DOUBLE,
credit_interest DOUBLE,
credit_toBePaid DOUBLE
);

CREATE TABLE CreditDateInfos
(
card_number CHAR(19) PRIMARY KEY,
credit_taken_date DATE,
credit_toReturn_date DATE
);

CREATE TABLE CreditBooleanInfos
(
card_number CHAR(19) PRIMARY KEY,
has_taken_credit BOOLEAN DEFAULT FALSE
#CONSTRAINT fk_CreditBooleanInfos_CreditDateInfos FOREIGN KEY (card_number) REFERENCES CreditDateInfos(card_number),
#CONSTRAINT fk_CreditBooleanInfos_CreditMoneyInfos FOREIGN KEY (card_number) REFERENCES CreditMoneyInfos(card_number)
);

CREATE TABLE UserInfos
(
EGN CHAR(10) PRIMARY KEY,
first_name VARCHAR(20) NOT NULL,
last_name VARCHAR(20) NOT NULL,
email VARCHAR(30)
);

CREATE TABLE UserBankInfos
(
card_number CHAR(19) PRIMARY KEY,
pin CHAR(4) NOT NULL,
IBAN CHAR(20) NOT NULL,
EGN CHAR(10) NOT NULL,
balance DOUBLE NOT NULL
#CONSTRAINT fk_UserBankInfos_UserIBANInfos FOREIGN KEY (IBAN) REFERENCES UserIBANInfos (IBAN),
#CONSTRAINT fk_UserBankInfos_CreditBooleanInfos FOREIGN KEY (card_number) REFERENCES CreditBooleanInfos(card_number),
#CONSTRAINT fk_UserBankInfos_UserInfos FOREIGN KEY (EGN) REFERENCES UserInfos(EGN)
);

CREATE TABLE UserIBANInfos
(
IBAN CHAR(20) PRIMARY KEY
);