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