OnB

Tables (7)

Budget (Untitled3)

  • id — string — Primary key — NOT NULL
  • trip_id — number — Foreign key → Trip.id — NOT NULL
  • currency_id — Foreign key → currency.id — NOT NULL
  • type — string
  • amount — number
  • title — string
  • ex_rate_avg — float

Expenses (Untitled4)

  • id — string — Primary key — NOT NULL
  • budget_id — Foreign key → Budget.id — NOT NULL
  • trip_id — number — Foreign key → Budget.trip_id — NOT NULL
  • Key (Key3) — Foreign key → Budget.currency_id — NOT NULL
  • amount — number
  • used_at — date
  • category — string

Income (CopyOfUntitled4)

  • id — string — Primary key — NOT NULL
  • budget_id — Foreign key → Budget.id — NOT NULL
  • trip_id — number — Foreign key → Budget.trip_id — NOT NULL
  • Key (Key3) — Foreign key → Budget.currency_id — NOT NULL
  • amount — number
  • used_at — date
  • category — string

Trip (Untitled2)

  • id — number — Primary key — NOT NULL
  • uid — Foreign key → User.id — NOT NULL
  • country_id — Foreign key → country.id — NOT NULL
  • title — string
  • started_at — date
  • ended_at — date

User (Untitled)

  • id — Primary key — NOT NULL
  • email — string
  • name — string

country (Untitled5)

  • id — string — Primary key — NOT NULL
  • name — string
  • name_en — string
  • flag_img — string
  • continent — string

currency (Untitled6)

  • id — string — Primary key — NOT NULL
  • name — string
  • amount_unit — int