attacks
67 rows where member_id = 470853853546414080
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 |
|---|---|---|---|---|---|---|---|---|---|
| 11 | 470853853546414080 470853853546414080 | 2025-06-26T00:51:00.567075+00:00 | 1 | 3 | 2 | 0 | |||
| 12 | 470853853546414080 470853853546414080 | 2025-06-26T00:51:00.567075+00:00 | 1 | 4 | 2 | 1 | 自動產生，關聯至完整刀 ID:11 | 11 | |
| 120 | 470853853546414080 470853853546414080 | 2025-06-27T01:06:12.067164+00:00 | 2 | 25 | 2 | 0 | 169755693 | ||
| 485 | 470853853546414080 470853853546414080 | 2025-07-27T02:49:21.861900+00:00 | 1 | 3 | 2 | 0 | 15000000 | ||
| 486 | 470853853546414080 470853853546414080 | 2025-07-27T02:49:21.861900+00:00 | 1 | 4 | 2 | 1 | 自動產生，關聯至完整刀 ID:485 | 485 | |
| 487 | 470853853546414080 470853853546414080 | 2025-07-27T02:50:08.743680+00:00 | 1 | 3 | 3 | 0 | 20000000 | ||
| 488 | 470853853546414080 470853853546414080 | 2025-07-27T02:50:08.743680+00:00 | 1 | 4 | 3 | 1 | 自動產生，關聯至完整刀 ID:487 | 487 | |
| 489 | 470853853546414080 470853853546414080 | 2025-07-27T02:50:51.418351+00:00 | 1 | 3 | 4 | 0 | 23000000 | ||
| 490 | 470853853546414080 470853853546414080 | 2025-07-27T02:50:51.418351+00:00 | 1 | 4 | 4 | 1 | 自動產生，關聯至完整刀 ID:489 | 489 | |
| 666 | 470853853546414080 470853853546414080 | 2025-07-28T01:03:25.592211+00:00 | 2 | 25 | 2 | 0 | 312866346 | ||
| 667 | 470853853546414080 470853853546414080 | 2025-07-28T01:53:35.487002+00:00 | 2 | 24 | 4 | 0 | 213128746 | ||
| 682 | 470853853546414080 470853853546414080 | 2025-07-28T06:39:25.032072+00:00 | 2 | 24 | 1 | 0 | 295884918 | ||
| 791 | 470853853546414080 470853853546414080 | 2025-07-29T04:45:49.466383+00:00 | 3 | 29 | 4 | 0 | 214907516 | ||
| 792 | 470853853546414080 470853853546414080 | 2025-07-29T04:51:50.513157+00:00 | 3 | 29 | 1 | 0 | 288867375 | ||
| 797 | 470853853546414080 470853853546414080 | 2025-07-29T05:11:25.662707+00:00 | 3 | 29 | 2 | 0 | 75856883 | ||
| 798 | 470853853546414080 470853853546414080 | 2025-07-29T05:11:47.843016+00:00 | 3 | 30 | 2 | 1 | 295890273 | ||
| 894 | 470853853546414080 470853853546414080 | 2025-07-29T23:23:04.772465+00:00 | 4 | 33 | 4 | 0 | 214525235 | ||
| 896 | 470853853546414080 470853853546414080 | 2025-07-29T23:28:20.789221+00:00 | 4 | 34 | 2 | 0 | 314440430 | ||
| 915 | 470853853546414080 470853853546414080 | 2025-07-30T09:55:56.441587+00:00 | 4 | 34 | 1 | 0 | 241201301 | ||
| 916 | 470853853546414080 470853853546414080 | 2025-07-30T09:58:06.873549+00:00 | 4 | 35 | 1 | 1 | 52534604 | ||
| 1018 | 470853853546414080 470853853546414080 | 2025-07-31T04:21:20.640053+00:00 | 5 | 39 | 1 | 0 | 279319936 | ||
| 1037 | 470853853546414080 470853853546414080 | 2025-07-31T09:34:30.299158+00:00 | 5 | 39 | 2 | 0 | 201085603 | ||
| 1038 | 470853853546414080 470853853546414080 | 2025-07-31T09:39:52.758780+00:00 | 5 | 30 | 2 | 1 | 117843728 | ||
| 1044 | 470853853546414080 470853853546414080 | 2025-07-31T10:14:07.065529+00:00 | 5 | 39 | 4 | 0 | 93608542 | ||
| 1045 | 470853853546414080 470853853546414080 | 2025-07-31T10:19:43.937037+00:00 | 5 | 30 | 4 | 0 | 144869864 | ||
| 1150 | 470853853546414080 470853853546414080 | 2025-08-27T06:05:20.468036+00:00 | 1 | 9 | 5 | 0 | 85000000 | ||
| 1151 | 470853853546414080 470853853546414080 | 2025-08-27T06:05:20.468036+00:00 | 1 | 10 | 5 | 1 | 自動產生，關聯至完整刀 ID:1150 | 1150 | |
| 1154 | 470853853546414080 470853853546414080 | 2025-08-27T06:05:50.348560+00:00 | 1 | 9 | 4 | 0 | 70000000 | ||
| 1155 | 470853853546414080 470853853546414080 | 2025-08-27T06:05:50.348560+00:00 | 1 | 10 | 4 | 1 | 自動產生，關聯至完整刀 ID:1154 | 1154 | |
| 1158 | 470853853546414080 470853853546414080 | 2025-08-27T06:11:16.380367+00:00 | 1 | 9 | 2 | 0 | 56000000 | ||
| 1159 | 470853853546414080 470853853546414080 | 2025-08-27T06:11:16.380367+00:00 | 1 | 10 | 2 | 1 | 自動產生，關聯至完整刀 ID:1158 | 1158 | |
| 1306 | 470853853546414080 470853853546414080 | 2025-08-28T06:36:26.396696+00:00 | 2 | 25 | 3 | 0 | 231294449 | ||
| 1314 | 470853853546414080 470853853546414080 | 2025-08-28T11:45:51.300548+00:00 | 2 | 26 | 4 | 0 | 305066379 | ||
| 1322 | 470853853546414080 470853853546414080 | 2025-08-28T12:33:57.531622+00:00 | 2 | 25 | 5 | 0 | 87704677 | ||
| 1324 | 470853853546414080 470853853546414080 | 2025-08-28T12:34:20.565478+00:00 | 2 | 26 | 5 | 1 | 121136232 | ||
| 1406 | 470853853546414080 470853853546414080 | 2025-08-29T02:31:27.413752+00:00 | 3 | 28 | 2 | 0 | 2249744 | ||
| 1407 | 470853853546414080 470853853546414080 | 2025-08-29T02:35:25.817332+00:00 | 3 | 30 | 4 | 0 | 350550394 | ||
| 1417 | 470853853546414080 470853853546414080 | 2025-08-29T04:22:02.984902+00:00 | 3 | 30 | 2 | 0 | 234801654 | ||
| 1424 | 470853853546414080 470853853546414080 | 2025-08-29T09:45:03.105071+00:00 | 3 | 30 | 5 | 1 | 174307116 | ||
| 1425 | 470853853546414080 470853853546414080 | 2025-08-29T09:45:38.413506+00:00 | 3 | 28 | 2 | 0 | 2249744 | ||
| 1515 | 470853853546414080 470853853546414080 | 2025-08-30T02:32:49.704798+00:00 | 4 | 34 | 3 | 0 | 232464352 | ||
| 1535 | 470853853546414080 470853853546414080 | 2025-08-30T04:30:41.139625+00:00 | 4 | 34 | 4 | 0 | 24950013 | ||
| 1537 | 470853853546414080 470853853546414080 | 2025-08-30T04:35:13.662731+00:00 | 4 | 35 | 4 | 0 | 350137579 | ||
| 1539 | 470853853546414080 470853853546414080 | 2025-08-30T04:47:40.553866+00:00 | 4 | 34 | 5 | 0 | 202818335 | ||
| 1677 | 470853853546414080 470853853546414080 | 2025-08-31T07:54:19.921201+00:00 | 5 | 40 | 5 | 0 | 202015589 | ||
| 1681 | 470853853546414080 470853853546414080 | 2025-08-31T09:33:23.501384+00:00 | 5 | 40 | 4 | 0 | 350478210 | ||
| 1683 | 470853853546414080 470853853546414080 | 2025-08-31T09:40:17.560966+00:00 | 5 | 39 | 3 | 0 | 131643796 | ||
| 1684 | 470853853546414080 470853853546414080 | 2025-08-31T09:45:51.108659+00:00 | 5 | 40 | 3 | 0 | 137680959 | ||
| 1821 | 470853853546414080 470853853546414080 | 2025-09-26T08:23:50.238193+00:00 | 1 | 15 | 4 | 0 | 70000000 | ||
| 1823 | 470853853546414080 470853853546414080 | 2025-09-26T08:24:15.496331+00:00 | 1 | 16 | 4 | 1 | 70000000 | ||
| 1825 | 470853853546414080 470853853546414080 | 2025-09-26T08:32:23.311574+00:00 | 1 | 15 | 3 | 0 | 64000000 | ||
| 1826 | 470853853546414080 470853853546414080 | 2025-09-26T08:32:23.311574+00:00 | 1 | 16 | 3 | 1 | 64000000 | 自動產生，關聯至完整刀 ID:1825 | 1825 |
| 1829 | 470853853546414080 470853853546414080 | 2025-09-26T08:39:15.497460+00:00 | 1 | 15 | 2 | 0 | 56000000 | ||
| 1831 | 470853853546414080 470853853546414080 | 2025-09-26T08:39:25.864427+00:00 | 1 | 16 | 2 | 1 | 56000000 | ||
| 1911 | 470853853546414080 470853853546414080 | 2025-09-27T03:22:10.428917+00:00 | 2 | 24 | 1 | 0 | 251294984 | ||
| 1914 | 470853853546414080 470853853546414080 | 2025-09-27T03:49:55.703350+00:00 | 2 | 24 | 4 | 0 | 80067507 | ||
| 1915 | 470853853546414080 470853853546414080 | 2025-09-27T03:50:14.003748+00:00 | 2 | 25 | 4 | 0 | 127352031 | ||
| 1930 | 470853853546414080 470853853546414080 | 2025-09-27T05:16:28.543613+00:00 | 2 | 25 | 2 | 0 | 285901264 | ||
| 2014 | 470853853546414080 470853853546414080 | 2025-09-27T21:25:14.642231+00:00 | 3 | 29 | 4 | 0 | 197528582 | ||
| 2028 | 470853853546414080 470853853546414080 | 2025-09-28T03:35:29.620044+00:00 | 3 | 29 | 1 | 0 | 254477355 | ||
| 2039 | 470853853546414080 470853853546414080 | 2025-09-28T07:07:29.639718+00:00 | 3 | 30 | 2 | 0 | 279733152 | ||
| 2129 | 470853853546414080 470853853546414080 | 2025-09-29T03:43:00.208156+00:00 | 4 | 34 | 4 | 0 | 193243985 | ||
| 2137 | 470853853546414080 470853853546414080 | 2025-09-29T04:24:24.874320+00:00 | 4 | 35 | 2 | 0 | 284208738 | ||
| 2140 | 470853853546414080 470853853546414080 | 2025-09-29T04:27:55.221191+00:00 | 4 | 35 | 1 | 0 | 255644406 | ||
| 2250 | 470853853546414080 470853853546414080 | 2025-09-30T00:45:37.269891+00:00 | 5 | 39 | 1 | 0 | 255105522 | ||
| 2251 | 470853853546414080 470853853546414080 | 2025-09-30T01:48:34.471988+00:00 | 5 | 39 | 2 | 0 | 284986037 | ||
| 2253 | 470853853546414080 470853853546414080 | 2025-09-30T01:56:54.117580+00:00 | 5 | 39 | 4 | 0 | 188784916 |
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)
);