MyWEST - Database Schema

In this page you find the schema (Figure 1) of the database supported by MyWEST application where extracted data are stored.

Figure 1. Suitable database schema

In MyWEST package we provide, for basic users, empty MS-Access and MySQL database to use with the application.
The following description of the schema is for general purpose, because every Data Base Management System has its own optimized commands for creating the schema of the database.

• Table structure for table 'column_names'
  
  TABLE column_names (
  ID_DATA int(11) NOT NULL default '0',
  NAME varchar(100) character set latin1 NOT NULL default '',
  PRIMARY KEY (ID_DATA),
  KEY NAME (NAME)
  )
  
  
  
• Table structure for table 'data'
  
  TABLE data (
  ID_DATA int(11) NOT NULL default '0',
  IDROW_DATA int(11) NOT NULL default '0',
  DATA longtext character set latin1 NOT NULL,
  PRIMARY KEY (ID_DATA),
  KEY IDROW_DATA (IDROW_DATA)
  )
  
  
  
• Table structure for table 'links'
  
  TABLE links (
  IDROW_LINK int(11) NOT NULL default '0',
  LINK varchar(255) character set latin1 NOT NULL default '',
  URL varchar(255) character set latin1 NOT NULL default '',
  KEY LINK (LINK),
  KEY IDROW_LINK (IDROW_LINK)
  )
  
  
  
• Table structure for table 'main'
  
  TABLE main (
  DATE_START datetime NOT NULL default '0000-00-00 00:00:00',
  DATE_END datetime NOT NULL default '0000-00-00 00:00:00',
  TEMPLATE varchar(50) character set latin1 NOT NULL default '',
  LAST_MOD_STRUCTURE datetime NOT NULL default '0000-00-00 00:00:00',
  TABLES varchar(50) character set latin1 NOT NULL default '',
  DATABASES varchar(50) character set latin1 NOT NULL default '',
  CODE varchar(50) character set latin1 NOT NULL default '',
  CODE_TYPE varchar(50) character set latin1 NOT NULL default '',
  IDROW_DATA_LINK int(11) NOT NULL default '0',
  UNIQUE KEY IDROW_DATA_LINK (IDROW_DATA_LINK),
  KEY CODE (CODE),
  KEY TABLES (TABLES)
  )