attacks
157 rows where member_id = 484465577432449043
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 |
|---|---|---|---|---|---|---|---|---|---|
| 84 | 484465577432449043 484465577432449043 | 2025-06-26T14:13:23.953616+00:00 | 1 | 23 | 4 | 0 | 221181005 | ||
| 85 | 484465577432449043 484465577432449043 | 2025-06-26T14:13:37.459663+00:00 | 1 | 23 | 4 | 0 | 220162431 | ||
| 87 | 484465577432449043 484465577432449043 | 2025-06-26T14:40:00.820173+00:00 | 1 | 23 | 5 | 0 | 206565186 | ||
| 88 | 484465577432449043 484465577432449043 | 2025-06-26T14:40:16.070363+00:00 | 1 | 23 | 5 | 0 | 204698140 | ||
| 89 | 484465577432449043 484465577432449043 | 2025-06-26T15:07:41.632197+00:00 | 1 | 23 | 3 | 0 | 170370348 | ||
| 93 | 484465577432449043 484465577432449043 | 2025-06-26T15:41:20.015055+00:00 | 1 | 23 | 3 | 0 | 169433227 | ||
| 185 | 484465577432449043 484465577432449043 | 2025-06-27T17:34:34.305796+00:00 | 2 | 27 | 4 | 0 | 203453361 | ||
| 188 | 484465577432449043 484465577432449043 | 2025-06-27T17:41:24.197970+00:00 | 2 | 28 | 4 | 0 | 222124453 | ||
| 189 | 484465577432449043 484465577432449043 | 2025-06-27T18:00:53.233616+00:00 | 2 | 28 | 1 | 0 | 180667729 | ||
| 190 | 484465577432449043 484465577432449043 | 2025-06-27T18:01:10.015083+00:00 | 2 | 28 | 1 | 0 | 180453527 | ||
| 191 | 484465577432449043 484465577432449043 | 2025-06-27T18:15:44.844476+00:00 | 2 | 28 | 5 | 0 | 205948272 | ||
| 192 | 484465577432449043 484465577432449043 | 2025-06-27T18:15:57.553823+00:00 | 2 | 28 | 5 | 0 | 143204793 | ||
| 193 | 484465577432449043 484465577432449043 | 2025-06-27T18:46:13.192329+00:00 | 2 | 28 | 3 | 1 | 62940200 | ||
| 194 | 484465577432449043 484465577432449043 | 2025-06-27T18:46:57.729980+00:00 | 2 | 28 | 3 | 1 | 30872175 | ||
| 284 | 484465577432449043 484465577432449043 | 2025-06-28T16:58:09.486175+00:00 | 3 | 32 | 4 | 0 | 221900485 | ||
| 285 | 484465577432449043 484465577432449043 | 2025-06-28T17:09:25.353442+00:00 | 3 | 32 | 1 | 0 | 179891541 | ||
| 286 | 484465577432449043 484465577432449043 | 2025-06-28T17:09:36.144979+00:00 | 3 | 32 | 1 | 0 | 8632052 | ||
| 287 | 484465577432449043 484465577432449043 | 2025-06-28T17:14:34.539292+00:00 | 3 | 33 | 1 | 1 | 180358855 | ||
| 288 | 484465577432449043 484465577432449043 | 2025-06-28T17:20:21.644602+00:00 | 3 | 33 | 4 | 0 | 222971439 | ||
| 289 | 484465577432449043 484465577432449043 | 2025-06-28T17:28:13.899861+00:00 | 3 | 32 | 3 | 0 | 169656085 | ||
| 290 | 484465577432449043 484465577432449043 | 2025-06-28T17:29:20.102470+00:00 | 3 | 32 | 3 | 0 | 169451407 | ||
| 342 | 484465577432449043 484465577432449043 | 2025-06-29T13:00:02.192915+00:00 | 4 | 35 | 3 | 0 | 46470985 | ||
| 344 | 484465577432449043 484465577432449043 | 2025-06-29T13:08:21.015065+00:00 | 4 | 35 | 4 | 0 | 76761706 | ||
| 345 | 484465577432449043 484465577432449043 | 2025-06-29T13:08:43.446195+00:00 | 4 | 36 | 3 | 1 | 157188721 | ||
| 346 | 484465577432449043 484465577432449043 | 2025-06-29T13:13:55.798010+00:00 | 4 | 36 | 4 | 1 | 172466233 | ||
| 348 | 484465577432449043 484465577432449043 | 2025-06-29T13:20:08.240999+00:00 | 4 | 35 | 1 | 0 | 179711187 | ||
| 350 | 484465577432449043 484465577432449043 | 2025-06-29T13:24:51.701298+00:00 | 4 | 36 | 3 | 0 | 170777168 | ||
| 353 | 484465577432449043 484465577432449043 | 2025-06-29T13:39:24.753976+00:00 | 4 | 36 | 4 | 0 | 221285439 | ||
| 355 | 484465577432449043 484465577432449043 | 2025-06-29T13:44:39.671666+00:00 | 4 | 36 | 5 | 0 | 208131780 | ||
| 422 | 484465577432449043 484465577432449043 | 2025-06-30T12:32:58.121916+00:00 | 5 | 39 | 1 | 0 | 180100309 | ||
| 423 | 484465577432449043 484465577432449043 | 2025-06-30T12:33:08.719583+00:00 | 5 | 39 | 1 | 0 | 26867593 | ||
| 424 | 484465577432449043 484465577432449043 | 2025-06-30T12:38:08.200357+00:00 | 5 | 40 | 1 | 1 | 180923923 | ||
| 624 | 484465577432449043 484465577432449043 | 2025-07-27T14:25:51.197313+00:00 | 1 | 23 | 1 | 0 | 313923356 | ||
| 625 | 484465577432449043 484465577432449043 | 2025-07-27T14:26:02.394917+00:00 | 1 | 23 | 1 | 0 | 315485013 | ||
| 627 | 484465577432449043 484465577432449043 | 2025-07-27T14:45:18.874672+00:00 | 1 | 23 | 3 | 0 | 272269111 | ||
| 628 | 484465577432449043 484465577432449043 | 2025-07-27T14:45:34.788028+00:00 | 1 | 23 | 3 | 0 | 272567423 | ||
| 631 | 484465577432449043 484465577432449043 | 2025-07-27T15:07:17.822853+00:00 | 1 | 23 | 2 | 0 | 345755293 | ||
| 632 | 484465577432449043 484465577432449043 | 2025-07-27T15:07:28.955607+00:00 | 1 | 23 | 2 | 0 | 18945305 | ||
| 633 | 484465577432449043 484465577432449043 | 2025-07-27T15:13:53.898354+00:00 | 1 | 24 | 2 | 0 | 342446490 | ||
| 764 | 484465577432449043 484465577432449043 | 2025-07-28T16:49:55.936804+00:00 | 2 | 28 | 5 | 0 | 295816246 | ||
| 765 | 484465577432449043 484465577432449043 | 2025-07-28T16:50:11.124757+00:00 | 2 | 28 | 5 | 0 | 39604217 | ||
| 767 | 484465577432449043 484465577432449043 | 2025-07-28T16:54:41.578101+00:00 | 2 | 29 | 5 | 0 | 298807400 | ||
| 768 | 484465577432449043 484465577432449043 | 2025-07-28T17:21:14.674663+00:00 | 2 | 28 | 1 | 0 | 314377863 | ||
| 769 | 484465577432449043 484465577432449043 | 2025-07-28T17:21:23.487680+00:00 | 2 | 28 | 1 | 0 | 313993255 | ||
| 770 | 484465577432449043 484465577432449043 | 2025-07-28T17:22:17.244365+00:00 | 2 | 28 | 1 | 0 | 2602904 | ||
| 771 | 484465577432449043 484465577432449043 | 2025-07-28T17:32:57.005125+00:00 | 2 | 28 | 3 | 0 | 270751159 | ||
| 772 | 484465577432449043 484465577432449043 | 2025-07-28T17:33:07.241601+00:00 | 2 | 28 | 3 | 0 | 80173157 | ||
| 773 | 484465577432449043 484465577432449043 | 2025-07-28T17:46:41.780920+00:00 | 2 | 28 | 4 | 1 | 207108169 | ||
| 821 | 484465577432449043 484465577432449043 | 2025-07-29T12:22:32.544239+00:00 | 3 | 30 | 2 | 0 | 347300226 | ||
| 823 | 484465577432449043 484465577432449043 | 2025-07-29T12:22:44.443992+00:00 | 3 | 30 | 2 | 0 | 20281525 | ||
| 826 | 484465577432449043 484465577432449043 | 2025-07-29T12:29:36.524098+00:00 | 3 | 31 | 2 | 0 | 346873732 | ||
| 831 | 484465577432449043 484465577432449043 | 2025-07-29T12:48:47.596976+00:00 | 3 | 31 | 5 | 0 | 296880909 | ||
| 832 | 484465577432449043 484465577432449043 | 2025-07-29T12:48:57.475039+00:00 | 3 | 31 | 5 | 0 | 297266365 | ||
| 838 | 484465577432449043 484465577432449043 | 2025-07-29T13:42:30.030866+00:00 | 3 | 31 | 1 | 0 | 316240879 | ||
| 839 | 484465577432449043 484465577432449043 | 2025-07-29T13:42:38.862409+00:00 | 3 | 31 | 1 | 0 | 140825440 | ||
| 842 | 484465577432449043 484465577432449043 | 2025-07-29T13:50:37.067031+00:00 | 3 | 32 | 1 | 1 | 213298778 | ||
| 978 | 484465577432449043 484465577432449043 | 2025-07-30T16:10:20.692213+00:00 | 4 | 37 | 2 | 0 | 343372549 | ||
| 979 | 484465577432449043 484465577432449043 | 2025-07-30T16:10:29.603076+00:00 | 4 | 37 | 2 | 0 | 18423285 | ||
| 981 | 484465577432449043 484465577432449043 | 2025-07-30T16:14:59.634058+00:00 | 4 | 38 | 2 | 1 | 346005481 | ||
| 983 | 484465577432449043 484465577432449043 | 2025-07-30T16:35:19.719035+00:00 | 4 | 37 | 5 | 0 | 298210759 | ||
| 984 | 484465577432449043 484465577432449043 | 2025-07-30T16:35:30.618432+00:00 | 4 | 37 | 5 | 0 | 276904369 | ||
| 985 | 484465577432449043 484465577432449043 | 2025-07-30T17:20:26.077144+00:00 | 4 | 37 | 1 | 1 | 39324263 | ||
| 986 | 484465577432449043 484465577432449043 | 2025-07-30T17:29:01.078898+00:00 | 4 | 37 | 1 | 0 | 316303633 | ||
| 987 | 484465577432449043 484465577432449043 | 2025-07-30T17:29:11.596925+00:00 | 4 | 37 | 1 | 0 | 138615013 | ||
| 988 | 484465577432449043 484465577432449043 | 2025-07-30T17:40:48.813824+00:00 | 4 | 37 | 4 | 0 | 161285767 | ||
| 1091 | 484465577432449043 484465577432449043 | 2025-07-31T15:11:51.251906+00:00 | 5 | 41 | 1 | 0 | 314157229 | ||
| 1092 | 484465577432449043 484465577432449043 | 2025-07-31T15:11:59.439886+00:00 | 5 | 41 | 1 | 0 | 58194399 | ||
| 1093 | 484465577432449043 484465577432449043 | 2025-07-31T15:16:49.502612+00:00 | 5 | 42 | 1 | 1 | 315647673 | ||
| 1095 | 484465577432449043 484465577432449043 | 2025-07-31T15:22:44.252023+00:00 | 5 | 42 | 5 | 0 | 290644362 | ||
| 1097 | 484465577432449043 484465577432449043 | 2025-07-31T15:24:25.593859+00:00 | 5 | 42 | 5 | 0 | 289915499 | ||
| 1099 | 484465577432449043 484465577432449043 | 2025-07-31T15:33:02.934276+00:00 | 5 | 41 | 2 | 0 | 62465751 | ||
| 1100 | 484465577432449043 484465577432449043 | 2025-07-31T15:37:39.846345+00:00 | 5 | 42 | 2 | 1 | 249094195 | ||
| 1101 | 484465577432449043 484465577432449043 | 2025-07-31T15:42:46.750228+00:00 | 5 | 42 | 2 | 0 | 351897387 | ||
| 1259 | 484465577432449043 484465577432449043 | 2025-08-27T15:39:25.234137+00:00 | 1 | 23 | 5 | 0 | 265167702 | ||
| 1261 | 484465577432449043 484465577432449043 | 2025-08-27T15:47:42.467026+00:00 | 1 | 23 | 3 | 0 | 278142325 | ||
| 1262 | 484465577432449043 484465577432449043 | 2025-08-27T15:47:50.876820+00:00 | 1 | 23 | 3 | 0 | 35409122 | ||
| 1264 | 484465577432449043 484465577432449043 | 2025-08-27T15:50:52.086777+00:00 | 1 | 24 | 3 | 1 | 277786281 | ||
| 1266 | 484465577432449043 484465577432449043 | 2025-08-27T16:08:39.451098+00:00 | 1 | 23 | 1 | 0 | 327028213 | ||
| 1267 | 484465577432449043 484465577432449043 | 2025-08-27T16:08:51.260518+00:00 | 1 | 23 | 1 | 0 | 158605392 | ||
| 1269 | 484465577432449043 484465577432449043 | 2025-08-27T16:12:57.396395+00:00 | 1 | 24 | 1 | 1 | 180255320 | ||
| 1275 | 484465577432449043 484465577432449043 | 2025-08-27T17:34:09.336786+00:00 | 1 | 23 | 2 | 0 | 245510360 | ||
| 1360 | 484465577432449043 484465577432449043 | 2025-08-28T14:12:37.979290+00:00 | 2 | 27 | 1 | 0 | 329845759 | ||
| 1361 | 484465577432449043 484465577432449043 | 2025-08-28T14:12:48.815303+00:00 | 2 | 27 | 1 | 0 | 295242764 | ||
| 1367 | 484465577432449043 484465577432449043 | 2025-08-28T14:33:01.797743+00:00 | 2 | 28 | 3 | 0 | 276000108 | ||
| 1368 | 484465577432449043 484465577432449043 | 2025-08-28T14:33:09.312310+00:00 | 2 | 28 | 3 | 0 | 274153892 | ||
| 1373 | 484465577432449043 484465577432449043 | 2025-08-28T14:55:30.945725+00:00 | 2 | 27 | 5 | 0 | 167277267 | ||
| 1374 | 484465577432449043 484465577432449043 | 2025-08-28T15:00:44.984761+00:00 | 2 | 28 | 5 | 1 | 118050178 | ||
| 1377 | 484465577432449043 484465577432449043 | 2025-08-28T16:30:04.040641+00:00 | 2 | 27 | 2 | 0 | 248398493 | ||
| 1380 | 484465577432449043 484465577432449043 | 2025-08-28T16:34:48.935199+00:00 | 2 | 28 | 5 | 0 | 41177856 | ||
| 1462 | 484465577432449043 484465577432449043 | 2025-08-29T14:34:04.848730+00:00 | 3 | 31 | 2 | 0 | 248642040 | ||
| 1467 | 484465577432449043 484465577432449043 | 2025-08-29T14:49:44.644145+00:00 | 3 | 31 | 1 | 0 | 328117887 | ||
| 1468 | 484465577432449043 484465577432449043 | 2025-08-29T14:49:53.680679+00:00 | 3 | 31 | 1 | 0 | 104187033 | ||
| 1469 | 484465577432449043 484465577432449043 | 2025-08-29T14:55:17.845655+00:00 | 3 | 32 | 1 | 1 | 280581428 | ||
| 1474 | 484465577432449043 484465577432449043 | 2025-08-29T15:15:02.079481+00:00 | 3 | 32 | 4 | 0 | 380800011 | ||
| 1475 | 484465577432449043 484465577432449043 | 2025-08-29T15:18:37.186268+00:00 | 3 | 32 | 3 | 0 | 275351897 | ||
| 1476 | 484465577432449043 484465577432449043 | 2025-08-29T15:23:05.652934+00:00 | 3 | 32 | 5 | 0 | 265770500 | ||
| 1571 | 484465577432449043 484465577432449043 | 2025-08-30T13:48:39.742779+00:00 | 4 | 35 | 1 | 0 | 326691043 | ||
| 1572 | 484465577432449043 484465577432449043 | 2025-08-30T13:48:49.790008+00:00 | 4 | 35 | 1 | 0 | 327503579 | ||
| 1576 | 484465577432449043 484465577432449043 | 2025-08-30T14:16:12.966265+00:00 | 4 | 36 | 5 | 0 | 260518068 | ||
| 1584 | 484465577432449043 484465577432449043 | 2025-08-30T14:36:32.007643+00:00 | 4 | 36 | 3 | 0 | 278917174 |
Advanced export
JSON shape: default, array, newline-delimited, object
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)
);