Help+
Tables (7)
company_entity
- id — bigint — Primary key — NOT NULL
- create_at — datetime(6)
- is_delete — tinyint(1)
- send_to_sfdc — tinyint(1)
- update_at — datetime(6)
- case_cnt — int — NOT NULL
- customer_rank — enum('EXPERT', 'NEW', 'PREMIUM')
- name — varchar(255)
- sfdc_id — varchar(255)
contact_entity
- id — bigint — Primary key — NOT NULL
- company_id — bigint — Foreign key → company_entity.id — NOT NULL
- is_delete — tinyint(1)
- send_to_sfdc — tinyint(1)
- create_at — datetime(6)
- update_at — datetime(6)
- email — varchar(255)
- name — varchar(255)
- sfdc_id — varchar(255)
- tel — varchar(255)
faq_entity
- id — bigint — Primary key — NOT NULL
- is_delete — tinyint(1)
- order_no — int — NOT NULL
- send_to_sfdc — tinyint(1)
- sfdc_connect — bit(1)
- create_at — datetime(6)
- update_at — datetime(6)
- hash — varchar(255)
- summary — varchar(255)
- title — varchar(255)
- contents — longtext
faq_file_entity
- id — bigint — Primary key — NOT NULL
- id (faq_id) — bigint — Foreign key → faq_entity.id — NOT NULL
- is_delete — tinyint(1)
- send_to_sfdc — tinyint(1)
- create_at — datetime(6)
- update_at — datetime(6)
- file_name — varchar(255)
- file_path — varchar(255)
- file_type — varchar(255)
- origin_name — varchar(255)
help_case_entity
- id — bigint — Primary key — NOT NULL
- company_id (id2) — bigint — Foreign key → company_entity.id — NOT NULL
- contactor_id — bigint — Foreign key → contact_entity.id — NOT NULL
- is_delete — tinyint(1)
- send_to_sfdc — tinyint(1)
- create_at — datetime(6)
- update_at — datetime(6)
- sfdc_id — varchar(255)
- title — varchar(255)
- category — enum( 'ADVANCEMENT', 'MAINTENANCE', 'SIMPLE_INQUIRY', 'SYSTEM_ERROR' )
- contents — longtext
- status — enum('NEW', 'PROCESS')
help_case_file_entity
- id — bigint — Primary key — NOT NULL
- case_id — bigint — Foreign key → help_case_entity.id — NOT NULL
- is_delete — tinyint(1)
- send_to_sfdc — tinyint(1)
- create_at — datetime(6)
- update_at — datetime(6)
- file_name — varchar(255)
- file_path — varchar(255)
- file_type — varchar(255)
- origin_name — varchar(255)
help_case_history_entity
- id — bigint — Primary key — NOT NULL
- case_id — bigint — Foreign key → help_case_entity.id — NOT NULL
- is_delete — tinyint(1)
- send_to_sfdc — tinyint(1)
- create_at — datetime(6)
- update_at — datetime(6)
- contents — varchar(255)
- title — varchar(255)