Wanted
Tables (5)
Company (기업)
- id — LONG — Primary key — NOT NULL
- user_id — LONG — Foreign key → User.id — NOT NULL
- name — VARCHAR(20)
- business_reg_code — VARCHAR(10)
- image — VARCHAR(200)
- industry — VARCHAR(15)
- employee_count — VARCHAR(15)
Recruitment (채용공고)
- id — LONG — Primary key — NOT NULL
- company_id — LONG — Foreign key → Company.id — NOT NULL
- job_field — VARCHAR(15)
- job_specialties — VARCHAR(100)
- title — VARCHAR(50)
- description — VARCHAR(1000)
- upload_date — LOCALDATETIME
- update_date — LOCALDATETIME
- due_date — LOCALDATE
- address — VARCHAR(50)
User (회원)
- id — LONG — Primary key — NOT NULL
- email — VARCHAR(50)
- name — VARCHAR(20)
- country_code — VARCHAR(2)
- phone_number — VARCHAR(11)
- image — VARCHAR(200)
- password — VARCHAR(200)
- marketing_email — BOOLEAN
- marketing_push — BOOLEAN
- marketing_sms — BOOLEAN
- job_field — VARCHAR(20)
- job_specialties — VARCHAR(100)
User-Recruitment (지원)
- id — LONG — Primary key — NOT NULL
- recruitment_id — LONG — Foreign key → Recruitment.id — NOT NULL
- user_id — LONG — Foreign key → User.id — NOT NULL
- applied_at — LOCALDATETIME
- updated_at — LOCALDATETIME
- status — VARCHAR(10)
User-Reruitment (좋아요)
- id — LONG — Primary key — NOT NULL
- recruitment_id — LONG — Foreign key → Recruitment.id — NOT NULL
- user_id — LONG — Foreign key → User.id — NOT NULL