home / japari_dc_bot

attacks

57 rows where member_id = 476788426012622855

✎ View and edit SQL

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

CSV options:

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)
        );
Powered by Datasette · Queries took 36.86ms