attacks
85 rows where member_id = 493449969878040578
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 |
|---|---|---|---|---|---|---|---|---|---|
| 61 | 493449969878040578 493449969878040578 | 2025-06-26T08:58:32.170186+00:00 | 1 | 15 | 4 | 0 | |||
| 62 | 493449969878040578 493449969878040578 | 2025-06-26T08:58:32.170186+00:00 | 1 | 16 | 4 | 1 | 自動產生，關聯至完整刀 ID:61 | 61 | |
| 63 | 493449969878040578 493449969878040578 | 2025-06-26T09:02:05.995992+00:00 | 1 | 15 | 3 | 0 | |||
| 64 | 493449969878040578 493449969878040578 | 2025-06-26T09:02:05.995992+00:00 | 1 | 16 | 3 | 1 | 自動產生，關聯至完整刀 ID:63 | 63 | |
| 65 | 493449969878040578 493449969878040578 | 2025-06-26T09:05:04.530731+00:00 | 1 | 15 | 2 | 0 | |||
| 66 | 493449969878040578 493449969878040578 | 2025-06-26T09:05:04.530731+00:00 | 1 | 16 | 2 | 1 | 自動產生，關聯至完整刀 ID:65 | 65 | |
| 118 | 493449969878040578 493449969878040578 | 2025-06-26T22:37:00.551695+00:00 | 2 | 25 | 3 | 0 | 167580594 | ||
| 119 | 493449969878040578 493449969878040578 | 2025-06-26T22:45:21.231807+00:00 | 2 | 25 | 5 | 0 | 207588988 | ||
| 131 | 493449969878040578 493449969878040578 | 2025-06-27T09:20:49.127478+00:00 | 2 | 25 | 4 | 0 | 118617114 | ||
| 132 | 493449969878040578 493449969878040578 | 2025-06-27T09:26:42.929977+00:00 | 2 | 26 | 4 | 1 | 92774749 | ||
| 200 | 493449969878040578 493449969878040578 | 2025-06-27T22:45:17.921967+00:00 | 3 | 29 | 5 | 0 | 204124537 | ||
| 203 | 493449969878040578 493449969878040578 | 2025-06-28T02:12:57.380427+00:00 | 3 | 28 | 4 | 0 | 220976707 | ||
| 206 | 493449969878040578 493449969878040578 | 2025-06-28T02:20:30.474641+00:00 | 3 | 28 | 3 | 0 | 54561465 | ||
| 208 | 493449969878040578 493449969878040578 | 2025-06-28T02:26:30.853061+00:00 | 3 | 29 | 3 | 1 | 141686086 | ||
| 291 | 493449969878040578 493449969878040578 | 2025-06-28T22:43:45.329106+00:00 | 4 | 33 | 5 | 0 | 207467541 | ||
| 306 | 493449969878040578 493449969878040578 | 2025-06-29T05:12:44.833449+00:00 | 4 | 34 | 4 | 0 | 217651608 | ||
| 307 | 493449969878040578 493449969878040578 | 2025-06-29T06:06:43.055775+00:00 | 4 | 33 | 3 | 0 | 166413502 | ||
| 374 | 493449969878040578 493449969878040578 | 2025-06-29T22:40:19.777387+00:00 | 5 | 38 | 4 | 0 | 220884601 | ||
| 375 | 493449969878040578 493449969878040578 | 2025-06-29T22:45:19.605053+00:00 | 5 | 37 | 3 | 0 | 165197601 | ||
| 395 | 493449969878040578 493449969878040578 | 2025-06-30T09:03:24.296096+00:00 | 5 | 38 | 5 | 0 | 105580274 | ||
| 396 | 493449969878040578 493449969878040578 | 2025-06-30T09:09:03.945853+00:00 | 5 | 39 | 5 | 1 | 53454784 | ||
| 525 | 493449969878040578 493449969878040578 | 2025-07-27T04:24:49.691299+00:00 | 1 | 9 | 4 | 0 | 70000000 | ||
| 526 | 493449969878040578 493449969878040578 | 2025-07-27T04:24:49.691299+00:00 | 1 | 10 | 4 | 1 | 自動產生，關聯至完整刀 ID:525 | 525 | |
| 527 | 493449969878040578 493449969878040578 | 2025-07-27T04:26:33.368126+00:00 | 1 | 10 | 4 | 0 | 70000000 | ||
| 528 | 493449969878040578 493449969878040578 | 2025-07-27T04:26:33.368126+00:00 | 1 | 11 | 4 | 1 | 自動產生，關聯至完整刀 ID:527 | 527 | |
| 529 | 493449969878040578 493449969878040578 | 2025-07-27T04:28:49.391105+00:00 | 1 | 9 | 3 | 0 | 64000000 | ||
| 530 | 493449969878040578 493449969878040578 | 2025-07-27T04:28:49.391105+00:00 | 1 | 10 | 3 | 1 | 自動產生，關聯至完整刀 ID:529 | 529 | |
| 531 | 493449969878040578 493449969878040578 | 2025-07-27T04:30:22.989505+00:00 | 1 | 10 | 3 | 0 | 64000000 | ||
| 532 | 493449969878040578 493449969878040578 | 2025-07-27T04:30:22.989505+00:00 | 1 | 11 | 3 | 1 | 自動產生，關聯至完整刀 ID:531 | 531 | |
| 533 | 493449969878040578 493449969878040578 | 2025-07-27T04:32:08.136579+00:00 | 1 | 9 | 2 | 0 | 56000000 | ||
| 534 | 493449969878040578 493449969878040578 | 2025-07-27T04:32:08.136579+00:00 | 1 | 10 | 2 | 1 | 自動產生，關聯至完整刀 ID:533 | 533 | |
| 535 | 493449969878040578 493449969878040578 | 2025-07-27T04:33:42.680367+00:00 | 1 | 10 | 2 | 0 | 56000000 | ||
| 536 | 493449969878040578 493449969878040578 | 2025-07-27T04:33:42.680367+00:00 | 1 | 11 | 2 | 1 | 自動產生，關聯至完整刀 ID:535 | 535 | |
| 670 | 493449969878040578 493449969878040578 | 2025-07-28T04:08:21.744042+00:00 | 2 | 25 | 3 | 0 | 270892319 | ||
| 672 | 493449969878040578 493449969878040578 | 2025-07-28T04:16:05.056941+00:00 | 2 | 24 | 4 | 0 | 238797414 | ||
| 674 | 493449969878040578 493449969878040578 | 2025-07-28T04:37:20.085592+00:00 | 2 | 24 | 5 | 0 | 63221227 | ||
| 675 | 493449969878040578 493449969878040578 | 2025-07-28T04:41:53.740814+00:00 | 2 | 25 | 5 | 1 | 276600427 | ||
| 786 | 493449969878040578 493449969878040578 | 2025-07-29T04:21:37.353919+00:00 | 3 | 29 | 4 | 0 | 239317462 | ||
| 787 | 493449969878040578 493449969878040578 | 2025-07-29T04:25:55.349507+00:00 | 3 | 30 | 3 | 0 | 271055128 | ||
| 789 | 493449969878040578 493449969878040578 | 2025-07-29T04:30:00.478916+00:00 | 3 | 30 | 5 | 0 | 277846203 | ||
| 897 | 493449969878040578 493449969878040578 | 2025-07-30T04:07:48.791921+00:00 | 4 | 33 | 4 | 0 | 239909960 | ||
| 899 | 493449969878040578 493449969878040578 | 2025-07-30T04:12:03.543028+00:00 | 4 | 34 | 3 | 0 | 268972726 | ||
| 902 | 493449969878040578 493449969878040578 | 2025-07-30T04:42:23.912207+00:00 | 4 | 34 | 5 | 0 | 274247346 | ||
| 1016 | 493449969878040578 493449969878040578 | 2025-07-31T04:08:32.853123+00:00 | 5 | 38 | 4 | 0 | 242964052 | ||
| 1017 | 493449969878040578 493449969878040578 | 2025-07-31T04:12:12.409754+00:00 | 5 | 39 | 5 | 0 | 278613924 | ||
| 1021 | 493449969878040578 493449969878040578 | 2025-07-31T04:47:42.348506+00:00 | 5 | 38 | 3 | 0 | 116659693 | ||
| 1022 | 493449969878040578 493449969878040578 | 2025-07-31T04:51:59.430041+00:00 | 5 | 39 | 3 | 1 | 206512478 | ||
| 1138 | 493449969878040578 493449969878040578 | 2025-08-27T04:27:40.924776+00:00 | 1 | 7 | 5 | 0 | 85000000 | ||
| 1139 | 493449969878040578 493449969878040578 | 2025-08-27T04:27:40.924776+00:00 | 1 | 8 | 5 | 1 | 自動產生，關聯至完整刀 ID:1138 | 1138 | |
| 1142 | 493449969878040578 493449969878040578 | 2025-08-27T04:32:35.139964+00:00 | 1 | 7 | 4 | 0 | 70000000 | ||
| 1143 | 493449969878040578 493449969878040578 | 2025-08-27T04:32:35.139964+00:00 | 1 | 8 | 4 | 1 | 自動產生，關聯至完整刀 ID:1142 | 1142 | |
| 1144 | 493449969878040578 493449969878040578 | 2025-08-27T04:35:50.970526+00:00 | 1 | 7 | 3 | 0 | 64000000 | ||
| 1145 | 493449969878040578 493449969878040578 | 2025-08-27T04:35:50.970526+00:00 | 1 | 8 | 3 | 1 | 自動產生，關聯至完整刀 ID:1144 | 1144 | |
| 1295 | 493449969878040578 493449969878040578 | 2025-08-28T04:13:46.031886+00:00 | 2 | 25 | 3 | 0 | 276000053 | ||
| 1298 | 493449969878040578 493449969878040578 | 2025-08-28T04:22:40.402401+00:00 | 2 | 24 | 5 | 0 | 261454165 | ||
| 1376 | 493449969878040578 493449969878040578 | 2025-08-28T15:44:41.208640+00:00 | 2 | 28 | 4 | 0 | 380776025 | ||
| 1415 | 493449969878040578 493449969878040578 | 2025-08-29T04:17:24.700823+00:00 | 3 | 30 | 4 | 0 | 380626880 | ||
| 1416 | 493449969878040578 493449969878040578 | 2025-08-29T04:21:30.500974+00:00 | 3 | 30 | 3 | 0 | 276477459 | ||
| 1478 | 493449969878040578 493449969878040578 | 2025-08-29T15:51:00.718575+00:00 | 3 | 32 | 5 | 0 | 261861901 | ||
| 1530 | 493449969878040578 493449969878040578 | 2025-08-30T04:17:16.453953+00:00 | 4 | 34 | 3 | 0 | 279955100 | ||
| 1533 | 493449969878040578 493449969878040578 | 2025-08-30T04:23:08.862807+00:00 | 4 | 34 | 5 | 0 | 248756812 | ||
| 1536 | 493449969878040578 493449969878040578 | 2025-08-30T04:31:41.770519+00:00 | 4 | 34 | 4 | 0 | 380327405 | ||
| 1632 | 493449969878040578 493449969878040578 | 2025-08-31T02:05:25.501300+00:00 | 5 | 38 | 5 | 0 | 261154022 | ||
| 1643 | 493449969878040578 493449969878040578 | 2025-08-31T04:32:49.599524+00:00 | 5 | 39 | 4 | 0 | 379724536 | ||
| 1648 | 493449969878040578 493449969878040578 | 2025-08-31T04:41:25.422127+00:00 | 5 | 38 | 3 | 0 | 187701285 | ||
| 1651 | 493449969878040578 493449969878040578 | 2025-08-31T04:44:51.399301+00:00 | 5 | 39 | 3 | 1 | 117387037 | ||
| 1797 | 493449969878040578 493449969878040578 | 2025-09-26T04:24:07.448643+00:00 | 1 | 9 | 5 | 0 | |||
| 1798 | 493449969878040578 493449969878040578 | 2025-09-26T04:24:07.448643+00:00 | 1 | 10 | 5 | 1 | 自動產生，關聯至完整刀 ID:1797 | 1797 | |
| 1799 | 493449969878040578 493449969878040578 | 2025-09-26T04:27:51.601633+00:00 | 1 | 11 | 4 | 0 | |||
| 1800 | 493449969878040578 493449969878040578 | 2025-09-26T04:27:51.601633+00:00 | 1 | 12 | 4 | 1 | 自動產生，關聯至完整刀 ID:1799 | 1799 | |
| 1801 | 493449969878040578 493449969878040578 | 2025-09-26T04:32:55.048282+00:00 | 1 | 11 | 3 | 0 | |||
| 1802 | 493449969878040578 493449969878040578 | 2025-09-26T04:32:55.048282+00:00 | 1 | 12 | 3 | 1 | 自動產生，關聯至完整刀 ID:1801 | 1801 | |
| 1921 | 493449969878040578 493449969878040578 | 2025-09-27T04:33:49.378148+00:00 | 2 | 25 | 4 | 0 | 257597444 | ||
| 1938 | 493449969878040578 493449969878040578 | 2025-09-27T05:46:27.667965+00:00 | 2 | 26 | 3 | 0 | 380114024 | ||
| 1980 | 493449969878040578 493449969878040578 | 2025-09-27T15:48:31.357653+00:00 | 2 | 27 | 5 | 0 | 292575024 | ||
| 2035 | 493449969878040578 493449969878040578 | 2025-09-28T05:36:55.877267+00:00 | 3 | 30 | 5 | 0 | 292576309 | ||
| 2109 | 493449969878040578 493449969878040578 | 2025-09-28T15:43:23.564734+00:00 | 3 | 33 | 4 | 0 | 286674185 | ||
| 2114 | 493449969878040578 493449969878040578 | 2025-09-28T15:58:10.462381+00:00 | 3 | 34 | 3 | 0 | 379032743 | ||
| 2136 | 493449969878040578 493449969878040578 | 2025-09-29T04:20:58.404403+00:00 | 4 | 33 | 5 | 0 | 87074708 | ||
| 2143 | 493449969878040578 493449969878040578 | 2025-09-29T04:32:35.237356+00:00 | 4 | 34 | 5 | 1 | 174659800 | ||
| 2159 | 493449969878040578 493449969878040578 | 2025-09-29T05:39:42.699288+00:00 | 4 | 35 | 4 | 0 | 284430783 | ||
| 2160 | 493449969878040578 493449969878040578 | 2025-09-29T05:46:37.604225+00:00 | 4 | 36 | 3 | 0 | 379157934 | ||
| 2252 | 493449969878040578 493449969878040578 | 2025-09-30T01:56:53.899484+00:00 | 5 | 39 | 4 | 0 | 286134133 | ||
| 2254 | 493449969878040578 493449969878040578 | 2025-09-30T02:06:02.828310+00:00 | 5 | 39 | 5 | 0 | 292399677 | ||
| 2264 | 493449969878040578 493449969878040578 | 2025-09-30T05:04:31.118929+00:00 | 5 | 40 | 3 | 0 | 379662401 |
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)
);