japari_dc_bot

Custom SQL query

Tables

attacks

attack_id, member_id, attack_datetime, battle_day, lap, boss_number, is_residual, damage, notes, related_full_attack_id

2,223 rows

command_logs

id, member_discord_id, guild_id, channel_id, command_name, command_args, invoked_at, is_success

3,592 rows

command_responses

id, custom_command_id, response_text, created_at

24 rows

custom_commands

id, command_name, is_enabled, description, created_at, updated_at

11 rows

discord_members

id, discord_id, discord_name, current_nickname, nickname_history, first_seen_at, last_updated_at

43 rows

interactive_roles

id, guild_id, role_id, role_name, role_color, message_id, channel_id, button_label, button_emoji, created_at, created_by_user_id, is_bound_role, custom_message_content

10 rows

members

member_id, discord_name, discord_id, game_id, account_count, is_in_role, timestamp

28 rows

sqlite_sequence

name, seq

6 rows

user_interactive_roles

user_discord_id, interactive_role_id, assigned_at

20 rows