SQLite Web: mira.db

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())

Cancel