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