Advertisement

Schema Browser

I am using SQLite3 for my primary database. SQLite has extremely simple schema that consists of one table called "sqlite_master". This program lets you see the schema of select databases on my server.

I will also open source the code for the site which you can browse with the Code Viewer

Available Databases

IDDB NamePlatformFile
1mainsqlitemain.db
Holds global information for the site including User Database and Web_Site Description
2logsqlitelog.db
Holds large logging database for the site
3dirsqlitedir.db
Contains files to create a link directory.
4calsqlitecal.db
Contains Information for the web site calendar.
5mstocksqlitemstock.db
Contains Meta Information about Mirostock used on the site.
6codesqlitecode.db
Program used to display the code used on this open source web site.
7commsqlitecomm.db
Database provides a model for analyzing a community
8msgsqlitemsg.db
Database contains messages from and to users

Connecting +comm

Tables in comm
Table NameRowsDDL
Country244
CREATE TABLE Country (
      iso_id INTEGER PRIMARY KEY,
  country_nm TEXT)
County3226
CREATE TABLE County (
    state_cd char(2),
        fips INTEGER,
   county_nm TEXT,
 PRIMARY KEY (state_cd,county_nm));

State_Data70
CREATE TABLE State_Data (
    state_cd char(2),
    state_nm TEXT,
     fips_id INTEGER,
  PRIMARY KEY (state_cd));

Stock_Action0
CREATE TABLE Stock_Action (
   action_id INTEGER PRIMARY KEY,
      ticker TEXT,
     type_id INTEGER,
   action_dt INTEGER,
   report_dt INTEGER,
      shares INTEGER,
  high_price REAL,
   low_price REAL,
market_value INTEGER,
 trans_value INTEGER,
   locations INTEGER,
   employees INTEGER,
       notes TEXT)
Stock_Exchange19
CREATE TABLE Stock_Exchange (
 exchange_id INTEGER PRIMARY KEY,
    short_nm TEXT,
 exchange_nm TEXT,
    local_nm TEXT)
Stock_Link220
CREATE TABLE Stock_Link (
         uid INTEGER PRIMARY KEY,
      ticker TEXT,
      weight INTEGER,
     link_id INTEGER,
       pg_id INTEGER,
     user_id INTEGER,
      add_dt TEXT,
      exp_dt TEXT,
     link_nm TEXT,
    link_url TEXT,
   follow_yn char(1) NOT NULL DEFAULT 'Y');
CREATE INDEX Stock_Link_Ticker_IX
    ON Stock_Link (ticker)
Stock_Site195
CREATE TABLE Stock_Site (
     site_id INTEGER,
      ticker TEXT,
  short_desc TEXT,
  PRIMARY KEY (site_id,ticker));

Stock_Ticker224
CREATE TABLE Stock_Ticker (
      ticker TEXT,
        isin TEXT,
 exchange_id TEXT,
  country_id INT,
  company_nm TEXT,
     city_nm TEXT,
    state_cd char(2),
        hits INT,
  short_desc TEXT,
    wiki_lnk TEXT,
 merged_into TEXT,
  PRIMARY KEY (ticker));

Zipcode32038
CREATE TABLE Zipcode (
      geo_id INTEGER PRIMARY KEY,
    state_cd char(2) NOT NULL,
    latitude REAL,
   longitude REAL,
     town_nm TEXT)