design

Tables (19)

ALARM

  • ALARM_ID — BIGINT
  • TARGET_TYPE — ENUM('COMPANY','APPLICANT') — NOT NULL
  • TARGET_ID — BIGINT — NOT NULL
  • CHANNEL — ENUM('EMAIL','KAKAO','SMS','PUSH') — NOT NULL
  • TITLE — VARCHAR(200) — NOT NULL
  • MESSAGE — VARCHAR(1000) — NOT NULL
  • SENT_YN — TINYINT(1) — NOT NULL
  • SENT_AT — DATETIME
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL
  • INDEX — IX_ALARM_TARGET

APPLICANT_INFO

  • APPLICANT_ID — BIGINT
  • EMAIL — VARCHAR(255) — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • BIRTHDATE — DATE
  • PHONE — VARCHAR(50)
  • GENDER — ENUM('M','F','N')
  • JOB_CATEGORY — VARCHAR(100)
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

APPLICANT_TRACKING

  • APPTRACK_ID — BIGINT
  • APPLICANT_ID — BIGINT — NOT NULL
  • JOBPOSTING_ID — BIGINT — NOT NULL
  • RESUME_ID — BIGINT
  • STATUS — ENUM('APPLIED','SCREENING','INTERVIEW','OFFER','REJECTED','WITHDRAWN')
  • NOTE — VARCHAR(1000)
  • APPLIED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

APPLIED_COMPANIES

  • APPLIED_ID — BIGINT
  • APPLICANT_ID — BIGINT — NOT NULL
  • COMPANY_NAME — VARCHAR(200) — NOT NULL
  • APPLY_TYPE — ENUM('BOOKMARK','APPLIED','PASSED','FAILED')
  • MEMO — VARCHAR(500)
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

APP_CAREER

  • CAREER_ID — BIGINT
  • APPLICANT_ID — BIGINT — NOT NULL
  • COMPANY_NAME — VARCHAR(200) — NOT NULL
  • POSITION_TITLE — VARCHAR(200) — NOT NULL
  • START_DATE — DATE — NOT NULL
  • END_DATE — DATE
  • EMPLOY_TYPE — ENUM('FULL','PART','CONTRACT','INTERN','FREELANCE')
  • DESCRIPTION — TEXT
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

APP_EDUCATION

  • EDUCATION_ID — BIGINT
  • APPLICANT_ID — BIGINT — NOT NULL
  • SCHOOL_NAME — VARCHAR(200) — NOT NULL
  • MAJOR — VARCHAR(200)
  • DEGREE — ENUM('HS','BA','MA','PHD','OTHER')
  • ENROLL_DATE — DATE
  • GRADUATE_DATE — DATE
  • GPA — DECIMAL(3,2)
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

CAREER_SKILL

  • CAREER_SKILL_ID — BIGINT
  • CAREER_ID — BIGINT — NOT NULL
  • SKILL_NAME — VARCHAR(100) — NOT NULL
  • SKILL_LEVEL — ENUM('BEGINNER','JUNIOR','MID','SENIOR','EXPERT')
  • YEARS — DECIMAL(4,1)
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

COMP_JOB_POSTING

  • JOBPOSTING_ID — BIGINT
  • COMPANY_ID — BIGINT — NOT NULL
  • TITLE — VARCHAR(200) — NOT NULL
  • CONTENTS — TEXT — NOT NULL
  • EDUCATION_LEVEL — ENUM('ANY','HS','BA','MA','PHD')
  • CAREER_YEARS_REQ — DECIMAL(4,1)
  • LOCATION — VARCHAR(200)
  • STATUS — ENUM('OPEN','CLOSED','HIDDEN')
  • DEADLINE_DATE — DATE
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL
  • INDEX — IX_JOB_COMPANY_STATUS

COM_INFO

  • COMPANY_ID — BIGINT
  • BIZ_NO — VARCHAR(20) — NOT NULL
  • COMPANY_NAME — VARCHAR(200) — NOT NULL
  • EMAIL — VARCHAR(255)
  • PHONE — VARCHAR(50)
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

COM_PROF

  • PROF_ID — BIGINT
  • COMPANY_ID — BIGINT — NOT NULL
  • LOGO_URL — VARCHAR(500)
  • SITE_URL — VARCHAR(500)
  • BIZ_SUMMARY — VARCHAR(500)
  • ADDRESS — VARCHAR(300)
  • CEO_NAME — VARCHAR(100)
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

COM_USER_AUTHORITY

  • AUTH_ID — BIGINT
  • COMPANY_ID — BIGINT — NOT NULL
  • HRM_ID — BIGINT — NOT NULL
  • ROLE — ENUM('OWNER','ADMIN','RECRUITER','VIEWER') — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

HR_MANAGERS

  • HRM_ID — BIGINT
  • COMPANY_ID — BIGINT — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • EMAIL — VARCHAR(255) — NOT NULL
  • PHONE — VARCHAR(50)
  • POSITION_TITLE — VARCHAR(100)
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

JOB_POSTING_SKILL

  • JPS_ID — BIGINT
  • JOBPOSTING_ID — BIGINT — NOT NULL
  • SKILL_NAME — VARCHAR(100) — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

MANAGE_USERS

  • ADMIN_ID — BIGINT
  • EMAIL — VARCHAR(255) — NOT NULL
  • NAME — VARCHAR(100) — NOT NULL
  • ROLE — ENUM('SUPER','OPERATOR','ANALYST') — NOT NULL
  • STATUS — ENUM('ACTIVE','INACTIVE') — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL

MENU

  • MENU_ID — BIGINT
  • PARENT_ID — BIGINT
  • NAME — VARCHAR(100) — NOT NULL
  • PATH — VARCHAR(200) — NOT NULL
  • SORT_ORDER — INT — NOT NULL
  • ENABLED_YN — TINYINT(1) — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL
  • INDEX — IX_MENU_PARENT

MESSAGE

  • MESSAGE_ID — BIGINT
  • THREAD_ID — BIGINT
  • COMPANY_ID — BIGINT
  • APPLICANT_ID — BIGINT
  • SENDER_TYPE — ENUM('COMPANY','APPLICANT','ADMIN') — NOT NULL
  • BODY — TEXT — NOT NULL
  • READ_YN — TINYINT(1) — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL
  • INDEX — IX_MSG_THREAD

PAYMENT

  • PAYMENT_ID — BIGINT
  • COMPANY_ID — BIGINT — NOT NULL
  • ORDER_NO — VARCHAR(100) — NOT NULL
  • AMOUNT — DECIMAL(12,2) — NOT NULL
  • METHOD — ENUM('CARD','BANK','CASH','ETC') — NOT NULL
  • STATUS — ENUM('PENDING','PAID','CANCEL','REFUND') — NOT NULL
  • PAID_AT — DATETIME
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL
  • INDEX — IX_PAY_COMPANY_STATUS

PAYMENT_SALES

  • SALES_ID — BIGINT
  • PAYMENT_ID — BIGINT — NOT NULL
  • COMPANY_ID — BIGINT — NOT NULL
  • AMOUNT — DECIMAL(12,2) — NOT NULL
  • STATUS_SNAPSHOT — ENUM('PENDING','PAID','CANCEL','REFUND') — NOT NULL
  • SALES_DATE — DATE — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL
  • INDEX — IX_SALES_DATE

RESUME_TRACKING

  • RESUME_ID — BIGINT
  • APPLICANT_ID — BIGINT — NOT NULL
  • TITLE — VARCHAR(200) — NOT NULL
  • VERSION_NO — INT — NOT NULL
  • FILE_PATH — VARCHAR(500)
  • IS_DEFAULT — TINYINT(1) — NOT NULL
  • CREATED_AT — DATETIME — NOT NULL
  • UPDATED_AT — DATETIME — NOT NULL
  • DELETED_YN — CHAR(1) — NOT NULL