attacks
81 rows where member_id = 509582053801459732
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 |
|---|---|---|---|---|---|---|---|---|---|
| 59 | 509582053801459732 509582053801459732 | 2025-06-26T08:29:19.734493+00:00 | 1 | 15 | 5 | 0 | |||
| 60 | 509582053801459732 509582053801459732 | 2025-06-26T08:29:19.734493+00:00 | 1 | 16 | 5 | 1 | 自動產生，關聯至完整刀 ID:59 | 59 | |
| 77 | 509582053801459732 509582053801459732 | 2025-06-26T12:26:35.134744+00:00 | 1 | 19 | 4 | 0 | |||
| 78 | 509582053801459732 509582053801459732 | 2025-06-26T12:26:35.134744+00:00 | 1 | 20 | 4 | 1 | 自動產生，關聯至完整刀 ID:77 | 77 | |
| 79 | 509582053801459732 509582053801459732 | 2025-06-26T12:32:23.640111+00:00 | 1 | 21 | 3 | 0 | |||
| 80 | 509582053801459732 509582053801459732 | 2025-06-26T12:32:23.640111+00:00 | 1 | 22 | 3 | 1 | 自動產生，關聯至完整刀 ID:79 | 79 | |
| 174 | 509582053801459732 509582053801459732 | 2025-06-27T16:18:06.993903+00:00 | 2 | 28 | 5 | 0 | 209134859 | ||
| 176 | 509582053801459732 509582053801459732 | 2025-06-27T16:24:53.210741+00:00 | 2 | 27 | 1 | 1 | 176717552 | ||
| 179 | 509582053801459732 509582053801459732 | 2025-06-27T16:35:57.492752+00:00 | 2 | 27 | 3 | 0 | 155455249 | ||
| 180 | 509582053801459732 509582053801459732 | 2025-06-27T16:46:58.465899+00:00 | 2 | 28 | 3 | 0 | 48818383 | ||
| 181 | 509582053801459732 509582053801459732 | 2025-06-27T16:50:48.211787+00:00 | 2 | 28 | 2 | 1 | 18062036 | ||
| 247 | 509582053801459732 509582053801459732 | 2025-06-28T11:29:23.099016+00:00 | 3 | 31 | 5 | 0 | 210093648 | ||
| 249 | 509582053801459732 509582053801459732 | 2025-06-28T11:35:28.146884+00:00 | 3 | 31 | 2 | 0 | 212096527 | ||
| 250 | 509582053801459732 509582053801459732 | 2025-06-28T11:40:41.309385+00:00 | 3 | 30 | 3 | 0 | 152155713 | ||
| 251 | 509582053801459732 509582053801459732 | 2025-06-28T11:44:06.533715+00:00 | 3 | 31 | 1 | 0 | 22985888 | ||
| 368 | 509582053801459732 509582053801459732 | 2025-06-29T18:30:41.249998+00:00 | 4 | 36 | 3 | 0 | 15051514 | ||
| 369 | 509582053801459732 509582053801459732 | 2025-06-29T18:36:13.466951+00:00 | 4 | 37 | 3 | 1 | 168998018 | ||
| 370 | 509582053801459732 509582053801459732 | 2025-06-29T18:39:54.379602+00:00 | 4 | 36 | 1 | 0 | 24654881 | ||
| 372 | 509582053801459732 509582053801459732 | 2025-06-29T18:48:19.788545+00:00 | 4 | 37 | 1 | 1 | 162997728 | ||
| 373 | 509582053801459732 509582053801459732 | 2025-06-29T18:54:09.183665+00:00 | 4 | 37 | 5 | 0 | 209330441 | ||
| 387 | 509582053801459732 509582053801459732 | 2025-06-30T03:55:43.220265+00:00 | 5 | 38 | 5 | 0 | 208945237 | ||
| 388 | 509582053801459732 509582053801459732 | 2025-06-30T04:01:04.809118+00:00 | 5 | 38 | 3 | 0 | 169381273 | ||
| 389 | 509582053801459732 509582053801459732 | 2025-06-30T04:07:05.070427+00:00 | 5 | 38 | 1 | 0 | 182800018 | ||
| 469 | 509582053801459732 509582053801459732 | 2025-07-27T00:56:31.795947+00:00 | 1 | 1 | 1 | 0 | 12000000 | ||
| 470 | 509582053801459732 509582053801459732 | 2025-07-27T00:56:31.795947+00:00 | 1 | 2 | 1 | 1 | 自動產生，關聯至完整刀 ID:469 | 469 | |
| 471 | 509582053801459732 509582053801459732 | 2025-07-27T01:00:02.754453+00:00 | 1 | 1 | 2 | 0 | 15000000 | ||
| 472 | 509582053801459732 509582053801459732 | 2025-07-27T01:00:02.754453+00:00 | 1 | 2 | 2 | 1 | 自動產生，關聯至完整刀 ID:471 | 471 | |
| 473 | 509582053801459732 509582053801459732 | 2025-07-27T01:02:19.936711+00:00 | 1 | 3 | 5 | 0 | 30000000 | ||
| 474 | 509582053801459732 509582053801459732 | 2025-07-27T01:02:19.936711+00:00 | 1 | 4 | 5 | 1 | 自動產生，關聯至完整刀 ID:473 | 473 | |
| 774 | 509582053801459732 509582053801459732 | 2025-07-28T19:54:51.537576+00:00 | 2 | 29 | 3 | 0 | 269032441 | ||
| 775 | 509582053801459732 509582053801459732 | 2025-07-28T20:00:15.385421+00:00 | 2 | 29 | 2 | 0 | 348376218 | ||
| 776 | 509582053801459732 509582053801459732 | 2025-07-28T20:06:52.306648+00:00 | 2 | 29 | 5 | 0 | 311478209 | ||
| 877 | 509582053801459732 509582053801459732 | 2025-07-29T18:40:59.566193+00:00 | 3 | 32 | 4 | 0 | 177430336 | ||
| 878 | 509582053801459732 509582053801459732 | 2025-07-29T18:47:18.799973+00:00 | 3 | 33 | 2 | 0 | 351625468 | ||
| 879 | 509582053801459732 509582053801459732 | 2025-07-29T18:50:41.576252+00:00 | 3 | 32 | 3 | 1 | 47938813 | ||
| 881 | 509582053801459732 509582053801459732 | 2025-07-29T18:55:17.189892+00:00 | 3 | 33 | 3 | 0 | 269616248 | ||
| 957 | 509582053801459732 509582053801459732 | 2025-07-30T13:42:56.461048+00:00 | 4 | 36 | 5 | 0 | 309359382 | ||
| 959 | 509582053801459732 509582053801459732 | 2025-07-30T13:48:16.027136+00:00 | 4 | 36 | 4 | 0 | 244821506 | ||
| 962 | 509582053801459732 509582053801459732 | 2025-07-30T13:58:23.025845+00:00 | 4 | 36 | 3 | 0 | 172757164 | ||
| 963 | 509582053801459732 509582053801459732 | 2025-07-30T14:00:46.464467+00:00 | 4 | 37 | 3 | 1 | 111475349 | ||
| 1012 | 509582053801459732 509582053801459732 | 2025-07-31T03:20:36.001309+00:00 | 5 | 39 | 5 | 0 | 303921960 | ||
| 1013 | 509582053801459732 509582053801459732 | 2025-07-31T03:25:07.794494+00:00 | 5 | 38 | 4 | 0 | 242429162 | ||
| 1014 | 509582053801459732 509582053801459732 | 2025-07-31T03:32:49.478818+00:00 | 5 | 38 | 1 | 0 | 277133151 | ||
| 1015 | 509582053801459732 509582053801459732 | 2025-07-31T03:35:02.031701+00:00 | 5 | 38 | 3 | 1 | 48172717 | ||
| 1162 | 509582053801459732 509582053801459732 | 2025-08-27T06:51:15.777067+00:00 | 1 | 9 | 1 | 0 | |||
| 1163 | 509582053801459732 509582053801459732 | 2025-08-27T06:51:15.777067+00:00 | 1 | 10 | 1 | 1 | 自動產生，關聯至完整刀 ID:1162 | 1162 | |
| 1164 | 509582053801459732 509582053801459732 | 2025-08-27T06:54:07.337889+00:00 | 1 | 11 | 5 | 0 | |||
| 1165 | 509582053801459732 509582053801459732 | 2025-08-27T06:54:07.337889+00:00 | 1 | 12 | 5 | 1 | 自動產生，關聯至完整刀 ID:1164 | 1164 | |
| 1166 | 509582053801459732 509582053801459732 | 2025-08-27T06:59:28.858803+00:00 | 1 | 11 | 4 | 0 | |||
| 1167 | 509582053801459732 509582053801459732 | 2025-08-27T06:59:28.858803+00:00 | 1 | 12 | 4 | 1 | 自動產生，關聯至完整刀 ID:1166 | 1166 | |
| 1395 | 509582053801459732 509582053801459732 | 2025-08-28T19:11:02.056081+00:00 | 2 | 29 | 4 | 0 | 383854206 | ||
| 1396 | 509582053801459732 509582053801459732 | 2025-08-28T19:18:35.985402+00:00 | 2 | 28 | 2 | 0 | 223839079 | ||
| 1397 | 509582053801459732 509582053801459732 | 2025-08-28T19:34:35.556217+00:00 | 2 | 29 | 3 | 0 | 295832374 | ||
| 1508 | 509582053801459732 509582053801459732 | 2025-08-29T19:20:11.644863+00:00 | 3 | 33 | 5 | 0 | 266914601 | ||
| 1509 | 509582053801459732 509582053801459732 | 2025-08-29T19:24:53.190860+00:00 | 3 | 33 | 2 | 0 | 223639489 | ||
| 1510 | 509582053801459732 509582053801459732 | 2025-08-29T19:31:03.609767+00:00 | 3 | 33 | 1 | 0 | 330484495 | ||
| 1620 | 509582053801459732 509582053801459732 | 2025-08-30T17:19:18.047158+00:00 | 4 | 38 | 4 | 0 | 375237718 | ||
| 1621 | 509582053801459732 509582053801459732 | 2025-08-30T17:24:36.728107+00:00 | 4 | 37 | 3 | 0 | 301528107 | ||
| 1622 | 509582053801459732 509582053801459732 | 2025-08-30T17:36:29.877338+00:00 | 4 | 36 | 2 | 0 | 223794627 | ||
| 1706 | 509582053801459732 509582053801459732 | 2025-08-31T12:26:45.076541+00:00 | 5 | 41 | 5 | 0 | 266562339 | ||
| 1709 | 509582053801459732 509582053801459732 | 2025-08-31T12:33:06.883201+00:00 | 5 | 41 | 1 | 0 | 333521141 | ||
| 1728 | 509582053801459732 509582053801459732 | 2025-08-31T14:11:55.234666+00:00 | 5 | 40 | 2 | 0 | 223788265 | ||
| 1845 | 509582053801459732 509582053801459732 | 2025-09-26T12:30:10.291504+00:00 | 1 | 19 | 5 | 0 | |||
| 1846 | 509582053801459732 509582053801459732 | 2025-09-26T12:30:10.291504+00:00 | 1 | 20 | 5 | 1 | 自動產生，關聯至完整刀 ID:1845 | 1845 | |
| 1847 | 509582053801459732 509582053801459732 | 2025-09-26T12:33:31.756133+00:00 | 1 | 19 | 4 | 0 | |||
| 1848 | 509582053801459732 509582053801459732 | 2025-09-26T12:33:31.756133+00:00 | 1 | 20 | 4 | 1 | 自動產生，關聯至完整刀 ID:1847 | 1847 | |
| 1849 | 509582053801459732 509582053801459732 | 2025-09-26T12:37:51.161308+00:00 | 1 | 21 | 2 | 0 | |||
| 1850 | 509582053801459732 509582053801459732 | 2025-09-26T12:37:51.161308+00:00 | 1 | 22 | 2 | 1 | 自動產生，關聯至完整刀 ID:1849 | 1849 | |
| 2007 | 509582053801459732 509582053801459732 | 2025-09-27T19:09:51.613164+00:00 | 2 | 29 | 2 | 0 | 302517534 | ||
| 2008 | 509582053801459732 509582053801459732 | 2025-09-27T19:18:44.463254+00:00 | 2 | 29 | 4 | 0 | 261200554 | ||
| 2009 | 509582053801459732 509582053801459732 | 2025-09-27T19:28:14.538222+00:00 | 2 | 29 | 4 | 0 | 287307195 | ||
| 2125 | 509582053801459732 509582053801459732 | 2025-09-28T19:05:46.360274+00:00 | 3 | 34 | 1 | 0 | 330108552 | ||
| 2126 | 509582053801459732 509582053801459732 | 2025-09-28T19:05:55.463243+00:00 | 3 | 33 | 5 | 0 | 300286939 | ||
| 2127 | 509582053801459732 509582053801459732 | 2025-09-28T19:06:06.898929+00:00 | 3 | 33 | 4 | 0 | 24136787 | ||
| 2128 | 509582053801459732 509582053801459732 | 2025-09-28T19:06:16.874474+00:00 | 3 | 34 | 4 | 1 | 258301109 | ||
| 2222 | 509582053801459732 509582053801459732 | 2025-09-29T18:07:05.473060+00:00 | 4 | 38 | 1 | 0 | 320192040 | ||
| 2223 | 509582053801459732 509582053801459732 | 2025-09-29T18:12:02.518938+00:00 | 4 | 38 | 4 | 0 | 262197235 | ||
| 2224 | 509582053801459732 509582053801459732 | 2025-09-29T18:20:41.197633+00:00 | 4 | 37 | 5 | 0 | 299813883 | ||
| 2355 | 509582053801459732 509582053801459732 | 2025-09-30T15:35:50.416583+00:00 | 5 | 43 | 5 | 0 | 300243341 | ||
| 2357 | 509582053801459732 509582053801459732 | 2025-09-30T15:41:47.424487+00:00 | 5 | 44 | 2 | 0 | 309870928 | ||
| 2358 | 509582053801459732 509582053801459732 | 2025-09-30T15:59:12.029084+00:00 | 5 | 44 | 3 | 0 | 316855623 |
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)
);