attacks
57 rows where member_id = 476788426012622855
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 |
|---|---|---|---|---|---|---|---|---|---|
| 549 | 476788426012622855 476788426012622855 | 2025-07-27T05:19:52.728744+00:00 | 1 | 13 | 1 | 0 | 50000000 | ||
| 550 | 476788426012622855 476788426012622855 | 2025-07-27T05:19:52.728744+00:00 | 1 | 14 | 1 | 1 | 自動產生，關聯至完整刀 ID:549 | 549 | |
| 551 | 476788426012622855 476788426012622855 | 2025-07-27T05:22:54.011125+00:00 | 1 | 13 | 2 | 0 | 56000000+ | ||
| 552 | 476788426012622855 476788426012622855 | 2025-07-27T05:22:54.011125+00:00 | 1 | 14 | 2 | 1 | 自動產生，關聯至完整刀 ID:551 | 551 | |
| 553 | 476788426012622855 476788426012622855 | 2025-07-27T05:25:42.374281+00:00 | 1 | 13 | 3 | 0 | 64000000 | ||
| 554 | 476788426012622855 476788426012622855 | 2025-07-27T05:25:42.374281+00:00 | 1 | 14 | 3 | 1 | 自動產生，關聯至完整刀 ID:553 | 553 | |
| 701 | 476788426012622855 476788426012622855 | 2025-07-28T12:33:53.333692+00:00 | 2 | 26 | 5 | 0 | 276787967 | ||
| 717 | 476788426012622855 476788426012622855 | 2025-07-28T14:00:49.848884+00:00 | 2 | 27 | 4 | 0 | 244649007 | ||
| 718 | 476788426012622855 476788426012622855 | 2025-07-28T14:08:38.701300+00:00 | 2 | 27 | 2 | 0 | 349930105 | ||
| 793 | 476788426012622855 476788426012622855 | 2025-07-29T04:57:36.271922+00:00 | 3 | 30 | 5 | 0 | 279260354 | ||
| 794 | 476788426012622855 476788426012622855 | 2025-07-29T05:03:05.680193+00:00 | 3 | 29 | 4 | 0 | 243439598 | ||
| 796 | 476788426012622855 476788426012622855 | 2025-07-29T05:08:23.964614+00:00 | 3 | 30 | 3 | 0 | 271501128 | ||
| 965 | 476788426012622855 476788426012622855 | 2025-07-30T14:38:47.684654+00:00 | 4 | 37 | 3 | 0 | 270622183 | ||
| 967 | 476788426012622855 476788426012622855 | 2025-07-30T14:45:55.509695+00:00 | 4 | 36 | 5 | 0 | 33183964 | ||
| 970 | 476788426012622855 476788426012622855 | 2025-07-30T14:58:07.752767+00:00 | 4 | 37 | 5 | 1 | 310706179 | ||
| 974 | 476788426012622855 476788426012622855 | 2025-07-30T15:37:54.317800+00:00 | 4 | 36 | 2 | 0 | 347071925 | ||
| 1046 | 476788426012622855 476788426012622855 | 2025-07-31T10:20:38.929233+00:00 | 5 | 40 | 1 | 0 | 272317735 | ||
| 1047 | 476788426012622855 476788426012622855 | 2025-07-31T10:25:55.592887+00:00 | 5 | 39 | 3 | 0 | 226641998 | ||
| 1048 | 476788426012622855 476788426012622855 | 2025-07-31T10:32:30.725732+00:00 | 5 | 30 | 4 | 0 | 241545354 | ||
| 1140 | 476788426012622855 476788426012622855 | 2025-08-27T04:31:37.600763+00:00 | 1 | 7 | 1 | 0 | |||
| 1141 | 476788426012622855 476788426012622855 | 2025-08-27T04:31:37.600763+00:00 | 1 | 8 | 1 | 1 | 自動產生，關聯至完整刀 ID:1140 | 1140 | |
| 1146 | 476788426012622855 476788426012622855 | 2025-08-27T04:37:05.217077+00:00 | 1 | 7 | 2 | 0 | |||
| 1147 | 476788426012622855 476788426012622855 | 2025-08-27T04:37:05.217077+00:00 | 1 | 8 | 2 | 1 | 自動產生，關聯至完整刀 ID:1146 | 1146 | |
| 1148 | 476788426012622855 476788426012622855 | 2025-08-27T04:40:43.953049+00:00 | 1 | 9 | 3 | 0 | |||
| 1149 | 476788426012622855 476788426012622855 | 2025-08-27T04:40:43.953049+00:00 | 1 | 10 | 3 | 1 | 自動產生，關聯至完整刀 ID:1148 | 1148 | |
| 1302 | 476788426012622855 476788426012622855 | 2025-08-28T04:59:07.786681+00:00 | 2 | 25 | 5 | 0 | 261487931 | ||
| 1317 | 476788426012622855 476788426012622855 | 2025-08-28T12:05:44.455682+00:00 | 2 | 26 | 3 | 0 | 277172790 | ||
| 1347 | 476788426012622855 476788426012622855 | 2025-08-28T13:19:11.524886+00:00 | 2 | 27 | 4 | 0 | 368772551 | ||
| 1412 | 476788426012622855 476788426012622855 | 2025-08-29T04:03:43.240777+00:00 | 3 | 29 | 5 | 0 | 259479574 | ||
| 1413 | 476788426012622855 476788426012622855 | 2025-08-29T04:08:32.214980+00:00 | 3 | 29 | 2 | 0 | 247417311 | ||
| 1414 | 476788426012622855 476788426012622855 | 2025-08-29T04:13:22.802892+00:00 | 3 | 30 | 3 | 0 | 275388688 | ||
| 1547 | 476788426012622855 476788426012622855 | 2025-08-30T07:18:39.829900+00:00 | 4 | 35 | 5 | 0 | 260084781 | ||
| 1559 | 476788426012622855 476788426012622855 | 2025-08-30T09:02:02.137692+00:00 | 4 | 35 | 3 | 0 | 277364440 | ||
| 1560 | 476788426012622855 476788426012622855 | 2025-08-30T09:06:15.755909+00:00 | 4 | 35 | 2 | 0 | 247030026 | ||
| 1667 | 476788426012622855 476788426012622855 | 2025-08-31T06:52:52.050840+00:00 | 5 | 39 | 1 | 0 | 327803155 | ||
| 1668 | 476788426012622855 476788426012622855 | 2025-08-31T06:58:28.735631+00:00 | 5 | 37 | 2 | 0 | 247122085 | ||
| 1669 | 476788426012622855 476788426012622855 | 2025-08-31T07:10:38.327568+00:00 | 5 | 39 | 5 | 0 | 265008984 | ||
| 1791 | 476788426012622855 476788426012622855 | 2025-09-26T04:09:34.783488+00:00 | 1 | 9 | 1 | 0 | |||
| 1792 | 476788426012622855 476788426012622855 | 2025-09-26T04:09:34.783488+00:00 | 1 | 10 | 1 | 1 | 自動產生，關聯至完整刀 ID:1791 | 1791 | |
| 1793 | 476788426012622855 476788426012622855 | 2025-09-26T04:12:18.118033+00:00 | 1 | 9 | 2 | 0 | |||
| 1794 | 476788426012622855 476788426012622855 | 2025-09-26T04:12:18.118033+00:00 | 1 | 10 | 2 | 1 | 自動產生，關聯至完整刀 ID:1793 | 1793 | |
| 1795 | 476788426012622855 476788426012622855 | 2025-09-26T04:15:25.912498+00:00 | 1 | 9 | 4 | 0 | |||
| 1796 | 476788426012622855 476788426012622855 | 2025-09-26T04:15:25.912498+00:00 | 1 | 10 | 4 | 1 | 自動產生，關聯至完整刀 ID:1795 | 1795 | |
| 1939 | 476788426012622855 476788426012622855 | 2025-09-27T05:59:26.573961+00:00 | 2 | 26 | 4 | 0 | 251523103 | ||
| 1944 | 476788426012622855 476788426012622855 | 2025-09-27T06:41:04.632103+00:00 | 2 | 26 | 5 | 0 | 310849226 | ||
| 1947 | 476788426012622855 476788426012622855 | 2025-09-27T08:59:24.804284+00:00 | 2 | 26 | 2 | 0 | 302893917 | ||
| 1948 | 476788426012622855 476788426012622855 | 2025-09-27T09:06:08.946331+00:00 | 2 | 27 | 2 | 1 | 28482128 | ||
| 2042 | 476788426012622855 476788426012622855 | 2025-09-28T07:21:27.269227+00:00 | 3 | 31 | 1 | 0 | 284075600 | ||
| 2045 | 476788426012622855 476788426012622855 | 2025-09-28T07:28:44.398696+00:00 | 3 | 31 | 2 | 0 | 315701857 | ||
| 2072 | 476788426012622855 476788426012622855 | 2025-09-28T12:54:48.628559+00:00 | 3 | 32 | 3 | 0 | 392939893 | ||
| 2173 | 476788426012622855 476788426012622855 | 2025-09-29T10:12:50.263443+00:00 | 4 | 36 | 1 | 0 | 304135535 | ||
| 2179 | 476788426012622855 476788426012622855 | 2025-09-29T10:50:44.306430+00:00 | 4 | 36 | 5 | 0 | 224914057 | ||
| 2180 | 476788426012622855 476788426012622855 | 2025-09-29T11:00:48.694786+00:00 | 4 | 36 | 4 | 0 | 263607757 | ||
| 2265 | 476788426012622855 476788426012622855 | 2025-09-30T05:12:54.892221+00:00 | 5 | 40 | 1 | 0 | 304037750 | ||
| 2282 | 476788426012622855 476788426012622855 | 2025-09-30T11:46:06.018765+00:00 | 5 | 40 | 4 | 0 | 261116491 | ||
| 2331 | 476788426012622855 476788426012622855 | 2025-09-30T14:10:03.053920+00:00 | 5 | 42 | 5 | 0 | 291715254 | ||
| 2334 | 476788426012622855 476788426012622855 | 2025-09-30T14:16:35.567003+00:00 | 5 | 43 | 5 | 1 | 26931071 |
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)
);