CREATE TABLE VISIT
(
    ID_visit CHAR(32) NOT NULL,
	duration integer,
    PRIMARY KEY (ID_visit)
);
CREATE TABLE VISITOR
(
    ID_visitor CHAR(32) NOT NULL,
	gender CHAR(32),
    PRIMARY KEY (ID_visitor)
);
CREATE TABLE EXHIBIT
(
    ID_exhibit CHAR(32) NOT NULL,
	categiry CHAR(32),
    PRIMARY KEY (ID_exhibit)
);
CREATE TABLE TIME
(
    ID_time CHAR(32) NOT NULL,
	quarter CHAR(32),
    PRIMARY KEY (ID_time)
);
CREATE TABLE FACT_TABLE
(
    ID_fact_table CHAR(32) NOT NULL,
	exhibit_visit_counter integer,
	visitor_exhibit_counter integer,
	visit_time_duration integer,
	FK_visit_id CHAR(32),
	FK_visitor_id CHAR(32),
	FK_exhibit_id CHAR(32),
	FK_time_id CHAR(32),
	FOREIGN KEY (FK_visit_id) REFERENCES VISIT(ID_visit),
	FOREIGN KEY (FK_visitor_id) REFERENCES VISITOR(ID_visitor),
	FOREIGN KEY (FK_exhibit_id) REFERENCES EXHIBIT(ID_exhibit),
	FOREIGN KEY (FK_time_id) REFERENCES TIME(ID_time),
    PRIMARY KEY (ID_fact_table)
);