attacks
51 rows where member_id = 374538532787847169
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 |
|---|---|---|---|---|---|---|---|---|---|
| 580 | 374538532787847169 374538532787847169 | 2025-07-27T09:15:43.564205+00:00 | 1 | 15 | 5 | 0 | 85000000 | ||
| 581 | 374538532787847169 374538532787847169 | 2025-07-27T09:15:43.564205+00:00 | 1 | 16 | 5 | 1 | 自動產生，關聯至完整刀 ID:580 | 580 | |
| 584 | 374538532787847169 374538532787847169 | 2025-07-27T09:16:35.299747+00:00 | 1 | 17 | 4 | 0 | 70000000 | ||
| 585 | 374538532787847169 374538532787847169 | 2025-07-27T09:16:35.299747+00:00 | 1 | 18 | 4 | 1 | 自動產生，關聯至完整刀 ID:584 | 584 | |
| 586 | 374538532787847169 374538532787847169 | 2025-07-27T09:17:50.179519+00:00 | 1 | 17 | 3 | 0 | 64000000 | ||
| 587 | 374538532787847169 374538532787847169 | 2025-07-27T09:17:50.179519+00:00 | 1 | 18 | 3 | 1 | 自動產生，關聯至完整刀 ID:586 | 586 | |
| 756 | 374538532787847169 374538532787847169 | 2025-07-28T16:14:50.642869+00:00 | 2 | 28 | 1 | 0 | 306043532 | ||
| 759 | 374538532787847169 374538532787847169 | 2025-07-28T16:25:47.720518+00:00 | 2 | 28 | 4 | 0 | 227208367 | ||
| 761 | 374538532787847169 374538532787847169 | 2025-07-28T16:38:10.044893+00:00 | 2 | 28 | 2 | 0 | 155563108 | ||
| 762 | 374538532787847169 374538532787847169 | 2025-07-28T16:38:49.601503+00:00 | 2 | 29 | 2 | 1 | 218354056 | ||
| 868 | 374538532787847169 374538532787847169 | 2025-07-29T16:54:25.482806+00:00 | 3 | 33 | 1 | 0 | 307993241 | ||
| 869 | 374538532787847169 374538532787847169 | 2025-07-29T16:59:45.493721+00:00 | 3 | 33 | 2 | 0 | 332072484 | ||
| 870 | 374538532787847169 374538532787847169 | 2025-07-29T17:05:17.937675+00:00 | 3 | 32 | 4 | 0 | 226984981 | ||
| 1039 | 374538532787847169 374538532787847169 | 2025-07-31T09:57:35.523492+00:00 | 5 | 40 | 2 | 0 | 332373960 | ||
| 1041 | 374538532787847169 374538532787847169 | 2025-07-31T10:04:42.094980+00:00 | 5 | 39 | 1 | 0 | 308345678 | ||
| 1043 | 374538532787847169 374538532787847169 | 2025-07-31T10:13:43.152558+00:00 | 5 | 39 | 4 | 0 | 218490063 | ||
| 1102 | 374538532787847169 374538532787847169 | 2025-08-01T09:14:52.519997+00:00 | 0 | 36 | 2 | 0 | 28251516 | ||
| 1103 | 374538532787847169 374538532787847169 | 2025-08-01T09:15:15.662119+00:00 | 0 | 37 | 2 | 1 | 332279395 | ||
| 1104 | 374538532787847169 374538532787847169 | 2025-08-01T09:16:01.586977+00:00 | 0 | 36 | 4 | 0 | 167515373 | ||
| 1105 | 374538532787847169 374538532787847169 | 2025-08-01T09:16:19.155229+00:00 | 0 | 37 | 4 | 1 | 44953010 | ||
| 1107 | 374538532787847169 374538532787847169 | 2025-08-01T09:17:23.402341+00:00 | 0 | 36 | 1 | 0 | 308757477 | ||
| 1186 | 374538532787847169 374538532787847169 | 2025-08-27T10:03:40.640071+00:00 | 1 | 15 | 1 | 0 | |||
| 1187 | 374538532787847169 374538532787847169 | 2025-08-27T10:03:40.640071+00:00 | 1 | 16 | 1 | 1 | 自動產生，關聯至完整刀 ID:1186 | 1186 | |
| 1188 | 374538532787847169 374538532787847169 | 2025-08-27T10:03:44.009957+00:00 | 1 | 15 | 2 | 0 | |||
| 1189 | 374538532787847169 374538532787847169 | 2025-08-27T10:03:44.009957+00:00 | 1 | 16 | 2 | 1 | 自動產生，關聯至完整刀 ID:1188 | 1188 | |
| 1190 | 374538532787847169 374538532787847169 | 2025-08-27T10:03:53.496827+00:00 | 1 | 15 | 3 | 0 | |||
| 1191 | 374538532787847169 374538532787847169 | 2025-08-27T10:03:53.496827+00:00 | 1 | 16 | 3 | 1 | 自動產生，關聯至完整刀 ID:1190 | 1190 | |
| 1381 | 374538532787847169 374538532787847169 | 2025-08-28T17:45:32.709846+00:00 | 2 | 28 | 1 | 0 | 264287218 | ||
| 1384 | 374538532787847169 374538532787847169 | 2025-08-28T17:54:49.990780+00:00 | 2 | 28 | 3 | 0 | 253706453 | ||
| 1388 | 374538532787847169 374538532787847169 | 2025-08-28T18:01:23.293724+00:00 | 2 | 28 | 5 | 0 | 223004942 | ||
| 1479 | 374538532787847169 374538532787847169 | 2025-08-29T15:51:37.908284+00:00 | 3 | 32 | 1 | 0 | 268814904 | ||
| 1481 | 374538532787847169 374538532787847169 | 2025-08-29T16:01:01.061209+00:00 | 3 | 32 | 3 | 0 | 263816752 | ||
| 1483 | 374538532787847169 374538532787847169 | 2025-08-29T16:23:53.513237+00:00 | 3 | 32 | 5 | 0 | 249708085 | ||
| 1575 | 374538532787847169 374538532787847169 | 2025-08-30T14:09:04.948029+00:00 | 4 | 36 | 3 | 0 | 252097743 | ||
| 1577 | 374538532787847169 374538532787847169 | 2025-08-30T14:21:47.579078+00:00 | 4 | 35 | 2 | 0 | 183380169 | ||
| 1578 | 374538532787847169 374538532787847169 | 2025-08-30T14:23:32.568514+00:00 | 4 | 36 | 2 | 1 | 30368708 | ||
| 1594 | 374538532787847169 374538532787847169 | 2025-08-30T15:08:04.814256+00:00 | 4 | 37 | 4 | 0 | 365311921 | ||
| 1734 | 374538532787847169 374538532787847169 | 2025-08-31T15:09:24.682069+00:00 | 5 | 42 | 3 | 0 | 240316855 | ||
| 1736 | 374538532787847169 374538532787847169 | 2025-08-31T15:15:55.809313+00:00 | 5 | 42 | 4 | 0 | 370422333 | ||
| 1739 | 374538532787847169 374538532787847169 | 2025-08-31T15:21:43.154311+00:00 | 5 | 42 | 5 | 0 | 256785086 | ||
| 2086 | 374538532787847169 374538532787847169 | 2025-09-28T14:34:29.997301+00:00 | 3 | 32 | 2 | 0 | 305943832 | ||
| 2099 | 374538532787847169 374538532787847169 | 2025-09-28T14:55:11.855591+00:00 | 3 | 32 | 1 | 0 | 274696701 | ||
| 2111 | 374538532787847169 374538532787847169 | 2025-09-28T15:46:58.407074+00:00 | 3 | 33 | 3 | 0 | 237686839 | ||
| 2113 | 374538532787847169 374538532787847169 | 2025-09-28T15:49:48.486196+00:00 | 3 | 34 | 3 | 1 | 87892965 | ||
| 2207 | 374538532787847169 374538532787847169 | 2025-09-29T15:14:20.424459+00:00 | 4 | 38 | 2 | 0 | 306664788 | ||
| 2210 | 374538532787847169 374538532787847169 | 2025-09-29T15:24:43.930288+00:00 | 4 | 37 | 4 | 0 | 206689629 | ||
| 2220 | 374538532787847169 374538532787847169 | 2025-09-29T16:41:58.384376+00:00 | 4 | 37 | 1 | 0 | 225813721 | ||
| 2221 | 374538532787847169 374538532787847169 | 2025-09-29T16:42:17.188088+00:00 | 4 | 38 | 1 | 1 | 28451494 | ||
| 2341 | 374538532787847169 374538532787847169 | 2025-09-30T14:54:47.803981+00:00 | 5 | 43 | 4 | 0 | 208248470 | ||
| 2348 | 374538532787847169 374538532787847169 | 2025-09-30T15:23:13.944808+00:00 | 5 | 43 | 2 | 0 | 305134825 | ||
| 2350 | 374538532787847169 374538532787847169 | 2025-09-30T15:24:04.224852+00:00 | 5 | 43 | 1 | 0 | 275346458 |
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)
);