B6-1

Tables (4)

expense (Untitled3)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • trip_id (Field) — INTEGER
  • paid_by_traveler_id (Field2) — INTEGER
  • category (Field3) — VARCHAR(30)
  • amount (Field4) — NUMERIC(10, 2)
  • description (Field5) — VARCHAR(200)
  • expense_date (Field6) — DATE
  • created_at (Field7) — DATE
  • Field8

expense_split (Untitled4)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • traveler_id (Field) — INTEGER
  • expense_id (Field2) — INTEGER
  • share_amount (Field3) — NUMERIC(10, 2)
  • is_settled (Field4) — BOOLEAN
  • Field5

traveler (Untitled)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • name (Field) — VARCHAR(50)
  • email (Field2) — VARCHAR(100)
  • phone (Field3) — VARCHAR(20)
  • created_at (Field4) — DATE
  • Field5

trip (Untitled2)

  • id (Key) — SERIAL — Primary key — NOT NULL
  • title (Field) — VARCHAR(100)
  • organizer_id (Field2) — INTEGER
  • start_date (Field3) — DATE
  • end_date (Field4) — DATE
  • created_at (Field5) — DATE
  • Field6