nadamCnC

Tables (32)

BOARD_FILE

  • BOARD_NO — int(11) — Foreign key → Board.BOARD_NO — NOT NULL
  • FILE_NO — int(11) — Foreign key → attachment.FILE_NO — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL

BOARD_TYPE

  • BOARD_TYPE_CODE — int(11) — Primary key — NOT NULL
  • BOARD_TYPE_NAME — varchar(45) — NOT NULL

Board

  • BOARD_NO — int(11) — Primary key — NOT NULL
  • BOARD_TITLE — varchar(45) — NOT NULL
  • BOARD_CONTENT — varchar(2000) — NOT NULL
  • BOARD_ENROLL_DATE — datetime — NOT NULL
  • BOARD_MODIFY_DATE — datetime
  • BOARD_STATUS — varchar(45)
  • BOARD_TYPE_CODE — int(11) — Foreign key → BOARD_TYPE.BOARD_TYPE_CODE — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL

CAREER

  • CAREER_NO — int(11) — Primary key — NOT NULL
  • COMPANY_NAME — varchar(45) — NOT NULL
  • POSITION — varchar(45) — NOT NULL
  • HIRE_DATE — varchar(50) — NOT NULL
  • RESIGNATION_DATE — varchar(50)
  • CAREER_STATUS — varchar(45) — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL

CAREER_RANK

  • CAREER_RANK_NO — int(11) — Primary key — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL
  • RANK_VALUE — varchar(45) — NOT NULL

DEGREE

  • DEGREE_CODE — int(11) — Primary key — NOT NULL
  • DEGREE_NAME — varchar(45) — NOT NULL

DEPARTMENT

  • DEPT_CODE — int(11) — Primary key — NOT NULL
  • DEPT_NAME — varchar(45) — NOT NULL

DISCHARGE

  • DISCHARGE_CODE — int(11) — Primary key — NOT NULL
  • DISCHARGE_NAME — varchar(45) — NOT NULL

EDUCATION

  • EDU_NO — int(11) — Primary key — NOT NULL
  • EDU_NAME — varchar(45) — NOT NULL
  • EDU_INSTITUTE_NAME — varchar(50) — NOT NULL
  • EDU_START_DATE — varchar(50) — NOT NULL
  • EDU_END_DATE — varchar(50) — NOT NULL
  • EDU_STATUS — varchar(45)
  • EDU_STATUS_CODE — int(11) — Foreign key → EDUCATION_STATUS.EDU_STATUS_CODE — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL
  • ADMISSION_STATUS_CODE — int(11) — Foreign key → admission_status.admission_status_code — NOT NULL

EDUCATION_STATUS

  • EDU_STATUS_CODE — int(11) — Primary key — NOT NULL
  • EDU_STATUS_NAME — varchar(45) — NOT NULL

EMP_MODIFY

  • EMP_MODIFY_NO — int(11) — Primary key — NOT NULL
  • EMP_MODIFY_DATE — datetime — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL

EMP_SKILL

  • EMP_SKILL_NO — int(11) — Primary key — NOT NULL
  • EMP_SKILL_STATUS — varchar(45)
  • SKILL_CODE — int(11) — Foreign key → SKILL.SKILL_CODE — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL

GRADUATE_STATUS

  • GRADUATE_STATUS_CODE — int(11) — Primary key — NOT NULL
  • GRADUATE_STATUS_NAME — varchar(45) — NOT NULL

LICENSE

  • LICENSE_NO — int(11) — Primary key — NOT NULL
  • ACQUISITION_DATE — varchar(50)
  • LICENSE_STATUS — varchar(45)
  • LICENSE_LIST_CODE — int(11) — Foreign key → LICENSE_LIST.LICENSE_LIST_CODE — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL

LICENSE_LIST

  • LICENSE_LIST_CODE — int(11) — Primary key — NOT NULL
  • LICENSE_LIST_NAME — varchar(45) — NOT NULL

LOGIN_HISTORY

  • LOGIN_HISTORY_NO — int(11) — Primary key — NOT NULL
  • LOGIN_DATE — datetime — NOT NULL
  • LOGIN_IP — varchar(45) — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL

MILITARY

  • MILITARY_NO — int(11) — Primary key — NOT NULL
  • ENROLL_DATE — varchar(50)
  • DISCHARGE_DATE — varchar(50)
  • MILITARY_SERVICE_CODE — int(11) — Foreign key → MILITARY_SERVICE.MILITARY_SERVICE_CODE
  • MILITARY_GROUP_CODE — int(11) — Foreign key → MILITARY_GROUP.MILITARY_GROUP_CODE
  • DISCHARGE_CODE — int(11) — Foreign key → DISCHARGE.DISCHARGE_CODE
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL
  • MILITARY_RANK_CODE — int(11) — Foreign key → MILITARY_RANK.MILITARY_RANK_CODE

MILITARY_GROUP

  • MILITARY_GROUP_CODE — int(11) — Primary key — NOT NULL
  • MILITARY_GROUP_NAME — varchar(45) — NOT NULL

MILITARY_RANK

  • MILITARY_RANK_CODE — int(11) — Primary key — NOT NULL
  • MILITARY_RANK_NAME — varchar(45) — NOT NULL

MILITARY_SERVICE

  • MILITARY_SERVICE_CODE — int(11) — Primary key — NOT NULL
  • MILITARY_SERVICE_NAME — varchar(45) — NOT NULL

PROJECT

  • PROJECT_NO — int(11) — Primary key — NOT NULL
  • PROJECT_NAME — varchar(45) — NOT NULL
  • START_DATE — varchar(45) — NOT NULL
  • END_DATE — varchar(45) — NOT NULL
  • CLIENT — varchar(45) — NOT NULL
  • WORKPLACE — varchar(45) — NOT NULL
  • PART — varchar(45) — NOT NULL
  • PROJECT_STATUS — varchar(45)
  • CAREER_NO — int(11) — Foreign key → CAREER.CAREER_NO — NOT NULL
  • OS — varchar(100)
  • LANGUAGE — varchar(100)
  • TOOL — varchar(100)
  • DB — varchar(100)
  • WAS — varchar(100)
  • ETC — varchar(100)

PROJECT_FILE

  • FILE_NO — int(11) — Foreign key → attachment.FILE_NO — NOT NULL
  • PROJECT_NO — int(11) — Foreign key → PROJECT.PROJECT_NO — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL

SCHOOL

  • SCHOOL_NO — int(11) — Primary key — NOT NULL
  • SCHOOL_NAME — varchar(45) — NOT NULL
  • MAJOR — varchar(45) — NOT NULL
  • ADMISSION_DATE — varchar(50) — NOT NULL
  • GRADUATE_DATE — varchar(50) — NOT NULL
  • SCHOOL_STATUS — varchar(45)
  • GRADUATE_STATUS_CODE — int(11) — Foreign key → GRADUATE_STATUS.GRADUATE_STATUS_CODE — NOT NULL
  • EMP_NO — int(11) — Foreign key → employee.EMP_NO — NOT NULL
  • ADMISSION_STATUS_CODE — int(11) — Foreign key → admission_status.admission_status_code — NOT NULL
  • DEGREE_CODE — int(11) — Foreign key → DEGREE.DEGREE_CODE — NOT NULL

SKILL

  • SKILL_CODE — int(11) — Primary key — NOT NULL
  • SKILL_NAME — varchar(45) — NOT NULL
  • SKILL_TYPE_CODE — int(11) — Foreign key → SKILL_TYPE.SKILL_TYPE_CODE — NOT NULL

SKILL_TYPE

  • SKILL_TYPE_CODE — int(11) — Primary key — NOT NULL
  • SKILL_TYPE_NAME — varchar(45) — NOT NULL

USER_CONTENT_BOARD

  • BOARD_ID — int(11) — Primary key — NOT NULL
  • BOARD_WRITER — varchar(45) — NOT NULL
  • BOARD_DETAIL_CONTENT — varchar(2000)
  • BOARD_REMARK — varchar(2000)
  • BOARD_REGISTERED_DATE — datetime — NOT NULL

USER_ROLE

  • ID — varchar(100) — Primary key — NOT NULL — 회원가입시 입력받는 유저 아이디
  • ROLE_NAME — varchar(100) — NOT NULL — 유저 권한을 설정한다.

Untitled

    admission_status

    • admission_status_code — int(11) — Primary key — NOT NULL
    • admission_status_name — varchar(45) — NOT NULL

    attachment

    • FILE_NO — int(11) — Primary key — NOT NULL
    • ORIGIN_NAME — varchar(2000) — NOT NULL
    • CHANGE_NAME — varchar(2000)
    • FILE_PATH — varchar(100) — NOT NULL
    • FILE_STATUS — varchar(45)
    • UPLOAD_DATE — datetime — NOT NULL

    employee

    • EMP_NO — int(11) — Primary key — NOT NULL
    • EMP_ID — varchar(100) — Foreign key → USER_ROLE.ID — NOT NULL — 회원가입시 입력받는 유저 아이디
    • EMP_PWD — varchar(100) — NOT NULL
    • EMP_NAME — varchar(45) — NOT NULL
    • BIRTH — date — NOT NULL
    • GENDER — varchar(45) — NOT NULL
    • PHONE — varchar(45) — NOT NULL
    • EMAIL — varchar(45) — NOT NULL
    • ADDRESS — varchar(45)
    • JOIN_DATE — datetime — NOT NULL
    • WITHDRAW_DATE — datetime
    • EMP_STATUS — varchar(45)
    • DEPT_CODE — int(11) — Foreign key → DEPARTMENT.DEPT_CODE — NOT NULL
    • isEnabled — int(11)

    profile_img

    • file_no — int(11) — Foreign key → attachment.FILE_NO — NOT NULL
    • emp_no — int(11) — Foreign key → employee.EMP_NO — NOT NULL
    • emp_id — varchar(50) — NOT NULL