reversing_test
Tables (15)
admin_account
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- is_approved — bit(1) — NOT NULL
- login_id — varchar(20)
- login_password — varchar(128)
- name — varchar(32)
- roles — int(11) — NOT NULL
agency
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- agency_id — varchar(20) — NOT NULL
- allowed_ips_json — varchar(255) — NOT NULL
- perm_to_send — bit(1) — NOT NULL
- secret_key — varchar(255) — NOT NULL
- webhook_url — varchar(128)
- webhook_url2 — varchar(128)
- agency_corp_id — bigint(20) — Foreign key → agency_corp.id
agency_corp
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- contacts_json — longtext
- corp_certi_url — varchar(128)
- corp_regi_num — varchar(255)
- name — varchar(255)
brand_portal_client
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- client_id — varchar(20) — NOT NULL
- secret_key — varchar(255) — NOT NULL
- id (id2) — bigint(20) — Foreign key → chatbot_brand_home.id — NOT NULL
chatbot
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- builder_bot_id — varchar(255)
- builder_end_point_url — varchar(255)
- builder_platform — varchar(255)
- bot_tc_page_url — varchar(128) — NOT NULL
- chatbot_id — varchar(255) — NOT NULL
- display — varchar(255) — NOT NULL
- msisdn — varchar(255)
- samsung_access_token — varchar(255)
- samsung_bot_id — varchar(255)
- samsung_bot_webhook_url — varchar(255)
- samsung_service_id — varchar(255)
- samsung_sip_uri — varchar(255)
- samsung_verification_key — varchar(255)
- search_weight — int(11) — NOT NULL
- sms_mo — bit(1) — NOT NULL
- status — int(11)
- sub_image — varchar(255)
- sub_num — varchar(255)
- sub_title — varchar(255)
- type — int(11) — NOT NULL
- chatbot_brand_home_id — bigint(20) — Foreign key → chatbot_brand_home.id
- chatbot_corp_id — bigint(20) — Foreign key → chatbot_corp_info.id
chatbot_brand_home
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- address — varchar(255) — NOT NULL
- background_image_url — varchar(128) — NOT NULL
- brandhome_id — varchar(255) — NOT NULL
- category — varchar(255) — NOT NULL
- category_opt — varchar(255)
- category_sub — varchar(255) — NOT NULL
- contacts_json — longtext
- description — longtext
- displayed_num — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- icon_url — varchar(128) — NOT NULL
- menus_json — longtext
- name — varchar(255) — NOT NULL
- related_chatbots_json — longtext
- theme_color — varchar(255)
- web_site_url — varchar(128) — NOT NULL
chatbot_corp_info
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- address — longtext
- biz_condition — varchar(255)
- category — varchar(255)
- contacts_json — longtext
- corp_id — varchar(255)
- corp_name — varchar(255)
- corp_regi_num — varchar(255)
- name — varchar(255)
chatbots_message_base
- chatbots_id — bigint(20) — Foreign key → chatbot.id — NOT NULL
- message_bases_id — bigint(20) — Foreign key → message_base.id — NOT NULL
chatbots_resellers
- chatbots_id — bigint(20) — Foreign key → chatbot.id — NOT NULL
- resellers_id — bigint(20) — Foreign key → reseller.id — NOT NULL
message_base
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- biz_category — varchar(255)
- biz_condition — varchar(255)
- biz_serivce — varchar(255)
- card_type — varchar(255)
- description — longtext
- formatted_string_json — longtext — NOT NULL
- is_public — bit(1)
- message_base_id — varchar(40) — NOT NULL
- params_json — longtext
- policy_info_json — longtext
- spec — varchar(255) — NOT NULL
- status — varchar(20) — NOT NULL
- message_product_code_id — bigint(20) — Foreign key → message_product_code.id — NOT NULL
- reseller_id — bigint(20) — Foreign key → reseller.id
message_product_code
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- file_name — varchar(150) — NOT NULL
- name — varchar(16) — NOT NULL
- swing_product_code — varchar(32) — NOT NULL
messages
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- agency_id — bigint(20) — NOT NULL
- body_message_json — longtext — NOT NULL
- chatbot_id — bigint(20) — NOT NULL
- contact_num — varchar(20) — NOT NULL
- error_reason — longtext
- expiry_option — int(11) — NOT NULL
- footer_message — varchar(80) — NOT NULL
- group_id — varchar(32) — NOT NULL
- header_message — varchar(80) — NOT NULL
- message_base_id — varchar(40) — NOT NULL
- message_id — varchar(40) — NOT NULL
- message_product_code_id — bigint(20) — NOT NULL
- message_status — varchar(20) — NOT NULL
- res_msg_id — varchar(50)
- reseller_id — bigint(20) — NOT NULL
- id (id2) — bigint(20) — Foreign key → message_base.id — NOT NULL
- id (id3) — bigint(20) — Foreign key → agency.id — NOT NULL
messages_delivered_log
- id — bigint(20) — Primary key — NOT NULL
- agency_id — bigint(20)
- created_date — datetime(6) — NOT NULL
- message_product_code_id — bigint(20)
- messages_id — bigint(20)
- id (id2) — bigint(20) — Foreign key → messages.id — NOT NULL
messages_non_delivered_log
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- fail_reason — varchar(255)
- message_status — varchar(255) — NOT NULL
- messages_id — bigint(20)
- id (id2) — bigint(20) — Foreign key → messages.id — NOT NULL
reseller
- id — bigint(20) — Primary key — NOT NULL
- created_date — datetime(6) — NOT NULL
- is_active — bit(1)
- modified_date — datetime(6)
- address — varchar(255)
- agency_id — varchar(20) — NOT NULL
- contacts_json — longtext
- corp_name — varchar(255)
- corp_regi_num — varchar(255)
- name — varchar(255)