TwitchChatBot
Tables (7)
audience (Untitled2)
- audience_id (Key2) — bigint(20) — Primary key — NOT NULL
- streamer_id (Key) — bigint(20) — Foreign key → streamer.streamer_id — NOT NULL
- audience_user_id (Field) — varchar(255) — NOT NULL
audience_attendance (Untitled4)
- audience_id (Key2) — int(11) — Foreign key → audience.audience_id — NOT NULL
- streamer_id (Key) — bigint(20) — Foreign key → audience.streamer_id — NOT NULL
- attend_date (Field) — date
- attend_datetime (Field2) — datetime
- attend_continuity (Field3) — int(11)
basic_command (Untitled6)
- basic_command_id (Key) — bigint(20) — Primary key — NOT NULL
- basic command_keyword (Field) — varchar(255) — NOT NULL
- basic_command_execution — varchar(255) — NOT NULL
bot_token (Untitled7)
- streamer_id (Key) — bigint(20) — Foreign key → streamer.streamer_id — NOT NULL
forbidden_word (Untitled5)
- streamer_id (Key2) — bigint(20) — Foreign key → streamer_detail.streamer_id — NOT NULL
- forbidden_word (Field) — varchar(255)
streamer (Untitled)
- streamer_id (Key) — bigint(20) — Primary key — NOT NULL
- streamer_key (id) — bigint(20) — NOT NULL
- streamer_user_id (Field4) — varchar(255) — NOT NULL
- channel_name (Field) — varchar(255) — NOT NULL
- refresh_token (Field5) — varchar(255) — NOT NULL
streamer_detail (Untitled3)
- streamer_id (Key) — bigint(20) — Foreign key → streamer.streamer_id — NOT NULL
- bot_in_use (Field2) — int(1) — NOT NULL
- donation_link (Field3) — varchar(255)
- greeting_message (Field4) — varchar(255)
- forbidden_word_limit (Field7) — int(1) — NOT NULL
- forbidden_word_timeout (Field5) — int(11)
- long_text_limit (Field6) — int(1) — NOT NULL
- long_text_limit_timeout (Field8) — int(11) — NOT NULL
- long_text_limit_length (Field9) — int(11) — NOT NULL
- special_character_limit (Field10) — int(1) — NOT NULL
- special_character_limit_timeout (Field11) — int(11) — NOT NULL
- lol_nickname (Field12) — varchar(255)