attacks
84 rows where member_id = 159343144243036162
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 |
|---|---|---|---|---|---|---|---|---|---|
| 47 | 159343144243036162 159343144243036162 | 2025-06-26T03:11:03.299018+00:00 | 1 | 11 | 2 | 0 | |||
| 48 | 159343144243036162 159343144243036162 | 2025-06-26T03:11:03.299018+00:00 | 1 | 12 | 2 | 1 | 自動產生，關聯至完整刀 ID:47 | 47 | |
| 49 | 159343144243036162 159343144243036162 | 2025-06-26T03:15:47.497631+00:00 | 1 | 11 | 3 | 0 | |||
| 50 | 159343144243036162 159343144243036162 | 2025-06-26T03:15:47.497631+00:00 | 1 | 12 | 3 | 1 | 自動產生，關聯至完整刀 ID:49 | 49 | |
| 51 | 159343144243036162 159343144243036162 | 2025-06-26T03:21:04.351064+00:00 | 1 | 11 | 4 | 0 | |||
| 52 | 159343144243036162 159343144243036162 | 2025-06-26T03:21:04.351064+00:00 | 1 | 12 | 4 | 1 | 自動產生，關聯至完整刀 ID:51 | 51 | |
| 122 | 159343144243036162 159343144243036162 | 2025-06-27T02:24:45.350966+00:00 | 2 | 25 | 5 | 0 | 207294302 | ||
| 123 | 159343144243036162 159343144243036162 | 2025-06-27T02:49:38.535237+00:00 | 2 | 25 | 3 | 0 | 170044112 | ||
| 124 | 159343144243036162 159343144243036162 | 2025-06-27T03:15:44.546662+00:00 | 2 | 25 | 2 | 0 | 216511689 | ||
| 257 | 159343144243036162 159343144243036162 | 2025-06-28T14:06:15.879417+00:00 | 3 | 31 | 3 | 0 | 170284811 | ||
| 260 | 159343144243036162 159343144243036162 | 2025-06-28T14:23:37.444771+00:00 | 3 | 31 | 4 | 0 | 224209784 | ||
| 266 | 159343144243036162 159343144243036162 | 2025-06-28T14:42:49.226074+00:00 | 3 | 31 | 2 | 0 | 77562124 | ||
| 267 | 159343144243036162 159343144243036162 | 2025-06-28T14:44:53.335067+00:00 | 3 | 32 | 2 | 1 | 101600812 | ||
| 292 | 159343144243036162 159343144243036162 | 2025-06-29T03:20:20.715775+00:00 | 4 | 32 | 3 | 0 | 168911733 | ||
| 293 | 159343144243036162 159343144243036162 | 2025-06-29T03:25:00.441361+00:00 | 4 | 34 | 2 | 0 | 209831249 | ||
| 296 | 159343144243036162 159343144243036162 | 2025-06-29T03:40:56.513328+00:00 | 4 | 33 | 1 | 0 | 165956551 | ||
| 315 | 159343144243036162 159343144243036162 | 2025-06-29T10:04:38.028764+00:00 | 4 | 34 | 1 | 1 | 19067524 | ||
| 384 | 159343144243036162 159343144243036162 | 2025-06-30T02:57:10.981560+00:00 | 5 | 38 | 2 | 0 | 213302197 | ||
| 385 | 159343144243036162 159343144243036162 | 2025-06-30T03:05:10.641485+00:00 | 5 | 37 | 3 | 0 | 169048632 | ||
| 386 | 159343144243036162 159343144243036162 | 2025-06-30T03:12:35.171861+00:00 | 5 | 38 | 1 | 0 | 183705124 | ||
| 511 | 159343144243036162 159343144243036162 | 2025-07-27T03:49:17.659002+00:00 | 1 | 7 | 2 | 0 | 56000000 | ||
| 512 | 159343144243036162 159343144243036162 | 2025-07-27T03:49:17.659002+00:00 | 1 | 8 | 2 | 1 | 自動產生，關聯至完整刀 ID:511 | 511 | |
| 515 | 159343144243036162 159343144243036162 | 2025-07-27T03:50:44.528863+00:00 | 1 | 8 | 2 | 0 | 56000000 | ||
| 516 | 159343144243036162 159343144243036162 | 2025-07-27T03:50:44.528863+00:00 | 1 | 9 | 2 | 1 | 自動產生，關聯至完整刀 ID:515 | 515 | |
| 517 | 159343144243036162 159343144243036162 | 2025-07-27T03:53:22.273865+00:00 | 1 | 7 | 3 | 0 | 64000000 | ||
| 518 | 159343144243036162 159343144243036162 | 2025-07-27T03:53:22.273865+00:00 | 1 | 8 | 3 | 1 | 自動產生，關聯至完整刀 ID:517 | 517 | |
| 668 | 159343144243036162 159343144243036162 | 2025-07-28T03:48:17.533289+00:00 | 2 | 24 | 5 | 0 | 279863840 | ||
| 669 | 159343144243036162 159343144243036162 | 2025-07-28T03:56:25.204033+00:00 | 2 | 24 | 4 | 0 | 244697506 | ||
| 671 | 159343144243036162 159343144243036162 | 2025-07-28T04:09:58.702976+00:00 | 2 | 25 | 3 | 0 | 277867512 | ||
| 781 | 159343144243036162 159343144243036162 | 2025-07-29T03:39:52.298443+00:00 | 3 | 29 | 3 | 0 | 266589027 | ||
| 782 | 159343144243036162 159343144243036162 | 2025-07-29T03:43:53.318559+00:00 | 3 | 28 | 4 | 0 | 197426765 | ||
| 783 | 159343144243036162 159343144243036162 | 2025-07-29T04:10:12.647694+00:00 | 3 | 29 | 5 | 0 | 280388158 | ||
| 785 | 159343144243036162 159343144243036162 | 2025-07-29T04:19:09.125498+00:00 | 3 | 29 | 1 | 1 | 51856128 | ||
| 788 | 159343144243036162 159343144243036162 | 2025-07-29T04:26:59.049130+00:00 | 3 | 30 | 5 | 0 | 6060906 | ||
| 898 | 159343144243036162 159343144243036162 | 2025-07-30T04:08:08.469192+00:00 | 4 | 34 | 3 | 0 | 275527273 | ||
| 900 | 159343144243036162 159343144243036162 | 2025-07-30T04:12:15.492121+00:00 | 4 | 34 | 5 | 0 | 282452135 | ||
| 901 | 159343144243036162 159343144243036162 | 2025-07-30T04:19:11.468974+00:00 | 4 | 33 | 4 | 0 | 210638194 | ||
| 903 | 159343144243036162 159343144243036162 | 2025-07-30T05:50:59.857449+00:00 | 4 | 34 | 5 | 1 | 12332758 | ||
| 1001 | 159343144243036162 159343144243036162 | 2025-07-31T00:27:27.526603+00:00 | 5 | 38 | 4 | 0 | 242906010 | ||
| 1002 | 159343144243036162 159343144243036162 | 2025-07-31T00:31:39.978298+00:00 | 5 | 38 | 3 | 0 | 275915496 | ||
| 1003 | 159343144243036162 159343144243036162 | 2025-07-31T00:35:48.635871+00:00 | 5 | 38 | 5 | 0 | 284260380 | ||
| 1132 | 159343144243036162 159343144243036162 | 2025-08-27T02:47:31.401749+00:00 | 1 | 5 | 5 | 0 | 30000000 | ||
| 1133 | 159343144243036162 159343144243036162 | 2025-08-27T02:47:31.401749+00:00 | 1 | 6 | 5 | 1 | 自動產生，關聯至完整刀 ID:1132 | 1132 | |
| 1134 | 159343144243036162 159343144243036162 | 2025-08-27T02:50:01.701979+00:00 | 1 | 5 | 2 | 0 | 15000000 | ||
| 1135 | 159343144243036162 159343144243036162 | 2025-08-27T02:50:01.701979+00:00 | 1 | 6 | 2 | 1 | 自動產生，關聯至完整刀 ID:1134 | 1134 | |
| 1136 | 159343144243036162 159343144243036162 | 2025-08-27T02:51:58.738478+00:00 | 1 | 5 | 1 | 0 | 12000000 | ||
| 1137 | 159343144243036162 159343144243036162 | 2025-08-27T02:51:58.738478+00:00 | 1 | 6 | 1 | 1 | 自動產生，關聯至完整刀 ID:1136 | 1136 | |
| 1294 | 159343144243036162 159343144243036162 | 2025-08-28T04:09:33.791940+00:00 | 2 | 24 | 2 | 0 | 253989186 | ||
| 1296 | 159343144243036162 159343144243036162 | 2025-08-28T04:17:43.835190+00:00 | 2 | 25 | 1 | 0 | 289828799 | ||
| 1299 | 159343144243036162 159343144243036162 | 2025-08-28T04:26:36.357224+00:00 | 2 | 24 | 5 | 0 | 173616308 | ||
| 1300 | 159343144243036162 159343144243036162 | 2025-08-28T04:30:34.131254+00:00 | 2 | 25 | 5 | 1 | 43190531 | ||
| 1408 | 159343144243036162 159343144243036162 | 2025-08-29T03:15:35.333123+00:00 | 3 | 29 | 2 | 0 | 253840504 | ||
| 1409 | 159343144243036162 159343144243036162 | 2025-08-29T03:21:53.359272+00:00 | 3 | 29 | 5 | 0 | 266875083 | ||
| 1410 | 159343144243036162 159343144243036162 | 2025-08-29T03:32:18.197164+00:00 | 3 | 29 | 3 | 0 | 264621810 | ||
| 1411 | 159343144243036162 159343144243036162 | 2025-08-29T03:37:53.537147+00:00 | 3 | 29 | 5 | 1 | 40074282 | ||
| 1538 | 159343144243036162 159343144243036162 | 2025-08-30T04:45:09.802302+00:00 | 4 | 34 | 3 | 0 | 282644630 | ||
| 1540 | 159343144243036162 159343144243036162 | 2025-08-30T04:50:27.374201+00:00 | 4 | 34 | 5 | 0 | 241342972 | ||
| 1541 | 159343144243036162 159343144243036162 | 2025-08-30T05:00:03.333419+00:00 | 4 | 35 | 4 | 0 | 384412303 | ||
| 1624 | 159343144243036162 159343144243036162 | 2025-08-30T18:08:41.732201+00:00 | 4 | 38 | 2 | 0 | 33718132 | ||
| 1634 | 159343144243036162 159343144243036162 | 2025-08-31T03:44:30.305781+00:00 | 5 | 38 | 2 | 0 | 254711237 | ||
| 1652 | 159343144243036162 159343144243036162 | 2025-08-31T04:47:56.508377+00:00 | 5 | 39 | 3 | 0 | 279859818 | ||
| 1686 | 159343144243036162 159343144243036162 | 2025-08-31T10:25:18.095811+00:00 | 5 | 40 | 5 | 0 | 86319399 | ||
| 1712 | 159343144243036162 159343144243036162 | 2025-08-31T13:02:35.715546+00:00 | 5 | 41 | 1 | 1 | 207962941 | ||
| 1785 | 159343144243036162 159343144243036162 | 2025-09-26T03:38:08.969360+00:00 | 1 | 7 | 4 | 0 | |||
| 1786 | 159343144243036162 159343144243036162 | 2025-09-26T03:38:08.969360+00:00 | 1 | 8 | 4 | 1 | 自動產生，關聯至完整刀 ID:1785 | 1785 | |
| 1787 | 159343144243036162 159343144243036162 | 2025-09-26T03:41:19.775686+00:00 | 1 | 7 | 5 | 0 | |||
| 1788 | 159343144243036162 159343144243036162 | 2025-09-26T03:41:19.775686+00:00 | 1 | 8 | 5 | 1 | 自動產生，關聯至完整刀 ID:1787 | 1787 | |
| 1789 | 159343144243036162 159343144243036162 | 2025-09-26T03:44:46.917470+00:00 | 1 | 9 | 3 | 0 | |||
| 1790 | 159343144243036162 159343144243036162 | 2025-09-26T03:44:46.917470+00:00 | 1 | 10 | 3 | 1 | 自動產生，關聯至完整刀 ID:1789 | 1789 | |
| 1916 | 159343144243036162 159343144243036162 | 2025-09-27T03:52:15.730893+00:00 | 2 | 25 | 4 | 0 | 250048042 | ||
| 1918 | 159343144243036162 159343144243036162 | 2025-09-27T04:07:09.986976+00:00 | 2 | 24 | 1 | 0 | 41034073 | ||
| 1919 | 159343144243036162 159343144243036162 | 2025-09-27T04:10:13.038506+00:00 | 2 | 25 | 1 | 1 | 314109159 | ||
| 1920 | 159343144243036162 159343144243036162 | 2025-09-27T04:28:06.752361+00:00 | 2 | 25 | 5 | 0 | 290758330 | ||
| 2027 | 159343144243036162 159343144243036162 | 2025-09-28T02:27:32.456507+00:00 | 3 | 30 | 4 | 0 | 282957412 | ||
| 2029 | 159343144243036162 159343144243036162 | 2025-09-28T03:45:35.629950+00:00 | 3 | 29 | 1 | 0 | 284150126 | ||
| 2033 | 159343144243036162 159343144243036162 | 2025-09-28T05:34:56.161921+00:00 | 3 | 30 | 5 | 0 | 290528294 | ||
| 2064 | 159343144243036162 159343144243036162 | 2025-09-28T11:28:56.753638+00:00 | 3 | 32 | 2 | 0 | 31364405 | ||
| 2130 | 159343144243036162 159343144243036162 | 2025-09-29T03:43:35.401735+00:00 | 4 | 34 | 4 | 0 | 283100103 | ||
| 2153 | 159343144243036162 159343144243036162 | 2025-09-29T05:14:37.330372+00:00 | 4 | 35 | 5 | 0 | 290568209 | ||
| 2161 | 159343144243036162 159343144243036162 | 2025-09-29T07:10:52.931169+00:00 | 4 | 35 | 2 | 0 | 316220246 | ||
| 2255 | 159343144243036162 159343144243036162 | 2025-09-30T04:16:23.965063+00:00 | 5 | 39 | 1 | 0 | 312646418 | ||
| 2257 | 159343144243036162 159343144243036162 | 2025-09-30T04:24:41.318430+00:00 | 5 | 39 | 5 | 0 | 290426300 | ||
| 2259 | 159343144243036162 159343144243036162 | 2025-09-30T04:31:48.353868+00:00 | 5 | 39 | 3 | 0 | 346776698 | ||
| 2275 | 159343144243036162 159343144243036162 | 2025-09-30T10:41:37.460617+00:00 | 5 | 39 | 4 | 1 | 9168622 |
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)
);