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_Key460
CREATE TABLE Cat_Key (
          id INTEGER,
  claimed_yn char(1) NOT NULL DEFAULT 'N',
  PRIMARY KEY (id))
Check_Cat3004
CREATE TABLE Check_Cat (
      cat_id INT,
     user_id INT,
          ts REAL)
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_Review271
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)
Kickstarter273
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)
Link33288
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_FWD35
CREATE TABLE Link_Cat_FWD (
      old_nm TEXT,
      new_nm TEXT,
  PRIMARY KEY (old_nm)
);

Link_Category4959
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_Delete20464
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_Keyword60842
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_Found10214
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_Review5838
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, picture_url TEXT)
Site_Review_Link7778
CREATE TABLE "Site_Review_Link" (
     link_id INT,
   review_id INT,
     site_id INT,
   status_cd INT default 1,
   review_dt INT,
     hit_cnt INT default 0,
    prev_btn TEXT,
    next_btn TEXT, 
      add_ts REAL default (julianday('now')) ,
 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_stat123
CREATE TABLE sqlite_stat1(tbl,idx,stat)