attacks
58 rows where member_id = 239056289550958592
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 |
|---|---|---|---|---|---|---|---|---|---|
| 145 | 239056289550958592 239056289550958592 | 2025-06-27T13:28:58.092079+00:00 | 2 | 26 | 4 | 0 | 212738003 | ||
| 148 | 239056289550958592 239056289550958592 | 2025-06-27T13:35:31.591439+00:00 | 2 | 27 | 2 | 0 | 192922363 | ||
| 156 | 239056289550958592 239056289550958592 | 2025-06-27T14:27:18.484720+00:00 | 2 | 26 | 3 | 0 | 153576932 | ||
| 600 | 239056289550958592 239056289550958592 | 2025-07-27T11:49:01.463450+00:00 | 1 | 19 | 5 | 0 | 85000000 | ||
| 601 | 239056289550958592 239056289550958592 | 2025-07-27T11:49:01.463450+00:00 | 1 | 20 | 5 | 1 | 自動產生，關聯至完整刀 ID:600 | 600 | |
| 604 | 239056289550958592 239056289550958592 | 2025-07-27T11:51:48.979373+00:00 | 1 | 19 | 4 | 0 | 70000000 | ||
| 605 | 239056289550958592 239056289550958592 | 2025-07-27T11:51:48.979373+00:00 | 1 | 20 | 4 | 1 | 自動產生，關聯至完整刀 ID:604 | 604 | |
| 608 | 239056289550958592 239056289550958592 | 2025-07-27T11:55:00.671964+00:00 | 1 | 21 | 3 | 0 | 64000000 | ||
| 609 | 239056289550958592 239056289550958592 | 2025-07-27T11:55:00.671964+00:00 | 1 | 22 | 3 | 1 | 自動產生，關聯至完整刀 ID:608 | 608 | |
| 703 | 239056289550958592 239056289550958592 | 2025-07-28T12:47:54.019669+00:00 | 2 | 26 | 5 | 0 | 270905593 | ||
| 705 | 239056289550958592 239056289550958592 | 2025-07-28T13:02:41.523979+00:00 | 2 | 26 | 4 | 0 | 230222101 | ||
| 713 | 239056289550958592 239056289550958592 | 2025-07-28T13:42:20.363842+00:00 | 2 | 26 | 2 | 0 | 331066988 | ||
| 813 | 239056289550958592 239056289550958592 | 2025-07-29T11:27:08.866455+00:00 | 3 | 30 | 5 | 0 | 265846515 | ||
| 814 | 239056289550958592 239056289550958592 | 2025-07-29T11:30:54.892840+00:00 | 3 | 31 | 5 | 1 | 269067110 | ||
| 815 | 239056289550958592 239056289550958592 | 2025-07-29T11:36:46.295796+00:00 | 3 | 30 | 3 | 0 | 232509450 | ||
| 816 | 239056289550958592 239056289550958592 | 2025-07-29T11:41:39.156511+00:00 | 3 | 31 | 3 | 0 | 205673251 | ||
| 817 | 239056289550958592 239056289550958592 | 2025-07-29T11:45:36.195804+00:00 | 3 | 30 | 2 | 1 | 48908306 | ||
| 933 | 239056289550958592 239056289550958592 | 2025-07-30T12:51:25.721346+00:00 | 4 | 35 | 4 | 0 | 230641474 | ||
| 937 | 239056289550958592 239056289550958592 | 2025-07-30T12:58:43.599933+00:00 | 4 | 35 | 1 | 0 | 308909873 | ||
| 941 | 239056289550958592 239056289550958592 | 2025-07-30T13:04:26.261466+00:00 | 4 | 36 | 2 | 0 | 335769069 | ||
| 1073 | 239056289550958592 239056289550958592 | 2025-07-31T13:10:11.006263+00:00 | 5 | 41 | 5 | 0 | 265625707 | ||
| 1075 | 239056289550958592 239056289550958592 | 2025-07-31T13:15:41.658026+00:00 | 5 | 41 | 4 | 0 | 227039633 | ||
| 1077 | 239056289550958592 239056289550958592 | 2025-07-31T13:22:05.639617+00:00 | 5 | 41 | 2 | 0 | 336426004 | ||
| 1240 | 239056289550958592 239056289550958592 | 2025-08-27T12:41:38.947781+00:00 | 1 | 22 | 3 | 0 | 64000000 | ||
| 1241 | 239056289550958592 239056289550958592 | 2025-08-27T12:41:38.947781+00:00 | 1 | 23 | 3 | 1 | 自動產生，關聯至完整刀 ID:1240 | 1240 | |
| 1242 | 239056289550958592 239056289550958592 | 2025-08-27T12:43:24.190184+00:00 | 1 | 22 | 2 | 1 | |||
| 1243 | 239056289550958592 239056289550958592 | 2025-08-27T12:43:24.190184+00:00 | 1 | 23 | 2 | 1 | 自動產生，關聯至完整刀 ID:1242 | 1242 | |
| 1244 | 239056289550958592 239056289550958592 | 2025-08-27T12:48:42.673629+00:00 | 1 | 23 | 4 | 0 | 352809159 | ||
| 1245 | 239056289550958592 239056289550958592 | 2025-08-27T13:00:58.208161+00:00 | 1 | 23 | 5 | 0 | 204026996 | ||
| 1358 | 239056289550958592 239056289550958592 | 2025-08-28T14:06:43.680555+00:00 | 2 | 27 | 5 | 0 | 204173769 | ||
| 1363 | 239056289550958592 239056289550958592 | 2025-08-28T14:17:41.049031+00:00 | 2 | 27 | 3 | 0 | 245693651 | ||
| 1365 | 239056289550958592 239056289550958592 | 2025-08-28T14:21:02.947816+00:00 | 2 | 27 | 3 | 0 | 3799275 | ||
| 1366 | 239056289550958592 239056289550958592 | 2025-08-28T14:29:20.008581+00:00 | 2 | 27 | 4 | 1 | 372001814 | ||
| 1428 | 239056289550958592 239056289550958592 | 2025-08-29T12:55:28.220523+00:00 | 3 | 28 | 2 | 0 | 196068761 | ||
| 1430 | 239056289550958592 239056289550958592 | 2025-08-29T13:01:23.779714+00:00 | 3 | 30 | 5 | 0 | 204274909 | ||
| 1431 | 239056289550958592 239056289550958592 | 2025-08-29T13:05:45.076675+00:00 | 3 | 29 | 4 | 0 | 41247036 | ||
| 1436 | 239056289550958592 239056289550958592 | 2025-08-29T13:22:52.389872+00:00 | 3 | 32 | 4 | 1 | 371557275 | ||
| 1562 | 239056289550958592 239056289550958592 | 2025-08-30T12:42:14.397953+00:00 | 4 | 34 | 1 | 0 | 228437181 | ||
| 1564 | 239056289550958592 239056289550958592 | 2025-08-30T12:51:19.867942+00:00 | 4 | 36 | 5 | 0 | 203616927 | ||
| 1566 | 239056289550958592 239056289550958592 | 2025-08-30T12:55:41.869968+00:00 | 4 | 36 | 4 | 0 | 371866265 | ||
| 1724 | 239056289550958592 239056289550958592 | 2025-08-31T13:52:19.221475+00:00 | 5 | 42 | 4 | 0 | 371893571 | ||
| 1725 | 239056289550958592 239056289550958592 | 2025-08-31T13:57:06.332717+00:00 | 5 | 41 | 5 | 0 | 204823090 | ||
| 1726 | 239056289550958592 239056289550958592 | 2025-08-31T14:02:16.701913+00:00 | 5 | 42 | 1 | 0 | 227587899 | ||
| 1875 | 239056289550958592 239056289550958592 | 2025-09-26T15:26:55.040700+00:00 | 1 | 23 | 5 | 0 | 216026759 | ||
| 1878 | 239056289550958592 239056289550958592 | 2025-09-26T15:54:25.088858+00:00 | 1 | 23 | 4 | 0 | 243403289 | ||
| 1880 | 239056289550958592 239056289550958592 | 2025-09-26T15:58:26.396838+00:00 | 1 | 23 | 1 | 0 | 254712254 | ||
| 1973 | 239056289550958592 239056289550958592 | 2025-09-27T15:12:21.994791+00:00 | 2 | 28 | 4 | 0 | 241893945 | ||
| 1974 | 239056289550958592 239056289550958592 | 2025-09-27T15:19:36.031308+00:00 | 2 | 27 | 1 | 0 | 254084172 | ||
| 1978 | 239056289550958592 239056289550958592 | 2025-09-27T15:31:30.720576+00:00 | 2 | 28 | 2 | 0 | 225205009 | ||
| 2094 | 239056289550958592 239056289550958592 | 2025-09-28T14:45:02.593753+00:00 | 3 | 32 | 1 | 0 | 256329765 | ||
| 2098 | 239056289550958592 239056289550958592 | 2025-09-28T14:51:53.797847+00:00 | 3 | 33 | 4 | 0 | 243204116 | ||
| 2100 | 239056289550958592 239056289550958592 | 2025-09-28T15:01:25.795779+00:00 | 3 | 33 | 2 | 0 | 224947033 | ||
| 2185 | 239056289550958592 239056289550958592 | 2025-09-29T12:14:54.493254+00:00 | 4 | 37 | 2 | 0 | 225080161 | ||
| 2186 | 239056289550958592 239056289550958592 | 2025-09-29T12:25:03.293281+00:00 | 4 | 36 | 1 | 0 | 255457898 | ||
| 2190 | 239056289550958592 239056289550958592 | 2025-09-29T12:31:09.376282+00:00 | 4 | 36 | 4 | 0 | 242815979 | ||
| 2304 | 239056289550958592 239056289550958592 | 2025-09-30T12:44:50.470684+00:00 | 5 | 41 | 4 | 0 | 242222803 | ||
| 2306 | 239056289550958592 239056289550958592 | 2025-09-30T12:49:47.024258+00:00 | 5 | 42 | 1 | 0 | 241837644 | ||
| 2312 | 239056289550958592 239056289550958592 | 2025-09-30T13:02:06.161644+00:00 | 5 | 41 | 2 | 0 | 225264945 |
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)
);