pre_on_board

Tables (4)

apply_posting (지원내역)

  • id — bigint — Primary key — NOT NULL
  • user_id (유저_id) — bigint — Foreign key → user_info.id — NOT NULL
  • posting_id (채용공고_id) — bigint — Foreign key → jop_posting.id — NOT NULL

company (회사)

  • id — bigint — Primary key — NOT NULL
  • company_name (회사명)
  • country (국가) — varchar(100)
  • location (지역) — varchar(100)
  • posting (구인공고) — object

jop_posting (채용공고)

  • id — bigint — Primary key — NOT NULL
  • company_id (회사_id) — bigint — Foreign key → company.id — NOT NULL
  • position (채용포지션) — varchar(200)
  • compensation (채용보상) — int
  • content (채용내용) — TEXT
  • skill (필수스킬) — varchar(100)

user_info (사용자)

  • id — bigint — Primary key — NOT NULL
  • username (이름) — varchar(50)
  • position (주포지션) — varchar(100)
  • apply (지원내역) — obejct
  • email (이메일) — varchar(100)