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)