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