attacks
74 rows where member_id = 508472239264628738
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 |
|---|---|---|---|---|---|---|---|---|---|
| 41 | 508472239264628738 508472239264628738 | 2025-06-26T02:04:01.301311+00:00 | 1 | 9 | 3 | 0 | |||
| 42 | 508472239264628738 508472239264628738 | 2025-06-26T02:04:01.301311+00:00 | 1 | 10 | 3 | 1 | 自動產生，關聯至完整刀 ID:41 | 41 | |
| 43 | 508472239264628738 508472239264628738 | 2025-06-26T02:12:50.172712+00:00 | 1 | 9 | 2 | 0 | |||
| 44 | 508472239264628738 508472239264628738 | 2025-06-26T02:12:50.172712+00:00 | 1 | 10 | 2 | 1 | 自動產生，關聯至完整刀 ID:43 | 43 | |
| 45 | 508472239264628738 508472239264628738 | 2025-06-26T02:15:33.278007+00:00 | 1 | 11 | 5 | 0 | |||
| 46 | 508472239264628738 508472239264628738 | 2025-06-26T02:15:33.278007+00:00 | 1 | 12 | 5 | 1 | 自動產生，關聯至完整刀 ID:45 | 45 | |
| 135 | 508472239264628738 508472239264628738 | 2025-06-27T12:39:19.674177+00:00 | 2 | 25 | 2 | 0 | 200722058 | ||
| 139 | 508472239264628738 508472239264628738 | 2025-06-27T12:46:04.309362+00:00 | 2 | 26 | 3 | 0 | 176493407 | ||
| 144 | 508472239264628738 508472239264628738 | 2025-06-27T13:27:58.429198+00:00 | 2 | 25 | 1 | 0 | 179896275 | ||
| 201 | 508472239264628738 508472239264628738 | 2025-06-28T00:30:05.111827+00:00 | 3 | 29 | 5 | 0 | 205686092 | ||
| 205 | 508472239264628738 508472239264628738 | 2025-06-28T02:19:40.962783+00:00 | 3 | 28 | 3 | 0 | 174828665 | ||
| 211 | 508472239264628738 508472239264628738 | 2025-06-28T05:22:04.204449+00:00 | 3 | 29 | 2 | 0 | 23616850 | ||
| 212 | 508472239264628738 508472239264628738 | 2025-06-28T05:26:34.143057+00:00 | 3 | 30 | 2 | 1 | 212367615 | ||
| 297 | 508472239264628738 508472239264628738 | 2025-06-29T03:59:48.913373+00:00 | 4 | 33 | 3 | 0 | 175711249 | ||
| 298 | 508472239264628738 508472239264628738 | 2025-06-29T04:06:24.068349+00:00 | 4 | 34 | 5 | 0 | 203726507 | ||
| 299 | 508472239264628738 508472239264628738 | 2025-06-29T04:20:01.336722+00:00 | 4 | 34 | 5 | 1 | 26595131 | ||
| 428 | 508472239264628738 508472239264628738 | 2025-06-30T12:54:43.303336+00:00 | 5 | 37 | 1 | 0 | 161276422 | ||
| 435 | 508472239264628738 508472239264628738 | 2025-06-30T13:16:28.911949+00:00 | 5 | 41 | 4 | 0 | 188573608 | ||
| 436 | 508472239264628738 508472239264628738 | 2025-06-30T13:27:21.395094+00:00 | 5 | 41 | 2 | 0 | 198690078 | ||
| 618 | 508472239264628738 508472239264628738 | 2025-07-27T13:11:28.285956+00:00 | 1 | 22 | 5 | 0 | 85000000 | ||
| 619 | 508472239264628738 508472239264628738 | 2025-07-27T13:11:28.285956+00:00 | 1 | 23 | 5 | 1 | 自動產生，關聯至完整刀 ID:618 | 618 | |
| 620 | 508472239264628738 508472239264628738 | 2025-07-27T13:17:33.835021+00:00 | 1 | 23 | 2 | 0 | 351095966 | ||
| 621 | 508472239264628738 508472239264628738 | 2025-07-27T13:24:26.149678+00:00 | 1 | 23 | 5 | 0 | 278083501 | ||
| 673 | 508472239264628738 508472239264628738 | 2025-07-28T04:36:10.849033+00:00 | 2 | 24 | 5 | 0 | 276741836 | ||
| 677 | 508472239264628738 508472239264628738 | 2025-07-28T04:52:53.548703+00:00 | 2 | 25 | 3 | 0 | 274252321 | ||
| 680 | 508472239264628738 508472239264628738 | 2025-07-28T06:07:12.128669+00:00 | 2 | 25 | 2 | 0 | 356292916 | ||
| 777 | 508472239264628738 508472239264628738 | 2025-07-28T21:08:55.402503+00:00 | 3 | 29 | 3 | 0 | 274228983 | ||
| 784 | 508472239264628738 508472239264628738 | 2025-07-29T04:11:03.710168+00:00 | 3 | 29 | 5 | 0 | 269326233 | ||
| 790 | 508472239264628738 508472239264628738 | 2025-07-29T04:30:37.655894+00:00 | 3 | 30 | 3 | 1 | 50567116 | ||
| 795 | 508472239264628738 508472239264628738 | 2025-07-29T05:05:59.010387+00:00 | 3 | 29 | 2 | 0 | 351874783 | ||
| 885 | 508472239264628738 508472239264628738 | 2025-07-29T21:52:56.882078+00:00 | 4 | 33 | 3 | 0 | 273572839 | ||
| 887 | 508472239264628738 508472239264628738 | 2025-07-29T21:57:23.178174+00:00 | 4 | 34 | 5 | 0 | 275307842 | ||
| 893 | 508472239264628738 508472239264628738 | 2025-07-29T22:39:14.651366+00:00 | 4 | 34 | 2 | 0 | 355726868 | ||
| 995 | 508472239264628738 508472239264628738 | 2025-07-30T21:16:25.281659+00:00 | 5 | 38 | 5 | 0 | 279078204 | ||
| 999 | 508472239264628738 508472239264628738 | 2025-07-30T21:28:53.974127+00:00 | 5 | 38 | 3 | 0 | 262018726 | ||
| 1000 | 508472239264628738 508472239264628738 | 2025-07-30T21:40:40.112405+00:00 | 5 | 38 | 2 | 0 | 357187954 | ||
| 1246 | 508472239264628738 508472239264628738 | 2025-08-27T13:10:03.885519+00:00 | 1 | 23 | 1 | 0 | 277129300 | ||
| 1247 | 508472239264628738 508472239264628738 | 2025-08-27T13:15:37.679985+00:00 | 1 | 23 | 4 | 0 | 381719894 | ||
| 1250 | 508472239264628738 508472239264628738 | 2025-08-27T13:22:11.500999+00:00 | 1 | 23 | 5 | 0 | 261584067 | ||
| 1287 | 508472239264628738 508472239264628738 | 2025-08-27T21:59:01.744494+00:00 | 2 | 25 | 4 | 0 | 381734454 | ||
| 1288 | 508472239264628738 508472239264628738 | 2025-08-27T22:07:28.291513+00:00 | 2 | 24 | 1 | 0 | 298497291 | ||
| 1289 | 508472239264628738 508472239264628738 | 2025-08-27T22:25:08.240028+00:00 | 2 | 25 | 3 | 1 | 45087733 | ||
| 1303 | 508472239264628738 508472239264628738 | 2025-08-28T05:05:47.543560+00:00 | 2 | 25 | 5 | 0 | 263864982 | ||
| 1398 | 508472239264628738 508472239264628738 | 2025-08-28T21:12:23.918055+00:00 | 3 | 29 | 4 | 0 | 380877092 | ||
| 1400 | 508472239264628738 508472239264628738 | 2025-08-28T21:26:28.688286+00:00 | 3 | 29 | 1 | 0 | 329378359 | ||
| 1403 | 508472239264628738 508472239264628738 | 2025-08-28T21:53:11.614354+00:00 | 3 | 29 | 5 | 0 | 268443935 | ||
| 1404 | 508472239264628738 508472239264628738 | 2025-08-28T21:59:07.343228+00:00 | 3 | 29 | 5 | 1 | 30139520 | ||
| 1512 | 508472239264628738 508472239264628738 | 2025-08-30T01:20:48.109002+00:00 | 4 | 33 | 1 | 0 | 330699856 | ||
| 1514 | 508472239264628738 508472239264628738 | 2025-08-30T01:21:23.190548+00:00 | 4 | 33 | 1 | 0 | 122410 | ||
| 1522 | 508472239264628738 508472239264628738 | 2025-08-30T02:55:08.746914+00:00 | 4 | 34 | 5 | 1 | 263978950 | ||
| 1524 | 508472239264628738 508472239264628738 | 2025-08-30T03:01:20.008432+00:00 | 4 | 33 | 4 | 0 | 88194233 | ||
| 1526 | 508472239264628738 508472239264628738 | 2025-08-30T03:06:00.570997+00:00 | 4 | 34 | 4 | 0 | 382175472 | ||
| 1631 | 508472239264628738 508472239264628738 | 2025-08-30T21:11:18.579972+00:00 | 5 | 38 | 5 | 0 | 266661224 | ||
| 1658 | 508472239264628738 508472239264628738 | 2025-08-31T06:09:58.385321+00:00 | 5 | 38 | 1 | 0 | 331404554 | ||
| 1662 | 508472239264628738 508472239264628738 | 2025-08-31T06:13:31.429619+00:00 | 5 | 39 | 5 | 1 | 29805633 | ||
| 1663 | 508472239264628738 508472239264628738 | 2025-08-31T06:14:27.552338+00:00 | 5 | 39 | 4 | 0 | 374416946 | ||
| 1866 | 508472239264628738 508472239264628738 | 2025-09-26T14:17:40.782749+00:00 | 1 | 23 | 1 | 0 | 309170258 | ||
| 1867 | 508472239264628738 508472239264628738 | 2025-09-26T14:22:34.746334+00:00 | 1 | 23 | 2 | 0 | 319199396 | ||
| 1869 | 508472239264628738 508472239264628738 | 2025-09-26T14:30:37.820521+00:00 | 1 | 23 | 3 | 0 | 381594501 | ||
| 1904 | 508472239264628738 508472239264628738 | 2025-09-26T21:21:10.603829+00:00 | 2 | 25 | 2 | 0 | 319018652 | ||
| 1905 | 508472239264628738 508472239264628738 | 2025-09-26T21:36:43.505604+00:00 | 2 | 24 | 3 | 0 | 24941213 | ||
| 1906 | 508472239264628738 508472239264628738 | 2025-09-26T21:45:50.907630+00:00 | 2 | 25 | 3 | 1 | 402084518 | ||
| 1958 | 508472239264628738 508472239264628738 | 2025-09-27T12:03:20.077654+00:00 | 2 | 26 | 5 | 0 | 297228241 | ||
| 2015 | 508472239264628738 508472239264628738 | 2025-09-27T21:35:11.324644+00:00 | 3 | 29 | 4 | 0 | 281193384 | ||
| 2016 | 508472239264628738 508472239264628738 | 2025-09-27T21:44:15.324279+00:00 | 3 | 29 | 5 | 0 | 297118004 | ||
| 2021 | 508472239264628738 508472239264628738 | 2025-09-27T22:05:22.633677+00:00 | 3 | 29 | 3 | 0 | 75273698 | ||
| 2022 | 508472239264628738 508472239264628738 | 2025-09-27T22:14:04.961593+00:00 | 3 | 30 | 3 | 1 | 402370633 | ||
| 2024 | 508472239264628738 508472239264628738 | 2025-09-27T22:26:10.831794+00:00 | 3 | 29 | 2 | 1 | 28948518 | ||
| 2142 | 508472239264628738 508472239264628738 | 2025-09-29T04:30:38.616524+00:00 | 4 | 35 | 3 | 0 | 394247612 | ||
| 2144 | 508472239264628738 508472239264628738 | 2025-09-29T04:35:04.128622+00:00 | 4 | 35 | 2 | 0 | 319538348 | ||
| 2145 | 508472239264628738 508472239264628738 | 2025-09-29T04:39:08.274461+00:00 | 4 | 35 | 1 | 0 | 312304275 | ||
| 2247 | 508472239264628738 508472239264628738 | 2025-09-29T22:29:38.647455+00:00 | 5 | 39 | 2 | 0 | 314632408 | ||
| 2248 | 508472239264628738 508472239264628738 | 2025-09-29T22:37:48.475769+00:00 | 5 | 39 | 5 | 0 | 297441551 | ||
| 2249 | 508472239264628738 508472239264628738 | 2025-09-29T22:45:50.195501+00:00 | 5 | 39 | 3 | 0 | 383963326 |
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)
);