attacks
83 rows where member_id = 299222924320309249
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 |
|---|---|---|---|---|---|---|---|---|---|
| 71 | 299222924320309249 299222924320309249 | 2025-06-26T11:58:24.548960+00:00 | 1 | 19 | 1 | 0 | |||
| 72 | 299222924320309249 299222924320309249 | 2025-06-26T11:58:24.548960+00:00 | 1 | 20 | 1 | 1 | 自動產生，關聯至完整刀 ID:71 | 71 | |
| 73 | 299222924320309249 299222924320309249 | 2025-06-26T12:02:07.130851+00:00 | 1 | 19 | 2 | 0 | |||
| 74 | 299222924320309249 299222924320309249 | 2025-06-26T12:02:07.130851+00:00 | 1 | 20 | 2 | 1 | 自動產生，關聯至完整刀 ID:73 | 73 | |
| 75 | 299222924320309249 299222924320309249 | 2025-06-26T12:05:26.832485+00:00 | 1 | 19 | 5 | 0 | |||
| 76 | 299222924320309249 299222924320309249 | 2025-06-26T12:05:26.832485+00:00 | 1 | 20 | 5 | 1 | 自動產生，關聯至完整刀 ID:75 | 75 | |
| 128 | 299222924320309249 299222924320309249 | 2025-06-27T08:23:23.060614+00:00 | 2 | 24 | 1 | 0 | 112388930 | ||
| 129 | 299222924320309249 299222924320309249 | 2025-06-27T08:25:25.974572+00:00 | 2 | 25 | 1 | 1 | 43567083 | ||
| 130 | 299222924320309249 299222924320309249 | 2025-06-27T09:19:41.022850+00:00 | 2 | 25 | 4 | 0 | 218663405 | ||
| 136 | 299222924320309249 299222924320309249 | 2025-06-27T12:39:36.738799+00:00 | 2 | 25 | 2 | 0 | 91101235 | ||
| 137 | 299222924320309249 299222924320309249 | 2025-06-27T12:42:28.627565+00:00 | 2 | 26 | 2 | 1 | 111095960 | ||
| 232 | 299222924320309249 299222924320309249 | 2025-06-28T10:05:53.723695+00:00 | 3 | 29 | 4 | 0 | 219730850 | ||
| 236 | 299222924320309249 299222924320309249 | 2025-06-28T10:18:00.220851+00:00 | 3 | 30 | 1 | 0 | 145903841 | ||
| 238 | 299222924320309249 299222924320309249 | 2025-06-28T10:22:45.386101+00:00 | 3 | 30 | 2 | 0 | 196626150 | ||
| 308 | 299222924320309249 299222924320309249 | 2025-06-29T06:26:14.042561+00:00 | 4 | 34 | 1 | 0 | 143241464 | ||
| 309 | 299222924320309249 299222924320309249 | 2025-06-29T07:41:39.362303+00:00 | 4 | 34 | 2 | 0 | 191177411 | ||
| 310 | 299222924320309249 299222924320309249 | 2025-06-29T07:48:22.995707+00:00 | 4 | 34 | 4 | 0 | 220030411 | ||
| 398 | 299222924320309249 299222924320309249 | 2025-06-30T10:22:07.407201+00:00 | 5 | 38 | 1 | 0 | 142477519 | ||
| 401 | 299222924320309249 299222924320309249 | 2025-06-30T10:30:45.955108+00:00 | 5 | 38 | 5 | 0 | 217420547 | ||
| 403 | 299222924320309249 299222924320309249 | 2025-06-30T10:37:53.930167+00:00 | 5 | 38 | 2 | 0 | 134494847 | ||
| 405 | 299222924320309249 299222924320309249 | 2025-06-30T10:40:00.096785+00:00 | 5 | 39 | 2 | 1 | 62848962 | ||
| 612 | 299222924320309249 299222924320309249 | 2025-07-27T12:04:27.537289+00:00 | 1 | 21 | 1 | 0 | |||
| 613 | 299222924320309249 299222924320309249 | 2025-07-27T12:04:27.537289+00:00 | 1 | 22 | 1 | 1 | 自動產生，關聯至完整刀 ID:612 | 612 | |
| 614 | 299222924320309249 299222924320309249 | 2025-07-27T12:10:17.072885+00:00 | 1 | 21 | 2 | 0 | |||
| 615 | 299222924320309249 299222924320309249 | 2025-07-27T12:10:17.072885+00:00 | 1 | 22 | 2 | 1 | 自動產生，關聯至完整刀 ID:614 | 614 | |
| 616 | 299222924320309249 299222924320309249 | 2025-07-27T12:14:09.664657+00:00 | 1 | 21 | 4 | 0 | |||
| 617 | 299222924320309249 299222924320309249 | 2025-07-27T12:14:09.664657+00:00 | 1 | 22 | 4 | 1 | 自動產生，關聯至完整刀 ID:616 | 616 | |
| 687 | 299222924320309249 299222924320309249 | 2025-07-28T08:04:46.709130+00:00 | 2 | 25 | 1 | 0 | 304882279 | ||
| 691 | 299222924320309249 299222924320309249 | 2025-07-28T08:25:14.772878+00:00 | 2 | 25 | 4 | 0 | 214663376 | ||
| 697 | 299222924320309249 299222924320309249 | 2025-07-28T11:48:11.018059+00:00 | 2 | 25 | 5 | 0 | 262845448 | ||
| 828 | 299222924320309249 299222924320309249 | 2025-07-29T12:39:00.949643+00:00 | 3 | 31 | 1 | 0 | 307465105 | ||
| 830 | 299222924320309249 299222924320309249 | 2025-07-29T12:44:30.344611+00:00 | 3 | 31 | 4 | 0 | 226281887 | ||
| 849 | 299222924320309249 299222924320309249 | 2025-07-29T14:18:06.135553+00:00 | 3 | 31 | 3 | 0 | 74138567 | ||
| 850 | 299222924320309249 299222924320309249 | 2025-07-29T14:18:38.526589+00:00 | 3 | 32 | 3 | 1 | 230640711 | ||
| 954 | 299222924320309249 299222924320309249 | 2025-07-30T13:41:20.625348+00:00 | 4 | 36 | 4 | 0 | 227896006 | ||
| 961 | 299222924320309249 299222924320309249 | 2025-07-30T13:56:51.702255+00:00 | 4 | 36 | 3 | 0 | 252306091 | ||
| 972 | 299222924320309249 299222924320309249 | 2025-07-30T15:02:45.274381+00:00 | 4 | 36 | 1 | 0 | 102329132 | ||
| 973 | 299222924320309249 299222924320309249 | 2025-07-30T15:02:59.816949+00:00 | 4 | 37 | 1 | 0 | 260059688 | ||
| 1062 | 299222924320309249 299222924320309249 | 2025-07-31T12:47:05.966157+00:00 | 5 | 40 | 4 | 0 | 45272967 | ||
| 1063 | 299222924320309249 299222924320309249 | 2025-07-31T12:47:22.793664+00:00 | 5 | 41 | 4 | 0 | 230259858 | ||
| 1065 | 299222924320309249 299222924320309249 | 2025-07-31T12:53:26.589144+00:00 | 5 | 40 | 1 | 0 | 307927981 | ||
| 1069 | 299222924320309249 299222924320309249 | 2025-07-31T12:59:37.317717+00:00 | 5 | 40 | 3 | 0 | 252733612 | ||
| 1192 | 299222924320309249 299222924320309249 | 2025-08-27T10:07:46.815569+00:00 | 1 | 15 | 4 | 0 | |||
| 1193 | 299222924320309249 299222924320309249 | 2025-08-27T10:07:46.815569+00:00 | 1 | 16 | 4 | 1 | 自動產生，關聯至完整刀 ID:1192 | 1192 | |
| 1200 | 299222924320309249 299222924320309249 | 2025-08-27T10:11:12.010146+00:00 | 1 | 17 | 1 | 0 | |||
| 1201 | 299222924320309249 299222924320309249 | 2025-08-27T10:11:12.010146+00:00 | 1 | 18 | 1 | 1 | 自動產生，關聯至完整刀 ID:1200 | 1200 | |
| 1204 | 299222924320309249 299222924320309249 | 2025-08-27T10:19:47.668760+00:00 | 1 | 17 | 3 | 0 | |||
| 1205 | 299222924320309249 299222924320309249 | 2025-08-27T10:19:47.668760+00:00 | 1 | 18 | 3 | 1 | 自動產生，關聯至完整刀 ID:1204 | 1204 | |
| 1350 | 299222924320309249 299222924320309249 | 2025-08-28T13:30:49.867434+00:00 | 2 | 27 | 3 | 0 | 278524833 | ||
| 1353 | 299222924320309249 299222924320309249 | 2025-08-28T13:40:57.686287+00:00 | 2 | 26 | 2 | 0 | 117996803 | ||
| 1355 | 299222924320309249 299222924320309249 | 2025-08-28T13:44:13.350414+00:00 | 2 | 27 | 2 | 1 | 117467714 | ||
| 1357 | 299222924320309249 299222924320309249 | 2025-08-28T13:58:10.374414+00:00 | 2 | 27 | 1 | 0 | 240332309 | ||
| 1459 | 299222924320309249 299222924320309249 | 2025-08-29T14:32:26.986267+00:00 | 3 | 30 | 1 | 0 | 10357522 | ||
| 1461 | 299222924320309249 299222924320309249 | 2025-08-29T14:32:57.685100+00:00 | 3 | 31 | 1 | 0 | 239038866 | ||
| 1465 | 299222924320309249 299222924320309249 | 2025-08-29T14:43:44.267136+00:00 | 3 | 31 | 3 | 0 | 27031884 | ||
| 1466 | 299222924320309249 299222924320309249 | 2025-08-29T14:43:53.399959+00:00 | 3 | 32 | 3 | 0 | 267679751 | ||
| 1470 | 299222924320309249 299222924320309249 | 2025-08-29T14:58:56.085311+00:00 | 3 | 31 | 4 | 0 | 33272850 | ||
| 1471 | 299222924320309249 299222924320309249 | 2025-08-29T14:59:06.999837+00:00 | 3 | 32 | 4 | 1 | 273388087 | ||
| 1573 | 299222924320309249 299222924320309249 | 2025-08-30T13:49:00.549870+00:00 | 4 | 36 | 3 | 0 | 267627816 | ||
| 1581 | 299222924320309249 299222924320309249 | 2025-08-30T14:32:20.862596+00:00 | 4 | 36 | 4 | 0 | 33526721 | ||
| 1582 | 299222924320309249 299222924320309249 | 2025-08-30T14:32:52.867393+00:00 | 4 | 35 | 2 | 0 | 209292648 | ||
| 1590 | 299222924320309249 299222924320309249 | 2025-08-30T14:51:15.308075+00:00 | 4 | 35 | 1 | 1 | 239418869 | ||
| 1633 | 299222924320309249 299222924320309249 | 2025-08-31T03:27:48.684838+00:00 | 5 | 38 | 2 | 0 | 209512282 | ||
| 1659 | 299222924320309249 299222924320309249 | 2025-08-31T06:10:23.069837+00:00 | 5 | 38 | 1 | 0 | 152541029 | ||
| 1664 | 299222924320309249 299222924320309249 | 2025-08-31T06:16:54.060011+00:00 | 5 | 39 | 1 | 1 | 63891135 | ||
| 1666 | 299222924320309249 299222924320309249 | 2025-08-31T06:17:32.323964+00:00 | 5 | 40 | 4 | 0 | 366592260 | ||
| 1871 | 299222924320309249 299222924320309249 | 2025-09-26T15:02:43.961715+00:00 | 1 | 23 | 5 | 0 | 289020445 | ||
| 1872 | 299222924320309249 299222924320309249 | 2025-09-26T15:09:03.256927+00:00 | 1 | 23 | 4 | 0 | 210136993 | ||
| 1873 | 299222924320309249 299222924320309249 | 2025-09-26T15:15:07.328254+00:00 | 1 | 23 | 2 | 0 | 302328153 | ||
| 1945 | 299222924320309249 299222924320309249 | 2025-09-27T07:28:42.593694+00:00 | 2 | 26 | 5 | 0 | 287543728 | ||
| 1946 | 299222924320309249 299222924320309249 | 2025-09-27T07:37:20.256153+00:00 | 2 | 26 | 2 | 0 | 301811385 | ||
| 1972 | 299222924320309249 299222924320309249 | 2025-09-27T15:04:03.742459+00:00 | 2 | 28 | 4 | 0 | 247153025 | ||
| 2066 | 299222924320309249 299222924320309249 | 2025-09-28T11:39:03.500572+00:00 | 3 | 32 | 2 | 0 | 303014669 | ||
| 2067 | 299222924320309249 299222924320309249 | 2025-09-28T11:46:58.473453+00:00 | 3 | 31 | 5 | 0 | 288364449 | ||
| 2075 | 299222924320309249 299222924320309249 | 2025-09-28T13:01:36.687289+00:00 | 3 | 31 | 4 | 0 | 106535183 | ||
| 2077 | 299222924320309249 299222924320309249 | 2025-09-28T13:07:47.417712+00:00 | 3 | 32 | 4 | 0 | 174555436 | ||
| 2181 | 299222924320309249 299222924320309249 | 2025-09-29T11:31:59.491493+00:00 | 4 | 36 | 4 | 0 | 251953770 | ||
| 2183 | 299222924320309249 299222924320309249 | 2025-09-29T11:50:41.836804+00:00 | 4 | 36 | 2 | 0 | 223210153 | ||
| 2184 | 299222924320309249 299222924320309249 | 2025-09-29T11:52:33.557099+00:00 | 4 | 37 | 2 | 1 | 975212800 | ||
| 2192 | 299222924320309249 299222924320309249 | 2025-09-29T12:58:22.593444+00:00 | 4 | 36 | 5 | 0 | 288800041 | ||
| 2323 | 299222924320309249 299222924320309249 | 2025-09-30T13:44:36.219409+00:00 | 5 | 42 | 4 | 0 | 251562523 | ||
| 2324 | 299222924320309249 299222924320309249 | 2025-09-30T13:51:54.105339+00:00 | 5 | 42 | 5 | 0 | 288751936 | ||
| 2327 | 299222924320309249 299222924320309249 | 2025-09-30T14:01:51.482316+00:00 | 5 | 42 | 2 | 0 | 304906178 |
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)
);