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)