attacks
77 rows where member_id = 320933630484545539
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 |
|---|---|---|---|---|---|---|---|---|---|
| 113 | 320933630484545539 320933630484545539 | 2025-06-26T17:49:25.207388+00:00 | 2 | 23 | 1 | 0 | 140529141 | ||
| 114 | 320933630484545539 320933630484545539 | 2025-06-26T18:11:01.799865+00:00 | 2 | 24 | 3 | 0 | 149001917 | ||
| 115 | 320933630484545539 320933630484545539 | 2025-06-26T18:33:35.368863+00:00 | 2 | 24 | 2 | 0 | 172927726 | ||
| 117 | 320933630484545539 320933630484545539 | 2025-06-26T18:37:57.289780+00:00 | 2 | 24 | 4 | 1 | 893832 | ||
| 125 | 320933630484545539 320933630484545539 | 2025-06-27T06:17:05.264941+00:00 | 2 | 25 | 5 | 0 | 196108242 | ||
| 126 | 320933630484545539 320933630484545539 | 2025-06-27T06:47:42.180423+00:00 | 2 | 24 | 1 | 0 | 138702878 | ||
| 127 | 320933630484545539 320933630484545539 | 2025-06-27T07:08:45.049653+00:00 | 2 | 25 | 3 | 0 | 153359784 | ||
| 225 | 320933630484545539 320933630484545539 | 2025-06-28T08:42:36.594013+00:00 | 3 | 30 | 1 | 0 | 140575768 | ||
| 226 | 320933630484545539 320933630484545539 | 2025-06-28T08:48:24.703599+00:00 | 3 | 30 | 5 | 0 | 196371388 | ||
| 227 | 320933630484545539 320933630484545539 | 2025-06-28T09:13:59.231570+00:00 | 3 | 29 | 3 | 0 | 154263768 | ||
| 312 | 320933630484545539 320933630484545539 | 2025-06-29T08:28:24.369915+00:00 | 4 | 34 | 3 | 0 | 160144712 | ||
| 314 | 320933630484545539 320933630484545539 | 2025-06-29T09:22:49.145977+00:00 | 4 | 34 | 1 | 0 | 140726442 | ||
| 332 | 320933630484545539 320933630484545539 | 2025-06-29T11:28:16.946796+00:00 | 4 | 35 | 5 | 0 | 162579227 | ||
| 390 | 320933630484545539 320933630484545539 | 2025-06-30T07:45:03.085537+00:00 | 5 | 38 | 1 | 0 | 141437554 | ||
| 391 | 320933630484545539 320933630484545539 | 2025-06-30T07:51:05.840835+00:00 | 5 | 38 | 3 | 0 | 157520268 | ||
| 392 | 320933630484545539 320933630484545539 | 2025-06-30T07:52:39.913958+00:00 | 5 | 39 | 3 | 1 | 9701287 | ||
| 393 | 320933630484545539 320933630484545539 | 2025-06-30T08:12:14.679478+00:00 | 5 | 38 | 5 | 0 | 161713907 | ||
| 626 | 320933630484545539 320933630484545539 | 2025-07-27T14:38:02.847120+00:00 | 1 | 23 | 4 | 0 | 224437965 | ||
| 629 | 320933630484545539 320933630484545539 | 2025-07-27T14:50:29.266278+00:00 | 1 | 23 | 2 | 0 | 324203436 | ||
| 640 | 320933630484545539 320933630484545539 | 2025-07-27T15:53:55.900156+00:00 | 1 | 24 | 1 | 0 | 296255513 | ||
| 679 | 320933630484545539 320933630484545539 | 2025-07-28T05:58:19.988298+00:00 | 2 | 25 | 4 | 0 | 224160192 | ||
| 681 | 320933630484545539 320933630484545539 | 2025-07-28T06:08:49.020008+00:00 | 2 | 25 | 2 | 0 | 87621738 | ||
| 683 | 320933630484545539 320933630484545539 | 2025-07-28T06:40:28.338098+00:00 | 2 | 24 | 1 | 0 | 232639336 | ||
| 684 | 320933630484545539 320933630484545539 | 2025-07-28T06:42:24.891945+00:00 | 2 | 25 | 1 | 1 | 46332800 | ||
| 686 | 320933630484545539 320933630484545539 | 2025-07-28T06:47:23.216341+00:00 | 2 | 26 | 2 | 1 | 291027118 | ||
| 799 | 320933630484545539 320933630484545539 | 2025-07-29T05:28:08.092971+00:00 | 3 | 30 | 2 | 0 | 327619670 | ||
| 801 | 320933630484545539 320933630484545539 | 2025-07-29T05:39:58.205940+00:00 | 3 | 29 | 4 | 0 | 182632601 | ||
| 802 | 320933630484545539 320933630484545539 | 2025-07-29T05:41:43.727991+00:00 | 3 | 30 | 4 | 1 | 22443644 | ||
| 803 | 320933630484545539 320933630484545539 | 2025-07-29T06:24:35.186506+00:00 | 3 | 29 | 1 | 0 | 296242829 | ||
| 911 | 320933630484545539 320933630484545539 | 2025-07-30T08:16:37.358069+00:00 | 4 | 34 | 4 | 0 | 221558489 | ||
| 913 | 320933630484545539 320933630484545539 | 2025-07-30T08:23:08.556259+00:00 | 4 | 34 | 1 | 0 | 298829121 | ||
| 925 | 320933630484545539 320933630484545539 | 2025-07-30T12:38:29.600002+00:00 | 4 | 34 | 2 | 0 | 44165803 | ||
| 928 | 320933630484545539 320933630484545539 | 2025-07-30T12:43:16.167574+00:00 | 4 | 35 | 2 | 0 | 323981043 | ||
| 1035 | 320933630484545539 320933630484545539 | 2025-07-31T08:49:53.368822+00:00 | 5 | 39 | 4 | 0 | 222932346 | ||
| 1036 | 320933630484545539 320933630484545539 | 2025-07-31T09:33:10.345911+00:00 | 5 | 39 | 2 | 0 | 324393824 | ||
| 1040 | 320933630484545539 320933630484545539 | 2025-07-31T10:04:39.288778+00:00 | 5 | 39 | 1 | 0 | 96175552 | ||
| 1042 | 320933630484545539 320933630484545539 | 2025-07-31T10:09:00.922529+00:00 | 5 | 40 | 1 | 1 | 244291212 | ||
| 1278 | 320933630484545539 320933630484545539 | 2025-08-27T19:21:00.816310+00:00 | 1 | 20 | 2 | 0 | 106165397 | ||
| 1279 | 320933630484545539 320933630484545539 | 2025-08-27T19:21:00.816310+00:00 | 1 | 21 | 2 | 1 | 自動產生，關聯至完整刀 ID:1278 | 1278 | |
| 1280 | 320933630484545539 320933630484545539 | 2025-08-27T19:22:51.037402+00:00 | 1 | 24 | 2 | 0 | 58392497 | ||
| 1281 | 320933630484545539 320933630484545539 | 2025-08-27T19:41:01.226055+00:00 | 1 | 24 | 5 | 0 | 243666549 | ||
| 1282 | 320933630484545539 320933630484545539 | 2025-08-27T19:45:32.467709+00:00 | 1 | 24 | 4 | 0 | 327581647 | ||
| 1304 | 320933630484545539 320933630484545539 | 2025-08-28T05:56:29.557922+00:00 | 2 | 24 | 2 | 0 | 185883337 | ||
| 1305 | 320933630484545539 320933630484545539 | 2025-08-28T06:02:44.305116+00:00 | 2 | 25 | 5 | 0 | 240985665 | ||
| 1311 | 320933630484545539 320933630484545539 | 2025-08-28T11:37:38.579406+00:00 | 2 | 26 | 4 | 0 | 326165624 | ||
| 1418 | 320933630484545539 320933630484545539 | 2025-08-29T06:01:24.485510+00:00 | 3 | 29 | 2 | 0 | 185879896 | ||
| 1421 | 320933630484545539 320933630484545539 | 2025-08-29T07:04:53.063368+00:00 | 3 | 29 | 5 | 0 | 34958107 | ||
| 1422 | 320933630484545539 320933630484545539 | 2025-08-29T07:11:34.157941+00:00 | 3 | 30 | 5 | 1 | 238061211 | ||
| 1423 | 320933630484545539 320933630484545539 | 2025-08-29T07:15:38.212621+00:00 | 3 | 29 | 4 | 0 | 347575690 | ||
| 1543 | 320933630484545539 320933630484545539 | 2025-08-30T06:43:00.409438+00:00 | 4 | 34 | 2 | 0 | 185868293 | ||
| 1544 | 320933630484545539 320933630484545539 | 2025-08-30T06:48:26.739021+00:00 | 4 | 35 | 5 | 0 | 238104548 | ||
| 1555 | 320933630484545539 320933630484545539 | 2025-08-30T08:06:49.917578+00:00 | 4 | 35 | 4 | 0 | 345698637 | ||
| 1670 | 320933630484545539 320933630484545539 | 2025-08-31T07:20:00.733733+00:00 | 5 | 37 | 2 | 0 | 185882988 | ||
| 1671 | 320933630484545539 320933630484545539 | 2025-08-31T07:26:35.663061+00:00 | 5 | 40 | 4 | 0 | 347416067 | ||
| 1673 | 320933630484545539 320933630484545539 | 2025-08-31T07:32:30.798572+00:00 | 5 | 39 | 5 | 0 | 93273198 | ||
| 1674 | 320933630484545539 320933630484545539 | 2025-08-31T07:35:51.763650+00:00 | 5 | 40 | 5 | 0 | 141359271 | ||
| 1896 | 320933630484545539 320933630484545539 | 2025-09-26T19:09:30.354181+00:00 | 1 | 24 | 2 | 0 | 246896616 | ||
| 1897 | 320933630484545539 320933630484545539 | 2025-09-26T19:10:34.719513+00:00 | 1 | 25 | 2 | 0 | 3469384 | ||
| 1899 | 320933630484545539 320933630484545539 | 2025-09-26T19:21:36.101929+00:00 | 1 | 24 | 5 | 0 | 274837669 | ||
| 1901 | 320933630484545539 320933630484545539 | 2025-09-26T19:48:38.754243+00:00 | 1 | 24 | 3 | 0 | 272398421 | ||
| 1907 | 320933630484545539 320933630484545539 | 2025-09-27T02:19:54.110905+00:00 | 2 | 25 | 2 | 0 | 288355754 | ||
| 1908 | 320933630484545539 320933630484545539 | 2025-09-27T02:24:12.403331+00:00 | 2 | 25 | 3 | 0 | 258652982 | ||
| 1909 | 320933630484545539 320933630484545539 | 2025-09-27T02:52:32.790042+00:00 | 2 | 24 | 5 | 0 | 123687871 | ||
| 1910 | 320933630484545539 320933630484545539 | 2025-09-27T02:56:46.307176+00:00 | 2 | 25 | 5 | 0 | 162592326 | ||
| 2069 | 320933630484545539 320933630484545539 | 2025-09-28T12:43:55.856598+00:00 | 3 | 31 | 3 | 0 | 171740978 | ||
| 2070 | 320933630484545539 320933630484545539 | 2025-09-28T12:45:51.076142+00:00 | 3 | 32 | 3 | 1 | 74535411 | ||
| 2071 | 320933630484545539 320933630484545539 | 2025-09-28T12:53:34.327362+00:00 | 3 | 31 | 5 | 0 | 248412073 | ||
| 2087 | 320933630484545539 320933630484545539 | 2025-09-28T14:35:13.337674+00:00 | 3 | 32 | 2 | 0 | 46590297 | ||
| 2089 | 320933630484545539 320933630484545539 | 2025-09-28T14:38:41.703074+00:00 | 3 | 33 | 2 | 0 | 288282936 | ||
| 2154 | 320933630484545539 320933630484545539 | 2025-09-29T05:16:26.227262+00:00 | 4 | 35 | 5 | 0 | 270835552 | ||
| 2157 | 320933630484545539 320933630484545539 | 2025-09-29T05:33:23.341867+00:00 | 4 | 35 | 3 | 0 | 237861782 | ||
| 2158 | 320933630484545539 320933630484545539 | 2025-09-29T05:35:20.689418+00:00 | 4 | 36 | 3 | 1 | 49958143 | ||
| 2162 | 320933630484545539 320933630484545539 | 2025-09-29T07:11:26.976921+00:00 | 4 | 35 | 2 | 0 | 100350122 | ||
| 2164 | 320933630484545539 320933630484545539 | 2025-09-29T07:14:48.539557+00:00 | 4 | 36 | 2 | 0 | 201484977 | ||
| 2263 | 320933630484545539 320933630484545539 | 2025-09-30T05:02:08.578431+00:00 | 5 | 40 | 5 | 0 | 275629421 | ||
| 2267 | 320933630484545539 320933630484545539 | 2025-09-30T05:38:45.171352+00:00 | 5 | 39 | 2 | 0 | 289622314 | ||
| 2270 | 320933630484545539 320933630484545539 | 2025-09-30T05:53:19.219761+00:00 | 5 | 40 | 3 | 0 | 330242533 |
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)
);