pdl.sqlite•32.8 kB
SQLite format 3 @ .r�
� � �� � B
? � � %%�[tableactivity_logactivity_logCREATE TABLE activity_log (
id INTEGER PRIMARY KEY AUTOINCREMENT,
project_name TEXT,
timestamp TEXT,
actor TEXT,
action TEXT,
details TEXT,
phase_number INTEGER,
sprint_id TEXT,
FOREIGN KEY (project_name) REFERENCES projects (project_name)
)�Q�ytablesprintssprintsCREATE TABLE sprints (
sprint_id TEXT PRIMARY KEY,
sprint_name TEXT,
project_name TEXT,
phase_number INTEGER,
start_date TEXT,
end_date TEXT,
status TEXT,
tasks TEXT,
velocity INTEGER,
burn_down TEXT,
retrospective TEXT,
FOREIGN KEY (project_name) REFERENCES projects (project_name)
)-A indexsqlite_autoindex_sprints_1sprintsP++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)�.�7tablephasesphasesCREATE TABLE phases (
id INTEGER PRIMARY KEY AUTOINCREMENT,
project_name TEXT,
phase_number INTEGER,
phase_name TEXT,
status TEXT,
start_date TEXT,
end_date TEXT,
primary_driver TEXT,
completion_percentage INTEGER DEFAULT 0,
key_activities TEXT,
deliverables TEXT,
blockers TEXT,
notes TEXT,
FOREIGN KEY (project_name) REFERENCES projects (project_name)
)� �QtableprojectsprojectsCREATE TABLE projects (
project_name TEXT PRIMARY KEY,
description TEXT,
created_at TEXT,
updated_at TEXT,
team_composition TEXT,
roadmap TEXT
)/C indexsqlite_autoindex_projects_1projects