attacks
69 rows where member_id = 1378503431311851520
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 |
|---|---|---|---|---|---|---|---|---|---|
| 457 | 1378503431311851520 1378503431311851520 | 2025-07-26T21:31:42.245408+00:00 | 1 | 1 | 3 | 0 | 20000000 | ||
| 458 | 1378503431311851520 1378503431311851520 | 2025-07-26T21:31:42.245408+00:00 | 1 | 2 | 3 | 1 | 自動產生，關聯至完整刀 ID:457 | 457 | |
| 461 | 1378503431311851520 1378503431311851520 | 2025-07-26T21:32:46.923736+00:00 | 1 | 1 | 5 | 0 | 30000000 | ||
| 462 | 1378503431311851520 1378503431311851520 | 2025-07-26T21:32:46.923736+00:00 | 1 | 2 | 5 | 1 | 自動產生，關聯至完整刀 ID:461 | 461 | |
| 465 | 1378503431311851520 1378503431311851520 | 2025-07-26T21:33:47.658387+00:00 | 1 | 1 | 4 | 0 | 23000000 | ||
| 466 | 1378503431311851520 1378503431311851520 | 2025-07-26T21:33:47.658387+00:00 | 1 | 2 | 4 | 1 | 自動產生，關聯至完整刀 ID:465 | 465 | |
| 664 | 1378503431311851520 1378503431311851520 | 2025-07-27T21:41:38.787132+00:00 | 2 | 24 | 3 | 0 | 51572326 | ||
| 665 | 1378503431311851520 1378503431311851520 | 2025-07-27T21:46:38.666784+00:00 | 2 | 25 | 3 | 1 | 227986815 | ||
| 676 | 1378503431311851520 1378503431311851520 | 2025-07-28T04:46:21.052109+00:00 | 2 | 24 | 4 | 0 | 201806960 | ||
| 711 | 1378503431311851520 1378503431311851520 | 2025-07-28T13:30:50.506745+00:00 | 2 | 26 | 1 | 0 | 316856859 | ||
| 712 | 1378503431311851520 1378503431311851520 | 2025-07-28T13:35:36.543396+00:00 | 2 | 26 | 1 | 1 | 37458952 | ||
| 778 | 1378503431311851520 1378503431311851520 | 2025-07-28T22:54:09.186945+00:00 | 3 | 29 | 1 | 0 | 317612604 | ||
| 779 | 1378503431311851520 1378503431311851520 | 2025-07-28T23:24:47.207688+00:00 | 3 | 28 | 4 | 0 | 246335050 | ||
| 780 | 1378503431311851520 1378503431311851520 | 2025-07-28T23:34:41.599676+00:00 | 3 | 29 | 3 | 0 | 270149549 | ||
| 886 | 1378503431311851520 1378503431311851520 | 2025-07-29T21:56:19.151322+00:00 | 4 | 33 | 4 | 0 | 246194609 | ||
| 888 | 1378503431311851520 1378503431311851520 | 2025-07-29T22:14:35.794572+00:00 | 4 | 33 | 3 | 1 | 65779838 | ||
| 889 | 1378503431311851520 1378503431311851520 | 2025-07-29T22:21:38.897868+00:00 | 4 | 33 | 1 | 1 | 39925052 | ||
| 890 | 1378503431311851520 1378503431311851520 | 2025-07-29T22:22:19.546010+00:00 | 4 | 33 | 3 | 0 | 245832498 | ||
| 891 | 1378503431311851520 1378503431311851520 | 2025-07-29T22:37:05.159974+00:00 | 4 | 33 | 2 | 0 | 192722494 | ||
| 993 | 1378503431311851520 1378503431311851520 | 2025-07-30T21:07:40.573400+00:00 | 5 | 37 | 4 | 0 | 226604802 | ||
| 994 | 1378503431311851520 1378503431311851520 | 2025-07-30T21:12:52.626810+00:00 | 5 | 37 | 4 | 0 | 668298 | ||
| 996 | 1378503431311851520 1378503431311851520 | 2025-07-30T21:17:43.976158+00:00 | 5 | 38 | 1 | 1 | 256666530 | ||
| 997 | 1378503431311851520 1378503431311851520 | 2025-07-30T21:25:39.440845+00:00 | 5 | 37 | 3 | 0 | 159312719 | ||
| 998 | 1378503431311851520 1378503431311851520 | 2025-07-30T21:26:15.049769+00:00 | 5 | 38 | 3 | 1 | 107882498 | ||
| 1108 | 1378503431311851520 1378503431311851520 | 2025-08-26T21:16:18.324843+00:00 | 1 | 1 | 5 | 0 | |||
| 1109 | 1378503431311851520 1378503431311851520 | 2025-08-26T21:16:18.324843+00:00 | 1 | 2 | 5 | 1 | 自動產生，關聯至完整刀 ID:1108 | 1108 | |
| 1110 | 1378503431311851520 1378503431311851520 | 2025-08-26T21:20:34.161230+00:00 | 1 | 1 | 4 | 0 | |||
| 1111 | 1378503431311851520 1378503431311851520 | 2025-08-26T21:20:34.161230+00:00 | 1 | 2 | 4 | 1 | 自動產生，關聯至完整刀 ID:1110 | 1110 | |
| 1112 | 1378503431311851520 1378503431311851520 | 2025-08-26T21:24:56.162696+00:00 | 1 | 1 | 3 | 0 | |||
| 1113 | 1378503431311851520 1378503431311851520 | 2025-08-26T21:24:56.162696+00:00 | 1 | 2 | 3 | 1 | 自動產生，關聯至完整刀 ID:1112 | 1112 | |
| 1283 | 1378503431311851520 1378503431311851520 | 2025-08-27T21:18:36.728346+00:00 | 2 | 24 | 2 | 0 | 251922864 | ||
| 1284 | 1378503431311851520 1378503431311851520 | 2025-08-27T21:28:24.916409+00:00 | 2 | 24 | 1 | 0 | 282991201 | ||
| 1285 | 1378503431311851520 1378503431311851520 | 2025-08-27T21:42:15.237759+00:00 | 2 | 24 | 4 | 0 | 46698172 | ||
| 1286 | 1378503431311851520 1378503431311851520 | 2025-08-27T21:54:50.373229+00:00 | 2 | 25 | 4 | 0 | 383088997 | ||
| 1399 | 1378503431311851520 1378503431311851520 | 2025-08-28T21:20:06.076926+00:00 | 3 | 28 | 1 | 0 | 163518520 | ||
| 1401 | 1378503431311851520 1378503431311851520 | 2025-08-28T21:26:34.731324+00:00 | 3 | 28 | 2 | 0 | 251814353 | ||
| 1402 | 1378503431311851520 1378503431311851520 | 2025-08-28T21:37:17.671106+00:00 | 3 | 28 | 5 | 1 | 54122406 | ||
| 1405 | 1378503431311851520 1378503431311851520 | 2025-08-28T22:08:00.242944+00:00 | 3 | 29 | 1 | 1 | 24639461 | ||
| 1511 | 1378503431311851520 1378503431311851520 | 2025-08-29T21:17:28.200991+00:00 | 4 | 33 | 3 | 0 | 243976959 | ||
| 1625 | 1378503431311851520 1378503431311851520 | 2025-08-30T18:09:23.383826+00:00 | 4 | 37 | 2 | 0 | 124079616 | ||
| 1627 | 1378503431311851520 1378503431311851520 | 2025-08-30T18:25:09.323168+00:00 | 4 | 37 | 5 | 1 | 49478664 | ||
| 1628 | 1378503431311851520 1378503431311851520 | 2025-08-30T18:46:06.868561+00:00 | 4 | 38 | 5 | 0 | 266293954 | ||
| 1629 | 1378503431311851520 1378503431311851520 | 2025-08-30T18:50:34.679644+00:00 | 4 | 37 | 1 | 1 | 29546303 | ||
| 1630 | 1378503431311851520 1378503431311851520 | 2025-08-30T18:50:48.563441+00:00 | 4 | 37 | 1 | 1 | 123035288 | ||
| 1635 | 1378503431311851520 1378503431311851520 | 2025-08-31T04:05:16.207777+00:00 | 5 | 37 | 1 | 0 | 283409045 | ||
| 1644 | 1378503431311851520 1378503431311851520 | 2025-08-31T04:33:35.470417+00:00 | 5 | 36 | 2 | 0 | 249022289 | ||
| 1649 | 1378503431311851520 1378503431311851520 | 2025-08-31T04:41:50.311036+00:00 | 5 | 38 | 3 | 0 | 273956131 | ||
| 1749 | 1378503431311851520 1378503431311851520 | 2025-09-25T21:20:51.707284+00:00 | 1 | 1 | 4 | 0 | |||
| 1750 | 1378503431311851520 1378503431311851520 | 2025-09-25T21:20:51.707284+00:00 | 1 | 2 | 4 | 1 | 自動產生，關聯至完整刀 ID:1749 | 1749 | |
| 1751 | 1378503431311851520 1378503431311851520 | 2025-09-25T21:21:20.012378+00:00 | 1 | 1 | 5 | 0 | |||
| 1752 | 1378503431311851520 1378503431311851520 | 2025-09-25T21:21:20.012378+00:00 | 1 | 2 | 5 | 1 | 自動產生，關聯至完整刀 ID:1751 | 1751 | |
| 1753 | 1378503431311851520 1378503431311851520 | 2025-09-25T21:24:38.101919+00:00 | 1 | 1 | 3 | 0 | |||
| 1754 | 1378503431311851520 1378503431311851520 | 2025-09-25T21:24:38.101919+00:00 | 1 | 2 | 3 | 1 | 自動產生，關聯至完整刀 ID:1753 | 1753 | |
| 2010 | 1378503431311851520 1378503431311851520 | 2025-09-27T20:17:43.613352+00:00 | 2 | 28 | 5 | 0 | 133219632 | ||
| 2011 | 1378503431311851520 1378503431311851520 | 2025-09-27T20:23:39.147647+00:00 | 2 | 29 | 5 | 1 | 167869169 | ||
| 2012 | 1378503431311851520 1378503431311851520 | 2025-09-27T20:42:54.915458+00:00 | 2 | 29 | 5 | 0 | 268457766 | ||
| 2013 | 1378503431311851520 1378503431311851520 | 2025-09-27T20:57:48.888378+00:00 | 2 | 29 | 1 | 0 | 249361311 | ||
| 2018 | 1378503431311851520 1378503431311851520 | 2025-09-27T21:45:32.455704+00:00 | 3 | 29 | 1 | 0 | 128406226 | ||
| 2019 | 1378503431311851520 1378503431311851520 | 2025-09-27T21:48:03.297258+00:00 | 3 | 30 | 1 | 1 | 186763950 | ||
| 2020 | 1378503431311851520 1378503431311851520 | 2025-09-27T22:03:52.629411+00:00 | 3 | 29 | 3 | 0 | 355518923 | ||
| 2023 | 1378503431311851520 1378503431311851520 | 2025-09-27T22:20:32.275759+00:00 | 3 | 30 | 4 | 0 | 286417490 | ||
| 2199 | 1378503431311851520 1378503431311851520 | 2025-09-29T13:57:46.958710+00:00 | 4 | 36 | 5 | 0 | 89508494 | ||
| 2200 | 1378503431311851520 1378503431311851520 | 2025-09-29T14:02:59.896729+00:00 | 4 | 37 | 5 | 1 | 176420715 | ||
| 2201 | 1378503431311851520 1378503431311851520 | 2025-09-29T14:35:51.931602+00:00 | 4 | 37 | 2 | 0 | 317462142 | ||
| 2205 | 1378503431311851520 1378503431311851520 | 2025-09-29T14:55:59.040356+00:00 | 4 | 37 | 4 | 0 | 248925003 | ||
| 2283 | 1378503431311851520 1378503431311851520 | 2025-09-30T11:55:15.328756+00:00 | 5 | 40 | 5 | 0 | 298484295 | ||
| 2288 | 1378503431311851520 1378503431311851520 | 2025-09-30T12:07:33.098878+00:00 | 5 | 41 | 1 | 1 | 219769063 | ||
| 2289 | 1378503431311851520 1378503431311851520 | 2025-09-30T12:14:06.461268+00:00 | 5 | 40 | 4 | 0 | 284366434 | ||
| 2354 | 1378503431311851520 1378503431311851520 | 2025-09-30T15:33:12.624774+00:00 | 5 | 40 | 1 | 0 | 143099133 |
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)
);