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