← back to SDCC Stories
db/stories.db
2763 lines
SQLite format 3 @ W W .��
�
����Q �h%%�tableschedule_logschedule_logCREATE TABLE schedule_log (
id INTEGER PRIMARY KEY AUTOINCREMENT,
story_id INTEGER,
platform TEXT,
status TEXT,
message TEXT,
created_at TEXT DEFAULT (datetime('now'))
)a�tablesettingssettingsCREATE TABLE settings (
key TEXT PRIMARY KEY,
value TEXT
)/C indexsqlite_autoindex_settings_1settings P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)��wtablestoriesstoriesCREATE TABLE stories (
id INTEGER PRIMARY KEY AUTOINCREMENT,
candidate_id INTEGER REFERENCES candidates(id),
story_one_liner TEXT,
instagram_caption TEXT,
x_post TEXT,
hashtags TEXT,
story_category TEXT,
image_path TEXT,
lawmaker_image_path TEXT,
status TEXT DEFAULT 'draft',
scheduled_at TEXT,
posted_at TEXT,
ig_media_id TEXT,
platform TEXT DEFAULT 'instagram',
lane TEXT DEFAULT 'action',
created_at TEXT DEFAULT (datetime('now'))
)�!!�gtablecandidatescandidatesCREATE TABLE candidates (
id INTEGER PRIMARY KEY,
first_name TEXT,
last_name TEXT,
email TEXT,
zip_code TEXT,
age TEXT,
amount_owed_raw TEXT,
amount_low INTEGER DEFAULT 0,
amount_high INTEGER DEFAULT 0,
amount_display TEXT,
income_type TEXT,
income_range TEXT,
income_amount_low INTEGER DEFAULT 0,
income_amount_high INTEGER DEFAULT 0,
emotional_impact TEXT,
affordability_impacts_raw TEXT,
affordability_count INTEGER DEFAULT 0,
alt_spending TEXT,
story TEXT,
key_quote TEXT,
sharing_consent TEXT,
press_ready TEXT,
is_voter TEXT,
employment TEXT,
education TEXT,
race_ethnicity TEXT,
gender TEXT,
marital_status TEXT,
household_size TEXT,
loan_types_raw TEXT,
repayment_plan TEXT,
monthly_payment TEXT,
first_loan_year TEXT,
story_type TEXT,
platform_fit TEXT,
story_strength INTEGER DEFAULT 0,
story_category TEXT,
press_pitch_angle TEXT,
candidate_score INTEGER DEFAULT 0,
tier TEXT DEFAULT 'D',
district_code TEXT,
representative_name TEXT,
representative_party TEXT,
data_json TEXT,
created_at TEXT DEFAULT (datetime('now')),
updated_at TEXT DEFAULT (datetime('now'))
) � ��������������������������~ytoje`[VQLGB=83.)$�������������������������zupkfa\WRMHC>94/*%
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
y
s
m
g
a
[
U
O
I
C
=
7
1
+
%
���������������������}wqke_YSMGA;5/)#����������������������{uoic]WQKE?93-'!
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
�
y
s
m
g
a
[
U
O
I
C
=
7
1
+
%
� � � � � � � � � � � � � � � � � � � � � } w q k e _ Y S M G A ; 5 / ) # ����������������������{uoic]WQKE?93-'! ���������������������ysmga[UOIC=71+%
���������������������}wqke_YSMGA;5/)#����������������������{uoic]WQKE?93-'! ���������������������ysmga[UOIC=71+%: I�d H�c G�a F�` E�_ D�^ C�] B�\ A�Z @�Y ?�X >�V =�U <�T ;�S :�R 9�Q 7�N 6�M 5�L 4�K 3�J 2�H 1�G 0�F /�D .�B -�A ,�@ +�? )�= (�<