attacks
89 rows where member_id = 509719720639987712
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 |
|---|---|---|---|---|---|---|---|---|---|
| 53 | 509719720639987712 509719720639987712 | 2025-06-26T06:37:03.350505+00:00 | 1 | 13 | 4 | 0 | |||
| 54 | 509719720639987712 509719720639987712 | 2025-06-26T06:37:03.350505+00:00 | 1 | 14 | 4 | 1 | 自動產生，關聯至完整刀 ID:53 | 53 | |
| 55 | 509719720639987712 509719720639987712 | 2025-06-26T06:44:59.936986+00:00 | 1 | 13 | 5 | 0 | |||
| 56 | 509719720639987712 509719720639987712 | 2025-06-26T06:44:59.936986+00:00 | 1 | 14 | 5 | 1 | 自動產生，關聯至完整刀 ID:55 | 55 | |
| 57 | 509719720639987712 509719720639987712 | 2025-06-26T06:49:10.662941+00:00 | 1 | 13 | 1 | 0 | |||
| 58 | 509719720639987712 509719720639987712 | 2025-06-26T06:49:10.662941+00:00 | 1 | 14 | 1 | 1 | 自動產生，關聯至完整刀 ID:57 | 57 | |
| 160 | 509719720639987712 509719720639987712 | 2025-06-27T14:54:46.222747+00:00 | 2 | 27 | 4 | 0 | 219003126 | ||
| 165 | 509719720639987712 509719720639987712 | 2025-06-27T15:37:46.273235+00:00 | 2 | 26 | 1 | 0 | 167399749 | ||
| 166 | 509719720639987712 509719720639987712 | 2025-06-27T15:42:12.478548+00:00 | 2 | 27 | 1 | 1 | 17176648 | ||
| 172 | 509719720639987712 509719720639987712 | 2025-06-27T16:08:03.331331+00:00 | 2 | 27 | 2 | 0 | 20926173 | ||
| 173 | 509719720639987712 509719720639987712 | 2025-06-27T16:13:01.213400+00:00 | 2 | 28 | 2 | 1 | 196404909 | ||
| 210 | 509719720639987712 509719720639987712 | 2025-06-28T05:21:47.619729+00:00 | 3 | 29 | 2 | 0 | 198030202 | ||
| 213 | 509719720639987712 509719720639987712 | 2025-06-28T05:31:04.500827+00:00 | 3 | 29 | 1 | 0 | 33350629 | ||
| 216 | 509719720639987712 509719720639987712 | 2025-06-28T05:38:16.483754+00:00 | 3 | 30 | 1 | 0 | 178623000 | ||
| 217 | 509719720639987712 509719720639987712 | 2025-06-28T05:48:37.559464+00:00 | 3 | 29 | 4 | 0 | 221496791 | ||
| 304 | 509719720639987712 509719720639987712 | 2025-06-29T04:46:53.770215+00:00 | 4 | 34 | 1 | 0 | 178786038 | ||
| 354 | 509719720639987712 509719720639987712 | 2025-06-29T13:39:57.760309+00:00 | 4 | 36 | 4 | 0 | 200468226 | ||
| 356 | 509719720639987712 509719720639987712 | 2025-06-29T13:54:20.797061+00:00 | 4 | 36 | 3 | 1 | 48286775 | ||
| 359 | 509719720639987712 509719720639987712 | 2025-06-29T14:08:49.627501+00:00 | 4 | 36 | 2 | 0 | 61182729 | ||
| 360 | 509719720639987712 509719720639987712 | 2025-06-29T14:15:05.469708+00:00 | 4 | 37 | 2 | 1 | 168947829 | ||
| 402 | 509719720639987712 509719720639987712 | 2025-06-30T10:31:20.513614+00:00 | 5 | 38 | 5 | 0 | 164159065 | ||
| 404 | 509719720639987712 509719720639987712 | 2025-06-30T10:37:54.249662+00:00 | 5 | 38 | 2 | 0 | 202016322 | ||
| 406 | 509719720639987712 509719720639987712 | 2025-06-30T10:49:52.013332+00:00 | 5 | 39 | 1 | 0 | 163456142 | ||
| 448 | 509719720639987712 509719720639987712 | 2025-06-30T15:25:26.868330+00:00 | 5 | 40 | 3 | 1 | 66156455 | ||
| 557 | 509719720639987712 509719720639987712 | 2025-07-27T07:01:35.710951+00:00 | 1 | 13 | 4 | 0 | |||
| 558 | 509719720639987712 509719720639987712 | 2025-07-27T07:01:35.710951+00:00 | 1 | 14 | 4 | 1 | 自動產生，關聯至完整刀 ID:557 | 557 | |
| 559 | 509719720639987712 509719720639987712 | 2025-07-27T07:06:45.453449+00:00 | 1 | 13 | 5 | 0 | |||
| 560 | 509719720639987712 509719720639987712 | 2025-07-27T07:06:45.453449+00:00 | 1 | 14 | 5 | 1 | 自動產生，關聯至完整刀 ID:559 | 559 | |
| 561 | 509719720639987712 509719720639987712 | 2025-07-27T07:13:33.073207+00:00 | 1 | 15 | 2 | 0 | |||
| 562 | 509719720639987712 509719720639987712 | 2025-07-27T07:13:33.073207+00:00 | 1 | 16 | 2 | 1 | 自動產生，關聯至完整刀 ID:561 | 561 | |
| 678 | 509719720639987712 509719720639987712 | 2025-07-28T04:54:12.642085+00:00 | 2 | 25 | 3 | 0 | 29001033 | ||
| 685 | 509719720639987712 509719720639987712 | 2025-07-28T06:46:30.171664+00:00 | 2 | 26 | 3 | 1 | 271779888 | ||
| 715 | 509719720639987712 509719720639987712 | 2025-07-28T13:51:35.589184+00:00 | 2 | 26 | 4 | 0 | 242161461 | ||
| 720 | 509719720639987712 509719720639987712 | 2025-07-28T14:11:42.281977+00:00 | 2 | 26 | 5 | 0 | 55531904 | ||
| 722 | 509719720639987712 509719720639987712 | 2025-07-28T14:17:00.070816+00:00 | 2 | 27 | 5 | 1 | 277153915 | ||
| 800 | 509719720639987712 509719720639987712 | 2025-07-29T05:39:31.283538+00:00 | 3 | 29 | 4 | 0 | 239702823 | ||
| 840 | 509719720639987712 509719720639987712 | 2025-07-29T13:46:01.924054+00:00 | 3 | 31 | 3 | 0 | 270496717 | ||
| 863 | 509719720639987712 509719720639987712 | 2025-07-29T16:26:49.145917+00:00 | 3 | 32 | 5 | 0 | 273365637 | ||
| 953 | 509719720639987712 509719720639987712 | 2025-07-30T13:37:44.150357+00:00 | 4 | 35 | 3 | 0 | 60241059 | ||
| 956 | 509719720639987712 509719720639987712 | 2025-07-30T13:42:53.462361+00:00 | 4 | 36 | 3 | 1 | 269831542 | ||
| 966 | 509719720639987712 509719720639987712 | 2025-07-30T14:45:42.850590+00:00 | 4 | 36 | 5 | 0 | 275128576 | ||
| 971 | 509719720639987712 509719720639987712 | 2025-07-30T14:59:55.979077+00:00 | 4 | 36 | 4 | 0 | 243861980 | ||
| 1020 | 509719720639987712 509719720639987712 | 2025-07-31T04:46:49.875508+00:00 | 5 | 38 | 3 | 0 | 269350870 | ||
| 1024 | 509719720639987712 509719720639987712 | 2025-07-31T05:06:09.403770+00:00 | 5 | 38 | 4 | 0 | 145008285 | ||
| 1027 | 509719720639987712 509719720639987712 | 2025-07-31T05:14:35.037412+00:00 | 5 | 39 | 5 | 0 | 81221700 | ||
| 1028 | 509719720639987712 509719720639987712 | 2025-07-31T05:25:25.282858+00:00 | 5 | 39 | 4 | 1 | 96151222 | ||
| 1029 | 509719720639987712 509719720639987712 | 2025-07-31T05:34:19.352094+00:00 | 5 | 40 | 5 | 1 | 244092801 | ||
| 1168 | 509719720639987712 509719720639987712 | 2025-08-27T07:15:49.433328+00:00 | 1 | 11 | 3 | 0 | |||
| 1169 | 509719720639987712 509719720639987712 | 2025-08-27T07:15:49.433328+00:00 | 1 | 12 | 3 | 1 | 自動產生，關聯至完整刀 ID:1168 | 1168 | |
| 1170 | 509719720639987712 509719720639987712 | 2025-08-27T07:19:17.935343+00:00 | 1 | 11 | 2 | 0 | |||
| 1171 | 509719720639987712 509719720639987712 | 2025-08-27T07:19:17.935343+00:00 | 1 | 12 | 2 | 1 | 自動產生，關聯至完整刀 ID:1170 | 1170 | |
| 1172 | 509719720639987712 509719720639987712 | 2025-08-27T07:21:24.381728+00:00 | 1 | 11 | 1 | 0 | |||
| 1173 | 509719720639987712 509719720639987712 | 2025-08-27T07:21:24.381728+00:00 | 1 | 12 | 1 | 1 | 自動產生，關聯至完整刀 ID:1172 | 1172 | |
| 1318 | 509719720639987712 509719720639987712 | 2025-08-28T12:24:13.115878+00:00 | 2 | 25 | 1 | 0 | 328600778 | ||
| 1352 | 509719720639987712 509719720639987712 | 2025-08-28T13:40:34.150062+00:00 | 2 | 26 | 2 | 0 | 250075629 | ||
| 1372 | 509719720639987712 509719720639987712 | 2025-08-28T14:54:53.390145+00:00 | 2 | 27 | 5 | 0 | 260456672 | ||
| 1420 | 509719720639987712 509719720639987712 | 2025-08-29T07:04:22.305366+00:00 | 3 | 29 | 5 | 0 | 260029499 | ||
| 1434 | 509719720639987712 509719720639987712 | 2025-08-29T13:17:31.989419+00:00 | 3 | 29 | 1 | 0 | 325775311 | ||
| 1453 | 509719720639987712 509719720639987712 | 2025-08-29T14:00:49.844213+00:00 | 3 | 30 | 2 | 0 | 250264762 | ||
| 1551 | 509719720639987712 509719720639987712 | 2025-08-30T07:40:12.293301+00:00 | 4 | 34 | 2 | 0 | 250131808 | ||
| 1563 | 509719720639987712 509719720639987712 | 2025-08-30T12:43:19.799163+00:00 | 4 | 34 | 1 | 0 | 240173210 | ||
| 1585 | 509719720639987712 509719720639987712 | 2025-08-30T14:36:46.573390+00:00 | 4 | 35 | 1 | 1 | 82280464 | ||
| 1588 | 509719720639987712 509719720639987712 | 2025-08-30T14:37:36.451274+00:00 | 4 | 36 | 5 | 0 | 235553933 | ||
| 1603 | 509719720639987712 509719720639987712 | 2025-08-30T15:54:03.557477+00:00 | 4 | 36 | 2 | 1 | 41360232 | ||
| 1672 | 509719720639987712 509719720639987712 | 2025-08-31T07:32:05.622677+00:00 | 5 | 39 | 5 | 0 | 260623789 | ||
| 1689 | 509719720639987712 509719720639987712 | 2025-08-31T10:57:00.238566+00:00 | 5 | 39 | 2 | 0 | 52863975 | ||
| 1692 | 509719720639987712 509719720639987712 | 2025-08-31T11:08:38.584030+00:00 | 5 | 40 | 2 | 1 | 250086515 | ||
| 1700 | 509719720639987712 509719720639987712 | 2025-08-31T12:14:21.361947+00:00 | 5 | 40 | 1 | 0 | 327202546 | ||
| 1809 | 509719720639987712 509719720639987712 | 2025-09-26T06:53:31.641893+00:00 | 1 | 13 | 5 | 0 | |||
| 1810 | 509719720639987712 509719720639987712 | 2025-09-26T06:53:31.641893+00:00 | 1 | 14 | 5 | 1 | 自動產生，關聯至完整刀 ID:1809 | 1809 | |
| 1811 | 509719720639987712 509719720639987712 | 2025-09-26T07:01:28.069127+00:00 | 1 | 13 | 4 | 0 | |||
| 1812 | 509719720639987712 509719720639987712 | 2025-09-26T07:01:28.069127+00:00 | 1 | 14 | 4 | 1 | 自動產生，關聯至完整刀 ID:1811 | 1811 | |
| 1813 | 509719720639987712 509719720639987712 | 2025-09-26T07:07:26.624228+00:00 | 1 | 13 | 1 | 0 | |||
| 1814 | 509719720639987712 509719720639987712 | 2025-09-26T07:07:26.624228+00:00 | 1 | 14 | 1 | 1 | 自動產生，關聯至完整刀 ID:1813 | 1813 | |
| 1936 | 509719720639987712 509719720639987712 | 2025-09-27T05:39:35.652605+00:00 | 2 | 25 | 3 | 0 | 393228103 | ||
| 1940 | 509719720639987712 509719720639987712 | 2025-09-27T06:03:35.214268+00:00 | 2 | 25 | 5 | 0 | 294851549 | ||
| 1951 | 509719720639987712 509719720639987712 | 2025-09-27T10:31:55.191557+00:00 | 2 | 26 | 4 | 0 | 261890633 | ||
| 2031 | 509719720639987712 509719720639987712 | 2025-09-28T05:26:13.460492+00:00 | 3 | 29 | 5 | 0 | 295477038 | ||
| 2081 | 509719720639987712 509719720639987712 | 2025-09-28T14:24:01.022368+00:00 | 3 | 32 | 3 | 0 | 393005339 | ||
| 2093 | 509719720639987712 509719720639987712 | 2025-09-28T14:44:41.729128+00:00 | 3 | 32 | 4 | 0 | 265122408 | ||
| 2147 | 509719720639987712 509719720639987712 | 2025-09-29T04:53:11.791704+00:00 | 4 | 34 | 5 | 0 | 295327711 | ||
| 2156 | 509719720639987712 509719720639987712 | 2025-09-29T05:32:42.712909+00:00 | 4 | 35 | 3 | 0 | 394343072 | ||
| 2202 | 509719720639987712 509719720639987712 | 2025-09-29T14:36:42.326866+00:00 | 4 | 37 | 2 | 0 | 149833892 | ||
| 2204 | 509719720639987712 509719720639987712 | 2025-09-29T14:54:59.087407+00:00 | 4 | 37 | 4 | 1 | 172827851 | ||
| 2278 | 509719720639987712 509719720639987712 | 2025-09-30T11:21:43.926742+00:00 | 5 | 41 | 3 | 0 | 394300528 | ||
| 2284 | 509719720639987712 509719720639987712 | 2025-09-30T11:56:13.648880+00:00 | 5 | 40 | 5 | 0 | 12986773 | ||
| 2287 | 509719720639987712 509719720639987712 | 2025-09-30T12:07:19.991248+00:00 | 5 | 41 | 5 | 1 | 295512043 | ||
| 2328 | 509719720639987712 509719720639987712 | 2025-09-30T14:02:54.822174+00:00 | 5 | 42 | 2 | 0 | 63923526 | ||
| 2337 | 509719720639987712 509719720639987712 | 2025-09-30T14:37:22.183672+00:00 | 5 | 42 | 4 | 1 | 264750352 |
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)
);