use projekt_hurtownie
create table FACT_ORDERS (
	ORDER_ID int PRIMARY KEY IDENTITY(1,1),
    CLIENT_ID int FOREIGN KEY REFERENCES DIM_CLIENT(CLIENT_ID),
	ORDER_DATE date,
	EMPLOYEE_ID int	FOREIGN KEY REFERENCES DIM_EMPLOYEE(EMPLOYEE_ID),
	BOOK_ID INT FOREIGN KEY REFERENCES DIM_BOOKS(BOOK_ID)
);

create table DIM_BOOKS (
	BOOK_ID int PRIMARY KEY IDENTITY(1,1),
	TITLE varchar(255),
	AUTHOR varchar(255),
	CATEGORY varchar(255)
);

create table DIM_CLIENT (
	CLIENT_ID int PRIMARY KEY IDENTITY(1,1),
	PESEL varchar(11),
	FIRST_NAME varchar(255),
	SURNAME varchar(255),
	CLIENT_RANK int
)

create table DIM_EMPLOYEE (
	EMPLOYEE_ID int PRIMARY KEY IDENTITY(1,1),
	PESEL varchar(11),
	FIRST_NAME varchar(255),
	SURNAME varchar(255)
)