sqlite-web 0.7.0
stockbot.db
companies
Create
Query
app_state
companies
daily_close
holdings
price_history
users
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into companies
guild_id
Primary key.
INTEGER NOT NULL
symbol
Primary key.
TEXT NOT NULL
name
TEXT NOT NULL
base_price
REAL NOT NULL
slope
REAL NOT NULL
drift
REAL NOT NULL
player_impact
REAL NOT NULL (default 0.5)
starting_tick
INTEGER NOT NULL
current_price
REAL NOT NULL (default 0)
last_tick
INTEGER NOT NULL (default 0)
updated_at
TEXT NOT NULL
Insert
Cancel