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