<?xml version="1.0" encoding="utf-8"?>
<Schema Namespace="Data.Store" Alias="Self" Provider="Npgsql" ProviderManifestToken="8.2.13" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns="http://schemas.microsoft.com/ado/2009/02/edm/ssdl">
  <EntityContainer Name="DataStoreContainer">
    <EntitySet Name="Barcode" EntityType="Data.Store.Barcode" store:Type="Tables" Schema="public" />
    <EntitySet Name="Eventi" EntityType="Data.Store.Eventi" store:Type="Tables" Schema="public" />
    <EntitySet Name="Fotografie" EntityType="Data.Store.Fotografie" store:Type="Tables" Schema="public" />
    <EntitySet Name="Layout" EntityType="Data.Store.Layout" store:Type="Tables" Schema="public" />
    <EntitySet Name="Rooms" EntityType="Data.Store.Rooms" store:Type="Tables" Schema="public" />
    <EntitySet Name="Spooler" EntityType="Data.Store.Spooler" store:Type="Tables" Schema="public" />
    <EntitySet Name="Statistiche" EntityType="Data.Store.Statistiche" store:Type="Tables" Schema="public" />
    <EntitySet Name="Story" EntityType="Data.Store.Story" store:Type="Tables" Schema="public" />
	<EntitySet Name="FotografieChanged" EntityType="Data.Store.FotografieChanged" store:Type="Tables" Schema="public" />
  </EntityContainer>
  <EntityType Name="Barcode">
    <Key>
      <PropertyRef Name="ID" />
    </Key>
    <Property Name="BARCODE" Type="varchar" MaxLength="256" />
    <Property Name="OPERATORE" Type="varchar" MaxLength="50" />
    <Property Name="DATA" Type="timestamp" />
    <Property Name="RULLINO" Type="int4" />
    <Property Name="CONTATORE" Type="int4" />
    <Property Name="ID" Type="int4" Nullable="false" StoreGeneratedPattern="Identity" />
  </EntityType>
  <EntityType Name="Eventi">
    <Key>
      <PropertyRef Name="ID" />
    </Key>
    <Property Name="ID" Type="int4" Nullable="false" StoreGeneratedPattern="Identity" />
    <Property Name="EVENTO" Type="varchar" MaxLength="64" />
  </EntityType>
  <EntityType Name="Fotografie">
    <Key>
      <PropertyRef Name="ID" />
    </Key>
    <Property Name="ID" Type="int4" Nullable="false" StoreGeneratedPattern="Identity" />
    <Property Name="OPERATORE" Type="varchar" MaxLength="50" />
    <Property Name="DATA" Type="timestamp" />
    <Property Name="RULLINO" Type="int4" />
    <Property Name="CONTATORE" Type="int4" />
    <Property Name="NOME_FILE" Type="varchar" MaxLength="255" />
    <Property Name="POSIZIONE" Type="int4" />
    <Property Name="FG_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="BG_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="ICON_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="ASPECT_RATIO" Type="float4" />
    <Property Name="IMAGEX" Type="int4" />
    <Property Name="IMAGEY" Type="int4" />
    <Property Name="CROPLEFT" Type="int4" />
    <Property Name="CROPTOP" Type="int4" />
    <Property Name="CROPRIGHT" Type="int4" />
    <Property Name="CROPBOTTOM" Type="int4" />
    <Property Name="ZOOM" Type="int2" />
    <Property Name="ROTATION" Type="int2" />
    <Property Name="RED" Type="int2" />
    <Property Name="GREEN" Type="int2" />
    <Property Name="BLUE" Type="int2" />
    <Property Name="CONTRAST" Type="int2" />
    <Property Name="BRIGHTNESS" Type="int2" />
    <Property Name="SATURATION" Type="int2" />
    <Property Name="ICONX" Type="int4" />
    <Property Name="ICONY" Type="int4" />
    <Property Name="ICONZOOM" Type="int2" />
    <Property Name="ICONROTATION" Type="int2" />
    <Property Name="TEXT" Type="varchar" MaxLength="255" />
    <Property Name="TEXTX" Type="int4" />
    <Property Name="TEXTY" Type="int4" />
    <Property Name="TEXTZOOM" Type="int2" />
    <Property Name="TEXTROTATION" Type="int4" />
    <Property Name="TEXTALIGN" Type="int2" />
    <Property Name="TEXTCOLOR" Type="int4" />
    <Property Name="FONTSTYLE" Type="int2" />
    <Property Name="FONTNAME" Type="varchar" MaxLength="255" />
    <Property Name="EVENTO" Type="varchar" MaxLength="1024" />
    <Property Name="PAGE" Type="varchar" MaxLength="8000" />
  </EntityType>
  <EntityType Name="Layout">
    <Key>
      <PropertyRef Name="ID" />
    </Key>
    <Property Name="ID" Type="int4" Nullable="false" StoreGeneratedPattern="Identity" />
    <Property Name="FG_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="BG_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="ICON_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="ASPECT_RATIO" Type="float4" />
    <Property Name="IMAGEX" Type="int4" />
    <Property Name="IMAGEY" Type="int4" />
    <Property Name="CROPLEFT" Type="int4" />
    <Property Name="CROPTOP" Type="int4" />
    <Property Name="CROPRIGHT" Type="int4" />
    <Property Name="CROPBOTTOM" Type="int4" />
    <Property Name="ZOOM" Type="int2" />
    <Property Name="ROTATION" Type="int2" />
    <Property Name="RED" Type="int2" />
    <Property Name="GREEN" Type="int2" />
    <Property Name="BLUE" Type="int2" />
    <Property Name="CONTRAST" Type="int2" />
    <Property Name="BRIGHTNESS" Type="int2" />
    <Property Name="SATURATION" Type="int2" />
    <Property Name="ICONX" Type="int4" />
    <Property Name="ICONY" Type="int4" />
    <Property Name="ICONZOOM" Type="int2" />
    <Property Name="ICONROTATION" Type="int2" />
    <Property Name="TEXT" Type="varchar" MaxLength="255" />
    <Property Name="TEXTX" Type="int4" />
    <Property Name="TEXTY" Type="int4" />
    <Property Name="TEXTZOOM" Type="int2" />
    <Property Name="TEXTROTATION" Type="int4" />
    <Property Name="TEXTALIGN" Type="int2" />
    <Property Name="TEXTCOLOR" Type="int4" />
    <Property Name="FONTSTYLE" Type="int2" />
    <Property Name="FONTNAME" Type="varchar" MaxLength="255" />
    <Property Name="PAGE" Type="varchar" MaxLength="8000" />
    <Property Name="NAME" Type="varchar" MaxLength="255" />
    <Property Name="GRUPPO" Type="varchar" MaxLength="256" />
    <Property Name="CATEGORIA" Type="varchar" MaxLength="256" />
  </EntityType>
  <EntityType Name="Rooms">
    <Key>
      <PropertyRef Name="ID" />
    </Key>
    <Property Name="ID" Type="int4" Nullable="false" StoreGeneratedPattern="Identity" />
    <Property Name="NAME" Type="varchar" MaxLength="255" />
    <Property Name="START_DATE" Type="timestamp" />
    <Property Name="END_DATE" Type="timestamp" />
    <Property Name="PWD" Type="varchar" MaxLength="50" />
  </EntityType>
  <EntityType Name="Spooler">
    <Key>
      <PropertyRef Name="ID" />
    </Key>
    <Property Name="ID" Type="int4" Nullable="false" StoreGeneratedPattern="Identity" />
    <Property Name="STATO" Type="int4" />
    <Property Name="CONTATORE" Type="int4" />
    <Property Name="OPERATORE" Type="varchar" MaxLength="50" />
    <Property Name="RULLINO" Type="int4" />
    <Property Name="DATA" Type="timestamp" />
    <Property Name="PRIORITA" Type="int4" />
    <Property Name="PRINT_LAYOUT" Type="int4" />
    <Property Name="MIRROR" Type="bool" Nullable="false" />
    <Property Name="FORMATO_CARTA" Type="int4" />
    <Property Name="NUMERO_COPIE" Type="int4" />
    <Property Name="NOME_FILE" Type="varchar" MaxLength="255" />
    <Property Name="FG_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="BG_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="ICON_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="ASPECT_RATIO" Type="float4" />
    <Property Name="IMAGEX" Type="int4" />
    <Property Name="IMAGEY" Type="int4" />
    <Property Name="CROPLEFT" Type="int4" />
    <Property Name="CROPTOP" Type="int4" />
    <Property Name="CROPRIGHT" Type="int4" />
    <Property Name="CROPBOTTOM" Type="int4" />
    <Property Name="ZOOM" Type="int2" />
    <Property Name="ROTATION" Type="int2" />
    <Property Name="RED" Type="int2" />
    <Property Name="GREEN" Type="int2" />
    <Property Name="BLUE" Type="int2" />
    <Property Name="CONTRAST" Type="int2" />
    <Property Name="BRIGHTNESS" Type="int2" />
    <Property Name="SATURATION" Type="int2" />
    <Property Name="ICONX" Type="int4" />
    <Property Name="ICONY" Type="int4" />
    <Property Name="ICONZOOM" Type="int2" />
    <Property Name="ICONROTATION" Type="int2" />
    <Property Name="TEXT" Type="varchar" MaxLength="254" />
    <Property Name="TEXTX" Type="int4" />
    <Property Name="TEXTY" Type="int4" />
    <Property Name="TEXTZOOM" Type="int2" />
    <Property Name="TEXTROTATION" Type="int4" />
    <Property Name="TEXTALIGN" Type="int2" />
    <Property Name="TEXTCOLOR" Type="int4" />
    <Property Name="FONTSTYLE" Type="int2" />
    <Property Name="FONTNAME" Type="varchar" MaxLength="255" />
    <Property Name="SPOOLERID" Type="int4" />
    <Property Name="PAGE" Type="varchar" MaxLength="8000" />
    <Property Name="PRODOTTO" Type="varchar" MaxLength="256" />
    <Property Name="EVENTO" Type="varchar" MaxLength="1024" />
  </EntityType>
  <EntityType Name="Statistiche">
    <Key>
      <PropertyRef Name="ID" />
    </Key>
    <Property Name="ID" Type="int4" Nullable="false" StoreGeneratedPattern="Identity" />
    <Property Name="EXTRA_DATA" Type="timestamp" />
    <Property Name="STATO" Type="int4" />
    <Property Name="CONTATORE" Type="int4" />
    <Property Name="OPERATORE" Type="varchar" MaxLength="50" />
    <Property Name="RULLINO" Type="int4" />
    <Property Name="DATA" Type="timestamp" />
    <Property Name="PRIORITA" Type="int4" />
    <Property Name="PRINT_LAYOUT" Type="int4" />
    <Property Name="MIRROR" Type="bool" Nullable="false" />
    <Property Name="FORMATO_CARTA" Type="int4" />
    <Property Name="NUMERO_COPIE" Type="int4" />
    <Property Name="NOME_FILE" Type="varchar" MaxLength="255" />
    <Property Name="FG_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="BG_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="ICON_IMAGE_NAME" Type="varchar" MaxLength="255" />
    <Property Name="ASPECT_RATIO" Type="float4" />
    <Property Name="IMAGEX" Type="int4" />
    <Property Name="IMAGEY" Type="int4" />
    <Property Name="CROPLEFT" Type="int4" />
    <Property Name="CROPTOP" Type="int4" />
    <Property Name="CROPRIGHT" Type="int4" />
    <Property Name="CROPBOTTOM" Type="int4" />
    <Property Name="ZOOM" Type="int2" />
    <Property Name="ROTATION" Type="int2" />
    <Property Name="RED" Type="int2" />
    <Property Name="GREEN" Type="int2" />
    <Property Name="BLUE" Type="int2" />
    <Property Name="CONTRAST" Type="int2" />
    <Property Name="BRIGHTNESS" Type="int2" />
    <Property Name="SATURATION" Type="int2" />
    <Property Name="ICONX" Type="int4" />
    <Property Name="ICONY" Type="int4" />
    <Property Name="ICONZOOM" Type="int2" />
    <Property Name="ICONROTATION" Type="int2" />
    <Property Name="TEXT" Type="varchar" MaxLength="254" />
    <Property Name="TEXTX" Type="int4" />
    <Property Name="TEXTY" Type="int4" />
    <Property Name="TEXTZOOM" Type="int2" />
    <Property Name="TEXTROTATION" Type="int4" />
    <Property Name="TEXTALIGN" Type="int2" />
    <Property Name="TEXTCOLOR" Type="int4" />
    <Property Name="FONTSTYLE" Type="int2" />
    <Property Name="FONTNAME" Type="varchar" MaxLength="255" />
    <Property Name="SPOOLERID" Type="int4" />
    <Property Name="PAGE" Type="varchar" MaxLength="8000" />
    <Property Name="EVENTO" Type="varchar" MaxLength="1024" />
    <Property Name="PRODOTTO" Type="varchar" MaxLength="256" />
  </EntityType>
  <EntityType Name="Story">
    <Key>
      <PropertyRef Name="ID" />
    </Key>
    <Property Name="ID" Type="int4" Nullable="false" StoreGeneratedPattern="Identity" />
    <Property Name="OPERATORE" Type="varchar" MaxLength="50" />
    <Property Name="DATA" Type="timestamp" />
    <Property Name="IMPORTATE" Type="int4" />
    <Property Name="STAMPATE" Type="int4" />
    <Property Name="FORMATO_CARTA" Type="int4" />
    <Property Name="PRODOTTO" Type="varchar" MaxLength="256" />
  </EntityType>
   <EntityType Name="FotografieChanged">
    <Key>
    <PropertyRef Name="ID" />
    </Key>
    <Property Name="ID" Type="int4" Nullable="false" />
    <Property Name="TIMESTAMP" Type="timestamp" Nullable="false" />
  </EntityType>
</Schema>