Open-ILS/src/reporter/tables.example.xml

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <tables>
   3
   4         <table id="silly.fact" partition="true" fact-table="true">
   5                 <label>Silly Fact table</label>
   6                 <description>Silly Fact table</description>
   7                 <tablename>stats.silly_fact</tablename>
   8
   9                 <partition>
  10                         <field>said_when</field>
  11                         <!-- Valid options:  years, months, weeks, days, hours, minutes, seconds  -->
  12                         <chunk>months</chunk>
  13                         <start>2005-09-01</start>
  14                         <end>2005-12-31</end>
  15                 </partition>
  16
  17                 <fields>
  18                         <field
  19                           name="id"
  20                           primary="true"
  21                           create-type="serial"
  22                           datatype="int">
  23                                 <label>Silly entry id</label>
  24                                 <description>Silly entry id</description>
  25                         </field>
  26                         <field
  27                           name="silly_word_dim"
  28                           datatype="int"
  29                           indexed="true">
  30                                 <label>Silly word dim</label>
  31                                 <description>Silly word entry dimension link</description>
  32                         </field>
  33                         <field
  34                           name="silly_sayer_dim"
  35                           datatype="int"
  36                           indexed="true">
  37                                 <label>Silly sayer dim</label>
  38                                 <description>Silly sayer entry dimension link</description>
  39                         </field>
  40                         <field
  41                           name="said_when"
  42                           datatype="timestamptz"
  43                           core="true"
  44                           indexed="true"
  45                           default="now()">
  46                                 <label>Silly word timestamp</label>
  47                                 <description>Silly word entry timestamp</description>
  48                         </field>
  49                 </fields>
  50                 <links>
  51                         <link
  52                           field="silly_word_dim"
  53                           table="silly.word_dim"
  54                           key="id"
  55                           type="has_a"/>
  56                         <link
  57                           field="silly_sayer_dim"
  58                           table="silly.sayer_dim"
  59                           key="id"
  60                           type="has_a"/>
  61                 </links>
  62         </table>
  63
  64         <table id="silly.word_dim">
  65                 <label>Silly word list</label>
  66                 <description>Silly word list</description>
  67                 <tablename>stats.words</tablename>
  68                 <fields>
  69                         <field
  70                           name="id"
  71                           primary="true"
  72                           create-type="serial"
  73                           datatype="int">
  74                                 <label>Silly word id</label>
  75                         </field>
  76                         <field
  77                           name="word"
  78                           datatype="text"
  79                           indexed="true"
  80                           index-type="BTREE">
  81                                 <label>Silly word</label>
  82                         </field>
  83                 </fields>
  84         </table>
  85
  86         <table id="silly.sayer_dim">
  87                 <label>Silly word sayer list</label>
  88                 <description>Silly word sayer list</description>
  89                 <tablename>stats.silly_sayers</tablename>
  90                 <fields>
  91                         <field
  92                           name="id"
  93                           primary="true"
  94                           create-type="serial"
  95                           datatype="int">
  96                                 <label>Silly person id</label>
  97                         </field>
  98                         <field
  99                           name="sayer"
 100                           widget-family="string-choose"
 101                           datatype="text"
 102                           indexed="true"
 103                           index-type="BTREE">
 104                                 <label>Silly person</label>
 105                         </field>
 106                 </fields>
 107         </table>
 108
 109 </tables>
 110