attacks
163 rows where member_id = 439677054238195714
This data as json, CSV (advanced)
Suggested facets: battle_day, lap, boss_number, is_residual, notes, attack_datetime (date)
| attack_id ▼ | member_id | attack_datetime | battle_day | lap | boss_number | is_residual | damage | notes | related_full_attack_id |
|---|---|---|---|---|---|---|---|---|---|
| 5 | 439677054238195714 439677054238195714 | 2025-06-26T00:39:49.543319+00:00 | 1 | 2 | 1 | 0 | |||
| 7 | 439677054238195714 439677054238195714 | 2025-06-26T00:45:35.418695+00:00 | 1 | 2 | 3 | 1 | |||
| 19 | 439677054238195714 439677054238195714 | 2025-06-26T01:08:27.552419+00:00 | 1 | 3 | 4 | 0 | |||
| 20 | 439677054238195714 439677054238195714 | 2025-06-26T01:08:27.552419+00:00 | 1 | 4 | 4 | 1 | 自動產生，關聯至完整刀 ID:19 | 19 | |
| 21 | 439677054238195714 439677054238195714 | 2025-06-26T01:13:08.867929+00:00 | 1 | 5 | 5 | 0 | |||
| 22 | 439677054238195714 439677054238195714 | 2025-06-26T01:13:08.867929+00:00 | 1 | 6 | 5 | 1 | 自動產生，關聯至完整刀 ID:21 | 21 | |
| 35 | 439677054238195714 439677054238195714 | 2025-06-26T01:37:13.108323+00:00 | 1 | 9 | 5 | 0 | |||
| 36 | 439677054238195714 439677054238195714 | 2025-06-26T01:37:13.108323+00:00 | 1 | 10 | 5 | 1 | 自動產生，關聯至完整刀 ID:35 | 35 | |
| 37 | 439677054238195714 439677054238195714 | 2025-06-26T01:42:16.232420+00:00 | 1 | 9 | 4 | 0 | |||
| 38 | 439677054238195714 439677054238195714 | 2025-06-26T01:42:16.232420+00:00 | 1 | 10 | 4 | 1 | 自動產生，關聯至完整刀 ID:37 | 37 | |
| 39 | 439677054238195714 439677054238195714 | 2025-06-26T01:53:29.595415+00:00 | 1 | 10 | 1 | 0 | |||
| 40 | 439677054238195714 439677054238195714 | 2025-06-26T01:53:29.595415+00:00 | 1 | 11 | 1 | 1 | 自動產生，關聯至完整刀 ID:39 | 39 | |
| 195 | 439677054238195714 439677054238195714 | 2025-06-27T19:05:02.016403+00:00 | 2 | 28 | 1 | 0 | 165929491 | ||
| 196 | 439677054238195714 439677054238195714 | 2025-06-27T19:37:27.938478+00:00 | 2 | 28 | 4 | 0 | 171262616 | 貓毛MK2 | |
| 197 | 439677054238195714 439677054238195714 | 2025-06-27T19:48:35.589951+00:00 | 2 | 29 | 5 | 0 | 164816537 | 貓毛MK2 | |
| 198 | 439677054238195714 439677054238195714 | 2025-06-27T20:01:35.916386+00:00 | 2 | 29 | 2 | 0 | 187657414 | 貓毛MK2 | |
| 199 | 439677054238195714 439677054238195714 | 2025-06-27T20:22:44.948776+00:00 | 2 | 28 | 3 | 0 | 153755893 | ||
| 243 | 439677054238195714 439677054238195714 | 2025-06-28T10:56:28.264781+00:00 | 3 | 30 | 5 | 0 | 163585166 | ||
| 244 | 439677054238195714 439677054238195714 | 2025-06-28T10:56:46.274835+00:00 | 3 | 30 | 5 | 0 | 144637993 | ||
| 245 | 439677054238195714 439677054238195714 | 2025-06-28T11:07:00.902595+00:00 | 3 | 31 | 5 | 1 | 11446888 | ||
| 246 | 439677054238195714 439677054238195714 | 2025-06-28T11:07:20.467666+00:00 | 3 | 30 | 4 | 0 | 170407549 | ||
| 248 | 439677054238195714 439677054238195714 | 2025-06-28T11:31:51.751680+00:00 | 3 | 30 | 3 | 0 | 141658985 | ||
| 252 | 439677054238195714 439677054238195714 | 2025-06-28T13:42:27.030284+00:00 | 3 | 30 | 4 | 0 | 170352148 | ||
| 256 | 439677054238195714 439677054238195714 | 2025-06-28T14:03:11.225280+00:00 | 3 | 31 | 2 | 0 | 189821892 | ||
| 294 | 439677054238195714 439677054238195714 | 2025-06-29T03:34:34.455767+00:00 | 4 | 33 | 5 | 0 | 84959253 | ||
| 295 | 439677054238195714 439677054238195714 | 2025-06-29T03:37:46.223211+00:00 | 4 | 34 | 5 | 1 | 92055078 | ||
| 300 | 439677054238195714 439677054238195714 | 2025-06-29T04:33:45.143926+00:00 | 4 | 33 | 4 | 0 | 171701114 | ||
| 301 | 439677054238195714 439677054238195714 | 2025-06-29T04:34:18.016449+00:00 | 4 | 33 | 4 | 0 | 166360417 | ||
| 302 | 439677054238195714 439677054238195714 | 2025-06-29T04:36:19.822861+00:00 | 4 | 34 | 4 | 1 | 2242883 | ||
| 303 | 439677054238195714 439677054238195714 | 2025-06-29T04:42:01.017885+00:00 | 4 | 33 | 3 | 0 | 140490871 | ||
| 305 | 439677054238195714 439677054238195714 | 2025-06-29T04:50:06.035905+00:00 | 4 | 34 | 5 | 0 | 167057379 | ||
| 311 | 439677054238195714 439677054238195714 | 2025-06-29T07:59:18.926682+00:00 | 4 | 35 | 2 | 0 | 187276595 | ||
| 410 | 439677054238195714 439677054238195714 | 2025-06-30T11:25:03.157029+00:00 | 5 | 39 | 4 | 0 | 171704923 | ||
| 411 | 439677054238195714 439677054238195714 | 2025-06-30T11:32:35.638858+00:00 | 5 | 39 | 5 | 0 | 171008046 | ||
| 412 | 439677054238195714 439677054238195714 | 2025-06-30T11:52:05.400355+00:00 | 5 | 39 | 2 | 0 | 188589126 | ||
| 413 | 439677054238195714 439677054238195714 | 2025-06-30T11:52:39.284659+00:00 | 5 | 39 | 2 | 0 | 76833964 | ||
| 414 | 439677054238195714 439677054238195714 | 2025-06-30T11:55:58.521429+00:00 | 5 | 40 | 2 | 1 | 133339387 | ||
| 415 | 439677054238195714 439677054238195714 | 2025-06-30T12:04:40.214682+00:00 | 5 | 39 | 3 | 0 | 86204696 | ||
| 417 | 439677054238195714 439677054238195714 | 2025-06-30T12:09:40.003716+00:00 | 5 | 40 | 5 | 0 | 166136239 | ||
| 493 | 439677054238195714 439677054238195714 | 2025-07-27T02:55:07.655818+00:00 | 1 | 3 | 1 | 0 | 12000000 | ||
| 494 | 439677054238195714 439677054238195714 | 2025-07-27T02:55:07.655818+00:00 | 1 | 4 | 1 | 1 | 自動產生，關聯至完整刀 ID:493 | 493 | |
| 495 | 439677054238195714 439677054238195714 | 2025-07-27T02:58:50.946036+00:00 | 1 | 5 | 5 | 0 | 30000000 | ||
| 496 | 439677054238195714 439677054238195714 | 2025-07-27T02:58:50.946036+00:00 | 1 | 6 | 5 | 1 | 自動產生，關聯至完整刀 ID:495 | 495 | |
| 497 | 439677054238195714 439677054238195714 | 2025-07-27T03:02:18.502747+00:00 | 1 | 5 | 4 | 0 | 23000000 | ||
| 498 | 439677054238195714 439677054238195714 | 2025-07-27T03:02:18.502747+00:00 | 1 | 6 | 4 | 1 | 自動產生，關聯至完整刀 ID:497 | 497 | |
| 499 | 439677054238195714 439677054238195714 | 2025-07-27T03:06:08.273461+00:00 | 1 | 5 | 2 | 0 | 15000000 | ||
| 500 | 439677054238195714 439677054238195714 | 2025-07-27T03:06:08.273461+00:00 | 1 | 6 | 2 | 1 | 自動產生，關聯至完整刀 ID:499 | 499 | |
| 501 | 439677054238195714 439677054238195714 | 2025-07-27T03:09:24.509743+00:00 | 1 | 5 | 3 | 0 | 20000000 | ||
| 502 | 439677054238195714 439677054238195714 | 2025-07-27T03:09:24.509743+00:00 | 1 | 6 | 3 | 1 | 自動產生，關聯至完整刀 ID:501 | 501 | |
| 503 | 439677054238195714 439677054238195714 | 2025-07-27T03:11:55.261185+00:00 | 1 | 5 | 1 | 0 | 12000000 | ||
| 504 | 439677054238195714 439677054238195714 | 2025-07-27T03:11:55.261185+00:00 | 1 | 6 | 1 | 1 | 自動產生，關聯至完整刀 ID:503 | 503 | |
| 704 | 439677054238195714 439677054238195714 | 2025-07-28T12:54:56.650661+00:00 | 2 | 25 | 4 | 0 | 221935104 | ||
| 708 | 439677054238195714 439677054238195714 | 2025-07-28T13:20:26.291922+00:00 | 2 | 25 | 1 | 0 | 304634472 | ||
| 709 | 439677054238195714 439677054238195714 | 2025-07-28T13:20:42.193412+00:00 | 2 | 25 | 1 | 0 | 27820046 | ||
| 710 | 439677054238195714 439677054238195714 | 2025-07-28T13:26:18.784398+00:00 | 2 | 26 | 1 | 1 | 293673324 | ||
| 714 | 439677054238195714 439677054238195714 | 2025-07-28T13:42:48.635045+00:00 | 2 | 26 | 2 | 0 | 62368321 | ||
| 716 | 439677054238195714 439677054238195714 | 2025-07-28T13:51:54.550577+00:00 | 2 | 26 | 4 | 0 | 172879754 | ||
| 725 | 439677054238195714 439677054238195714 | 2025-07-28T14:28:24.586421+00:00 | 2 | 27 | 2 | 1 | 3256639492 | ||
| 728 | 439677054238195714 439677054238195714 | 2025-07-28T14:34:21.785039+00:00 | 2 | 27 | 4 | 1 | 2657576 | ||
| 731 | 439677054238195714 439677054238195714 | 2025-07-28T14:37:58.242820+00:00 | 2 | 27 | 3 | 1 | 64451196 | ||
| 733 | 439677054238195714 439677054238195714 | 2025-07-28T14:43:59.418827+00:00 | 2 | 27 | 3 | 0 | 257715921 | ||
| 819 | 439677054238195714 439677054238195714 | 2025-07-29T12:07:11.822378+00:00 | 3 | 30 | 1 | 0 | 304150553 | ||
| 820 | 439677054238195714 439677054238195714 | 2025-07-29T12:07:47.912107+00:00 | 3 | 30 | 1 | 0 | 114808833 | ||
| 822 | 439677054238195714 439677054238195714 | 2025-07-29T12:22:42.165981+00:00 | 3 | 30 | 4 | 0 | 224474155 | ||
| 824 | 439677054238195714 439677054238195714 | 2025-07-29T12:23:15.180126+00:00 | 3 | 30 | 4 | 0 | 205697669 | ||
| 825 | 439677054238195714 439677054238195714 | 2025-07-29T12:26:27.434918+00:00 | 3 | 31 | 4 | 1 | 9104324 | ||
| 827 | 439677054238195714 439677054238195714 | 2025-07-29T12:34:07.519604+00:00 | 3 | 31 | 2 | 0 | 328245267 | ||
| 829 | 439677054238195714 439677054238195714 | 2025-07-29T12:43:10.367802+00:00 | 3 | 31 | 1 | 1 | 235468576 | ||
| 833 | 439677054238195714 439677054238195714 | 2025-07-29T12:57:54.663620+00:00 | 3 | 31 | 3 | 0 | 254511714 | ||
| 921 | 439677054238195714 439677054238195714 | 2025-07-30T11:42:31.108736+00:00 | 4 | 34 | 3 | 0 | 8471356 | ||
| 922 | 439677054238195714 439677054238195714 | 2025-07-30T11:46:39.523794+00:00 | 4 | 35 | 3 | 1 | 256722634 | ||
| 924 | 439677054238195714 439677054238195714 | 2025-07-30T12:37:38.726851+00:00 | 4 | 34 | 2 | 0 | 325666899 | ||
| 930 | 439677054238195714 439677054238195714 | 2025-07-30T12:45:54.880428+00:00 | 4 | 34 | 4 | 0 | 228351649 | ||
| 934 | 439677054238195714 439677054238195714 | 2025-07-30T12:52:24.351274+00:00 | 4 | 35 | 4 | 0 | 2247126522 | ||
| 942 | 439677054238195714 439677054238195714 | 2025-07-30T13:05:06.553461+00:00 | 4 | 36 | 2 | 0 | 328907490 | ||
| 944 | 439677054238195714 439677054238195714 | 2025-07-30T13:11:12.187816+00:00 | 4 | 36 | 1 | 0 | 304780447 | ||
| 1050 | 439677054238195714 439677054238195714 | 2025-07-31T11:51:34.577552+00:00 | 5 | 39 | 3 | 0 | 258517773 | ||
| 1051 | 439677054238195714 439677054238195714 | 2025-07-31T11:52:13.455400+00:00 | 5 | 39 | 3 | 0 | 116690890 | ||
| 1052 | 439677054238195714 439677054238195714 | 2025-07-31T11:58:28.193778+00:00 | 5 | 40 | 2 | 0 | 308225488 | ||
| 1053 | 439677054238195714 439677054238195714 | 2025-07-31T12:08:32.674730+00:00 | 5 | 40 | 2 | 0 | 329729437 | ||
| 1054 | 439677054238195714 439677054238195714 | 2025-07-31T12:17:15.889545+00:00 | 5 | 30 | 4 | 0 | 225215874 | ||
| 1055 | 439677054238195714 439677054238195714 | 2025-07-31T12:17:42.709851+00:00 | 5 | 30 | 4 | 0 | 227496755 | ||
| 1057 | 439677054238195714 439677054238195714 | 2025-07-31T12:22:07.907968+00:00 | 5 | 40 | 3 | 1 | 188486247 | ||
| 1058 | 439677054238195714 439677054238195714 | 2025-07-31T12:24:49.246865+00:00 | 5 | 40 | 2 | 1 | 12671884 | ||
| 1252 | 439677054238195714 439677054238195714 | 2025-08-27T13:52:10.250498+00:00 | 1 | 23 | 2 | 0 | 240015762 | ||
| 1253 | 439677054238195714 439677054238195714 | 2025-08-27T13:52:40.795439+00:00 | 1 | 23 | 2 | 0 | 237745877 | ||
| 1254 | 439677054238195714 439677054238195714 | 2025-08-27T14:18:34.053517+00:00 | 1 | 23 | 4 | 0 | 364871665 | ||
| 1255 | 439677054238195714 439677054238195714 | 2025-08-27T14:19:15.172888+00:00 | 1 | 23 | 4 | 0 | 20599282 | ||
| 1256 | 439677054238195714 439677054238195714 | 2025-08-27T14:31:43.999791+00:00 | 1 | 24 | 4 | 1 | 363261179 | ||
| 1257 | 439677054238195714 439677054238195714 | 2025-08-27T14:54:05.656460+00:00 | 1 | 23 | 3 | 0 | 267652854 | ||
| 1258 | 439677054238195714 439677054238195714 | 2025-08-27T14:56:03.546089+00:00 | 1 | 23 | 3 | 0 | 264353781 | ||
| 1309 | 439677054238195714 439677054238195714 | 2025-08-28T11:30:51.977981+00:00 | 2 | 24 | 2 | 0 | 226682641 | ||
| 1310 | 439677054238195714 439677054238195714 | 2025-08-28T11:31:29.307952+00:00 | 2 | 24 | 2 | 0 | 35051949 | ||
| 1313 | 439677054238195714 439677054238195714 | 2025-08-28T11:42:21.355701+00:00 | 2 | 25 | 2 | 1 | 237726839 | ||
| 1316 | 439677054238195714 439677054238195714 | 2025-08-28T12:01:31.747824+00:00 | 2 | 25 | 2 | 0 | 206989269 | ||
| 1319 | 439677054238195714 439677054238195714 | 2025-08-28T12:25:22.286794+00:00 | 2 | 25 | 1 | 0 | 109538676 | ||
| 1325 | 439677054238195714 439677054238195714 | 2025-08-28T12:36:37.866608+00:00 | 2 | 25 | 2 | 0 | 211585471 | ||
| 1329 | 439677054238195714 439677054238195714 | 2025-08-28T12:45:27.720626+00:00 | 2 | 26 | 1 | 1 | 180561672 | ||
| 1333 | 439677054238195714 439677054238195714 | 2025-08-28T12:53:39.102996+00:00 | 2 | 26 | 1 | 0 | 264404246 | ||
| 1486 | 439677054238195714 439677054238195714 | 2025-08-29T16:37:24.839074+00:00 | 3 | 32 | 2 | 0 | 240115279 |
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)
);