home / japari_dc_bot

attacks

81 rows where member_id = 509582053801459732

✎ 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
59 509582053801459732 509582053801459732 2025-06-26T08:29:19.734493+00:00 1 15 5 0      
60 509582053801459732 509582053801459732 2025-06-26T08:29:19.734493+00:00 1 16 5 1   自動產生,關聯至完整刀 ID:59 59
77 509582053801459732 509582053801459732 2025-06-26T12:26:35.134744+00:00 1 19 4 0      
78 509582053801459732 509582053801459732 2025-06-26T12:26:35.134744+00:00 1 20 4 1   自動產生,關聯至完整刀 ID:77 77
79 509582053801459732 509582053801459732 2025-06-26T12:32:23.640111+00:00 1 21 3 0      
80 509582053801459732 509582053801459732 2025-06-26T12:32:23.640111+00:00 1 22 3 1   自動產生,關聯至完整刀 ID:79 79
174 509582053801459732 509582053801459732 2025-06-27T16:18:06.993903+00:00 2 28 5 0 209134859    
176 509582053801459732 509582053801459732 2025-06-27T16:24:53.210741+00:00 2 27 1 1 176717552    
179 509582053801459732 509582053801459732 2025-06-27T16:35:57.492752+00:00 2 27 3 0 155455249    
180 509582053801459732 509582053801459732 2025-06-27T16:46:58.465899+00:00 2 28 3 0 48818383    
181 509582053801459732 509582053801459732 2025-06-27T16:50:48.211787+00:00 2 28 2 1 18062036    
247 509582053801459732 509582053801459732 2025-06-28T11:29:23.099016+00:00 3 31 5 0 210093648    
249 509582053801459732 509582053801459732 2025-06-28T11:35:28.146884+00:00 3 31 2 0 212096527    
250 509582053801459732 509582053801459732 2025-06-28T11:40:41.309385+00:00 3 30 3 0 152155713    
251 509582053801459732 509582053801459732 2025-06-28T11:44:06.533715+00:00 3 31 1 0 22985888    
368 509582053801459732 509582053801459732 2025-06-29T18:30:41.249998+00:00 4 36 3 0 15051514    
369 509582053801459732 509582053801459732 2025-06-29T18:36:13.466951+00:00 4 37 3 1 168998018    
370 509582053801459732 509582053801459732 2025-06-29T18:39:54.379602+00:00 4 36 1 0 24654881    
372 509582053801459732 509582053801459732 2025-06-29T18:48:19.788545+00:00 4 37 1 1 162997728    
373 509582053801459732 509582053801459732 2025-06-29T18:54:09.183665+00:00 4 37 5 0 209330441    
387 509582053801459732 509582053801459732 2025-06-30T03:55:43.220265+00:00 5 38 5 0 208945237    
388 509582053801459732 509582053801459732 2025-06-30T04:01:04.809118+00:00 5 38 3 0 169381273    
389 509582053801459732 509582053801459732 2025-06-30T04:07:05.070427+00:00 5 38 1 0 182800018    
469 509582053801459732 509582053801459732 2025-07-27T00:56:31.795947+00:00 1 1 1 0 12000000    
470 509582053801459732 509582053801459732 2025-07-27T00:56:31.795947+00:00 1 2 1 1   自動產生,關聯至完整刀 ID:469 469
471 509582053801459732 509582053801459732 2025-07-27T01:00:02.754453+00:00 1 1 2 0 15000000    
472 509582053801459732 509582053801459732 2025-07-27T01:00:02.754453+00:00 1 2 2 1   自動產生,關聯至完整刀 ID:471 471
473 509582053801459732 509582053801459732 2025-07-27T01:02:19.936711+00:00 1 3 5 0 30000000    
474 509582053801459732 509582053801459732 2025-07-27T01:02:19.936711+00:00 1 4 5 1   自動產生,關聯至完整刀 ID:473 473
774 509582053801459732 509582053801459732 2025-07-28T19:54:51.537576+00:00 2 29 3 0 269032441    
775 509582053801459732 509582053801459732 2025-07-28T20:00:15.385421+00:00 2 29 2 0 348376218    
776 509582053801459732 509582053801459732 2025-07-28T20:06:52.306648+00:00 2 29 5 0 311478209    
877 509582053801459732 509582053801459732 2025-07-29T18:40:59.566193+00:00 3 32 4 0 177430336    
878 509582053801459732 509582053801459732 2025-07-29T18:47:18.799973+00:00 3 33 2 0 351625468    
879 509582053801459732 509582053801459732 2025-07-29T18:50:41.576252+00:00 3 32 3 1 47938813    
881 509582053801459732 509582053801459732 2025-07-29T18:55:17.189892+00:00 3 33 3 0 269616248    
957 509582053801459732 509582053801459732 2025-07-30T13:42:56.461048+00:00 4 36 5 0 309359382    
959 509582053801459732 509582053801459732 2025-07-30T13:48:16.027136+00:00 4 36 4 0 244821506    
962 509582053801459732 509582053801459732 2025-07-30T13:58:23.025845+00:00 4 36 3 0 172757164    
963 509582053801459732 509582053801459732 2025-07-30T14:00:46.464467+00:00 4 37 3 1 111475349    
1012 509582053801459732 509582053801459732 2025-07-31T03:20:36.001309+00:00 5 39 5 0 303921960    
1013 509582053801459732 509582053801459732 2025-07-31T03:25:07.794494+00:00 5 38 4 0 242429162    
1014 509582053801459732 509582053801459732 2025-07-31T03:32:49.478818+00:00 5 38 1 0 277133151    
1015 509582053801459732 509582053801459732 2025-07-31T03:35:02.031701+00:00 5 38 3 1 48172717    
1162 509582053801459732 509582053801459732 2025-08-27T06:51:15.777067+00:00 1 9 1 0      
1163 509582053801459732 509582053801459732 2025-08-27T06:51:15.777067+00:00 1 10 1 1   自動產生,關聯至完整刀 ID:1162 1162
1164 509582053801459732 509582053801459732 2025-08-27T06:54:07.337889+00:00 1 11 5 0      
1165 509582053801459732 509582053801459732 2025-08-27T06:54:07.337889+00:00 1 12 5 1   自動產生,關聯至完整刀 ID:1164 1164
1166 509582053801459732 509582053801459732 2025-08-27T06:59:28.858803+00:00 1 11 4 0      
1167 509582053801459732 509582053801459732 2025-08-27T06:59:28.858803+00:00 1 12 4 1   自動產生,關聯至完整刀 ID:1166 1166
1395 509582053801459732 509582053801459732 2025-08-28T19:11:02.056081+00:00 2 29 4 0 383854206    
1396 509582053801459732 509582053801459732 2025-08-28T19:18:35.985402+00:00 2 28 2 0 223839079    
1397 509582053801459732 509582053801459732 2025-08-28T19:34:35.556217+00:00 2 29 3 0 295832374    
1508 509582053801459732 509582053801459732 2025-08-29T19:20:11.644863+00:00 3 33 5 0 266914601    
1509 509582053801459732 509582053801459732 2025-08-29T19:24:53.190860+00:00 3 33 2 0 223639489    
1510 509582053801459732 509582053801459732 2025-08-29T19:31:03.609767+00:00 3 33 1 0 330484495    
1620 509582053801459732 509582053801459732 2025-08-30T17:19:18.047158+00:00 4 38 4 0 375237718    
1621 509582053801459732 509582053801459732 2025-08-30T17:24:36.728107+00:00 4 37 3 0 301528107    
1622 509582053801459732 509582053801459732 2025-08-30T17:36:29.877338+00:00 4 36 2 0 223794627    
1706 509582053801459732 509582053801459732 2025-08-31T12:26:45.076541+00:00 5 41 5 0 266562339    
1709 509582053801459732 509582053801459732 2025-08-31T12:33:06.883201+00:00 5 41 1 0 333521141    
1728 509582053801459732 509582053801459732 2025-08-31T14:11:55.234666+00:00 5 40 2 0 223788265    
1845 509582053801459732 509582053801459732 2025-09-26T12:30:10.291504+00:00 1 19 5 0      
1846 509582053801459732 509582053801459732 2025-09-26T12:30:10.291504+00:00 1 20 5 1   自動產生,關聯至完整刀 ID:1845 1845
1847 509582053801459732 509582053801459732 2025-09-26T12:33:31.756133+00:00 1 19 4 0      
1848 509582053801459732 509582053801459732 2025-09-26T12:33:31.756133+00:00 1 20 4 1   自動產生,關聯至完整刀 ID:1847 1847
1849 509582053801459732 509582053801459732 2025-09-26T12:37:51.161308+00:00 1 21 2 0      
1850 509582053801459732 509582053801459732 2025-09-26T12:37:51.161308+00:00 1 22 2 1   自動產生,關聯至完整刀 ID:1849 1849
2007 509582053801459732 509582053801459732 2025-09-27T19:09:51.613164+00:00 2 29 2 0 302517534    
2008 509582053801459732 509582053801459732 2025-09-27T19:18:44.463254+00:00 2 29 4 0 261200554    
2009 509582053801459732 509582053801459732 2025-09-27T19:28:14.538222+00:00 2 29 4 0 287307195    
2125 509582053801459732 509582053801459732 2025-09-28T19:05:46.360274+00:00 3 34 1 0 330108552    
2126 509582053801459732 509582053801459732 2025-09-28T19:05:55.463243+00:00 3 33 5 0 300286939    
2127 509582053801459732 509582053801459732 2025-09-28T19:06:06.898929+00:00 3 33 4 0 24136787    
2128 509582053801459732 509582053801459732 2025-09-28T19:06:16.874474+00:00 3 34 4 1 258301109    
2222 509582053801459732 509582053801459732 2025-09-29T18:07:05.473060+00:00 4 38 1 0 320192040    
2223 509582053801459732 509582053801459732 2025-09-29T18:12:02.518938+00:00 4 38 4 0 262197235    
2224 509582053801459732 509582053801459732 2025-09-29T18:20:41.197633+00:00 4 37 5 0 299813883    
2355 509582053801459732 509582053801459732 2025-09-30T15:35:50.416583+00:00 5 43 5 0 300243341    
2357 509582053801459732 509582053801459732 2025-09-30T15:41:47.424487+00:00 5 44 2 0 309870928    
2358 509582053801459732 509582053801459732 2025-09-30T15:59:12.029084+00:00 5 44 3 0 316855623    

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