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

   1 <?xml version="1.0" encoding="UTF-8"?>
   2 <tables>
   3
   4         <table id="wide-copy" partition="false" fact-table="true">
   5                 <label>Wide Copy info</label>
   6                 <description>Base table for creating snapshot reports on copy information</description>
   7                 <tablename>stats.fleshed_copy</tablename>
   8
   9                 <fields>
  10                         <field
  11                           name="id"
  12                           primary="true"
  13                           create-type="serial"
  14                           datatype="int">
  15                                 <label>ID</label>
  16                                 <description>Copy ID</description>
  17                         </field>
  18                         <field
  19                           name="barcode"
  20                           datatype="text">
  21                                 <label>Barcode</label>
  22                                 <description>Copy Barcode</description>
  23                         </field>
  24                         <field
  25                           name="owning_lib"
  26                           datatype="int"
  27                           indexed="true">
  28                                 <label>Owner</label>
  29                                 <description>ID of the Owning Library</description>
  30                         </field>
  31                         <field
  32                           name="circ_lib"
  33                           datatype="int"
  34                           indexed="true">
  35                                 <label>Circulator</label>
  36                                 <description>ID of the Circulating Library</description>
  37                         </field>
  38                         <field
  39                           name="create_date"
  40                           datatype="timestamptz"
  41                           indexed="true"
  42                           default="now()">
  43                                 <label>Create Date</label>
  44                                 <description>Timestamp of the copy's cataloging</description>
  45                         </field>
  46                         <field
  47                           name="item_lang"
  48                           datatype="text">
  49                                 <label>Language</label>
  50                                 <description>MARC Item Language</description>
  51                         </field>
  52                         <field
  53                           name="item_form"
  54                           datatype="text">
  55                                 <label>Form</label>
  56                                 <description>MARC Item Form of Material</description>
  57                         </field>
  58                         <field
  59                           name="item_type"
  60                           datatype="text">
  61                                 <label>Type</label>
  62                                 <description>MARC Item Type</description>
  63                         </field>
  64                         <field
  65                           name="call_number_label"
  66                           datatype="text">
  67                                 <label>Call Number</label>
  68                                 <description>Copy Call Number Label</description>
  69                         </field>
  70                 </fields>
  71
  72                 <links>
  73                         <link
  74                           field="owning_lib"
  75                           table="org_unit"
  76                           id="copy_owning_lib"
  77                           key="id"
  78                           type="has_a"/>
  79                         <link
  80                           field="item_lang"
  81                           table="marc_lang_map"
  82                           id="copy_language"
  83                           key="code"
  84                           type="has_a"/>
  85                         <link
  86                           field="circ_lib"
  87                           table="org_unit"
  88                           id="copy_circ_lib"
  89                           key="id"
  90                           type="has_a"/>
  91                 </links>
  92
  93         </table>
  94
  95         <table id="org_unit" partition="false" fact-table="false">
  96                 <label>Organizational Units</label>
  97                 <description>Table containing library hierarchy definition</description>
  98                 <tablename>actor.org_unit</tablename>
  99
 100                 <fields>
 101                         <field
 102                           name="id"
 103                           primary="true"
 104                           create-type="serial"
 105                           datatype="int">
 106                                 <label>ID</label>
 107                                 <description>Library ID</description>
 108                         </field>
 109                         <field
 110                           name="name"
 111                           datatype="text">
 112                                 <label>Name</label>
 113                                 <description>Library Name</description>
 114                         </field>
 115                         <field
 116                           name="shortname"
 117                           datatype="text">
 118                                 <label>Short Name</label>
 119                                 <description>Library Short (Policy) Name</description>
 120                         </field>
 121                 </fields>
 122         </table>
 123
 124         <table id="marc_lang_map" partition="false" fact-table="false">
 125                 <label>MARC Language Codes</label>
 126                 <description>Table mapping MARC three character codes to language names</description>
 127                 <tablename>config.language_map</tablename>
 128
 129                 <fields>
 130                         <field
 131                           name="code"
 132                           primary='true'
 133                           datatype="text">
 134                                 <label>Code</label>
 135                                 <description>MARC Language Code</description>
 136                         </field>
 137                         <field
 138                           name="value"
 139                           datatype="text">
 140                                 <label>Language Name</label>
 141                                 <description>Name associated with the MARC code</description>
 142                         </field>
 143                 </fields>
 144         </table>
 145
 146         <table id="silly.fact" partition="true" fact-table="false">
 147                 <label>Silly Fact table</label>
 148                 <description>Base table for creating reports on silly words</description>
 149                 <tablename>stats.silly_fact</tablename>
 150
 151                 <partition>
 152                         <field>said_when</field>
 153                         <!-- Valid options:  years, months, weeks, days, hours, minutes, seconds  -->
 154                         <chunk>months</chunk>
 155                         <start>2005-09-01</start>
 156                         <end>2005-12-31</end>
 157                 </partition>
 158
 159                 <fields>
 160                         <field
 161                           name="id"
 162                           primary="true"
 163                           create-type="serial"
 164                           datatype="int">
 165                                 <label>Silly entry id</label>
 166                                 <description>Silly entry id</description>
 167                         </field>
 168                         <field
 169                           name="silly_word_dim"
 170                           datatype="int"
 171                           indexed="true">
 172                                 <label>Silly word dim</label>
 173                                 <description>Silly word entry dimension link</description>
 174                         </field>
 175                         <field
 176                           name="silly_sayer_dim"
 177                           datatype="int"
 178                           indexed="true">
 179                                 <label>Silly sayer dim</label>
 180                                 <description>Silly sayer entry dimension link</description>
 181                         </field>
 182                         <field
 183                           name="said_when"
 184                           datatype="timestamptz"
 185                           core="true"
 186                           indexed="true"
 187                           default="now()">
 188                                 <label>Silly word timestamp</label>
 189                                 <description>Silly word entry timestamp</description>
 190                         </field>
 191                 </fields>
 192                 <links>
 193                         <link
 194                           field="silly_word_dim"
 195                           table="silly.word_dim"
 196                           key="id"
 197                           type="has_a"/>
 198                         <link
 199                           field="silly_sayer_dim"
 200                           table="silly.sayer_dim"
 201                           key="id"
 202                           type="has_a"/>
 203                 </links>
 204         </table>
 205
 206         <table id="silly.word_dim">
 207                 <label>Silly word list</label>
 208                 <description>Silly word list</description>
 209                 <tablename>stats.words</tablename>
 210                 <fields>
 211                         <field
 212                           name="id"
 213                           primary="true"
 214                           create-type="serial"
 215                           datatype="int">
 216                                 <label>Silly word id</label>
 217                         </field>
 218                         <field
 219                           name="word"
 220                           datatype="text"
 221                           indexed="true"
 222                           index-type="BTREE">
 223                                 <label>Silly word</label>
 224                         </field>
 225                 </fields>
 226         </table>
 227
 228         <table id="silly.sayer_dim">
 229                 <label>Silly word sayer list</label>
 230                 <description>Silly word sayer list</description>
 231                 <tablename>stats.silly_sayers</tablename>
 232                 <fields>
 233                         <field
 234                           name="id"
 235                           primary="true"
 236                           create-type="serial"
 237                           datatype="int">
 238                                 <label>Silly person id</label>
 239                         </field>
 240                         <field
 241                           name="sayer"
 242                           widget-family="string-choose"
 243                           datatype="text"
 244                           indexed="true"
 245                           index-type="BTREE">
 246                                 <label>Silly person</label>
 247                         </field>
 248                 </fields>
 249         </table>
 250
 251 </tables>
 252