Create
Query
mira.db
—
identities
access_codes
balances
event_attachments
events
identities
profiles
room_boardings
rooms
sessions
settings
transactions
users
Toggle helper tables
Structure
Content
Query
Insert
Drop
Import
Export
Insert row into identities
id
Primary key.
TEXT
user_id
TEXT NOT NULL
travel_type
TEXT NOT NULL
document_type
TEXT NOT NULL
document_number
TEXT NOT NULL
travel_reason
TEXT NOT NULL
document_front
TEXT
document_back
TEXT
selfie
TEXT
check_in_date
TEXT NOT NULL
check_in_time
TEXT NOT NULL
check_out_date
TEXT NOT NULL
check_out_time
TEXT NOT NULL
first_name
TEXT NOT NULL
surname
TEXT NOT NULL
date_of_birth
TEXT NOT NULL
place_of_birth
TEXT NOT NULL
father_name
TEXT NOT NULL
mother_name
TEXT NOT NULL
occupation
TEXT NOT NULL
home_address
TEXT NOT NULL
children_under_15
INTEGER NOT NULL (default 0)
emergency_name
TEXT
emergency_phone
TEXT
phone_country
TEXT NOT NULL
phone_number
TEXT NOT NULL
email
TEXT
signature
TEXT
status
TEXT NOT NULL (default 'draft')
created_at
INTEGER NOT NULL (default unixepoch())
updated_at
INTEGER NOT NULL (default unixepoch())
Insert
Cancel