Нормализация. Звезда vs Снежинка. Создание core слоя по Кимбалу (часть 1).

create temporary unlogged table test_table drop on commit as 

SELECT datname FROM pg_database;

create schema core;

create table dim_inventory (

inventory_pk integer not null,

inventory_id integer not null,

film_id integer not null,

title varchar(255) not null,

rental_duration int2 not null,

rental_rate numeric(4,2) not null,

length int2,

rating varchar(10),

primary key(inventory_pk)

);

create table fact_payment (

payment_pk integer not null,

amount numeric(8,2) not null,

cnt int2 not null,

payment_date date not null,

inventory_fk integer not null references dim_inventory(inventory_pk),

staff_fk integer not null,

primary key(payment_pk)

);