roadline

Tables (7)

Copy Of Copy Of Untitled2 (Photo)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (day_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (img) — String
  • Field (dateTime) — TIMESTAMP

Copy Of Untitled (Plan)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (day_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — String
  • Field2 (pos) — Int
  • Field (lat) — Double
  • Field (lng) — Double
  • Field2 (name_alter) — String?
  • Field (time) — Long?
  • Field2 (memo) — String?

Copy Of Untitled2 (Money)

  • Key (id) — Long — Primary key — NOT NULL
  • Key (day_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Key (currency_id) — Long — Foreign key → Untitled.Key — NOT NULL
  • Field (img) — String
  • Field (price) — Double
  • Field (category) — String
  • Field (dateTime) — TIMESTAMP
  • Field (memo) — String?

Travel

  • id — Long — Primary key — NOT NULL
  • Field (title) — String
  • Field (date_start) — TIMESTAMP
  • Field (date_end) — TIMESTAMP
  • Field (img) — String?

Untitled (Day)

  • Key (id) — Long — Primary key — NOT NULL
  • id (travel_id) — Long — Foreign key → Travel.id — NOT NULL
  • Field (date) — TIMESTAMP

Untitled (Currency)

  • Key (id) — Long — Primary key — NOT NULL
  • Field (name) — String
  • Field (rate) — Double
  • Field (symbol) — String

Untitled (TravelCurrencyJoin)

  • id (travel_id) — Long — Foreign key → Travel.id — NOT NULL
  • Key (currency_id) — Long — Foreign key → Untitled.Key — NOT NULL