attacks
60 rows where member_id = 354673939676528641
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 |
|---|---|---|---|---|---|---|---|---|---|
| 69 | 354673939676528641 354673939676528641 | 2025-06-26T11:25:07.739562+00:00 | 1 | 17 | 5 | 0 | |||
| 70 | 354673939676528641 354673939676528641 | 2025-06-26T11:25:07.739562+00:00 | 1 | 18 | 5 | 1 | 自動產生，關聯至完整刀 ID:69 | 69 | |
| 505 | 354673939676528641 354673939676528641 | 2025-07-27T03:20:53.284790+00:00 | 1 | 7 | 5 | 0 | 85000000 | ||
| 506 | 354673939676528641 354673939676528641 | 2025-07-27T03:20:53.284790+00:00 | 1 | 8 | 5 | 1 | 自動產生，關聯至完整刀 ID:505 | 505 | |
| 507 | 354673939676528641 354673939676528641 | 2025-07-27T03:24:25.807383+00:00 | 1 | 7 | 4 | 0 | 70000000 | ||
| 508 | 354673939676528641 354673939676528641 | 2025-07-27T03:24:25.807383+00:00 | 1 | 8 | 4 | 1 | 自動產生，關聯至完整刀 ID:507 | 507 | |
| 509 | 354673939676528641 354673939676528641 | 2025-07-27T03:32:44.949699+00:00 | 1 | 7 | 1 | 0 | 50000000 | ||
| 510 | 354673939676528641 354673939676528641 | 2025-07-27T03:32:44.949699+00:00 | 1 | 8 | 1 | 1 | 自動產生，關聯至完整刀 ID:509 | 509 | |
| 696 | 354673939676528641 354673939676528641 | 2025-07-28T11:45:56.626237+00:00 | 2 | 25 | 5 | 0 | 64355720 | ||
| 698 | 354673939676528641 354673939676528641 | 2025-07-28T11:49:36.614213+00:00 | 2 | 26 | 5 | 1 | 261094161 | ||
| 699 | 354673939676528641 354673939676528641 | 2025-07-28T12:10:22.216444+00:00 | 2 | 25 | 4 | 0 | 234558649 | ||
| 700 | 354673939676528641 354673939676528641 | 2025-07-28T12:27:13.846834+00:00 | 2 | 26 | 3 | 0 | 240182195 | ||
| 810 | 354673939676528641 354673939676528641 | 2025-07-29T11:12:15.628153+00:00 | 3 | 30 | 4 | 0 | 235010699 | ||
| 811 | 354673939676528641 354673939676528641 | 2025-07-29T11:19:56.942531+00:00 | 3 | 30 | 3 | 0 | 254367178 | ||
| 812 | 354673939676528641 354673939676528641 | 2025-07-29T11:26:46.465492+00:00 | 3 | 30 | 5 | 0 | 268015894 | ||
| 918 | 354673939676528641 354673939676528641 | 2025-07-30T11:11:58.948752+00:00 | 4 | 35 | 5 | 0 | 273614251 | ||
| 919 | 354673939676528641 354673939676528641 | 2025-07-30T11:16:28.224214+00:00 | 4 | 34 | 4 | 0 | 236040186 | ||
| 920 | 354673939676528641 354673939676528641 | 2025-07-30T11:42:16.143390+00:00 | 4 | 34 | 3 | 0 | 255022067 | ||
| 1056 | 354673939676528641 354673939676528641 | 2025-07-31T12:19:43.025087+00:00 | 5 | 40 | 3 | 0 | 252803005 | ||
| 1060 | 354673939676528641 354673939676528641 | 2025-07-31T12:37:10.035877+00:00 | 5 | 40 | 5 | 0 | 265014612 | ||
| 1061 | 354673939676528641 354673939676528641 | 2025-07-31T12:42:43.085691+00:00 | 5 | 40 | 4 | 0 | 235599186 | ||
| 1222 | 354673939676528641 354673939676528641 | 2025-08-27T11:27:02.830469+00:00 | 1 | 20 | 5 | 0 | 85000000 | ||
| 1223 | 354673939676528641 354673939676528641 | 2025-08-27T11:27:02.830469+00:00 | 1 | 21 | 5 | 1 | 自動產生，關聯至完整刀 ID:1222 | 1222 | |
| 1226 | 354673939676528641 354673939676528641 | 2025-08-27T11:31:10.999252+00:00 | 1 | 20 | 4 | 0 | 70000000 | ||
| 1227 | 354673939676528641 354673939676528641 | 2025-08-27T11:31:10.999252+00:00 | 1 | 21 | 4 | 1 | 自動產生，關聯至完整刀 ID:1226 | 1226 | |
| 1232 | 354673939676528641 354673939676528641 | 2025-08-27T11:34:05.415960+00:00 | 1 | 20 | 3 | 0 | 64000000 | ||
| 1233 | 354673939676528641 354673939676528641 | 2025-08-27T11:34:05.415960+00:00 | 1 | 21 | 3 | 1 | 自動產生，關聯至完整刀 ID:1232 | 1232 | |
| 1323 | 354673939676528641 354673939676528641 | 2025-08-28T12:34:02.125259+00:00 | 2 | 26 | 5 | 0 | 256038008 | ||
| 1339 | 354673939676528641 354673939676528641 | 2025-08-28T13:08:46.181985+00:00 | 2 | 26 | 4 | 0 | 145297931 | ||
| 1341 | 354673939676528641 354673939676528641 | 2025-08-28T13:13:17.198781+00:00 | 2 | 27 | 4 | 1 | 264465491 | ||
| 1348 | 354673939676528641 354673939676528641 | 2025-08-28T13:23:12.643639+00:00 | 2 | 26 | 3 | 0 | 280925578 | ||
| 1427 | 354673939676528641 354673939676528641 | 2025-08-29T12:00:58.479949+00:00 | 3 | 30 | 5 | 0 | 256576024 | ||
| 1437 | 354673939676528641 354673939676528641 | 2025-08-29T13:23:48.612383+00:00 | 3 | 31 | 4 | 0 | 372048388 | ||
| 1448 | 354673939676528641 354673939676528641 | 2025-08-29T13:41:23.124358+00:00 | 3 | 30 | 3 | 0 | 273532180 | ||
| 1545 | 354673939676528641 354673939676528641 | 2025-08-30T07:06:49.547071+00:00 | 4 | 35 | 5 | 0 | 255413807 | ||
| 1556 | 354673939676528641 354673939676528641 | 2025-08-30T08:07:18.687586+00:00 | 4 | 35 | 4 | 0 | 39751481 | ||
| 1580 | 354673939676528641 354673939676528641 | 2025-08-30T14:30:15.499362+00:00 | 4 | 36 | 4 | 0 | 371492488 | ||
| 1592 | 354673939676528641 354673939676528641 | 2025-08-30T15:00:43.020324+00:00 | 4 | 37 | 3 | 0 | 273871758 | ||
| 1653 | 354673939676528641 354673939676528641 | 2025-08-31T05:00:36.600394+00:00 | 5 | 39 | 5 | 0 | 256062875 | ||
| 1654 | 354673939676528641 354673939676528641 | 2025-08-31T05:06:08.064201+00:00 | 5 | 39 | 3 | 0 | 269878142 | ||
| 1655 | 354673939676528641 354673939676528641 | 2025-08-31T05:10:16.407936+00:00 | 5 | 39 | 4 | 0 | 365858518 | ||
| 1851 | 354673939676528641 354673939676528641 | 2025-09-26T12:51:24.815060+00:00 | 1 | 21 | 5 | 0 | |||
| 1852 | 354673939676528641 354673939676528641 | 2025-09-26T12:51:24.815060+00:00 | 1 | 22 | 5 | 1 | 自動產生，關聯至完整刀 ID:1851 | 1851 | |
| 1853 | 354673939676528641 354673939676528641 | 2025-09-26T13:02:06.837181+00:00 | 1 | 21 | 3 | 0 | |||
| 1854 | 354673939676528641 354673939676528641 | 2025-09-26T13:02:06.837181+00:00 | 1 | 22 | 3 | 1 | 自動產生，關聯至完整刀 ID:1853 | 1853 | |
| 1855 | 354673939676528641 354673939676528641 | 2025-09-26T13:09:21.927122+00:00 | 1 | 21 | 4 | 0 | |||
| 1966 | 354673939676528641 354673939676528641 | 2025-09-27T14:41:14.107304+00:00 | 2 | 27 | 4 | 0 | 237331232 | ||
| 1969 | 354673939676528641 354673939676528641 | 2025-09-27T14:54:54.113966+00:00 | 2 | 28 | 4 | 1 | 9317758 | ||
| 1971 | 354673939676528641 354673939676528641 | 2025-09-27T14:58:35.506053+00:00 | 2 | 28 | 2 | 0 | 266444020 | ||
| 1977 | 354673939676528641 354673939676528641 | 2025-09-27T15:31:13.863181+00:00 | 2 | 27 | 3 | 0 | 40892323 | ||
| 1979 | 354673939676528641 354673939676528641 | 2025-09-27T15:35:56.489806+00:00 | 2 | 28 | 3 | 1 | 357231496 | ||
| 2056 | 354673939676528641 354673939676528641 | 2025-09-28T10:07:15.961141+00:00 | 3 | 31 | 4 | 0 | 247436184 | ||
| 2061 | 354673939676528641 354673939676528641 | 2025-09-28T11:28:39.755669+00:00 | 3 | 31 | 2 | 0 | 280443622 | ||
| 2068 | 354673939676528641 354673939676528641 | 2025-09-28T12:43:15.656765+00:00 | 3 | 31 | 3 | 0 | 356312324 | ||
| 2214 | 354673939676528641 354673939676528641 | 2025-09-29T15:31:39.840200+00:00 | 4 | 38 | 3 | 0 | 356454370 | ||
| 2216 | 354673939676528641 354673939676528641 | 2025-09-29T15:36:07.305424+00:00 | 4 | 37 | 4 | 0 | 249055862 | ||
| 2219 | 354673939676528641 354673939676528641 | 2025-09-29T16:06:32.723431+00:00 | 4 | 38 | 2 | 0 | 378869710 | ||
| 2276 | 354673939676528641 354673939676528641 | 2025-09-30T10:46:35.954563+00:00 | 5 | 40 | 4 | 0 | 247980645 | ||
| 2277 | 354673939676528641 354673939676528641 | 2025-09-30T10:51:49.640110+00:00 | 5 | 41 | 3 | 0 | 357042100 | ||
| 2281 | 354673939676528641 354673939676528641 | 2025-09-30T11:33:33.555982+00:00 | 5 | 40 | 2 | 0 | 278672942 |
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)
);