attacks
75 rows where member_id = 344478874354319371
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 |
|---|---|---|---|---|---|---|---|---|---|
| 164 | 344478874354319371 344478874354319371 | 2025-06-27T15:35:29.639944+00:00 | 2 | 27 | 3 | 0 | 163605651 | ||
| 168 | 344478874354319371 344478874354319371 | 2025-06-27T15:54:39.587734+00:00 | 2 | 27 | 5 | 0 | 162431995 | ||
| 170 | 344478874354319371 344478874354319371 | 2025-06-27T16:03:34.429636+00:00 | 2 | 27 | 1 | 0 | 150306591 | ||
| 175 | 344478874354319371 344478874354319371 | 2025-06-27T16:18:44.998007+00:00 | 2 | 28 | 5 | 1 | 42378678 | ||
| 230 | 344478874354319371 344478874354319371 | 2025-06-28T09:48:03.780323+00:00 | 3 | 30 | 3 | 0 | 168023382 | ||
| 242 | 344478874354319371 344478874354319371 | 2025-06-28T10:29:04.179553+00:00 | 3 | 31 | 1 | 0 | 163052132 | ||
| 269 | 344478874354319371 344478874354319371 | 2025-06-28T15:23:28.660503+00:00 | 3 | 31 | 5 | 0 | 1337826 | ||
| 270 | 344478874354319371 344478874354319371 | 2025-06-28T15:32:01.392185+00:00 | 3 | 32 | 5 | 1 | 201754110 | ||
| 343 | 344478874354319371 344478874354319371 | 2025-06-29T13:01:55.717866+00:00 | 4 | 36 | 5 | 0 | 204568874 | ||
| 349 | 344478874354319371 344478874354319371 | 2025-06-29T13:21:02.449063+00:00 | 4 | 35 | 1 | 0 | 26226194 | ||
| 351 | 344478874354319371 344478874354319371 | 2025-06-29T13:25:26.273912+00:00 | 4 | 36 | 1 | 1 | 162852510 | ||
| 352 | 344478874354319371 344478874354319371 | 2025-06-29T13:34:35.238115+00:00 | 4 | 36 | 3 | 0 | 168778498 | ||
| 394 | 344478874354319371 344478874354319371 | 2025-06-30T08:19:17.052974+00:00 | 5 | 39 | 3 | 0 | 168314710 | ||
| 397 | 344478874354319371 344478874354319371 | 2025-06-30T10:16:51.660856+00:00 | 5 | 39 | 5 | 0 | 203441162 | ||
| 399 | 344478874354319371 344478874354319371 | 2025-06-30T10:23:23.047100+00:00 | 5 | 38 | 1 | 0 | 49579785 | ||
| 400 | 344478874354319371 344478874354319371 | 2025-06-30T10:27:12.618575+00:00 | 5 | 39 | 1 | 1 | 150741300 | ||
| 592 | 344478874354319371 344478874354319371 | 2025-07-27T10:09:34.234798+00:00 | 1 | 19 | 1 | 0 | 50000000 | ||
| 593 | 344478874354319371 344478874354319371 | 2025-07-27T10:09:34.234798+00:00 | 1 | 20 | 1 | 1 | 自動產生，關聯至完整刀 ID:592 | 592 | |
| 594 | 344478874354319371 344478874354319371 | 2025-07-27T10:13:54.362541+00:00 | 1 | 19 | 2 | 0 | 56000000 | ||
| 595 | 344478874354319371 344478874354319371 | 2025-07-27T10:13:54.362541+00:00 | 1 | 20 | 2 | 1 | 自動產生，關聯至完整刀 ID:594 | 594 | |
| 596 | 344478874354319371 344478874354319371 | 2025-07-27T10:21:33.081617+00:00 | 1 | 19 | 3 | 0 | 64000000 | ||
| 597 | 344478874354319371 344478874354319371 | 2025-07-27T10:21:33.081617+00:00 | 1 | 20 | 3 | 1 | 自動產生，關聯至完整刀 ID:596 | 596 | |
| 707 | 344478874354319371 344478874354319371 | 2025-07-28T13:19:58.525538+00:00 | 2 | 26 | 4 | 0 | 233454420 | ||
| 724 | 344478874354319371 344478874354319371 | 2025-07-28T14:26:39.088858+00:00 | 2 | 27 | 5 | 0 | 270371184 | ||
| 732 | 344478874354319371 344478874354319371 | 2025-07-28T14:43:53.335402+00:00 | 2 | 26 | 1 | 0 | 308440089 | ||
| 856 | 344478874354319371 344478874354319371 | 2025-07-29T14:31:08.444210+00:00 | 3 | 32 | 4 | 0 | 234987331 | ||
| 859 | 344478874354319371 344478874354319371 | 2025-07-29T14:48:44.154131+00:00 | 3 | 32 | 1 | 0 | 300719671 | ||
| 861 | 344478874354319371 344478874354319371 | 2025-07-29T15:02:24.251260+00:00 | 3 | 33 | 1 | 1 | 31733372 | ||
| 867 | 344478874354319371 344478874354319371 | 2025-07-29T16:40:58.803380+00:00 | 3 | 33 | 5 | 0 | 263536642 | ||
| 917 | 344478874354319371 344478874354319371 | 2025-07-30T10:48:48.501587+00:00 | 4 | 35 | 1 | 0 | 308275164 | ||
| 927 | 344478874354319371 344478874354319371 | 2025-07-30T12:42:58.991095+00:00 | 4 | 35 | 5 | 0 | 270058320 | ||
| 938 | 344478874354319371 344478874354319371 | 2025-07-30T13:00:39.839621+00:00 | 4 | 35 | 4 | 0 | 235078272 | ||
| 1030 | 344478874354319371 344478874354319371 | 2025-07-31T07:12:57.276038+00:00 | 5 | 39 | 4 | 0 | 232249261 | ||
| 1031 | 344478874354319371 344478874354319371 | 2025-07-31T07:18:48.494904+00:00 | 5 | 40 | 5 | 0 | 268593007 | ||
| 1072 | 344478874354319371 344478874354319371 | 2025-07-31T13:04:49.688642+00:00 | 5 | 41 | 1 | 0 | 308643424 | ||
| 1202 | 344478874354319371 344478874354319371 | 2025-08-27T10:16:39.338524+00:00 | 1 | 17 | 2 | 0 | 56000000 | ||
| 1203 | 344478874354319371 344478874354319371 | 2025-08-27T10:16:39.338524+00:00 | 1 | 18 | 2 | 1 | 自動產生，關聯至完整刀 ID:1202 | 1202 | |
| 1206 | 344478874354319371 344478874354319371 | 2025-08-27T10:22:40.301368+00:00 | 1 | 17 | 4 | 0 | 70000000 | ||
| 1207 | 344478874354319371 344478874354319371 | 2025-08-27T10:22:40.301368+00:00 | 1 | 18 | 4 | 1 | 自動產生，關聯至完整刀 ID:1206 | 1206 | |
| 1208 | 344478874354319371 344478874354319371 | 2025-08-27T10:28:20.985094+00:00 | 1 | 17 | 5 | 0 | 85000000 | ||
| 1209 | 344478874354319371 344478874354319371 | 2025-08-27T10:28:20.985094+00:00 | 1 | 18 | 5 | 1 | 自動產生，關聯至完整刀 ID:1208 | 1208 | |
| 1362 | 344478874354319371 344478874354319371 | 2025-08-28T14:15:07.971416+00:00 | 2 | 27 | 2 | 0 | 218233492 | ||
| 1370 | 344478874354319371 344478874354319371 | 2025-08-28T14:43:39.920903+00:00 | 2 | 27 | 4 | 0 | 114760144 | ||
| 1371 | 344478874354319371 344478874354319371 | 2025-08-28T14:48:54.101922+00:00 | 2 | 28 | 4 | 1 | 318336237 | ||
| 1375 | 344478874354319371 344478874354319371 | 2025-08-28T15:42:44.707997+00:00 | 2 | 28 | 5 | 0 | 255812982 | ||
| 1429 | 344478874354319371 344478874354319371 | 2025-08-29T12:57:19.670106+00:00 | 3 | 29 | 2 | 0 | 156823528 | ||
| 1433 | 344478874354319371 344478874354319371 | 2025-08-29T13:12:04.834000+00:00 | 3 | 30 | 2 | 1 | 70672349 | ||
| 1447 | 344478874354319371 344478874354319371 | 2025-08-29T13:40:14.409122+00:00 | 3 | 31 | 5 | 0 | 255757530 | ||
| 1457 | 344478874354319371 344478874354319371 | 2025-08-29T14:27:00.460876+00:00 | 3 | 30 | 1 | 0 | 321624708 | ||
| 1542 | 344478874354319371 344478874354319371 | 2025-08-30T06:42:54.814769+00:00 | 4 | 34 | 1 | 0 | 320718244 | ||
| 1567 | 344478874354319371 344478874354319371 | 2025-08-30T12:58:20.871921+00:00 | 4 | 36 | 5 | 0 | 255203506 | ||
| 1583 | 344478874354319371 344478874354319371 | 2025-08-30T14:32:53.222941+00:00 | 4 | 36 | 2 | 0 | 217683610 | ||
| 1656 | 344478874354319371 344478874354319371 | 2025-08-31T05:41:35.838957+00:00 | 5 | 38 | 1 | 0 | 325659142 | ||
| 1657 | 344478874354319371 344478874354319371 | 2025-08-31T06:02:34.445984+00:00 | 5 | 39 | 2 | 0 | 218488051 | ||
| 1660 | 344478874354319371 344478874354319371 | 2025-08-31T06:10:34.689202+00:00 | 5 | 39 | 5 | 0 | 255225521 | ||
| 1833 | 344478874354319371 344478874354319371 | 2025-09-26T09:40:33.016051+00:00 | 1 | 15 | 1 | 0 | |||
| 1834 | 344478874354319371 344478874354319371 | 2025-09-26T09:40:33.016051+00:00 | 1 | 16 | 1 | 1 | 自動產生，關聯至完整刀 ID:1833 | 1833 | |
| 1835 | 344478874354319371 344478874354319371 | 2025-09-26T09:49:07.815799+00:00 | 1 | 17 | 2 | 0 | |||
| 1836 | 344478874354319371 344478874354319371 | 2025-09-26T09:49:07.815799+00:00 | 1 | 18 | 2 | 1 | 自動產生，關聯至完整刀 ID:1835 | 1835 | |
| 1837 | 344478874354319371 344478874354319371 | 2025-09-26T09:59:20.673770+00:00 | 1 | 17 | 5 | 0 | |||
| 1838 | 344478874354319371 344478874354319371 | 2025-09-26T09:59:20.673770+00:00 | 1 | 18 | 5 | 1 | 自動產生，關聯至完整刀 ID:1837 | 1837 | |
| 1967 | 344478874354319371 344478874354319371 | 2025-09-27T14:49:54.053467+00:00 | 2 | 26 | 1 | 0 | 214018429 | ||
| 1970 | 344478874354319371 344478874354319371 | 2025-09-27T14:58:14.971584+00:00 | 2 | 27 | 1 | 1 | 90123876 | ||
| 1976 | 344478874354319371 344478874354319371 | 2025-09-27T15:30:52.108700+00:00 | 2 | 27 | 3 | 0 | 386731570 | ||
| 1994 | 344478874354319371 344478874354319371 | 2025-09-27T16:59:49.304501+00:00 | 2 | 28 | 5 | 0 | 290305568 | ||
| 2083 | 344478874354319371 344478874354319371 | 2025-09-28T14:29:25.543821+00:00 | 3 | 31 | 1 | 0 | 304630918 | ||
| 2091 | 344478874354319371 344478874354319371 | 2025-09-28T14:42:21.790951+00:00 | 3 | 32 | 5 | 0 | 309948338 | ||
| 2112 | 344478874354319371 344478874354319371 | 2025-09-28T15:47:00.741231+00:00 | 3 | 33 | 3 | 0 | 373131751 | ||
| 2187 | 344478874354319371 344478874354319371 | 2025-09-29T12:25:55.969799+00:00 | 4 | 36 | 1 | 0 | 123941514 | ||
| 2189 | 344478874354319371 344478874354319371 | 2025-09-29T12:31:06.188730+00:00 | 4 | 37 | 1 | 1 | 225102747 | ||
| 2195 | 344478874354319371 344478874354319371 | 2025-09-29T13:21:14.453781+00:00 | 4 | 37 | 3 | 0 | 387131741 | ||
| 2203 | 344478874354319371 344478874354319371 | 2025-09-29T14:44:44.621646+00:00 | 4 | 37 | 5 | 0 | 308643939 | ||
| 2286 | 344478874354319371 344478874354319371 | 2025-09-30T12:03:38.950060+00:00 | 5 | 40 | 1 | 0 | 305757459 | ||
| 2311 | 344478874354319371 344478874354319371 | 2025-09-30T13:01:25.283218+00:00 | 5 | 42 | 3 | 0 | 323408924 | ||
| 2317 | 344478874354319371 344478874354319371 | 2025-09-30T13:17:04.493317+00:00 | 5 | 41 | 5 | 0 | 294722352 |
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)
);