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