DROP TABLE raumbuch;

CREATE TABLE raumbuch
(
  id serial NOT NULL,
  haus character varying(255),
  ebene character varying(255),
  raum_id character varying(255),
  bemerkung character varying(255),
  raumbezeichung character varying(255),
  raumgruppe character varying(255),
  belag character varying(255),
  veraenderung character varying(255),
  geaendert_am character varying(255),
  groesse_in_m2 character varying(255),
  raumleistung character varying(255),
  reinigungsturnus character varying(255),
  turnus_wert character varying(255),
  zeit_pro_reinigung_min character varying(255),
  zeit_pro_monat_min character varying(255),
  zeit_pro_jahr_stunden character varying(255),
  revier character varying(255),
  revier_samstags character varying(255),
  revier_sonntags character varying(255),
  montag character varying(255),
  dienstag character varying(255),
  mittwoch character varying(255),
  donnerstag character varying(255),
  freitag character varying(255),
  samstag character varying(255),
  sonntag character varying(255),
  CONSTRAINT eintrag PRIMARY KEY (id)
)
