CareerMate

Tables (9)

Notice_Template_Fields (채용_템플릿_필드)

  • notice_template_field_id (채용_템플릿_필드_id) — Primary key — NOT NULL
  • field_name (필드 이름)
  • data_type (필드의 데이터 유형)

Carrers (커리어)

  • template_data_id (템플릿_데이터_id) — Primary key — NOT NULL
  • career_id (커리어_id) — Foreign key → Profiles.career_id — NOT NULL
  • template_field_id (템플릿_필드_id) — Foreign key → Template_Fields.template_field_id — NOT NULL
  • template_id (템플릿_ id) — Foreign key → Templates.template_id — NOT NULL
  • value (데이터 값)

Contents (컨텐츠)

  • content_id (컨텐츠_id) — Primary key — NOT NULL
  • title (제목)
  • content_url (컨텐츠 외부 URL)

Profiles (프로필)

  • career_id (커리어_id) — Primary key — NOT NULL
  • user_id (회원_id) — Foreign key → User.user_id — NOT NULL
  • interest_job (Field)
  • interest_company (Field2)
  • university (학교)
  • department (학과)
  • grade (학년)

Template_Fields (템플릿_필드)

  • template_field_id (템플릿_필드_id) — Primary key — NOT NULL
  • template_id (템플릿_ id) — Foreign key → Templates.template_id — NOT NULL
  • field_name (필드 이름)
  • data_type (필드의 데이터 유형)
  • is_required (필수 여부)

Templates (템플릿)

  • template_id (템플릿_ id) — Primary key — NOT NULL
  • job_role (직업)
  • category (종류)

User (회원)

  • user_id (회원_id) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3

User_Contents (회원_컨텐츠)

  • user_content_id (Key) — Primary key — NOT NULL
  • user_id (회원_id) — Foreign key → User.user_id — NOT NULL
  • content_id (컨텐츠_id) — Foreign key → Contents.content_id — NOT NULL

User_Notices (저장한 채용공고)

  • notice_id (채용공고_id) — Primary key — NOT NULL
  • user_id (회원_id) — Foreign key → User.user_id — NOT NULL