Test

Tables (12)

apply_tb

  • apply_id — int — Primary key — NOT NULL
  • apply_result — boolean — 합격 true, 불합격 fasle , 미정 null
  • member_id — varchar(20) — NOT NULL
  • recruit_id — int — NOT NULL
  • apply_created_at — datetime — NOT NULL

bookmark

  • recruit_id — int — Foreign key → recruit_tb.recruit_id — NOT NULL
  • member_id — varchar(20) — Foreign key → member_tb.member_id — NOT NULL
  • bookmark_created_at — datetime — NOT NULL

community_article_tb

  • article_id — int — Primary key — NOT NULL
  • article_title — varchar(50) — NOT NULL
  • article_content — varchar(2048)
  • member_id — varchar(20) — NOT NULL
  • article_created_at — datetime — NOT NULL

community_like_tb

  • article_id — int — Foreign key → community_article_tb.article_id — NOT NULL
  • member_id — varchar(20) — Foreign key → member_tb.member_id — NOT NULL
  • like_created_at — datetime — NOT NULL

community_reply_tb

  • reply_id — int — Primary key — NOT NULL
  • reply_content — varchar(128)
  • article_id — int — NOT NULL
  • member_id — varchar(20) — NOT NULL
  • reply_created_at — datetime — NOT NULL

img_tb

  • member_id — varchar(20) — Foreign key → member_tb.member_id — NOT NULL
  • img_location — varchar(128) — NOT NULL
  • img_filename — varchar(128) — NOT NULL
  • img_filetype — varchar(10) — NOT NULL
  • img_updated_at — datetime — NOT NULL

member_tb

  • member_id — varchar(20) — Primary key — NOT NULL
  • member_pw — varchar(128) — NOT NULL
  • member_name — varchar(20) — NOT NULL
  • member_birth — date — NOT NULL
  • member_gender — char(1) — 기업회원은 NULL
  • member_phone — varchar(12) — NOT NULL
  • member_addr — varchar(256)
  • member_coord_x — float — 위도 (일반회원은 NULL)
  • member_coord_y — float — 경도 (일반회원은 NULL)
  • member_nickname — varchar(20) — NOT NULL
  • member_email — varchar(128) — NOT NULL
  • member_type — char(1) — NOT NULL — 일반회원 N, 기업회원 C, 관리자 A
  • member_reg_num — varchar(32) — 일반회원은 NULL
  • member_info — varchar(512)
  • member_active — boolean — true면 활성 회원. false면 탈퇴
  • member_created_at — datetime
  • work_area_id — int — NOT NULL
  • member_verified — boolean — 일반회원은 NULL가능. 다만 이후 이메일인증 사용시 이 필드 활용 가능

notification_tb

  • notification_id — int — Primary key — NOT NULL
  • member_id — varchar(20) — NOT NULL
  • suggest_id — int — NOT NULL — 둘 중에 NULL이 아닌 것에 대해 처리
  • apply_id — int — NOT NULL
  • notification_created_at — datetime — NOT NULL

recruit_tb

  • recruit_id — int — Primary key — NOT NULL
  • company_id — varchar(20) — NOT NULL
  • recruit_title — varchar(36) — NOT NULL
  • recruit_detail — varchar(1024)
  • work_area_id — int — NOT NULL
  • recruit_start_at — datetime — NOT NULL
  • recruit_end_at — datetime — NOT NULL
  • recruit_expose — boolean

resume_tb

  • member_id — varchar(20) — Foreign key → member_tb.member_id — NOT NULL
  • resume_location — varchar(128) — NOT NULL
  • resume_filename — varchar(128) — NOT NULL
  • resume_filetype — varchar(10) — NOT NULL
  • resume_updated_at — datetime — NOT NULL
  • resume_open — boolean — NOT NULL

suggest_tb

  • suggest_id — int — Primary key — NOT NULL
  • suggest_created_at — datetime — NOT NULL
  • company_id — varchar(20) — NOT NULL
  • member_id — varchar(20) — NOT NULL

work_area_tb

  • work_area_id — int — Primary key — NOT NULL
  • work_area_name — varchar(32) — NOT NULL
  • work_area_comment — varchar(256) — NOT NULL