Wanted

Tables (4)

Copy Of User (recruitments)

  • user_id (recruitments_id) — BIGINT — Primary key — NOT NULL
  • Field2 (company_name) — VARCHAR(50) — NOT NULL
  • Field (company_informaton) — TEXT — NOT NULL
  • Field (company_location) — VARCHAR(100) — NOT NULL
  • Field (position_name) — VARCHAR(50) — NOT NULL
  • Field (job_description) — TEXT — NOT NULL
  • Field (employment_count) — INT — NOT NULL
  • Field (deadline) — DATETIME — NOT NULL
  • Field (qualification_requirements) — VARCHAR(255) — NOT NULL
  • Field (preference_conditions) — VARCHAR(255)
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (additional_information) — TEXT — NOT NULL
  • Field (application_method) — VARCHAR(255) — NOT NULL

Untitled (application)

  • Key (application_id) — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • user_id (employment_id) — BIGINT — Foreign key → Copy Of User.user_id — NOT NULL
  • Field (application_condition) — TINYINT — NOT NULL — 지원 완료(1), 지원 취소(2), 합격(3), 불합격(4)

Untitled (like)

  • Key (like_id) — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → User.user_id — NOT NULL
  • user_id (employment_id) — BIGINT — Foreign key → Copy Of User.user_id — NOT NULL

User (user)

  • user_id — BIGINT — Primary key — NOT NULL
  • Field (user_type) — TINYINT — NOT NULL — 일반회원(1), 기업회원(2)
  • Field2 (name) — VARCHAR(50) — NOT NULL
  • Field (gender) — VARCHAR(10) — NOT NULL
  • Field (email) — VARCHAR(50) — NOT NULL
  • Field (phone_number) — VARCHAR(20) — NOT NULL
  • Field (address) — VARCHAR(100) — NOT NULL
  • Field (user_password) — VARCHAR(255) — NOT NULL
  • Field (birth_date) — TIMESTAMP — NOT NULL
  • Field (skill) — VARCHAR(255)
  • Field (preferred_position) — VARCHAR(255)
  • Field (link) — VARCHAR(255) — 블로그나, github, SNS
  • Field (current_status) — TINYINT — NOT NULL — 포지션 제안 받기 여부 O(1), X(2)
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL