미니프로젝트

깃헙 주소

https://github.com/seong9566/miniproject

GitHub - seong9566/miniproject

 

피그마 주소 

https://www.figma.com/file/CuPdydQek80QkEvXudvkG7/Green-7-%EC%A1%B0?node-id=0%3A1 

Figma

---

DB 테이블 설계

https://dbdiagram.io/d/633e714ef0018a1c5fa5f153

Table "users" {
  "users_id" integer [pk]
  "login_id" varchar(20)
  "login_password" varchar(50)
  "personal_id" integer
  "company_id" integer
  "created_at" timestamp
}

Table "company" {
  "company_id" integer [pk]
  "company_name" varchar(20)
  "company_category_id" integer
  "created_at" timestamp
}

Table "personal" {
  "personal_id" integer [pk]
  "personal_name" varchar(20)
  "personal_category_id" integer
  "created_at" timestamp
}

Table "personal_detail" {
  "personal_detail_id" integer [pk]
  "personal_id" integer
  "personal_email" varchar(50)
  "personal_phonenumber" varchar(20)
  "created_at" timestamp
}

Table "company_detail" {
  "company_detail_id" integer [pk]
  "company_id" integer
  "company_email" varchar(50)
  "company_phonenumber" varchar(20)
  "company_address" varchar(50)
  "created_at" timestamp
}

Table "resumes" {
  "resumes_id" integer [pk]
  "personal_id" integer
  "resumes_title" varchar(50)
  "resumes_picture" longtext
  "resumes_introduce" longtext
  "career_id" integer
  "created_at" timestamp
}

Table "job_posting_board" {
  "job_posting_board_id" integer [pk]
  "company_id" integer
  "job_posting_board_title" varchar(50)
  "job_posting_board_content" longtext
  "created_at" timestamp
}

Table "apply" {
  "apply_id" integer [pk]
  "company_job_posting_board_id" integer
  "resumes_id" integer
  "alarm_id" integer
  "created_at" timestamp
}

Table "subscirbe" {
  "subcirbe_id" integer [pk]
  "company_id" integer
  "personal_id" integer
  "alarm_id" integer
  "created_at" timestamp
}

Table "personal_like" {
  "personal_like_id" integer [pk]
  "resumes_id" integer
  "company_id" integer
  "alarm_id" integer
  "created_at" timestamp
}

Table "company_like" {
  "company_like_id" integer [pk]
  "personal_id" integer
  "company_id" integer
  "alarm_id" integer
  "created_at" timestamp
}

Table "category" {
  "category_id" integer [pk]
  "category_frontend" tinyint(1)
  "category_backend" tinyint(1)
  "category_devops" tinyint(1)
  "created_at" timestamp
}

Table "alarm" {
  "alarm_id" integer [pk]
  "users_id" integer
  "alarm_apply_id" integer
  "alarm_incruit_id" integer
  "alarm_subscribe_id" integer
  "alarm_company_like_id" integer
  "alarm_personal_like_id" integer
}

Ref:"personal"."personal_id" < "users"."personal_id"

Ref:"personal"."personal_id" < "personal_detail"."personal_id"

Ref:"company"."company_id" < "users"."company_id"

Ref:"personal"."personal_id" < "resumes"."personal_id"

Ref:"company"."company_id" < "company_detail"."company_id"

Ref:"company"."company_id" < "personal_like"."company_id"

Ref:"company"."company_id" < "job_posting_board"."company_id"

Ref:"company"."company_id" < "subscirbe"."company_id"

Ref:"personal"."personal_id" < "subscirbe"."personal_id"

Ref:"category"."category_id" < "personal"."personal_category_id"

Ref:"category"."category_id" < "company"."company_category_id"

Ref:"resumes"."resumes_id" < "apply"."resumes_id"

Ref:"job_posting_board"."job_posting_board_id" < "apply"."company_job_posting_board_id"

Ref:"personal"."personal_id" < "company_like"."personal_id"

Ref:"resumes"."resumes_id" < "personal_like"."resumes_id"

Ref:"company"."company_id" < "company_like"."company_id"

Ref:"alarm"."alarm_id" < "company_like"."alarm_id"

Ref:"alarm"."alarm_id" < "personal_like"."alarm_id"

Ref:"alarm"."alarm_id" < "subscirbe"."alarm_id"

Ref:"alarm"."alarm_id" < "apply"."alarm_id"

Ref:"company_like"."company_like_id" < "alarm"."alarm_company_like_id"

Ref:"personal_like"."personal_like_id" < "alarm"."alarm_personal_like_id"

Ref:"apply"."apply_id" < "alarm"."alarm_apply_id"

Ref:"subscirbe"."subcirbe_id" < "alarm"."alarm_subscribe_id"

Ref:"users"."users_id" < "alarm"."users_id"