attacks
163 rows where member_id = 651819395059810306
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 |
|---|---|---|---|---|---|---|---|---|---|
| 90 | 651819395059810306 651819395059810306 | 2025-06-26T15:15:34.416558+00:00 | 1 | 23 | 5 | 0 | 207356347 | ||
| 91 | 651819395059810306 651819395059810306 | 2025-06-26T15:16:02.038788+00:00 | 1 | 23 | 5 | 0 | 14439137 | ||
| 92 | 651819395059810306 651819395059810306 | 2025-06-26T15:31:07.835504+00:00 | 1 | 24 | 5 | 1 | 204333193 | ||
| 97 | 651819395059810306 651819395059810306 | 2025-06-26T15:56:18.607352+00:00 | 1 | 23 | 4 | 0 | 125604800 | ||
| 101 | 651819395059810306 651819395059810306 | 2025-06-26T16:08:47.959413+00:00 | 2 | 23 | 4 | 0 | 215175996 | ||
| 103 | 651819395059810306 651819395059810306 | 2025-06-26T16:31:51.626948+00:00 | 2 | 23 | 1 | 0 | 180714660 | ||
| 104 | 651819395059810306 651819395059810306 | 2025-06-26T16:38:08.019501+00:00 | 2 | 24 | 3 | 1 | 58710102 | ||
| 107 | 651819395059810306 651819395059810306 | 2025-06-26T16:49:15.202414+00:00 | 2 | 24 | 3 | 0 | 163200188 | ||
| 152 | 651819395059810306 651819395059810306 | 2025-06-27T14:00:35.620396+00:00 | 2 | 26 | 1 | 0 | 179819838 | ||
| 154 | 651819395059810306 651819395059810306 | 2025-06-27T14:13:25.108913+00:00 | 2 | 26 | 1 | 0 | 180380543 | ||
| 157 | 651819395059810306 651819395059810306 | 2025-06-27T14:45:36.921312+00:00 | 2 | 26 | 4 | 0 | 214742047 | ||
| 158 | 651819395059810306 651819395059810306 | 2025-06-27T14:45:55.431014+00:00 | 2 | 26 | 4 | 0 | 72583142 | ||
| 159 | 651819395059810306 651819395059810306 | 2025-06-27T14:52:17.939369+00:00 | 2 | 27 | 4 | 1 | 145098192 | ||
| 161 | 651819395059810306 651819395059810306 | 2025-06-27T14:58:52.410622+00:00 | 2 | 26 | 3 | 0 | 65015492 | ||
| 162 | 651819395059810306 651819395059810306 | 2025-06-27T15:08:21.514427+00:00 | 2 | 27 | 3 | 1 | 109422934 | ||
| 163 | 651819395059810306 651819395059810306 | 2025-06-27T15:13:40.310188+00:00 | 2 | 27 | 3 | 0 | 168549560 | ||
| 253 | 651819395059810306 651819395059810306 | 2025-06-28T13:43:24.153200+00:00 | 3 | 30 | 4 | 0 | 19401880 | ||
| 254 | 651819395059810306 651819395059810306 | 2025-06-28T13:50:42.259215+00:00 | 3 | 31 | 4 | 1 | 214434920 | ||
| 255 | 651819395059810306 651819395059810306 | 2025-06-28T14:01:28.862119+00:00 | 3 | 31 | 4 | 0 | 213559869 | ||
| 258 | 651819395059810306 651819395059810306 | 2025-06-28T14:19:27.942493+00:00 | 3 | 31 | 1 | 0 | 179476873 | ||
| 259 | 651819395059810306 651819395059810306 | 2025-06-28T14:19:43.738532+00:00 | 3 | 31 | 1 | 0 | 42505537 | ||
| 262 | 651819395059810306 651819395059810306 | 2025-06-28T14:26:01.176385+00:00 | 3 | 32 | 1 | 1 | 176950999 | ||
| 264 | 651819395059810306 651819395059810306 | 2025-06-28T14:33:25.682648+00:00 | 3 | 31 | 3 | 0 | 169498032 | ||
| 265 | 651819395059810306 651819395059810306 | 2025-06-28T14:34:23.279460+00:00 | 3 | 31 | 3 | 0 | 168974362 | ||
| 316 | 651819395059810306 651819395059810306 | 2025-06-29T10:14:12.582084+00:00 | 4 | 34 | 1 | 0 | 38598292 | ||
| 317 | 651819395059810306 651819395059810306 | 2025-06-29T10:20:34.985221+00:00 | 4 | 35 | 1 | 1 | 135132828 | ||
| 320 | 651819395059810306 651819395059810306 | 2025-06-29T10:26:25.600369+00:00 | 4 | 35 | 1 | 0 | 178909863 | ||
| 322 | 651819395059810306 651819395059810306 | 2025-06-29T10:37:29.917921+00:00 | 4 | 34 | 3 | 0 | 167397104 | ||
| 323 | 651819395059810306 651819395059810306 | 2025-06-29T10:37:43.761574+00:00 | 4 | 34 | 3 | 0 | 64323232 | ||
| 324 | 651819395059810306 651819395059810306 | 2025-06-29T10:41:31.025881+00:00 | 4 | 35 | 3 | 1 | 121362339 | ||
| 330 | 651819395059810306 651819395059810306 | 2025-06-29T11:20:55.827879+00:00 | 4 | 34 | 5 | 0 | 172370947 | ||
| 331 | 651819395059810306 651819395059810306 | 2025-06-29T11:21:06.408697+00:00 | 4 | 34 | 5 | 0 | 138194958 | ||
| 341 | 651819395059810306 651819395059810306 | 2025-06-29T12:52:05.095778+00:00 | 4 | 36 | 5 | 1 | 20169342 | ||
| 430 | 651819395059810306 651819395059810306 | 2025-06-30T13:01:18.477234+00:00 | 5 | 40 | 4 | 0 | 199851527 | ||
| 432 | 651819395059810306 651819395059810306 | 2025-06-30T13:10:08.279707+00:00 | 5 | 39 | 3 | 0 | 170971636 | ||
| 433 | 651819395059810306 651819395059810306 | 2025-06-30T13:10:30.299399+00:00 | 5 | 39 | 3 | 0 | 8939183 | ||
| 434 | 651819395059810306 651819395059810306 | 2025-06-30T13:14:28.180648+00:00 | 5 | 40 | 3 | 1 | 170757569 | ||
| 437 | 651819395059810306 651819395059810306 | 2025-06-30T13:27:27.817678+00:00 | 5 | 40 | 1 | 0 | 76017309 | ||
| 438 | 651819395059810306 651819395059810306 | 2025-06-30T13:32:26.470037+00:00 | 5 | 41 | 1 | 1 | 127097005 | ||
| 439 | 651819395059810306 651819395059810306 | 2025-06-30T13:39:37.451415+00:00 | 5 | 41 | 4 | 0 | 193342744 | ||
| 440 | 651819395059810306 651819395059810306 | 2025-06-30T13:46:24.684833+00:00 | 5 | 40 | 3 | 1 | 43386005 | ||
| 441 | 651819395059810306 651819395059810306 | 2025-06-30T13:50:20.400950+00:00 | 5 | 40 | 3 | 1 | 43632761 | ||
| 442 | 651819395059810306 651819395059810306 | 2025-06-30T13:56:43.518017+00:00 | 5 | 41 | 5 | 0 | 171532620 | ||
| 622 | 651819395059810306 651819395059810306 | 2025-07-27T14:16:09.001268+00:00 | 1 | 23 | 5 | 0 | 296972407 | ||
| 623 | 651819395059810306 651819395059810306 | 2025-07-27T14:25:26.694262+00:00 | 1 | 23 | 5 | 0 | 303546693 | ||
| 636 | 651819395059810306 651819395059810306 | 2025-07-27T15:31:18.301641+00:00 | 1 | 23 | 4 | 0 | 239189391 | ||
| 637 | 651819395059810306 651819395059810306 | 2025-07-27T15:31:40.437719+00:00 | 1 | 23 | 4 | 0 | 234391729 | ||
| 645 | 651819395059810306 651819395059810306 | 2025-07-27T16:02:19.521193+00:00 | 1 | 23 | 3 | 0 | 260916425 | ||
| 646 | 651819395059810306 651819395059810306 | 2025-07-27T16:02:34.099927+00:00 | 1 | 23 | 3 | 0 | 63285719 | ||
| 649 | 651819395059810306 651819395059810306 | 2025-07-27T16:08:11.280769+00:00 | 1 | 24 | 3 | 1 | 251029499 | ||
| 719 | 651819395059810306 651819395059810306 | 2025-07-28T14:09:56.710423+00:00 | 2 | 26 | 5 | 0 | 295680375 | ||
| 726 | 651819395059810306 651819395059810306 | 2025-07-28T14:30:01.793969+00:00 | 2 | 27 | 2 | 0 | 66501598 | ||
| 727 | 651819395059810306 651819395059810306 | 2025-07-28T14:33:49.055821+00:00 | 2 | 26 | 3 | 0 | 262468204 | ||
| 738 | 651819395059810306 651819395059810306 | 2025-07-28T15:02:16.884096+00:00 | 2 | 28 | 2 | 1 | 341792006 | ||
| 739 | 651819395059810306 651819395059810306 | 2025-07-28T15:11:48.185944+00:00 | 2 | 27 | 3 | 0 | 262442693 | ||
| 741 | 651819395059810306 651819395059810306 | 2025-07-28T15:17:31.375937+00:00 | 2 | 27 | 4 | 0 | 241482177 | ||
| 746 | 651819395059810306 651819395059810306 | 2025-07-28T15:30:10.581885+00:00 | 2 | 27 | 5 | 0 | 302427895 | ||
| 835 | 651819395059810306 651819395059810306 | 2025-07-29T13:29:31.553086+00:00 | 3 | 31 | 5 | 0 | 296785616 | ||
| 837 | 651819395059810306 651819395059810306 | 2025-07-29T13:38:34.976441+00:00 | 3 | 32 | 5 | 0 | 302109399 | ||
| 841 | 651819395059810306 651819395059810306 | 2025-07-29T13:47:12.259319+00:00 | 3 | 31 | 4 | 0 | 240371196 | ||
| 843 | 651819395059810306 651819395059810306 | 2025-07-29T14:00:05.805284+00:00 | 3 | 31 | 2 | 0 | 341638932 | ||
| 844 | 651819395059810306 651819395059810306 | 2025-07-29T14:00:19.952790+00:00 | 3 | 31 | 2 | 0 | 23242069 | ||
| 845 | 651819395059810306 651819395059810306 | 2025-07-29T14:07:31.607325+00:00 | 3 | 32 | 2 | 1 | 345991006 | ||
| 852 | 651819395059810306 651819395059810306 | 2025-07-29T14:20:07.401979+00:00 | 3 | 31 | 4 | 0 | 241078381 | ||
| 857 | 651819395059810306 651819395059810306 | 2025-07-29T14:47:49.232577+00:00 | 3 | 32 | 1 | 0 | 20416883 | ||
| 945 | 651819395059810306 651819395059810306 | 2025-07-30T13:12:06.872368+00:00 | 4 | 35 | 5 | 0 | 305271665 | ||
| 946 | 651819395059810306 651819395059810306 | 2025-07-30T13:12:14.918235+00:00 | 4 | 35 | 5 | 0 | 31760589 | ||
| 948 | 651819395059810306 651819395059810306 | 2025-07-30T13:17:37.082119+00:00 | 4 | 36 | 5 | 1 | 303050311 | ||
| 950 | 651819395059810306 651819395059810306 | 2025-07-30T13:26:29.717288+00:00 | 4 | 35 | 4 | 0 | 244018225 | ||
| 951 | 651819395059810306 651819395059810306 | 2025-07-30T13:26:39.224468+00:00 | 4 | 35 | 4 | 0 | 185535507 | ||
| 952 | 651819395059810306 651819395059810306 | 2025-07-30T13:37:35.883443+00:00 | 4 | 35 | 2 | 0 | 262483775 | ||
| 958 | 651819395059810306 651819395059810306 | 2025-07-30T13:44:19.181044+00:00 | 4 | 36 | 3 | 0 | 262473841 | ||
| 960 | 651819395059810306 651819395059810306 | 2025-07-30T13:49:39.622932+00:00 | 4 | 36 | 1 | 1 | 82637854 | ||
| 1076 | 651819395059810306 651819395059810306 | 2025-07-31T13:18:16.985521+00:00 | 5 | 41 | 5 | 0 | 303322246 | ||
| 1078 | 651819395059810306 651819395059810306 | 2025-07-31T13:30:30.163254+00:00 | 5 | 41 | 4 | 0 | 242576908 | ||
| 1079 | 651819395059810306 651819395059810306 | 2025-07-31T13:30:37.005658+00:00 | 5 | 41 | 4 | 0 | 194853110 | ||
| 1080 | 651819395059810306 651819395059810306 | 2025-07-31T13:44:34.924299+00:00 | 5 | 41 | 3 | 0 | 262484886 | ||
| 1081 | 651819395059810306 651819395059810306 | 2025-07-31T13:44:47.014015+00:00 | 5 | 41 | 3 | 0 | 262485878 | ||
| 1082 | 651819395059810306 651819395059810306 | 2025-07-31T13:52:06.940405+00:00 | 5 | 42 | 4 | 1 | 21923040 | ||
| 1086 | 651819395059810306 651819395059810306 | 2025-07-31T14:39:18.715280+00:00 | 5 | 41 | 5 | 0 | 292955626 | ||
| 1180 | 651819395059810306 651819395059810306 | 2025-08-27T08:37:51.598853+00:00 | 1 | 13 | 1 | 0 | |||
| 1181 | 651819395059810306 651819395059810306 | 2025-08-27T08:37:51.598853+00:00 | 1 | 14 | 1 | 1 | 自動產生，關聯至完整刀 ID:1180 | 1180 | |
| 1182 | 651819395059810306 651819395059810306 | 2025-08-27T08:43:36.532017+00:00 | 1 | 13 | 4 | 0 | |||
| 1183 | 651819395059810306 651819395059810306 | 2025-08-27T08:43:36.532017+00:00 | 1 | 14 | 4 | 1 | 自動產生，關聯至完整刀 ID:1182 | 1182 | |
| 1184 | 651819395059810306 651819395059810306 | 2025-08-27T08:48:31.015732+00:00 | 1 | 15 | 5 | 0 | |||
| 1185 | 651819395059810306 651819395059810306 | 2025-08-27T08:48:31.015732+00:00 | 1 | 16 | 5 | 1 | 自動產生，關聯至完整刀 ID:1184 | 1184 | |
| 1263 | 651819395059810306 651819395059810306 | 2025-08-27T15:47:52.439574+00:00 | 1 | 24 | 5 | 0 | 261618941 | ||
| 1271 | 651819395059810306 651819395059810306 | 2025-08-27T16:18:03.928161+00:00 | 1 | 24 | 3 | 0 | 272310659 | ||
| 1272 | 651819395059810306 651819395059810306 | 2025-08-27T16:19:12.367737+00:00 | 1 | 24 | 3 | 0 | 2150654 | ||
| 1274 | 651819395059810306 651819395059810306 | 2025-08-27T16:29:55.048526+00:00 | 1 | 23 | 2 | 1 | 210562604 | ||
| 1320 | 651819395059810306 651819395059810306 | 2025-08-28T12:29:32.432944+00:00 | 2 | 25 | 5 | 0 | 262766214 | ||
| 1326 | 651819395059810306 651819395059810306 | 2025-08-28T12:37:33.005700+00:00 | 2 | 25 | 2 | 0 | 133079975 | ||
| 1332 | 651819395059810306 651819395059810306 | 2025-08-28T12:49:00.025774+00:00 | 2 | 26 | 2 | 1 | 100038722 | ||
| 1334 | 651819395059810306 651819395059810306 | 2025-08-28T12:55:40.719649+00:00 | 2 | 26 | 3 | 0 | 275842844 | ||
| 1345 | 651819395059810306 651819395059810306 | 2025-08-28T13:17:53.577761+00:00 | 2 | 26 | 5 | 0 | 263431508 | ||
| 1349 | 651819395059810306 651819395059810306 | 2025-08-28T13:24:56.165603+00:00 | 2 | 26 | 3 | 0 | 8108604 | ||
| 1354 | 651819395059810306 651819395059810306 | 2025-08-28T13:42:36.021696+00:00 | 2 | 27 | 3 | 0 | 272850206 | ||
| 1378 | 651819395059810306 651819395059810306 | 2025-08-28T16:30:19.571187+00:00 | 2 | 27 | 2 | 0 | 203942020 | ||
| 1379 | 651819395059810306 651819395059810306 | 2025-08-28T16:33:49.097269+00:00 | 2 | 28 | 2 | 0 | 21142846 | ||
| 1449 | 651819395059810306 651819395059810306 | 2025-08-29T13:42:24.427374+00:00 | 3 | 30 | 3 | 0 | 19800019 |
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)
);