dd
Tables (10)
chat_history
- chat_history_id — int
- session_id2 — INT
- chat_history — VARCHAR(10) — NOT NULL
classified_type
- classified_type_id — INT
- user_request_id2 — INT
- classified_type — VARCHAR(50) — NOT NULL
corp_info
- corp_info_id — INT — Primary key — NOT NULL
- corp_name_id — INT — NOT NULL
- corp_intro — TEXT
- ideal_talent — TEXT
- main_business — TEXT
- esg_activity — TEXT
corp_name
- corp_name_id — INT — Primary key — NOT NULL
- session_id2 — INT
- corp_name — VARCHAR(255) — NOT NULL
coverletter
- my_cover_letter_id — INT
- user_request_id — INT
- my_cover_letter — LONGTEXT — NOT NULL
recruit_info
- recruit_info_id — INT
- session_id2 — INT
- corp_name_id — INT — NOT NULL
- recruit_info — TEXT — NOT NULL
revise_user_request
- revise_user_request_id — INT
- my_cover_letter_id — INT
- revise_user_request — TEXT — NOT NULL
revised_coverletter
- revised_cover_letter_id — INT
- revise_user_request_id — INT
- revised_cover_letter — LONGTEXT — NOT NULL
user_request
- user_request_id — INT
- corp_name_id — INT — NOT NULL
- recruit_info_id2 — INT
- my_request — TEXT — NOT NULL