sqlite-web 0.7.2
crm.db
tasks
Create
Query
_migrations
audiovisual_checklist
audiovisual_comment_files
audiovisual_comments
audiovisual_events
audiovisual_patrocinios
clients
communication_comment...
communication_comments
communications
departments
disenos
document_comments
document_types
documents
employees
expense_files
expenses
finance_committee_budgets
finance_contributions
finance_expense_files
finance_expenses
finance_monthly_reports
finance_solicitud_files
finance_solicitudes
logistics
logistics_flights
logistics_status
logistics_types
package_checklist
package_checklist_items
packages
patrocinio_checklist
patrocinio_comments
patrocinio_doc_urls
patrocinio_documents
patrocinios
profile_modules
redes
solicitud_comment_files
solicitud_comments
sponsor_statuses
sponsorship_payments
sqlite_sequence
task_comments
tasks
user_profiles
users
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into tasks
title
TEXT NOT NULL
description
TEXT
status
TEXT NOT NULL (default 'pending')
priority
TEXT NOT NULL (default 'medium')
due_date
TEXT
client_id
INTEGER
assigned_to
INTEGER
created_by
INTEGER
created_at
TEXT NOT NULL (default datetime('now','localtime'))
updated_at
TEXT NOT NULL (default datetime('now','localtime'))
patrocinio_id
INTEGER
Insert
Cancel