home / japari_dc_bot

attacks

74 rows where member_id = 508472239264628738

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: battle_day, lap, boss_number, is_residual, attack_datetime (date)

attack_id ▼ member_id attack_datetime battle_day lap boss_number is_residual damage notes related_full_attack_id
41 508472239264628738 508472239264628738 2025-06-26T02:04:01.301311+00:00 1 9 3 0      
42 508472239264628738 508472239264628738 2025-06-26T02:04:01.301311+00:00 1 10 3 1   自動產生,關聯至完整刀 ID:41 41
43 508472239264628738 508472239264628738 2025-06-26T02:12:50.172712+00:00 1 9 2 0      
44 508472239264628738 508472239264628738 2025-06-26T02:12:50.172712+00:00 1 10 2 1   自動產生,關聯至完整刀 ID:43 43
45 508472239264628738 508472239264628738 2025-06-26T02:15:33.278007+00:00 1 11 5 0      
46 508472239264628738 508472239264628738 2025-06-26T02:15:33.278007+00:00 1 12 5 1   自動產生,關聯至完整刀 ID:45 45
135 508472239264628738 508472239264628738 2025-06-27T12:39:19.674177+00:00 2 25 2 0 200722058    
139 508472239264628738 508472239264628738 2025-06-27T12:46:04.309362+00:00 2 26 3 0 176493407    
144 508472239264628738 508472239264628738 2025-06-27T13:27:58.429198+00:00 2 25 1 0 179896275    
201 508472239264628738 508472239264628738 2025-06-28T00:30:05.111827+00:00 3 29 5 0 205686092    
205 508472239264628738 508472239264628738 2025-06-28T02:19:40.962783+00:00 3 28 3 0 174828665    
211 508472239264628738 508472239264628738 2025-06-28T05:22:04.204449+00:00 3 29 2 0 23616850    
212 508472239264628738 508472239264628738 2025-06-28T05:26:34.143057+00:00 3 30 2 1 212367615    
297 508472239264628738 508472239264628738 2025-06-29T03:59:48.913373+00:00 4 33 3 0 175711249    
298 508472239264628738 508472239264628738 2025-06-29T04:06:24.068349+00:00 4 34 5 0 203726507    
299 508472239264628738 508472239264628738 2025-06-29T04:20:01.336722+00:00 4 34 5 1 26595131    
428 508472239264628738 508472239264628738 2025-06-30T12:54:43.303336+00:00 5 37 1 0 161276422    
435 508472239264628738 508472239264628738 2025-06-30T13:16:28.911949+00:00 5 41 4 0 188573608    
436 508472239264628738 508472239264628738 2025-06-30T13:27:21.395094+00:00 5 41 2 0 198690078    
618 508472239264628738 508472239264628738 2025-07-27T13:11:28.285956+00:00 1 22 5 0 85000000    
619 508472239264628738 508472239264628738 2025-07-27T13:11:28.285956+00:00 1 23 5 1   自動產生,關聯至完整刀 ID:618 618
620 508472239264628738 508472239264628738 2025-07-27T13:17:33.835021+00:00 1 23 2 0 351095966    
621 508472239264628738 508472239264628738 2025-07-27T13:24:26.149678+00:00 1 23 5 0 278083501    
673 508472239264628738 508472239264628738 2025-07-28T04:36:10.849033+00:00 2 24 5 0 276741836    
677 508472239264628738 508472239264628738 2025-07-28T04:52:53.548703+00:00 2 25 3 0 274252321    
680 508472239264628738 508472239264628738 2025-07-28T06:07:12.128669+00:00 2 25 2 0 356292916    
777 508472239264628738 508472239264628738 2025-07-28T21:08:55.402503+00:00 3 29 3 0 274228983    
784 508472239264628738 508472239264628738 2025-07-29T04:11:03.710168+00:00 3 29 5 0 269326233    
790 508472239264628738 508472239264628738 2025-07-29T04:30:37.655894+00:00 3 30 3 1 50567116    
795 508472239264628738 508472239264628738 2025-07-29T05:05:59.010387+00:00 3 29 2 0 351874783    
885 508472239264628738 508472239264628738 2025-07-29T21:52:56.882078+00:00 4 33 3 0 273572839    
887 508472239264628738 508472239264628738 2025-07-29T21:57:23.178174+00:00 4 34 5 0 275307842    
893 508472239264628738 508472239264628738 2025-07-29T22:39:14.651366+00:00 4 34 2 0 355726868    
995 508472239264628738 508472239264628738 2025-07-30T21:16:25.281659+00:00 5 38 5 0 279078204    
999 508472239264628738 508472239264628738 2025-07-30T21:28:53.974127+00:00 5 38 3 0 262018726    
1000 508472239264628738 508472239264628738 2025-07-30T21:40:40.112405+00:00 5 38 2 0 357187954    
1246 508472239264628738 508472239264628738 2025-08-27T13:10:03.885519+00:00 1 23 1 0 277129300    
1247 508472239264628738 508472239264628738 2025-08-27T13:15:37.679985+00:00 1 23 4 0 381719894    
1250 508472239264628738 508472239264628738 2025-08-27T13:22:11.500999+00:00 1 23 5 0 261584067    
1287 508472239264628738 508472239264628738 2025-08-27T21:59:01.744494+00:00 2 25 4 0 381734454    
1288 508472239264628738 508472239264628738 2025-08-27T22:07:28.291513+00:00 2 24 1 0 298497291    
1289 508472239264628738 508472239264628738 2025-08-27T22:25:08.240028+00:00 2 25 3 1 45087733    
1303 508472239264628738 508472239264628738 2025-08-28T05:05:47.543560+00:00 2 25 5 0 263864982    
1398 508472239264628738 508472239264628738 2025-08-28T21:12:23.918055+00:00 3 29 4 0 380877092    
1400 508472239264628738 508472239264628738 2025-08-28T21:26:28.688286+00:00 3 29 1 0 329378359    
1403 508472239264628738 508472239264628738 2025-08-28T21:53:11.614354+00:00 3 29 5 0 268443935    
1404 508472239264628738 508472239264628738 2025-08-28T21:59:07.343228+00:00 3 29 5 1 30139520    
1512 508472239264628738 508472239264628738 2025-08-30T01:20:48.109002+00:00 4 33 1 0 330699856    
1514 508472239264628738 508472239264628738 2025-08-30T01:21:23.190548+00:00 4 33 1 0 122410    
1522 508472239264628738 508472239264628738 2025-08-30T02:55:08.746914+00:00 4 34 5 1 263978950    
1524 508472239264628738 508472239264628738 2025-08-30T03:01:20.008432+00:00 4 33 4 0 88194233    
1526 508472239264628738 508472239264628738 2025-08-30T03:06:00.570997+00:00 4 34 4 0 382175472    
1631 508472239264628738 508472239264628738 2025-08-30T21:11:18.579972+00:00 5 38 5 0 266661224    
1658 508472239264628738 508472239264628738 2025-08-31T06:09:58.385321+00:00 5 38 1 0 331404554    
1662 508472239264628738 508472239264628738 2025-08-31T06:13:31.429619+00:00 5 39 5 1 29805633    
1663 508472239264628738 508472239264628738 2025-08-31T06:14:27.552338+00:00 5 39 4 0 374416946    
1866 508472239264628738 508472239264628738 2025-09-26T14:17:40.782749+00:00 1 23 1 0 309170258    
1867 508472239264628738 508472239264628738 2025-09-26T14:22:34.746334+00:00 1 23 2 0 319199396    
1869 508472239264628738 508472239264628738 2025-09-26T14:30:37.820521+00:00 1 23 3 0 381594501    
1904 508472239264628738 508472239264628738 2025-09-26T21:21:10.603829+00:00 2 25 2 0 319018652    
1905 508472239264628738 508472239264628738 2025-09-26T21:36:43.505604+00:00 2 24 3 0 24941213    
1906 508472239264628738 508472239264628738 2025-09-26T21:45:50.907630+00:00 2 25 3 1 402084518    
1958 508472239264628738 508472239264628738 2025-09-27T12:03:20.077654+00:00 2 26 5 0 297228241    
2015 508472239264628738 508472239264628738 2025-09-27T21:35:11.324644+00:00 3 29 4 0 281193384    
2016 508472239264628738 508472239264628738 2025-09-27T21:44:15.324279+00:00 3 29 5 0 297118004    
2021 508472239264628738 508472239264628738 2025-09-27T22:05:22.633677+00:00 3 29 3 0 75273698    
2022 508472239264628738 508472239264628738 2025-09-27T22:14:04.961593+00:00 3 30 3 1 402370633    
2024 508472239264628738 508472239264628738 2025-09-27T22:26:10.831794+00:00 3 29 2 1 28948518    
2142 508472239264628738 508472239264628738 2025-09-29T04:30:38.616524+00:00 4 35 3 0 394247612    
2144 508472239264628738 508472239264628738 2025-09-29T04:35:04.128622+00:00 4 35 2 0 319538348    
2145 508472239264628738 508472239264628738 2025-09-29T04:39:08.274461+00:00 4 35 1 0 312304275    
2247 508472239264628738 508472239264628738 2025-09-29T22:29:38.647455+00:00 5 39 2 0 314632408    
2248 508472239264628738 508472239264628738 2025-09-29T22:37:48.475769+00:00 5 39 5 0 297441551    
2249 508472239264628738 508472239264628738 2025-09-29T22:45:50.195501+00:00 5 39 3 0 383963326    

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE attacks (
            attack_id INTEGER PRIMARY KEY AUTOINCREMENT,
            member_id INTEGER NOT NULL,
            attack_datetime TEXT NOT NULL, -- ISO8601 format UTC
            battle_day INTEGER NOT NULL, -- 1-5 for day 1 to 5 of guild battle
            lap INTEGER NOT NULL,
            boss_number INTEGER NOT NULL, -- 1-5
            is_residual BOOLEAN DEFAULT 0, -- 0 for False, 1 for True
            damage INTEGER, -- 新增傷害欄位,允許 NULL
            notes TEXT, related_full_attack_id INTEGER,
            FOREIGN KEY (member_id) REFERENCES members(member_id)
        );
Powered by Datasette · Queries took 32.542ms