heymango

Tables (4)

TB_ANSWER

  • ANSWER_ID — bigint — Primary key — NOT NULL
  • ANSWER — longtext
  • FRST_REGIST_DT — date
  • RATE — varchar(1)
  • RATE_TEXT — longtext
  • RESPONSE_TIME — bigint
  • IS_ERROR — varchar(10)
  • CHAT_ID — bigint — Foreign key → TB_CHAT.CHAT_ID — NOT NULL

TB_CHANNEL

  • CHANNEL_ID — bigint — Primary key — NOT NULL
  • CHANNEL_NAME — varchar(255)
  • FRST_REGIST_DT — date
  • USER_ID — varchar(100) — Foreign key → TB_USER.USER_ID — NOT NULL

TB_CHAT

  • CHAT_ID — bigint — Primary key — NOT NULL
  • QUESTION — longtext
  • FRST_REGIST_DT
  • REFERENCE_TEXT — longtext
  • CHANNEL_ID — bigint — Foreign key → TB_CHANNEL.CHANNEL_ID — NOT NULL

TB_USER

  • USER_ID — varchar(100) — Primary key — NOT NULL
  • USER_PW — varchar(255)
  • USER_NAME — varchar(30)
  • USER_EMAIL — varchar(255)
  • USER_PHONE_NUM — varchar(30)