doc/predictops.model

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <!--
   3 CAUTION: Do not modify this file unless you know what you are doing.
   4          Unexpected results may occur if the code is changed deliberately.
   5 -->
   6 <dbmodel pgmodeler-ver="0.9.2" last-position="0,89" last-zoom="1" max-obj-count="4"
   7          default-schema="public" default-owner="postgres">
   8 <database name="extome" is-template="false" allow-conns="true">
   9 </database>
  10
  11 <schema name="public" layer="0" fill-color="#e1e1e1" sql-disabled="true">
  12 </schema>
  13
  14 <table name="METEO_STATION" layer="0" collapse-mode="2" max-obj-count="6">
  15         <schema name="public"/>
  16         <role name="postgres"/>
  17         <position x="660" y="540"/>
  18         <column name="METST_ID" not-null="true"
  19          identity-type="BY DEFAULT">
  20                 <type name="smallint" length="0"/>
  21         </column>
  22         <column name="METST_NAME" not-null="true">
  23                 <type name="text" length="0"/>
  24         </column>
  25         <column name="METST_IDNAME" not-null="true">
  26                 <type name="text" length="0"/>
  27         </column>
  28         <column name="METST_LOCATION" not-null="true">
  29                 <type name="point" length="0"/>
  30         </column>
  31         <column name="METST_TIMEZONE" not-null="true">
  32                 <type name="smallint" length="0"/>
  33         </column>
  34         <constraint name="METEO_STATION_pk" type="pk-constr" table="public.&quot;METEO_STATION&quot;">
  35                 <columns names="METST_ID" ref-type="src-columns"/>
  36         </constraint>
  37 </table>
  38
  39 <table name="METEO_FEATURE" layer="0" collapse-mode="2" max-obj-count="3">
  40         <schema name="public"/>
  41         <role name="postgres"/>
  42         <position x="640" y="280"/>
  43         <column name="METFT_ID" not-null="true"
  44          identity-type="BY DEFAULT">
  45                 <type name="smallint" length="0"/>
  46         </column>
  47         <column name="METFT_NAME" not-null="true">
  48                 <type name="text" length="0"/>
  49         </column>
  50         <constraint name="METEO_FEATURE_pk" type="pk-constr" table="public.&quot;METEO_FEATURE&quot;">
  51                 <columns names="METFT_ID" ref-type="src-columns"/>
  52         </constraint>
  53 </table>
  54
  55 <table name="METEO_FEATURE_VALUE" layer="0" collapse-mode="2" max-obj-count="6">
  56         <schema name="public"/>
  57         <role name="postgres"/>
  58         <position x="140" y="480"/>
  59         <column name="METVA_ID" not-null="true"
  60          identity-type="ALWAYS">
  61                 <type name="bigint" length="0"/>
  62         </column>
  63         <column name="METVA_VALUE">
  64                 <type name="numeric" length="0"/>
  65         </column>
  66         <column name="METVA_DATETIME" not-null="true">
  67                 <type name="timestamptz" length="0"/>
  68         </column>
  69         <constraint name="METEO_FEATURE_VALUE_pk" type="pk-constr" table="public.&quot;METEO_FEATURE_VALUE&quot;">
  70                 <columns names="METVA_ID" ref-type="src-columns"/>
  71         </constraint>
  72 </table>
  73
  74 <table name="PARAMETER" layer="0" collapse-mode="2" max-obj-count="2">
  75         <schema name="public"/>
  76         <role name="postgres"/>
  77         <position x="1120" y="300"/>
  78         <column name="PARAM_ID" not-null="true"
  79          identity-type="ALWAYS">
  80                 <type name="smallint" length="0"/>
  81         </column>
  82         <column name="PARAM_NAME" not-null="true">
  83                 <type name="text" length="0"/>
  84         </column>
  85         <constraint name="PARAMETER_pk" type="pk-constr" table="public.&quot;PARAMETER&quot;">
  86                 <columns names="PARAM_ID" ref-type="src-columns"/>
  87         </constraint>
  88 </table>
  89
  90 <relationship name="METEO_FEATURE_has_many_METEO_FEATURE_VALUE" type="rel1n" layer="0"
  91          src-col-pattern="{sc}_{st}"
  92          pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
  93          src-fk-pattern="{st}_fk"
  94          custom-color="#4ffef3"
  95          src-table="public.&quot;METEO_FEATURE&quot;"
  96          dst-table="public.&quot;METEO_FEATURE_VALUE&quot;"
  97          src-required="false" dst-required="false">
  98         <label ref-type="name-label">
  99                 <position x="-9.94066" y="1.0862"/>
 100         </label>
 101 </relationship>
 102
 103 <relationship name="METEO_STATION_has_many_METEO_FEATURE_VALUE" type="rel1n" layer="0"
 104          src-col-pattern="{sc}_{st}"
 105          pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
 106          src-fk-pattern="{st}_fk"
 107          custom-color="#2f4da6"
 108          src-table="public.&quot;METEO_STATION&quot;"
 109          dst-table="public.&quot;METEO_FEATURE_VALUE&quot;"
 110          src-required="false" dst-required="false"/>
 111
 112 <relationship name="PARAMETER_has_many_METEO_FEATURE" type="rel1n" layer="0"
 113          src-col-pattern="{sc}_{st}"
 114          pk-pattern="{dt}_pk" uq-pattern="{dt}_uq"
 115          src-fk-pattern="{st}_fk"
 116          custom-color="#d02c85"
 117          src-table="public.&quot;PARAMETER&quot;"
 118          dst-table="public.&quot;METEO_FEATURE&quot;"
 119          src-required="false" dst-required="false"/>
 120
 121 </dbmodel>