afasdf

Tables (32)

Admin

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • email — varchar(50) — NOT NULL — unique
  • password — varchar(128) — NOT NULL

Application_Letter

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • application_letter_type — varchar(10) — NOT NULL — original, mz
  • user_id — bigint — NOT NULL — FK
  • post_id — bigint — NOT NULL — index
  • submit_date — timestamp — NOT NULL — java - LocalDateTime
  • application_status — varchar(30) — NOT NULL
  • user_email — varchar(350) — NOT NULL
  • user_name — varchar(30) — NOT NULL
  • user_phone — varchar(350) — NOT NULL
  • user_education — varchar(20)
  • user_birth — date — java - LocalDate
  • user_job — varchar(50)
  • user_git_link — varchar(100)
  • user_career — int
  • user_photo — varchar(50)
  • resume_title — varchar(50)
  • cover_letter_title — varchar(50)

Application_Letter_Answer

  • question — varchar(255) — Primary key — NOT NULL — PK
  • application_letter_id — bigint — Foreign key → Application_Letter.id — NOT NULL — PK, FK
  • answer — text — NOT NULL

Application_Letter_Career_Detail

  • content — varchar(255) — Primary key — NOT NULL — PK
  • apllication_letter_id — bigint — Foreign key → Application_Letter.id — NOT NULL — PK, FK

Application_Letter_Etc

  • content — varchar(255) — Primary key — NOT NULL — PK
  • application_letter_id — bigint — Foreign key → Application_Letter.id — NOT NULL — PK, FK

Application_Letter_Project

  • apllication_letter_id — bigint — Foreign key → Application_Letter.id — NOT NULL — FK
  • content — text — NOT NULL

Application_Letter_Stack

  • stack_id — bigint — Primary key — NOT NULL — PK
  • apllication_letter_id — bigint — Foreign key → Application_Letter.id — NOT NULL — PK, FK

Base

  • created_at — timestamp — java는 LocalDateTime
  • modified_at — timestamp — java는 LocalDateTime

Bno

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • bno — varchar(50) — NOT NULL — unique
  • status — tinyint(1) — NOT NULL — 0 - 만료, 1 - 정상

Company

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • email — varchar(512) — NOT NULL — unique
  • bno — varchar(50) — NOT NULL — unique
  • password — varchar(128) — NOT NULL
  • name — varchar(50) — NOT NULL
  • photo — varchar(50) — NOT NULL
  • ceo_name — varchar(30) — NOT NULL
  • sector — varchar(50) — NOT NULL
  • address — varchar(255) — NOT NULL
  • introduction — text — NOT NULL
  • employee_num — int — NOT NULL
  • approve_status — tinyint(1) — NOT NULL — 0 - 미승인, 1 - 승인

Company_FAQ

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • company_id — bigint — NOT NULL — FK
  • question — varchar(255) — NOT NULL
  • answer — text — NOT NULL

CopyOfBase

  • created_at — timestamp — NOT NULL — java는 LocalDateTime
  • modified_at — timestamp — NOT NULL — java는 LocalDateTime

Cover_Letter

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • user_id — bigint — NOT NULL — FK
  • title — varchar(50) — NOT NULL

Cover_Letter_Qna

  • question — varchar(255) — Primary key — NOT NULL — PK
  • cover_letter_id — bigint — Foreign key → Cover_Letter.id — NOT NULL — PK, FK
  • answer — text

Inquiry

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • inquiry_type — varchar(20) — NOT NULL
  • title — varchar(50) — NOT NULL
  • question_content — text — NOT NULL
  • user_id — bigint — index
  • company_id — bigint — index
  • post_id — bigint
  • answer_date — timestamp — java - LocalDateTime
  • answer_content — text
  • answer_status — tinyint(1) — 0 - 미처리, 1 - 처리 완료

Interview

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • user_id — bigint — NOT NULL — FK
  • application_letter_id — bigint — NOT NULL — FK

Interview_Qna

  • question — varchar(255) — Primary key — NOT NULL — PK
  • id — bigint — Foreign key → Interview.id — NOT NULL — PK, FK
  • answer — text

Job

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • name — varchar(50) — NOT NULL — unique

Post

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • company_id — bigint — NOT NULL
  • post_type — varchar(10) — NOT NULL — original, mz
  • title — varchar(100) — NOT NULL
  • end_date — timestamp — NOT NULL — java - LocalDateTime
  • tool — varchar(100) — NOT NULL
  • work_address — varchar(255) — NOT NULL — index
  • main_task — text — NOT NULL
  • work_condition — text — NOT NULL
  • qualification — text — NOT NULL
  • benefit — text
  • special_skill — text
  • process — text — NOT NULL
  • notice — text
  • career — int — NOT NULL
  • closed — tinyint(1) — NOT NULL — 0 - 마감 전, 1 - 마감
  • deleted — tinyint(1) — NOT NULL — 0 - 삭제 전, 1 - 삭제 후
  • test_start_date — timestamp — java - LocalDateTime
  • test_end_date — timestamp — java - LocalDateTime

Post_Job

  • job_id — bigint — Primary key — NOT NULL — PK
  • post_id — bigint — Foreign key → Post.id — NOT NULL — PK, FK

Post_Stack

  • stack_id — bigint — Primary key — NOT NULL — PK
  • post_id — bigint — Foreign key → Post.id — NOT NULL — PK, FK

Question

  • id — bigint — Primary key — NOT NULL — PK, increment
  • post_id — bigint — NOT NULL — FK, index
  • question — varchar(255) — NOT NULL

Resume

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • user_id — bigint — NOT NULL — FK
  • title — varchar(50) — NOT NULL
  • education — varchar(20)
  • git_link — varchar(100)
  • photo — varchar(50)
  • career — int
  • open_status — tinyint(1) — 0 - 비공개, 1 - 공개

Resume_Career_Detail

  • content — varchar(255) — Primary key — NOT NULL — PK
  • resume_id — bigint — Foreign key → Resume.id — NOT NULL — PK, FK

Resume_Etc

  • content — varchar(255) — Primary key — NOT NULL — PK
  • resume_id — bigint — Foreign key → Resume.id — NOT NULL — PK, FK

Resume_Job

  • job_id — bigint — Primary key — NOT NULL — PK
  • resume_id — bigint — Foreign key → Resume.id — NOT NULL — PK, FK

Resume_Project

  • resume_id — bigint — Foreign key → Resume.id — NOT NULL — FK
  • content — text — NOT NULL

Resume_Stack

  • stack_id — bigint — Primary key — NOT NULL — PK
  • resume_id — bigint — Foreign key → Resume.id — NOT NULL — PK, FK

Scrap

  • post_id — bigint — Primary key — NOT NULL — PK
  • user_id — bigint — Foreign key → Users.id — NOT NULL — PK, FK

Stack

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • name — varchar(30) — NOT NULL — unique

User_Stack

  • stack_id — bigint — Primary key — NOT NULL — PK
  • user_id — bigint — Foreign key → Users.id — NOT NULL — PK, FK

Users

  • id — bigint — Primary key — NOT NULL — PK, auto increment
  • email — varchar(350) — NOT NULL — unique
  • password — varchar(128) — NOT NULL
  • name — varchar(30) — NOT NULL
  • phone — varchar(350) — NOT NULL
  • birth — date — NOT NULL — java는 LocalDate
  • address — varchar(255) — NOT NULL