attacks
62 rows where member_id = 489715315991642127
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 |
|---|---|---|---|---|---|---|---|---|---|
| 578 | 489715315991642127 489715315991642127 | 2025-07-27T09:12:57.074540+00:00 | 1 | 17 | 5 | 0 | |||
| 579 | 489715315991642127 489715315991642127 | 2025-07-27T09:12:57.074540+00:00 | 1 | 18 | 5 | 1 | 自動產生，關聯至完整刀 ID:578 | 578 | |
| 588 | 489715315991642127 489715315991642127 | 2025-07-27T09:19:25.116334+00:00 | 1 | 17 | 2 | 0 | |||
| 589 | 489715315991642127 489715315991642127 | 2025-07-27T09:19:25.116334+00:00 | 1 | 18 | 2 | 1 | 自動產生，關聯至完整刀 ID:588 | 588 | |
| 590 | 489715315991642127 489715315991642127 | 2025-07-27T09:27:00.159220+00:00 | 1 | 17 | 1 | 0 | |||
| 591 | 489715315991642127 489715315991642127 | 2025-07-27T09:27:00.159220+00:00 | 1 | 18 | 1 | 1 | 自動產生，關聯至完整刀 ID:590 | 590 | |
| 693 | 489715315991642127 489715315991642127 | 2025-07-28T10:09:31.051143+00:00 | 2 | 25 | 5 | 0 | 279045766 | ||
| 694 | 489715315991642127 489715315991642127 | 2025-07-28T10:38:47.801053+00:00 | 2 | 26 | 3 | 0 | 274238774 | ||
| 695 | 489715315991642127 489715315991642127 | 2025-07-28T10:57:14.477353+00:00 | 2 | 26 | 2 | 0 | 355537573 | ||
| 807 | 489715315991642127 489715315991642127 | 2025-07-29T09:23:05.488514+00:00 | 3 | 30 | 4 | 0 | 242792747 | ||
| 808 | 489715315991642127 489715315991642127 | 2025-07-29T09:51:11.670292+00:00 | 3 | 30 | 5 | 0 | 276217089 | ||
| 818 | 489715315991642127 489715315991642127 | 2025-07-29T11:51:13.433534+00:00 | 3 | 31 | 3 | 0 | 275179751 | ||
| 910 | 489715315991642127 489715315991642127 | 2025-07-30T08:10:20.709669+00:00 | 4 | 34 | 4 | 0 | 243871257 | ||
| 926 | 489715315991642127 489715315991642127 | 2025-07-30T12:41:50.751424+00:00 | 4 | 35 | 3 | 0 | 275069615 | ||
| 932 | 489715315991642127 489715315991642127 | 2025-07-30T12:47:47.186811+00:00 | 4 | 35 | 5 | 0 | 279295175 | ||
| 1032 | 489715315991642127 489715315991642127 | 2025-07-31T08:28:48.583898+00:00 | 5 | 39 | 4 | 0 | 247137188 | ||
| 1033 | 489715315991642127 489715315991642127 | 2025-07-31T08:40:32.954694+00:00 | 5 | 39 | 3 | 0 | 271636861 | ||
| 1034 | 489715315991642127 489715315991642127 | 2025-07-31T08:48:10.788229+00:00 | 5 | 40 | 5 | 0 | 279062420 | ||
| 1174 | 489715315991642127 489715315991642127 | 2025-08-27T07:48:37.164935+00:00 | 1 | 13 | 5 | 0 | |||
| 1175 | 489715315991642127 489715315991642127 | 2025-08-27T07:48:37.164935+00:00 | 1 | 14 | 5 | 1 | 自動產生，關聯至完整刀 ID:1174 | 1174 | |
| 1176 | 489715315991642127 489715315991642127 | 2025-08-27T07:54:06.412847+00:00 | 1 | 13 | 3 | 0 | |||
| 1177 | 489715315991642127 489715315991642127 | 2025-08-27T07:54:06.412847+00:00 | 1 | 14 | 3 | 1 | 自動產生，關聯至完整刀 ID:1176 | 1176 | |
| 1178 | 489715315991642127 489715315991642127 | 2025-08-27T07:59:44.583393+00:00 | 1 | 13 | 2 | 0 | |||
| 1179 | 489715315991642127 489715315991642127 | 2025-08-27T07:59:44.583393+00:00 | 1 | 14 | 2 | 1 | 自動產生，關聯至完整刀 ID:1178 | 1178 | |
| 1307 | 489715315991642127 489715315991642127 | 2025-08-28T08:07:13.467481+00:00 | 2 | 25 | 3 | 0 | 278377414 | ||
| 1308 | 489715315991642127 489715315991642127 | 2025-08-28T08:18:34.651909+00:00 | 2 | 25 | 3 | 0 | 4980696 | ||
| 1315 | 489715315991642127 489715315991642127 | 2025-08-28T11:46:25.125458+00:00 | 2 | 25 | 2 | 1 | 250618446 | ||
| 1351 | 489715315991642127 489715315991642127 | 2025-08-28T13:39:34.219129+00:00 | 2 | 27 | 5 | 0 | 264660784 | ||
| 1419 | 489715315991642127 489715315991642127 | 2025-08-29T06:41:44.481262+00:00 | 3 | 29 | 1 | 0 | 284539525 | ||
| 1480 | 489715315991642127 489715315991642127 | 2025-08-29T15:58:12.463181+00:00 | 3 | 31 | 2 | 0 | 242907508 | ||
| 1482 | 489715315991642127 489715315991642127 | 2025-08-29T16:07:34.223411+00:00 | 3 | 32 | 3 | 0 | 273151600 | ||
| 1484 | 489715315991642127 489715315991642127 | 2025-08-29T16:26:57.290837+00:00 | 3 | 32 | 2 | 1 | 17049579 | ||
| 1485 | 489715315991642127 489715315991642127 | 2025-08-29T16:36:02.625460+00:00 | 3 | 33 | 3 | 1 | 26737614 | ||
| 1569 | 489715315991642127 489715315991642127 | 2025-08-30T13:28:32.214094+00:00 | 4 | 35 | 3 | 0 | 281755154 | ||
| 1570 | 489715315991642127 489715315991642127 | 2025-08-30T13:32:03.707651+00:00 | 4 | 35 | 3 | 0 | 6485605 | ||
| 1579 | 489715315991642127 489715315991642127 | 2025-08-30T14:28:19.988464+00:00 | 4 | 36 | 2 | 1 | 247948944 | ||
| 1591 | 489715315991642127 489715315991642127 | 2025-08-30T14:53:40.981308+00:00 | 4 | 35 | 1 | 0 | 24106045 | ||
| 1593 | 489715315991642127 489715315991642127 | 2025-08-30T15:01:20.715416+00:00 | 4 | 36 | 1 | 1 | 280161278 | ||
| 1675 | 489715315991642127 489715315991642127 | 2025-08-31T07:36:04.339571+00:00 | 5 | 39 | 1 | 0 | 289581535 | ||
| 1676 | 489715315991642127 489715315991642127 | 2025-08-31T07:46:36.528653+00:00 | 5 | 40 | 5 | 0 | 263145412 | ||
| 1731 | 489715315991642127 489715315991642127 | 2025-08-31T14:35:04.582580+00:00 | 5 | 41 | 3 | 0 | 88432223 | ||
| 1732 | 489715315991642127 489715315991642127 | 2025-08-31T14:38:55.830684+00:00 | 5 | 42 | 3 | 1 | 205094574 | ||
| 1815 | 489715315991642127 489715315991642127 | 2025-09-26T07:53:59.901198+00:00 | 1 | 13 | 3 | 0 | |||
| 1816 | 489715315991642127 489715315991642127 | 2025-09-26T07:53:59.901198+00:00 | 1 | 14 | 3 | 1 | 自動產生，關聯至完整刀 ID:1815 | 1815 | |
| 1817 | 489715315991642127 489715315991642127 | 2025-09-26T07:57:04.232973+00:00 | 1 | 13 | 2 | 0 | |||
| 1818 | 489715315991642127 489715315991642127 | 2025-09-26T07:57:04.232973+00:00 | 1 | 14 | 2 | 1 | 自動產生，關聯至完整刀 ID:1817 | 1817 | |
| 1819 | 489715315991642127 489715315991642127 | 2025-09-26T08:01:23.864403+00:00 | 1 | 15 | 5 | 0 | |||
| 1820 | 489715315991642127 489715315991642127 | 2025-09-26T08:01:23.864403+00:00 | 1 | 16 | 5 | 1 | 自動產生，關聯至完整刀 ID:1819 | 1819 | |
| 1950 | 489715315991642127 489715315991642127 | 2025-09-27T09:37:05.491987+00:00 | 2 | 27 | 2 | 0 | 314396409 | ||
| 1954 | 489715315991642127 489715315991642127 | 2025-09-27T10:56:36.739842+00:00 | 2 | 27 | 4 | 0 | 265240818 | ||
| 1963 | 489715315991642127 489715315991642127 | 2025-09-27T12:49:35.197983+00:00 | 2 | 27 | 3 | 0 | 355095458 | ||
| 2055 | 489715315991642127 489715315991642127 | 2025-09-28T10:03:28.394450+00:00 | 3 | 31 | 3 | 0 | 354090038 | ||
| 2057 | 489715315991642127 489715315991642127 | 2025-09-28T10:16:42.463614+00:00 | 3 | 31 | 4 | 0 | 265974851 | ||
| 2058 | 489715315991642127 489715315991642127 | 2025-09-28T10:27:46.497109+00:00 | 3 | 30 | 5 | 0 | 193111272 | ||
| 2062 | 489715315991642127 489715315991642127 | 2025-09-28T11:28:43.954490+00:00 | 3 | 32 | 2 | 1 | 57584423 | ||
| 2167 | 489715315991642127 489715315991642127 | 2025-09-29T09:47:39.006969+00:00 | 4 | 35 | 4 | 0 | 265563477 | ||
| 2170 | 489715315991642127 489715315991642127 | 2025-09-29T10:01:41.452942+00:00 | 4 | 36 | 1 | 0 | 316465053 | ||
| 2176 | 489715315991642127 489715315991642127 | 2025-09-29T10:34:44.783940+00:00 | 4 | 36 | 5 | 0 | 276683745 | ||
| 2273 | 489715315991642127 489715315991642127 | 2025-09-30T08:28:30.345369+00:00 | 5 | 39 | 4 | 0 | 264041749 | ||
| 2274 | 489715315991642127 489715315991642127 | 2025-09-30T08:39:58.959193+00:00 | 5 | 39 | 4 | 0 | 242550734 | ||
| 2279 | 489715315991642127 489715315991642127 | 2025-09-30T11:23:04.968929+00:00 | 5 | 41 | 3 | 0 | 328657372 | ||
| 2280 | 489715315991642127 489715315991642127 | 2025-09-30T11:31:00.746393+00:00 | 5 | 40 | 4 | 1 | 48716346 |
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)
);