service-person/migrations/2021-10-22-182006_create_initial_tables/up.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34

-- Your SQL goes here

CREATE TABLE countries (
    id SERIAL PRIMARY KEY NOT NULL,
    name VARCHAR NOT NULL
);

CREATE TABLE cities (
    id SERIAL PRIMARY KEY NOT NULL,
    name VARCHAR NOT NULL
);

CREATE TABLE streets (
    id SERIAL PRIMARY KEY NOT NULL,
    name VARCHAR NOT NULL
);

CREATE TABLE address (
    id SERIAL PRIMARY KEY NOT NULL,

    country_id INTEGER REFERENCES countries(id) NOT NULL,
    city_id INTEGER REFERENCES cities(id) NOT NULL,
    street_id INTEGER REFERENCES streets(id) NOT NULL,

    addr_number INTEGER NOT NULL
);

CREATE TABLE persons (
    id SERIAL PRIMARY KEY NOT NULL,
    name VARCHAR NOT NULL,
    age INTEGER NOT NULL,

    address_id INTEGER REFERENCES address(id) NOT NULL
);