mira.db — identities

CREATE TABLE identities  (
  id                TEXT PRIMARY KEY,
  user_id           TEXT NOT NULL REFERENCES users(id),
  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())
)