stdout.db
Tables
awards
5
id
INTEGER NOT NULL PK
name
TEXT
awarded_by
TEXT NOT NULL
year
INTEGER NOT NULL
placement
TEXT NOT NULL
education_id
INTEGER NOT NULL FK
note
TEXT NOT NULL
certifications
5
id
INTEGER NOT NULL PK
name
TEXT
issuer
TEXT
year
INTEGER NOT NULL
area
TEXT
note
TEXT NOT NULL
educations
3
id
INTEGER NOT NULL PK
institution
TEXT
level
TEXT
city
TEXT NOT NULL
start_year
INTEGER NOT NULL
end_year
INTEGER NOT NULL
focus
TEXT NOT NULL
note
TEXT NOT NULL
employers
12
id
INTEGER NOT NULL PK
name
TEXT
industry
TEXT
city
TEXT NOT NULL
country
TEXT NOT NULL
about
TEXT NOT NULL
guestbook
1
id
INTEGER NOT NULL PK
name
TEXT
message
TEXT
signed_at
TEXT NOT NULL
links
5
id
INTEGER NOT NULL PK
kind
TEXT
label
TEXT
url
TEXT
note
TEXT NOT NULL
positions
12
id
INTEGER NOT NULL PK
employer_id
INTEGER FK
title
TEXT
field
TEXT
start_year
INTEGER
end_year
INTEGER NOT NULL
summary
TEXT NOT NULL
projects
5
id
INTEGER NOT NULL PK
name
TEXT
position_id
INTEGER NOT NULL FK
year
INTEGER NOT NULL
role
TEXT NOT NULL
stack
TEXT NOT NULL
description
TEXT NOT NULL
url
TEXT NOT NULL
quests
8
id
INTEGER NOT NULL PK
difficulty
INTEGER
question
TEXT
hint
TEXT
reward
TEXT NOT NULL
readme
10
id
INTEGER NOT NULL PK
topic
TEXT
body
TEXT
example
TEXT NOT NULL
skills
26
id
INTEGER NOT NULL PK
name
TEXT
category
TEXT
since_year
INTEGER NOT NULL
position_id
INTEGER NOT NULL FK
evidence
TEXT NOT NULL
tasting_notes
9
id
INTEGER NOT NULL PK
skill_id
INTEGER FK
subject
TEXT
pairs_with
TEXT
note
TEXT
timeline
23
id
INTEGER NOT NULL PK
year
INTEGER
event
TEXT
ref_table
TEXT NOT NULL
ref_id
INTEGER NOT NULL
users
1
id
INTEGER NOT NULL PK
name
TEXT
headline
TEXT NOT NULL
based_in
TEXT NOT NULL
summary
TEXT NOT NULL
hint
TEXT NOT NULL
Query
-- Write a query to the database to find all the info. SELECT * FROM users WHERE id = 1;
Run
Results
0 Rows · 0 Columns · 0 μs