Difference between revisions of "Database Tables"

From ARK
Jump to: navigation, search
 
Line 7: Line 7:
 
*'''cor_lut_datetype''' - stores the date types
 
*'''cor_lut_datetype''' - stores the date types
 
*'''cor_lut_file''' - stores the actual files
 
*'''cor_lut_file''' - stores the actual files
 +
*'''cor_lut_filetype''' - stores the file types
 
*'''cor_lut_grptype''' - stores the group types
 
*'''cor_lut_grptype''' - stores the group types
 
*'''cor_lut_language''' - stores the languages
 
*'''cor_lut_language''' - stores the languages
Line 37: Line 38:
 
*'''cor_tbl_wwwpages''' - stores the pages which must appear in the ARK view
 
*'''cor_tbl_wwwpages''' - stores the pages which must appear in the ARK view
 
*'''cor_tbl_xmi''' - stores the links between instances of modules
 
*'''cor_tbl_xmi''' - stores the links between instances of modules
 +
*'''cor_tbl_wmc''' - stores the instances of maps created
 
*'''cxt_tbl_cxttype''' - stores the context types
 
*'''cxt_tbl_cxttype''' - stores the context types
 
*'''cxt_tbl_cxt''' - stores the instances of contexts
 
*'''cxt_tbl_cxt''' - stores the instances of contexts

Latest revision as of 18:09, 24 February 2011

  • abk_lut_abktype - stores the address book types (at the moment only one: people)
  • abk_tbl_abk - stores the istances of the address book – the names are stores as texts in cor_tbl_txt
  • cor_lut_actiontype - stores action types
  • cor_lut_aliastype - stores alias types (at the moment only two: normal and against)
  • cor_lut_attribute - stores the attributes for each attribute type
  • cor_lut_attributetype - stores the attribute types
  • cor_lut_datetype - stores the date types
  • cor_lut_file - stores the actual files
  • cor_lut_filetype - stores the file types
  • cor_lut_grptype - stores the group types
  • cor_lut_language - stores the languages
  • cor_lut_place - stores the places
  • cor_lut_placetype - stores the place types
  • cor_lut_numbertype - stores the number types
  • cor_lut_spanlabel - stores the span labels for each span type
  • cor_lut_spantype - stores the span types
  • cor_lut_txttype - stores the text types
  • cor_lvu tables - stuff for the liveuser functionality
  • cor_tbl_action - stores the instances of action
  • cor_tbl_alias - stores the instances of aliases
  • cor_tbl_attribute - stores the instances of attributes
  • cor_tbl_cmap tables - stuff for importing functionality
  • cor_tbl_col - stores the columns
  • cor_tbl_date - stores the instances of dates
  • cor_tbl_file - stores the instances of files
  • cor_tbl_filters - stores the filters
  • cor_tbl_grp - stores the instances of group
  • cor_tbl_log - contains the log
  • cor_tbl_markup - stores the instances of markup
  • cor_tbl_module - stores the different modules in the ARK
  • cor_tbl_number - stores the instances of numbers
  • cor_tbl_sgrp - stores the security groups
  • cor_tbl_span - stores the instances of spans
  • cor_tbl_spanattr - stores the instances of span attributes
  • cor_tbl_ste - stores the sitecodes for the ARK
  • cor_tbl_txt - stores instances of text
  • cor_tbl_users - stores all the users
  • cor_tbl_wwwpages - stores the pages which must appear in the ARK view
  • cor_tbl_xmi - stores the links between instances of modules
  • cor_tbl_wmc - stores the instances of maps created
  • cxt_tbl_cxttype - stores the context types
  • cxt_tbl_cxt - stores the instances of contexts
  • pln_tbl_pln - stores the instances of plans
  • smp_tbl_smp - stores the instances of samples
  • spf_tbl_spf - stores the instances of special finds
  • sph_tbl_sph - stores the instances of site photos