6xRCsS50

1DROP TABLE IF EXISTS address CASCADE;
2CREATE TABLE address (
3	address_id SERIAL PRIMARY KEY,
4	country VARCHAR(255) NOT NULL
5	city VARCHAR(255) NOT NULL,
6	street VARCHAR(255) NOT NULL,
7	house_number VARCHAR(255) NOT NULL,
8	place_number VARCHAR(255),
9	postcode VARCHAR(255) NOT NULL,
10);
11
12DROP TABLE IF EXISTS person CASCADE;
13CREATE TABLE person (
14	person_id SERIAL PRIMARY KEY,
15	login VARCHAR(255) UNIQUE NOT NULL,
16	firstName VARCHAR(255) NOT NULL,
17	secondName VARCHAR(255) NOT NULL,
18	lastName VARCHAR(255) NOT NULL,
19	personalIdentityNumber VARCHAR(255) NOT NULL,
20	email VARCHAR(255) NOT NULL,
21    isActive BOOLEAN
22);
23
24DROP TABLE IF EXISTS account CASCADE;
25CREATE TABLE account (
26    account_id SERIAL PRIMARY KEY,
27    number VARCHAR(255) NOT NULL,
28    funds MONEY  (255) NOT NULL,
29    accountType INTEGER REFERENCES accountType(accountType_id)
30);
31
32DROP TABLE IF EXISTS accountType CASCADE;
33CREATE TABLE storey (
34	storey_id SERIAL PRIMARY KEY,
35    name VARCHAR(255) NOT NULL,
36    description VARCHAR(500),
37);