1. races → ON CONFLICT(venue_code, race_date, race_number) DO UPDATE 2. entries → race_idルックアップ後 DELETE + INSERT 3. results → race_idルックアップ後 DELETE + INSERT(UNIQUE: race_id, pit_number) 4.
SQL Query Tool for Vs30 for seismic analysis in Japan (derived from J-SHIS) This research tool is intended for the reading and querying the SQLite database with a processed subset of the J-SHIS ...