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 | ||||
|---|---|---|---|---|
| ID | DB Name | Platform | File | |
| 1 | main | sqlite | main.db | |
| Holds global information for the site including User Database and Web_Site Description | ||||
| 2 | log | sqlite | log.db | |
| Holds large logging database for the site | ||||
| 3 | dir | sqlite | dir.db | |
| Contains files to create a link directory. | ||||
| 4 | cal | sqlite | cal.db | |
| Contains Information for the web site calendar. | ||||
| 5 | mstock | sqlite | mstock.db | |
| Contains Meta Information about Mirostock used on the site. | ||||
| 6 | code | sqlite | code.db | |
| Program used to display the code used on this open source web site. | ||||
| 7 | comm | sqlite | comm.db | |
| Database provides a model for analyzing a community | ||||
| 8 | msg | sqlite | msg.db | |
| Database contains messages from and to users | ||||
Connecting +comm
| Tables in comm | ||
|---|---|---|
| Table Name | Rows | DDL |
| Country | 244 | CREATE TABLE Country (
iso_id INTEGER PRIMARY KEY,
country_nm TEXT)
|
| County | 3226 | CREATE TABLE County (
state_cd char(2),
fips INTEGER,
county_nm TEXT,
PRIMARY KEY (state_cd,county_nm));
|
| State_Data | 70 | CREATE TABLE State_Data (
state_cd char(2),
state_nm TEXT,
fips_id INTEGER,
PRIMARY KEY (state_cd));
|
| Stock_Action | 0 | 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_Exchange | 25 | CREATE TABLE Stock_Exchange (
exchange_id INTEGER PRIMARY KEY,
show_cd INT,
short_nm TEXT,
exchange_nm TEXT,
local_nm TEXT)
|
| Stock_Exchange_Old | 19 | CREATE TABLE "Stock_Exchange_Old" (
exchange_id INTEGER PRIMARY KEY,
short_nm TEXT,
exchange_nm TEXT,
local_nm TEXT)
|
| Stock_Link | 229 | CREATE TABLE Stock_Link (
uid INTEGER PRIMARY KEY,
ticker TEXT,
weight INT,
link_id INT,
pg_id INT,
user_id INT,
add_dt TEXT,
exp_dt TEXT,
link_nm TEXT,
link_url TEXT,
follow_yn char(1) NOT NULL DEFAULT 'Y',
ssl_cd char(1) DEFAULT '');
CREATE INDEX Stock_Link_Ticker_IX
ON Stock_Link (ticker)
|
| Stock_Site | 198 | CREATE TABLE Stock_Site (
site_id INTEGER,
ticker TEXT,
short_desc TEXT,
PRIMARY KEY (site_id,ticker));
|
| Stock_Ticker | 230 | 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));
|
| Zipcode | 32038 | CREATE TABLE Zipcode (
geo_id INTEGER PRIMARY KEY,
state_cd char(2) NOT NULL,
latitude REAL,
longitude REAL,
town_nm TEXT)
|