attacks
61 rows where member_id = 719437640809840723
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 |
|---|---|---|---|---|---|---|---|---|---|
| 563 | 719437640809840723 719437640809840723 | 2025-07-27T07:15:41.640306+00:00 | 1 | 15 | 1 | 0 | 50000000 | ||
| 564 | 719437640809840723 719437640809840723 | 2025-07-27T07:15:41.640306+00:00 | 1 | 16 | 1 | 1 | 自動產生，關聯至完整刀 ID:563 | 563 | |
| 569 | 719437640809840723 719437640809840723 | 2025-07-27T07:20:38.505560+00:00 | 1 | 15 | 3 | 0 | 64000000 | 正刀 | |
| 570 | 719437640809840723 719437640809840723 | 2025-07-27T07:20:38.505560+00:00 | 1 | 16 | 3 | 1 | 自動產生，關聯至完整刀 ID:569 | 569 | |
| 576 | 719437640809840723 719437640809840723 | 2025-07-27T07:32:51.393784+00:00 | 1 | 15 | 4 | 0 | |||
| 577 | 719437640809840723 719437640809840723 | 2025-07-27T07:32:51.393784+00:00 | 1 | 16 | 4 | 1 | 自動產生，關聯至完整刀 ID:576 | 576 | |
| 689 | 719437640809840723 719437640809840723 | 2025-07-28T08:07:05.854179+00:00 | 2 | 25 | 4 | 0 | 224682679 | ||
| 690 | 719437640809840723 719437640809840723 | 2025-07-28T08:12:45.031030+00:00 | 2 | 25 | 5 | 0 | 277152639 | ||
| 692 | 719437640809840723 719437640809840723 | 2025-07-28T08:29:34.196256+00:00 | 2 | 25 | 1 | 0 | 316330403 | ||
| 804 | 719437640809840723 719437640809840723 | 2025-07-29T06:25:36.095441+00:00 | 3 | 29 | 1 | 0 | 45421064 | ||
| 805 | 719437640809840723 719437640809840723 | 2025-07-29T06:30:18.153488+00:00 | 3 | 30 | 1 | 1 | 314324389 | ||
| 834 | 719437640809840723 719437640809840723 | 2025-07-29T13:25:50.954840+00:00 | 3 | 31 | 4 | 0 | 247120000 | ||
| 836 | 719437640809840723 719437640809840723 | 2025-07-29T13:34:48.975290+00:00 | 3 | 32 | 5 | 0 | 276276293 | ||
| 904 | 719437640809840723 719437640809840723 | 2025-07-30T06:56:37.981959+00:00 | 4 | 35 | 5 | 0 | 173585433 | ||
| 906 | 719437640809840723 719437640809840723 | 2025-07-30T07:22:51.507574+00:00 | 4 | 34 | 3 | 0 | 272006578 | ||
| 908 | 719437640809840723 719437640809840723 | 2025-07-30T07:42:49.992462+00:00 | 4 | 33 | 1 | 0 | 11967401 | ||
| 909 | 719437640809840723 719437640809840723 | 2025-07-30T07:43:25.574202+00:00 | 4 | 34 | 1 | 1 | 197124099 | ||
| 989 | 719437640809840723 719437640809840723 | 2025-07-30T17:57:47.229455+00:00 | 4 | 38 | 5 | 1 | 54765584 | ||
| 1019 | 719437640809840723 719437640809840723 | 2025-07-31T04:32:58.466409+00:00 | 5 | 39 | 1 | 0 | 316158834 | ||
| 1023 | 719437640809840723 719437640809840723 | 2025-07-31T05:05:57.012066+00:00 | 5 | 38 | 4 | 0 | 256692491 | ||
| 1026 | 719437640809840723 719437640809840723 | 2025-07-31T05:14:20.046895+00:00 | 5 | 39 | 5 | 0 | 279239660 | ||
| 1224 | 719437640809840723 719437640809840723 | 2025-08-27T11:28:49.810883+00:00 | 1 | 21 | 1 | 0 | |||
| 1225 | 719437640809840723 719437640809840723 | 2025-08-27T11:28:49.810883+00:00 | 1 | 22 | 1 | 1 | 自動產生，關聯至完整刀 ID:1224 | 1224 | |
| 1228 | 719437640809840723 719437640809840723 | 2025-08-27T11:31:11.041154+00:00 | 1 | 20 | 2 | 0 | |||
| 1229 | 719437640809840723 719437640809840723 | 2025-08-27T11:31:11.041154+00:00 | 1 | 21 | 2 | 1 | 自動產生，關聯至完整刀 ID:1228 | 1228 | |
| 1236 | 719437640809840723 719437640809840723 | 2025-08-27T11:39:41.889490+00:00 | 1 | 22 | 4 | 0 | 70000000 | ||
| 1238 | 719437640809840723 719437640809840723 | 2025-08-27T11:41:24.410293+00:00 | 1 | 22 | 5 | 1 | 85000000 | ||
| 1356 | 719437640809840723 719437640809840723 | 2025-08-28T13:57:43.957815+00:00 | 2 | 27 | 3 | 0 | 279132035 | ||
| 1359 | 719437640809840723 719437640809840723 | 2025-08-28T14:09:09.988057+00:00 | 2 | 27 | 2 | 0 | 251958281 | ||
| 1364 | 719437640809840723 719437640809840723 | 2025-08-28T14:20:56.882727+00:00 | 2 | 28 | 1 | 0 | 32938784 | ||
| 1458 | 719437640809840723 719437640809840723 | 2025-08-29T14:27:25.638295+00:00 | 3 | 31 | 2 | 0 | 252514506 | ||
| 1460 | 719437640809840723 719437640809840723 | 2025-08-29T14:32:43.926600+00:00 | 3 | 31 | 1 | 0 | 328656214 | ||
| 1464 | 719437640809840723 719437640809840723 | 2025-08-29T14:38:31.544744+00:00 | 3 | 31 | 3 | 0 | 277868315 | ||
| 1605 | 719437640809840723 719437640809840723 | 2025-08-30T16:08:04.975705+00:00 | 4 | 36 | 1 | 0 | 328868969 | ||
| 1607 | 719437640809840723 719437640809840723 | 2025-08-30T16:08:55.331080+00:00 | 4 | 37 | 3 | 0 | 270953211 | ||
| 1608 | 719437640809840723 719437640809840723 | 2025-08-30T16:12:09.586028+00:00 | 4 | 38 | 3 | 1 | 34057709 | ||
| 1610 | 719437640809840723 719437640809840723 | 2025-08-30T16:16:19.438124+00:00 | 4 | 37 | 2 | 0 | 252466673 | ||
| 1710 | 719437640809840723 719437640809840723 | 2025-08-31T12:56:40.485420+00:00 | 5 | 41 | 3 | 0 | 278439291 | ||
| 1715 | 719437640809840723 719437640809840723 | 2025-08-31T13:11:00.335914+00:00 | 5 | 41 | 1 | 0 | 253096728 | ||
| 1720 | 719437640809840723 719437640809840723 | 2025-08-31T13:20:22.779756+00:00 | 5 | 41 | 2 | 0 | 252448092 | ||
| 1721 | 719437640809840723 719437640809840723 | 2025-08-31T13:23:24.257326+00:00 | 5 | 42 | 1 | 1 | 30261317 | ||
| 1803 | 719437640809840723 719437640809840723 | 2025-09-26T04:54:12.018254+00:00 | 1 | 11 | 1 | 0 | |||
| 1804 | 719437640809840723 719437640809840723 | 2025-09-26T04:54:12.018254+00:00 | 1 | 12 | 1 | 1 | 自動產生，關聯至完整刀 ID:1803 | 1803 | |
| 1805 | 719437640809840723 719437640809840723 | 2025-09-26T05:03:02.898413+00:00 | 1 | 11 | 2 | 0 | |||
| 1806 | 719437640809840723 719437640809840723 | 2025-09-26T05:03:02.898413+00:00 | 1 | 12 | 2 | 1 | 自動產生，關聯至完整刀 ID:1805 | 1805 | |
| 1807 | 719437640809840723 719437640809840723 | 2025-09-26T05:05:09.150243+00:00 | 1 | 11 | 5 | 0 | |||
| 1808 | 719437640809840723 719437640809840723 | 2025-09-26T05:05:09.150243+00:00 | 1 | 12 | 5 | 1 | 自動產生，關聯至完整刀 ID:1807 | 1807 | |
| 1962 | 719437640809840723 719437640809840723 | 2025-09-27T12:45:23.045256+00:00 | 2 | 26 | 1 | 0 | 267613494 | ||
| 1964 | 719437640809840723 719437640809840723 | 2025-09-27T12:51:04.477698+00:00 | 2 | 27 | 2 | 0 | 302286310 | ||
| 1965 | 719437640809840723 719437640809840723 | 2025-09-27T13:08:28.038302+00:00 | 2 | 27 | 4 | 0 | 246145225 | ||
| 2101 | 719437640809840723 719437640809840723 | 2025-09-28T15:07:31.127375+00:00 | 3 | 32 | 5 | 0 | 291311299 | ||
| 2102 | 719437640809840723 719437640809840723 | 2025-09-28T15:09:02.205642+00:00 | 3 | 33 | 2 | 0 | 213569015 | ||
| 2103 | 719437640809840723 719437640809840723 | 2025-09-28T15:14:34.172605+00:00 | 3 | 32 | 1 | 0 | 277867004 | ||
| 2104 | 719437640809840723 719437640809840723 | 2025-09-28T15:16:58.065805+00:00 | 3 | 32 | 1 | 1 | 2665647 | ||
| 2206 | 719437640809840723 719437640809840723 | 2025-09-29T15:14:10.850293+00:00 | 4 | 37 | 3 | 0 | 291104704 | ||
| 2208 | 719437640809840723 719437640809840723 | 2025-09-29T15:18:41.571711+00:00 | 4 | 37 | 1 | 0 | 278924428 | ||
| 2213 | 719437640809840723 719437640809840723 | 2025-09-29T15:27:12.038815+00:00 | 4 | 37 | 3 | 0 | 335006992 | ||
| 2215 | 719437640809840723 719437640809840723 | 2025-09-29T15:31:54.476175+00:00 | 4 | 37 | 4 | 1 | 49174848 | ||
| 2316 | 719437640809840723 719437640809840723 | 2025-09-30T13:14:18.328471+00:00 | 5 | 42 | 2 | 0 | 292635009 | ||
| 2321 | 719437640809840723 719437640809840723 | 2025-09-30T13:29:05.324871+00:00 | 5 | 42 | 5 | 0 | 291574313 | ||
| 2322 | 719437640809840723 719437640809840723 | 2025-09-30T13:32:18.415722+00:00 | 5 | 42 | 1 | 0 | 308194032 |
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)
);