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">
   5                 <name>Silly Fact table</name>
   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                 <name>Silly word list</name>
  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                         <field
  75                           name="word"
  76                           datatype="text"
  77                           indexed="true"
  78                           index-type="BTREE"/>
  79                 </fields>
  80         </table>
  81
  82         <table id="silly.sayer_dim">
  83                 <name>Silly word sayer list</name>
  84                 <description>Silly word sayer list</description>
  85                 <tablename>stats.silly_sayers</tablename>
  86                 <fields>
  87                         <field
  88                           name="id"
  89                           primary="true"
  90                           create-type="serial"
  91                           datatype="int"/>
  92                         <field
  93                           name="sayer"
  94                           widget-family="string-choose"
  95                           datatype="text"
  96                           indexed="true"
  97                           index-type="BTREE"/>
  98                 </fields>
  99         </table>
 100
 101 </tables>
 102