adding widget support and moving tables to an external file
[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">
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