Ainterview

Tables (4)

Interview (interview)

  • interviewId (interview_id) — bigint — Primary key — NOT NULL
  • memberId (member_id) — bigint — Foreign key → Member.memberId — NOT NULL
  • resumeId (resume_id) — bigint — Foreign key → Resume.resumeId — NOT NULL
  • title — varchar(255)
  • job — varchar(255)
  • requirement — varchar(255)
  • qnaList (qna_list) — text

Member (member)

  • memberId (member_id) — bigint — Primary key — NOT NULL
  • nickname — varchar(255)
  • authority — varchar(255)
  • email — varchar(255)
  • password — varchar(255)

RefreshToken (refresh_token)

  • refreshId (rt_id) — bigint — Primary key — NOT NULL
  • key (rt_key) — String — Foreign key → Member.memberId — NOT NULL
  • value (rt_value) — String

Resume (resume)

  • resumeId (resume_id) — bigint — Primary key — NOT NULL
  • memberId (member_id) — bigint — Foreign key → Member.memberId — NOT NULL
  • title — varchar(255)
  • award — varchar(255)
  • career — varchar(255)
  • language — varchar(255)
  • introduction — text