 	CONSTRAINT pk_payments PRIMARY KEY ( id )
  );
 
-CREATE INDEX idx_payments ON payments ( id_order );
-
-CREATE TABLE photos ( 
-	id                   serial  NOT NULL,
-	id_facility          integer  NOT NULL,
-	filepath             varchar(200)  NOT NULL,
-	CONSTRAINT pk_galery PRIMARY KEY ( id )
- );
-
-CREATE INDEX idx_galery ON photos ( id_facility );
-
-CREATE TABLE reservations ( 
+CREATE INDEX idx_payments ON payment ( id_order );
+
+CREATE TABLE reservation ( 
 	id                   serial  NOT NULL,
 	id_room              integer  NOT NULL,
 	id_guest             integer  NOT NULL,

	CONSTRAINT pk_notifications PRIMARY KEY ( id )
 );

CREATE INDEX idx_notifications ON notifications ( id_department );

CREATE INDEX idx_notifications_0 ON notifications ( id_type );

CREATE TABLE orders ( 
	id                   serial  NOT NULL,
	id_guest             integer  NOT NULL,
	received_date        date  ,
	id_order_categories  integer  NOT NULL,
	id_notification      integer  NOT NULL,
	CONSTRAINT pk_orders PRIMARY KEY ( id )
 );

CREATE INDEX idx_orders ON orders ( id_order_categories );

CREATE INDEX idx_orders_0 ON orders ( id_guest );

CREATE INDEX idx_orders_1 ON orders ( id_notification );

CREATE TABLE payments ( 
	id                   serial  NOT NULL,
	id_order             integer  NOT NULL,
	amount               numeric(8,2)  NOT NULL,

	CONSTRAINT pk_sections PRIMARY KEY ( id )
 );

CREATE INDEX idx_sections ON department ( leader );

CREATE TABLE employee ( 
	id                   serial  NOT NULL,
	name                 varchar(200)  NOT NULL,
	address              varchar(300)  NOT NULL,
