SQLite format 3@ .zq ^` w  u fsuItabletripstripsCREATE TABLE trips ( id INTEGER NOT NULL, name VARCHAR(200) NOT NULL, description TEXT, creator_name VARCHAR(100) NOT NULL, currency_code VARCHAR(3) NOT NULL, share_code VARCHAR(10) NOT NULL, is_active VARCHAR(10), created_at DATETIME DEFAULT (CURRENT_TIMESTAMP), updated_at DATETIME, password_hash VARCHAR(255), PRIMARY KEY (id) )) ++ tablealembic_versionalembic_versionCREATE TABLE alembic_version ( version_num VARCHAR(32) NOT NULL, CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num) )=Q+indexsqlite_autoindex_alembic_version_1alembic_versionf 5)}indexix_expense_splits_idexpense_splits CREATE INDEX ix_expense_splits_id ON expense_splits (id)9 ))-tableexpense_splitsexpense_splits CREATE TABLE expense_splits ( id INTEGER NOT NULL, expense_id INTEGER NOT NULL, participant_id INTEGER NOT NULL, percentage FLOAT NOT NULL, amount FLOAT NOT NULL, is_settled BOOLEAN, created_at DATETIME DEFAULT (CURRENT_TIMESTAMP), updated_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(expense_id) REFERENCES expenses (id), FOREIGN KEY(participant_id) REFERENCES participants (id) )N )eindexix_expenses_idexpenses CREATE INDEX ix_expenses_id ON expenses (id)8 Ctableexpensesexpenses CREATE TABLE expenses ( id INTEGER NOT NULL, trip_id INTEGER NOT NULL, description VARCHAR(255) NOT NULL, amount FLOAT NOT NULL, currency_code VARCHAR(3) NOT NULL, exchange_rate FLOAT NOT NULL, category VARCHAR(50), receipt_url TEXT, paid_by_id INTEGER NOT NULL, date_incurred DATETIME DEFAULT (CURRENT_TIMESTAMP) NOT NULL, created_at DATETIME DEFAULT (CURRENT_TIMESTAMP), updated_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(trip_id) REFERENCES trips (id), FOREIGN KEY(paid_by_id) REFERENCES participants (id) )^1%uindexix_participants_idparticipants CREATE INDEX ix_participants_id ON participants (id)'%%tableparticipantsparticipantsCREATE TABLE participants ( id INTEGER NOT NULL, trip_id INTEGER NOT NULL, name VARCHAR(100) NOT NULL, email VARCHAR(255), phone VARCHAR(20), is_creator BOOLEAN, is_active BOOLEAN, device_id VARCHAR(100), last_accessed DATETIME, created_at DATETIME DEFAULT (CURRENT_TIMESTAMP), updated_at DATETIME, PRIMARY KEY (id), FOREIGN KEY(trip_id) REFERENCES trips (id) )V-!mindexix_currencies_idcurrenciesCREATE INDEX ix_currencies_id ON currencies (id)d1!indexix_currencies_codecurrenciesCREATE UNIQUE INDEX ix_currencies_code ON currencies (code)!!tablecurrenciescurrenciesCREATE TABLE currencies ( id INTEGER NOT NULL, code VARCHAR(3) NOT NULL, name VARCHAR(100) NOT NULL, symbol VARCHAR(5) NOT NULL, is_active BOOLEAN, created_at DATETIME DEFAULT (CURRENT_TIMESTAMP), updated_at DATETIME, PRIMARY KEY (id) )b3indexix_trips_share_codetripsCREATE UNIQUE INDEX ix_trips_share_code ON trips (share_code)B#Yindexix_trips_idtripsCREATE INDEX ix_trips_id ON trips (id)\ d -M3Weekend in ParisA fun trip to Paris with friendsJohn DoeEURSCQYB1active2025-11-08 23:08:58    SCQYB1  CR$d5 s C.! 3OMROmani Rialر.ع.2025-11-08 23:08:421) 3BHDBahraini Dinarب.د2025-11-08 23:08:420 ' 3KWDKuwaiti Dinarد.ك2025-11-08 23:08:42- % 3QARQatari Riyal﷼2025-11-08 23:08:42, # 3SARSaudi Riyal﷼2025-11-08 23:08:42- ! 3AEDUAE Dirhamد.إ2025-11-08 23:08:42+ # 3CHFSwiss FrancFr2025-11-08 23:08:42/+ 3CADCanadian DollarC$2025-11-08 23:08:421/ 3AUDAustralian DollarA$2025-11-08 23:08:42-% 3INRIndian Rupee₹2025-11-08 23:08:42,% 3CNYChinese Yuan¥2025-11-08 23:08:42,% 3JPYJapanese Yen¥2025-11-08 23:08:42-' 3GBPBritish Pound£2025-11-08 23:08:42% 3EUREuro€2025-11-08 23:08:42( 3USDUS Dollar$2025-11-08 23:08:42 OMRBHDKWD QAR SAR AED CHF CADAUDINRCNYJPYGBPEUR USD       nng ! /A33Jane Smithdevice_test1234562025-11-08 23:09:08.8353032025-11-08 23:09:082025-11-08 23:09:08'  3John Doe2025-11-08 23:08:58      002  002