removing stage1 reporter xml config
[working/Evergreen.git] / 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>Base table for creating reports on silly words</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