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

session

  • session_id — INT

user_request

  • user_request_id — INT
  • corp_name_id — INT — NOT NULL
  • recruit_info_id2 — INT
  • my_request — TEXT — NOT NULL