Individual_Token

Tables (6)

bot_tbl (bot)

  • Key — Primary key — NOT NULL
  • bot_explanation (Field) — varchar(40)

conv_tbl (conversation)

  • Key — Primary key — NOT NULL
  • bot_id (Field2) — varchar(20)
  • user_id (Field) — varchar(20)
  • start_time (Field3) — date
  • end_time (Field4) — date
  • token_id (Field5) — int

message_tbl (message)

  • message_id (Key) — varchar(20) — Primary key — NOT NULL
  • conversation_id (Field) — varchar(20)
  • user_message (Field2) — varchar(40)
  • bot_message (Field3) — varchar(40)
  • time_stamp (Field4) — date

token_tbl (token)

  • token_id (Key) — varchar(20) — Primary key — NOT NULL
  • user_id (Field) — varchar(20)
  • token_value (Field2) — int
  • token_made (Field3) — date
  • token_dead (Field4) — date

user_message_tbl (user_message)

  • user_id (Key) — varchar(20) — Primary key — NOT NULL
  • message_id (Key2) — varchar(20) — Primary key — NOT NULL

user_tbl (user)

  • user_id (Key) — varchar(20) — Primary key — NOT NULL
  • user_name (Field2) — varchar(20)
  • user_email (Field3) — varchar(20)