Create
Query
pilot.db
—
invoices
account_invites
accounts
applied_migrations
audit_log
availability
availability_exceptions
bookings
cards
invoices
magic_tokens
sessions
sqlite_sequence
students
trainer_settings
trainers
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into invoices
trainer_id
INTEGER NOT NULL
student_id
INTEGER NOT NULL
invoice_no
TEXT NOT NULL
category
TEXT NOT NULL
lines
TEXT NOT NULL
total_cents
INTEGER NOT NULL
status
TEXT NOT NULL (default 'open')
issued_at
TEXT NOT NULL (default datetime('now'))
paid_at
TEXT
archived_at
TIMESTAMP
Insert
Cancel