attacks
76 rows where member_id = 282193684391264259
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 |
|---|---|---|---|---|---|---|---|---|---|
| 94 | 282193684391264259 282193684391264259 | 2025-06-26T15:42:14.378150+00:00 | 1 | 23 | 3 | 0 | 126585009 | ||
| 95 | 282193684391264259 282193684391264259 | 2025-06-26T15:45:09.246839+00:00 | 1 | 24 | 3 | 1 | 35820062 | ||
| 99 | 282193684391264259 282193684391264259 | 2025-06-26T16:05:21.108697+00:00 | 2 | 23 | 2 | 0 | 162835111 | ||
| 100 | 282193684391264259 282193684391264259 | 2025-06-26T16:06:27.572404+00:00 | 2 | 24 | 2 | 1 | 17642699 | ||
| 102 | 282193684391264259 282193684391264259 | 2025-06-26T16:28:29.166411+00:00 | 2 | 24 | 5 | 0 | 200195342 | ||
| 177 | 282193684391264259 282193684391264259 | 2025-06-27T16:30:45.327077+00:00 | 2 | 28 | 5 | 0 | 199333398 | ||
| 178 | 282193684391264259 282193684391264259 | 2025-06-27T16:35:23.806138+00:00 | 2 | 27 | 3 | 0 | 162966606 | ||
| 186 | 282193684391264259 282193684391264259 | 2025-06-27T17:38:58.481820+00:00 | 2 | 28 | 2 | 0 | 103652308 | ||
| 187 | 282193684391264259 282193684391264259 | 2025-06-27T17:39:08.761648+00:00 | 2 | 29 | 2 | 1 | 58908640 | ||
| 276 | 282193684391264259 282193684391264259 | 2025-06-28T16:28:59.955965+00:00 | 3 | 31 | 3 | 0 | 83661053 | ||
| 278 | 282193684391264259 282193684391264259 | 2025-06-28T16:31:35.324808+00:00 | 3 | 32 | 3 | 1 | 69394803 | ||
| 280 | 282193684391264259 282193684391264259 | 2025-06-28T16:33:39.634536+00:00 | 3 | 32 | 2 | 0 | 46351867 | ||
| 281 | 282193684391264259 282193684391264259 | 2025-06-28T16:36:05.973755+00:00 | 3 | 33 | 2 | 1 | 116981975 | ||
| 282 | 282193684391264259 282193684391264259 | 2025-06-28T16:41:44.555769+00:00 | 3 | 33 | 5 | 0 | 206463123 | ||
| 362 | 282193684391264259 282193684391264259 | 2025-06-29T14:31:05.806436+00:00 | 4 | 36 | 5 | 0 | 189122915 | ||
| 363 | 282193684391264259 282193684391264259 | 2025-06-29T14:37:07.847228+00:00 | 4 | 37 | 2 | 0 | 195467978 | ||
| 365 | 282193684391264259 282193684391264259 | 2025-06-29T16:14:51.647122+00:00 | 4 | 36 | 3 | 0 | 164345705 | ||
| 366 | 282193684391264259 282193684391264259 | 2025-06-29T16:23:51.055408+00:00 | 4 | 36 | 3 | 1 | 35571619 | ||
| 429 | 282193684391264259 282193684391264259 | 2025-06-30T12:57:24.254682+00:00 | 5 | 39 | 3 | 0 | 164004791 | ||
| 431 | 282193684391264259 282193684391264259 | 2025-06-30T13:01:37.148231+00:00 | 5 | 40 | 2 | 0 | 196366183 | ||
| 443 | 282193684391264259 282193684391264259 | 2025-06-30T14:04:54.781608+00:00 | 5 | 41 | 5 | 0 | 171697691 | ||
| 659 | 282193684391264259 282193684391264259 | 2025-07-27T20:00:02.979089+00:00 | 1 | 24 | 4 | 0 | 221569374 | ||
| 660 | 282193684391264259 282193684391264259 | 2025-07-27T20:12:41.203898+00:00 | 1 | 24 | 5 | 0 | 271918120 | ||
| 661 | 282193684391264259 282193684391264259 | 2025-07-27T20:21:06.129264+00:00 | 1 | 24 | 3 | 0 | 268263070 | ||
| 755 | 282193684391264259 282193684391264259 | 2025-07-28T16:12:21.671200+00:00 | 2 | 28 | 5 | 0 | 276538189 | ||
| 757 | 282193684391264259 282193684391264259 | 2025-07-28T16:17:00.115287+00:00 | 2 | 28 | 3 | 0 | 269090912 | ||
| 758 | 282193684391264259 282193684391264259 | 2025-07-28T16:21:32.325869+00:00 | 2 | 28 | 4 | 0 | 241921649 | ||
| 874 | 282193684391264259 282193684391264259 | 2025-07-29T18:09:22.980322+00:00 | 3 | 32 | 4 | 0 | 241453781 | ||
| 875 | 282193684391264259 282193684391264259 | 2025-07-29T18:13:19.617347+00:00 | 3 | 32 | 3 | 0 | 271673258 | ||
| 876 | 282193684391264259 282193684391264259 | 2025-07-29T18:16:49.048754+00:00 | 3 | 33 | 5 | 0 | 276557886 | ||
| 990 | 282193684391264259 282193684391264259 | 2025-07-30T19:24:20.366449+00:00 | 4 | 37 | 3 | 0 | 271169092 | ||
| 991 | 282193684391264259 282193684391264259 | 2025-07-30T19:33:18.643731+00:00 | 4 | 37 | 4 | 0 | 239868290 | ||
| 992 | 282193684391264259 282193684391264259 | 2025-07-30T19:37:12.412847+00:00 | 4 | 38 | 5 | 0 | 276807928 | ||
| 1064 | 282193684391264259 282193684391264259 | 2025-07-31T12:49:26.565929+00:00 | 5 | 40 | 5 | 0 | 103237160 | ||
| 1066 | 282193684391264259 282193684391264259 | 2025-07-31T12:53:46.298934+00:00 | 5 | 41 | 5 | 1 | 104099635 | ||
| 1070 | 282193684391264259 282193684391264259 | 2025-07-31T13:01:08.112046+00:00 | 5 | 40 | 3 | 0 | 159954722 | ||
| 1071 | 282193684391264259 282193684391264259 | 2025-07-31T13:03:17.539232+00:00 | 5 | 41 | 3 | 1 | 151053299 | ||
| 1074 | 282193684391264259 282193684391264259 | 2025-07-31T13:11:43.305693+00:00 | 5 | 41 | 4 | 0 | 225270491 | ||
| 1260 | 282193684391264259 282193684391264259 | 2025-08-27T15:40:49.201199+00:00 | 1 | 23 | 5 | 0 | 224188492 | ||
| 1265 | 282193684391264259 282193684391264259 | 2025-08-27T16:08:01.320200+00:00 | 1 | 24 | 3 | 0 | 277456734 | ||
| 1277 | 282193684391264259 282193684391264259 | 2025-08-27T18:15:37.168852+00:00 | 1 | 24 | 4 | 0 | 382459002 | ||
| 1382 | 282193684391264259 282193684391264259 | 2025-08-28T17:48:43.959125+00:00 | 2 | 28 | 5 | 0 | 246451303 | ||
| 1383 | 282193684391264259 282193684391264259 | 2025-08-28T17:54:09.552116+00:00 | 2 | 28 | 4 | 0 | 382920506 | ||
| 1387 | 282193684391264259 282193684391264259 | 2025-08-28T18:01:03.186378+00:00 | 2 | 28 | 3 | 0 | 276139547 | ||
| 1389 | 282193684391264259 282193684391264259 | 2025-08-28T18:09:40.171901+00:00 | 2 | 28 | 2 | 1 | 24655640 | ||
| 1505 | 282193684391264259 282193684391264259 | 2025-08-29T18:24:33.045221+00:00 | 3 | 33 | 5 | 0 | 262259762 | ||
| 1506 | 282193684391264259 282193684391264259 | 2025-08-29T18:30:40.877066+00:00 | 3 | 33 | 4 | 0 | 382244339 | ||
| 1507 | 282193684391264259 282193684391264259 | 2025-08-29T18:35:42.341714+00:00 | 3 | 33 | 3 | 0 | 279361543 | ||
| 1618 | 282193684391264259 282193684391264259 | 2025-08-30T17:08:32.624389+00:00 | 4 | 38 | 4 | 0 | 382130954 | ||
| 1619 | 282193684391264259 282193684391264259 | 2025-08-30T17:13:42.532592+00:00 | 4 | 38 | 3 | 0 | 282756768 | ||
| 1626 | 282193684391264259 282193684391264259 | 2025-08-30T18:17:38.239942+00:00 | 4 | 37 | 5 | 0 | 262922845 | ||
| 1680 | 282193684391264259 282193684391264259 | 2025-08-31T09:33:03.941823+00:00 | 5 | 40 | 4 | 0 | 55513463 | ||
| 1682 | 282193684391264259 282193684391264259 | 2025-08-31T09:39:28.741771+00:00 | 5 | 39 | 3 | 0 | 281231207 | ||
| 1685 | 282193684391264259 282193684391264259 | 2025-08-31T10:23:56.653780+00:00 | 5 | 40 | 5 | 0 | 261720496 | ||
| 1716 | 282193684391264259 282193684391264259 | 2025-08-31T13:12:09.066871+00:00 | 5 | 41 | 4 | 1 | 382830216 | ||
| 1889 | 282193684391264259 282193684391264259 | 2025-09-26T18:34:21.980584+00:00 | 1 | 23 | 5 | 0 | 92101004 | ||
| 1893 | 282193684391264259 282193684391264259 | 2025-09-26T18:49:31.172798+00:00 | 1 | 24 | 5 | 1 | 175457149 | ||
| 1902 | 282193684391264259 282193684391264259 | 2025-09-26T19:49:38.618097+00:00 | 1 | 24 | 4 | 0 | 252170132 | ||
| 1903 | 282193684391264259 282193684391264259 | 2025-09-26T20:03:22.565484+00:00 | 1 | 24 | 3 | 0 | 349144677 | ||
| 1956 | 282193684391264259 282193684391264259 | 2025-09-27T11:48:10.960234+00:00 | 2 | 26 | 3 | 0 | 102749965 | ||
| 1957 | 282193684391264259 282193684391264259 | 2025-09-27T11:52:25.791678+00:00 | 2 | 27 | 3 | 1 | 297280649 | ||
| 1959 | 282193684391264259 282193684391264259 | 2025-09-27T12:04:04.822918+00:00 | 2 | 26 | 5 | 0 | 88301864 | ||
| 1960 | 282193684391264259 282193684391264259 | 2025-09-27T12:11:23.458015+00:00 | 2 | 27 | 5 | 0 | 262997250 | ||
| 1961 | 282193684391264259 282193684391264259 | 2025-09-27T12:15:57.724740+00:00 | 2 | 27 | 4 | 0 | 251807519 | ||
| 2092 | 282193684391264259 282193684391264259 | 2025-09-28T14:44:07.943566+00:00 | 3 | 33 | 3 | 0 | 349253510 | ||
| 2097 | 282193684391264259 282193684391264259 | 2025-09-28T14:49:14.043231+00:00 | 3 | 33 | 4 | 0 | 251903951 | ||
| 2105 | 282193684391264259 282193684391264259 | 2025-09-28T15:17:50.010461+00:00 | 3 | 32 | 5 | 0 | 274944570 | ||
| 2107 | 282193684391264259 282193684391264259 | 2025-09-28T15:22:43.946890+00:00 | 3 | 33 | 5 | 1 | 15673386 | ||
| 2231 | 282193684391264259 282193684391264259 | 2025-09-29T19:08:46.429668+00:00 | 4 | 38 | 5 | 0 | 288362548 | ||
| 2232 | 282193684391264259 282193684391264259 | 2025-09-29T19:12:59.532113+00:00 | 4 | 38 | 4 | 0 | 251133579 | ||
| 2236 | 282193684391264259 282193684391264259 | 2025-09-29T19:19:23.523305+00:00 | 4 | 38 | 3 | 0 | 34204234 | ||
| 2237 | 282193684391264259 282193684391264259 | 2025-09-29T19:23:19.625360+00:00 | 4 | 39 | 3 | 1 | 349259976 | ||
| 2318 | 282193684391264259 282193684391264259 | 2025-09-30T13:24:22.683521+00:00 | 5 | 41 | 5 | 0 | 9477115 | ||
| 2319 | 282193684391264259 282193684391264259 | 2025-09-30T13:24:33.920316+00:00 | 5 | 42 | 5 | 1 | 287958497 | ||
| 2320 | 282193684391264259 282193684391264259 | 2025-09-30T13:28:49.332483+00:00 | 5 | 42 | 4 | 0 | 252006357 | ||
| 2325 | 282193684391264259 282193684391264259 | 2025-09-30T14:01:21.641354+00:00 | 5 | 42 | 3 | 0 | 348658559 |
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)
);