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)