home / japari_dc_bot

attacks

83 rows where member_id = 299222924320309249

✎ 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
71 299222924320309249 299222924320309249 2025-06-26T11:58:24.548960+00:00 1 19 1 0      
72 299222924320309249 299222924320309249 2025-06-26T11:58:24.548960+00:00 1 20 1 1   自動產生,關聯至完整刀 ID:71 71
73 299222924320309249 299222924320309249 2025-06-26T12:02:07.130851+00:00 1 19 2 0      
74 299222924320309249 299222924320309249 2025-06-26T12:02:07.130851+00:00 1 20 2 1   自動產生,關聯至完整刀 ID:73 73
75 299222924320309249 299222924320309249 2025-06-26T12:05:26.832485+00:00 1 19 5 0      
76 299222924320309249 299222924320309249 2025-06-26T12:05:26.832485+00:00 1 20 5 1   自動產生,關聯至完整刀 ID:75 75
128 299222924320309249 299222924320309249 2025-06-27T08:23:23.060614+00:00 2 24 1 0 112388930    
129 299222924320309249 299222924320309249 2025-06-27T08:25:25.974572+00:00 2 25 1 1 43567083    
130 299222924320309249 299222924320309249 2025-06-27T09:19:41.022850+00:00 2 25 4 0 218663405    
136 299222924320309249 299222924320309249 2025-06-27T12:39:36.738799+00:00 2 25 2 0 91101235    
137 299222924320309249 299222924320309249 2025-06-27T12:42:28.627565+00:00 2 26 2 1 111095960    
232 299222924320309249 299222924320309249 2025-06-28T10:05:53.723695+00:00 3 29 4 0 219730850    
236 299222924320309249 299222924320309249 2025-06-28T10:18:00.220851+00:00 3 30 1 0 145903841    
238 299222924320309249 299222924320309249 2025-06-28T10:22:45.386101+00:00 3 30 2 0 196626150    
308 299222924320309249 299222924320309249 2025-06-29T06:26:14.042561+00:00 4 34 1 0 143241464    
309 299222924320309249 299222924320309249 2025-06-29T07:41:39.362303+00:00 4 34 2 0 191177411    
310 299222924320309249 299222924320309249 2025-06-29T07:48:22.995707+00:00 4 34 4 0 220030411    
398 299222924320309249 299222924320309249 2025-06-30T10:22:07.407201+00:00 5 38 1 0 142477519    
401 299222924320309249 299222924320309249 2025-06-30T10:30:45.955108+00:00 5 38 5 0 217420547    
403 299222924320309249 299222924320309249 2025-06-30T10:37:53.930167+00:00 5 38 2 0 134494847    
405 299222924320309249 299222924320309249 2025-06-30T10:40:00.096785+00:00 5 39 2 1 62848962    
612 299222924320309249 299222924320309249 2025-07-27T12:04:27.537289+00:00 1 21 1 0      
613 299222924320309249 299222924320309249 2025-07-27T12:04:27.537289+00:00 1 22 1 1   自動產生,關聯至完整刀 ID:612 612
614 299222924320309249 299222924320309249 2025-07-27T12:10:17.072885+00:00 1 21 2 0      
615 299222924320309249 299222924320309249 2025-07-27T12:10:17.072885+00:00 1 22 2 1   自動產生,關聯至完整刀 ID:614 614
616 299222924320309249 299222924320309249 2025-07-27T12:14:09.664657+00:00 1 21 4 0      
617 299222924320309249 299222924320309249 2025-07-27T12:14:09.664657+00:00 1 22 4 1   自動產生,關聯至完整刀 ID:616 616
687 299222924320309249 299222924320309249 2025-07-28T08:04:46.709130+00:00 2 25 1 0 304882279    
691 299222924320309249 299222924320309249 2025-07-28T08:25:14.772878+00:00 2 25 4 0 214663376    
697 299222924320309249 299222924320309249 2025-07-28T11:48:11.018059+00:00 2 25 5 0 262845448    
828 299222924320309249 299222924320309249 2025-07-29T12:39:00.949643+00:00 3 31 1 0 307465105    
830 299222924320309249 299222924320309249 2025-07-29T12:44:30.344611+00:00 3 31 4 0 226281887    
849 299222924320309249 299222924320309249 2025-07-29T14:18:06.135553+00:00 3 31 3 0 74138567    
850 299222924320309249 299222924320309249 2025-07-29T14:18:38.526589+00:00 3 32 3 1 230640711    
954 299222924320309249 299222924320309249 2025-07-30T13:41:20.625348+00:00 4 36 4 0 227896006    
961 299222924320309249 299222924320309249 2025-07-30T13:56:51.702255+00:00 4 36 3 0 252306091    
972 299222924320309249 299222924320309249 2025-07-30T15:02:45.274381+00:00 4 36 1 0 102329132    
973 299222924320309249 299222924320309249 2025-07-30T15:02:59.816949+00:00 4 37 1 0 260059688    
1062 299222924320309249 299222924320309249 2025-07-31T12:47:05.966157+00:00 5 40 4 0 45272967    
1063 299222924320309249 299222924320309249 2025-07-31T12:47:22.793664+00:00 5 41 4 0 230259858    
1065 299222924320309249 299222924320309249 2025-07-31T12:53:26.589144+00:00 5 40 1 0 307927981    
1069 299222924320309249 299222924320309249 2025-07-31T12:59:37.317717+00:00 5 40 3 0 252733612    
1192 299222924320309249 299222924320309249 2025-08-27T10:07:46.815569+00:00 1 15 4 0      
1193 299222924320309249 299222924320309249 2025-08-27T10:07:46.815569+00:00 1 16 4 1   自動產生,關聯至完整刀 ID:1192 1192
1200 299222924320309249 299222924320309249 2025-08-27T10:11:12.010146+00:00 1 17 1 0      
1201 299222924320309249 299222924320309249 2025-08-27T10:11:12.010146+00:00 1 18 1 1   自動產生,關聯至完整刀 ID:1200 1200
1204 299222924320309249 299222924320309249 2025-08-27T10:19:47.668760+00:00 1 17 3 0      
1205 299222924320309249 299222924320309249 2025-08-27T10:19:47.668760+00:00 1 18 3 1   自動產生,關聯至完整刀 ID:1204 1204
1350 299222924320309249 299222924320309249 2025-08-28T13:30:49.867434+00:00 2 27 3 0 278524833    
1353 299222924320309249 299222924320309249 2025-08-28T13:40:57.686287+00:00 2 26 2 0 117996803    
1355 299222924320309249 299222924320309249 2025-08-28T13:44:13.350414+00:00 2 27 2 1 117467714    
1357 299222924320309249 299222924320309249 2025-08-28T13:58:10.374414+00:00 2 27 1 0 240332309    
1459 299222924320309249 299222924320309249 2025-08-29T14:32:26.986267+00:00 3 30 1 0 10357522    
1461 299222924320309249 299222924320309249 2025-08-29T14:32:57.685100+00:00 3 31 1 0 239038866    
1465 299222924320309249 299222924320309249 2025-08-29T14:43:44.267136+00:00 3 31 3 0 27031884    
1466 299222924320309249 299222924320309249 2025-08-29T14:43:53.399959+00:00 3 32 3 0 267679751    
1470 299222924320309249 299222924320309249 2025-08-29T14:58:56.085311+00:00 3 31 4 0 33272850    
1471 299222924320309249 299222924320309249 2025-08-29T14:59:06.999837+00:00 3 32 4 1 273388087    
1573 299222924320309249 299222924320309249 2025-08-30T13:49:00.549870+00:00 4 36 3 0 267627816    
1581 299222924320309249 299222924320309249 2025-08-30T14:32:20.862596+00:00 4 36 4 0 33526721    
1582 299222924320309249 299222924320309249 2025-08-30T14:32:52.867393+00:00 4 35 2 0 209292648    
1590 299222924320309249 299222924320309249 2025-08-30T14:51:15.308075+00:00 4 35 1 1 239418869    
1633 299222924320309249 299222924320309249 2025-08-31T03:27:48.684838+00:00 5 38 2 0 209512282    
1659 299222924320309249 299222924320309249 2025-08-31T06:10:23.069837+00:00 5 38 1 0 152541029    
1664 299222924320309249 299222924320309249 2025-08-31T06:16:54.060011+00:00 5 39 1 1 63891135    
1666 299222924320309249 299222924320309249 2025-08-31T06:17:32.323964+00:00 5 40 4 0 366592260    
1871 299222924320309249 299222924320309249 2025-09-26T15:02:43.961715+00:00 1 23 5 0 289020445    
1872 299222924320309249 299222924320309249 2025-09-26T15:09:03.256927+00:00 1 23 4 0 210136993    
1873 299222924320309249 299222924320309249 2025-09-26T15:15:07.328254+00:00 1 23 2 0 302328153    
1945 299222924320309249 299222924320309249 2025-09-27T07:28:42.593694+00:00 2 26 5 0 287543728    
1946 299222924320309249 299222924320309249 2025-09-27T07:37:20.256153+00:00 2 26 2 0 301811385    
1972 299222924320309249 299222924320309249 2025-09-27T15:04:03.742459+00:00 2 28 4 0 247153025    
2066 299222924320309249 299222924320309249 2025-09-28T11:39:03.500572+00:00 3 32 2 0 303014669    
2067 299222924320309249 299222924320309249 2025-09-28T11:46:58.473453+00:00 3 31 5 0 288364449    
2075 299222924320309249 299222924320309249 2025-09-28T13:01:36.687289+00:00 3 31 4 0 106535183    
2077 299222924320309249 299222924320309249 2025-09-28T13:07:47.417712+00:00 3 32 4 0 174555436    
2181 299222924320309249 299222924320309249 2025-09-29T11:31:59.491493+00:00 4 36 4 0 251953770    
2183 299222924320309249 299222924320309249 2025-09-29T11:50:41.836804+00:00 4 36 2 0 223210153    
2184 299222924320309249 299222924320309249 2025-09-29T11:52:33.557099+00:00 4 37 2 1 975212800    
2192 299222924320309249 299222924320309249 2025-09-29T12:58:22.593444+00:00 4 36 5 0 288800041    
2323 299222924320309249 299222924320309249 2025-09-30T13:44:36.219409+00:00 5 42 4 0 251562523    
2324 299222924320309249 299222924320309249 2025-09-30T13:51:54.105339+00:00 5 42 5 0 288751936    
2327 299222924320309249 299222924320309249 2025-09-30T14:01:51.482316+00:00 5 42 2 0 304906178    

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 78.837ms