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