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 +dir

Tables in dir
Table NameRowsDDL
Cat_Key478
CREATE TABLE Cat_Key (
          id INTEGER,
  claimed_yn char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (id))
Fandango16
CREATE TABLE Fandango (
 fandango_id INTEGER PRIMARY KEY,
     site_id INTEGER,
     hit_cnt INTEGER,
  theater_cd TEXT,
  theater_nm TEXT,
     address TEXT,
        city TEXT,
       state TEXT,
         zip TEXT)
Go_Link209
CREATE TABLE Go_Link (
    short_nm TEXT,
     hit_cnt INTEGER NOT NULL DEFAULT '0',
   domain_nm TEXT,
     path_nm TEXT,
     link_nm TEXT,
      add_ts REAL,
  PRIMARY KEY (short_nm));

KS_Review134
CREATE TABLE KS_Review (
       ks_id INT,
   review_id INT,
 PRIMARY KEY (ks_id, review_id));

Keyword_Scope7
CREATE TABLE Keyword_Scope (
    scope_id INTEGER PRIMARY KEY,
   target_id INT,
    scope_nm TEXT)
Kickstarter135
CREATE TABLE Kickstarter (
       ks_id INTEGER PRIMARY KEY,
      end_dt INT,
 project_dir TEXT,
  creator_nm TEXT,
     city_nm TEXT,
    state_cd TEXT);
CREATE INDEX Kickstarter_State_IX
    ON Kickstarter (state_cd)
Link30940
CREATE TABLE Link (
     link_id INTEGER PRIMARY KEY,
 category_id INT,
     page_id INT,
     hit_cnt INT,
     user_id INT,
 merchant_id INT,
      weight INT,
      exp_dt INT,
   status_fl char(1),
    track_yn char(1) DEFAULT 'D',
      add_ts REAL,
     link_nm TEXT,
      ssl_cd char(1) default '',
     host_nm TEXT,
     path_nm TEXT,
    query_nm TEXT,
  short_desc TEXT,
  display_nm TEXT, title_extra TEXT);
CREATE INDEX Link_Cat_IX
    ON Link (category_id);
CREATE INDEX Link_Page_IX
    ON Link (page_id)
Link_Cat_FWD34
CREATE TABLE Link_Cat_FWD (
      old_nm TEXT,
      new_nm TEXT,
  PRIMARY KEY (old_nm)
);

Link_Category4616
CREATE TABLE Link_Category (
 category_id INTEGER PRIMARY KEY,
   parent_id INTEGER,
     site_id INTEGER,
      catpos INTEGER,
     blob_id INTEGER,
     side_id INTEGER,
   target_id INTEGER,
   bottom_id INTEGER,
 redirect_id INTEGER,
  sitemap_yn char(1),
     file_nm TEXT,
 category_nm TEXT,
  short_desc TEXT,
    keywords TEXT,
     hit_cnt INTEGER,
   update_ts REAL,
   event_cnt INTEGER DEFAULT 0);
CREATE INDEX Category_Parent_IX
    ON Link_Category (parent_id);
CREATE INDEX Category_Name_IX
    ON Link_Category(category_nm)
Link_Category_Old4497
CREATE TABLE "Link_Category_Old" (
 category_id INTEGER PRIMARY KEY,
   parent_id INTEGER,
     site_id INTEGER,
      catpos INTEGER,
     blob_id INTEGER,
     side_id INTEGER,
       ad_id INTEGER,
   bottom_id INTEGER,
 redirect_id INTEGER,
  sitemap_yn char(1),
     file_nm TEXT,
 category_nm TEXT,
  short_desc TEXT,
    keywords TEXT,
     hit_cnt INTEGER,
   update_ts REAL,
   event_cnt INTEGER DEFAULT 0);
CREATE INDEX CategoryParent_IX
    ON "Link_Category_Old" (parent_id)
Link_Check54
CREATE TABLE Link_Check (
     site_id INTEGER PRIMARY KEY,
      ok_cnt INT DEFAULT 0,
   fixed_cnt INT DEFAULT 0,
     del_cnt INT DEFAULT 0,
    link_cnt INT DEFAULT 0,
 deleted_cnt INT DEFAULT 0,
          ts REAL DEFAULT 0,
  oldest_exp INT DEFAULT 0)
Link_Delete15912
CREATE TABLE Link_Delete (
  deleter_id int,
   delete_ts REAL,
     link_id INT,
 category_id INT,
     page_id INT,
     hit_cnt INT,
     user_id INT,
 merchant_id INT,
      weight INT,
      exp_dt INT,
   status_fl char(1),
    track_yn char(1) DEFAULT 'D',
      add_ts REAL,
     link_nm TEXT,
      ssl_cd char(1) default '',
     host_nm TEXT,
     path_nm TEXT,
    query_nm TEXT,
  short_desc TEXT,
  display_nm TEXT, title_extra TEXT);
CREATE INDEX Link_Delete_Cat_IX
    ON Link_Delete (category_id)
Link_Keyword70751
CREATE TABLE Link_Keyword (
     link_id INTEGER,
     site_id INTEGER,
     keyword TEXT,
 PRIMARY KEY (link_id, keyword)
);
;
CREATE INDEX Keyword_IX 
    ON Link_Keyword (keyword)
Link_Not_Found440
CREATE TABLE Link_Not_Found (
     link_id INTEGER,
       ip_id INTEGER,
          ts REAL,
     site_id INTEGER,
   status_cd INTEGER default 0,
   refer_txt TEXT)
Link_Search55204
CREATE TABLE Link_Search (
     site_id INT,
        term TEXT,
     last_ts REAL,
         cnt INT,
  PRIMARY KEY (site_id,term)
);

Review_Books3
CREATE TABLE Review_Books (
       rowid INTEGER PRIMARY KEY,
   review_id INT,
        isbn INT,
      pub_yr INT,
       pages INT,
      add_ts REAL,
     type_cd TEXT,
    title_nm TEXT,
   author_nm TEXT,
    press_nm TEXT,
  short_desc TEXT);
CREATE INDEX Review_Books_IX
    ON Review_Books (review_id)
SRO7932
CREATE TABLE SRO(
  link_id INT,
  review_id INT,
  site_id INT,
  status_cd INT,
  review_dt INT,
  hit_cnt INT,
  prev_btn TEXT,
  next_btn TEXT,
  add_ts REAL
)
Site_Review4887
CREATE TABLE Site_Review (
     review_id INTEGER PRIMARY KEY,
      owner_id INT,
       hit_cnt INT,
     target_id INT,
         ad_id INT,
     status_cd INT DEFAULT 1,
      width_no INT,
      bg_color INT,
    text_color INT,
    link_color INT,
     review_nm TEXT,
     domain_nm TEXT,
       path_nm TEXT,
     site_desc TEXT,
canonical_site INT,
     update_ts REAL)
Site_Review_Link7733
CREATE TABLE Site_Review_Link (
     link_id INT,
   review_id INT,
     site_id INT,
   status_cd INT,
   review_dt INT,
     hit_cnt INT,
    prev_btn TEXT,
    next_btn TEXT, add_ts REAL,
 PRIMARY KEY (site_id, review_dt));
;
CREATE INDEX SRL_Link_IX
    ON Site_Review_Link (link_id);
CREATE INDEX SRL_Review_IX
    ON Site_Review_Link (review_id)
sqlite_stat122
CREATE TABLE sqlite_stat1(tbl,idx,stat)