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