R2N1F1hW

1CREATE TABLE IF NOT EXISTS  collateral(
2collateral_id varchar(30) NOT NULL,
3collateral_type integer,
4collateral_amount integer,
5collateral_end date,
6collateral_relation_type integer,
7constraint checkCollateralType check(collateral_type=1 OR collateral_type=2 OR collateral_type=3 OR collateral_type=4 OR collateral_type=5),
8constraint checkRelationType check(collateral_relation_type=1 OR collateral_relation_type=2 OR collateral_relation_type=3),
9primary key(collateral_id)
10
11);
12
13
14CREATE TABLE IF NOT EXISTS  account(
15account_id bigint NOT NULL,
16starting_date date,
17status varchar(18),
18product_code integer,
19collateral_id varchar(30) NOT NULL,
20contract_id varchar(30) NOT NULL,
21primary key(account_id),
22constraint checkStatus check(status='Energo' OR status='Diagegramenos' OR status='Dikastiko' OR status='Se Episfaleia' or status='Kleisto'),
23foreign key (collateral_id) REFERENCES collateral(collateral_id),
24foreign key (contract_id) REFERENCES contract(contract_id)