---

CREATE DATABASE IF NOT EXISTS museum;
USE museum;

create table visitor (
id int primary key auto_increment,
name int not null,
surname int not null);

create table category (
id int primary key auto_increment,
name int );

create table device(
id int primary key auto_increment,
name int not null,
category int not null,
price int,
status int,
foreign key device(category) references category(id) );

create table session(
id int primary key auto_increment,
id_visitor int,
id_device int,
data_vid datetime,
data_voz datetime,
oplata int
);


create table payments (
id int primary key auto_increment,
session_id int,
paystatus int);