2차
테이블 (34)
TBL_ACCOUNT
- AC_NO — NUMBER
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- AC_BANK — VARCHAR2(30)
- AC_NAME — VARCHAR2(30)
- USE_YN — CHAR(1)
TBL_BOARD
- BOARD_NO — NUMBER — 기본 키 — NOT NULL — SEQ_SQUENSE로
- BOARD_TYPE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- BOARD_CONTENT — VARCHR2(3000) — NOT NULL
- BOARD_TITLE — VARCHAR2(300) — NOT NULL
- CREARTER — NUMBER
- MODIFIER — NUMBER
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
- USE_YN — CHAR(1)
TBL_CALENDAR
- CAL_NO — NUMBER — 기본 키 — NOT NULL
- CAL_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- CAL_START_DATE — DATE
- CAL_END_DATE — DATE
- CAL_SUBJECT — VARCHAR2(100)
- CAL_CONTENT — VARCHAR2(600)
- CAL_COLOR — VARCHAR2(30)
- CAL_IMPORT_YN — CHAR(1)
- REMINDER_YN — CHAR(1)
- CAL_ALLDAY_YN — CHAR(1)
- CAL_STATUS — VARCHAR2(30)
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
- CREARTER — NUMBER
- MODIFIER — NUMBER
- USE_YN — CHAR(1)
TBL_CAL_CHECKLIST
- CAL_CHECKLIST_NO — NUMBER — 기본 키 — NOT NULL
- CAL_NO — NUMBER — 외래 키 → TBL_CALENDAR.CAL_NO — NOT NULL
- CAL_CHECKLIST_CONTENT — VARCHAR2(200)
- CREARTER — NUMBER
- MODIFIER — NUMBER
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
- END_YN — CHAR(1)
- USE_YN — CHAR(1)
TBL_CAL_COMMENT
- CAL_COMMENT_NO — NUMBER — 기본 키 — NOT NULL
- CAL_NO — NUMBER — 외래 키 → TBL_CALENDAR.CAL_NO — NOT NULL
- CAL_COMMENT_CONTENT — VARCHAR2(1000)
- CAL_COMMENT_LEVEL — NUMBER
- CAL_COMMENT_REF — NUMBER
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
- CREARTER — NUMBER
- MODIFIER — NUMBER
- USE_YN — CHAR(1)
TBL_CAL_INVITATION
- CAL_NO — NUMBER — 외래 키 → TBL_CALENDAR.CAL_NO — NOT NULL
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- USE_YN — CHAR(1)
TBL_CODE
- CODE_NO — VARCHAR2(30)
- CODE_NAME — VARCHAR2(100)
- USE_YN — CHAR(1)
TBL_DEDUTION
- DEDU_NO — NUMBER — 기본 키 — NOT NULL
- DEDU_EMP_INSUR — NUMBER
- DEDU_HEALTH_INSUR — NUMBER
- DEDU_LONGTERM_CARE_INSUR — NUMBER
- DEDU_INDUSTRY_INSUR — NUMBER
- DEDU_NATIONAL_PENSION — NUMBER
- DEDU_INCOME_TAX — NUMBER
- DEDU_LOCAL_INCOME_TAX — NUMBER
- USE_YN — CHAR(1)
TBL_DEPARTMENT
- DEPT_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- DEPT_UPSTAIR — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- DEPT_NAME — VARCHAR2(300)
- DEPT_LEVEL — NUMBER
TBL_EDOC
- EDOC_NO — VARCHAR2(100) — 기본 키 — NOT NULL
- EDOC_DOT_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- EDOC_TITLE — VARCHAR2(300)
- EDOC_PRESERVE_PERIOD — DATE
- EDOC_DSG_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- EDOC_CONTENT — CLOB
- EDOC_STARTDATE — DATE
- EDOC_ENDDATE — DATE
- EDOC_STATUS — VARCHAR2(30)
- CREATER — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- CREATE_DATE — DATE
- MODIFIER — NUMBER
- MODIFY_DATE — DATE
- USE_YN — CHAR(1)
- FINALIZED_DATE — DATE
TBL_EDOC_ACCESS_GRANT
- DSG_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- POS_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
TBL_EDOC_APPROVAL
- APRVL_NO — NUMBER — 기본 키 — NOT NULL
- APRVL_EDOC_NO — VARCHAR2(100) — 외래 키 → TBL_EDOC.EDOC_NO — NOT NULL
- APRVL_APV_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- APRVL_EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- APRVL_RANK — NUMBER
- APRVL_STATUS — CHAR(1)
- APRVL_COMMENT — VARCHAR2(4000)
- APRVL_DATE — DATE
TBL_EDOC_ATTACHFILE
- ATTACH_NO — NUMBER — 기본 키 — NOT NULL
- ATTACH_EDOC_REF — VARCHAR2(100) — 외래 키 → TBL_EDOC.EDOC_NO — NOT NULL
- ATTACH_ORIGINAL_FILENAME — VARCHAR2(4000)
- ATTACH_RENAMED_FILENAME — VARCHAR2(4000)
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- CREATE_DATE — DATE
- EMP_NO2 — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- MODIFY_DATE — DATE
- USE_YN — CHAR(1)
TBL_EDOC_REFERENCE_PERSON
- REFPER_NO — NUMBER — 기본 키 — NOT NULL
- REFPER_EDOC_NO — VARCHAR2 — 외래 키 → TBL_EDOC.EDOC_NO — NOT NULL
- REFPER_EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- REFPER_STATUS — CHAR(1)
TBL_EDOC_SAMPLE
- SAMPLE_NO — NUMBER — 기본 키 — NOT NULL
- SAMPLE_DOT_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- SAMPLE_DESC — VARCHAR2
- SAMPLE_CONTENT — CLOB
- CREATER — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- CREATE_DATE — DATE
- MODIFIER — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- MODIFY_DATE — DATE
- USE_YN — CHAR(1)
- SAMPLE_FORMAT — CLOB
TBL_EMPLOYEE
- EMP_NO — NUMBER — 기본 키 — NOT NULL
- DEPT_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- POSITION_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- JOB_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- WORK_TYPE_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- WORK_STATUS — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- WORK_PATTERN — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- AUT_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- EMP_ID — VARCHAR2(30) — 아이디
- EMP_PW — VARCHAR2(500) — 비밀번호
- EMP_NAME — VARCHAR2(30)
- EMP_PHONE — VARCHAR2(40)
- EMP_CELLPHONE — VARCHAR2(40)
- EMP_EMAIL — VARCHAR2(100)
- EMP_POSTCODE — VARCHAR2(300)
- EMP_ADDRESS — VARCHAR2(300)
- EMP_ADDRESS_DETAIL — VARCHAR2(300)
- EMP_RESIDENT_NO — VARCHAR2(60)
- EMP_MEMO — VARCHAR2(600)
- EMP_HIRED_DATE — DATE
- EMP_RETIRED_DATE — DATE
- USE_YN — CHAR(1)
- EMP_AUTO_FILENAME — VARCHAR2(1000)
- EMP_PROFILE_ORI_NAME — VARCHAR2(3000)
- EMP_PROFILE_RE_NAME — VARCHAR2(3000)
- CREATER — NUMBER
- CREATE_DATE — DATE
- MODIFIER — NUMBER
- MODIFY_DATE — DATE
TBL_MESSAGE
- MSG_NO — NUMBER — 기본 키 — NOT NULL
- MSG_SENDER — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- MSG_RECEIVER — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- MSG_CATEGORY — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- MSG_CONTENT — VARCHAR2(2000)
- MSG_DATE — TIMESTAMP
- MSG_READ_STATUS — VARCHAR2(10)
- MSG_DELETE — VARCHAR2(10)
- MSG_FILE_ORINAME — VARCHAR2(3000)
- MSG_FILE_RENAME — VARCHAR2(3000)
- MSG_MARKED_YN — VARCHAR2(10)
TBL_OVERTIME_PAY
- OT_PAY_NO — NUMBER — 기본 키 — NOT NULL
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- SAL_NO — NUMBER — 외래 키 → TBL_SALARY.SAL_NO — NOT NULL
- OT_PAY_PER_TIME — NUMBER
- USE_YN — CHAR(1)
TBL_OVERTIME_TOTAL
- OT_PAY_NO — NUMBER — 외래 키 → TBL_OVERTIME_PAY.OT_PAY_NO — NOT NULL
- WORK_NO — NUMBER — 외래 키 → TBL_WORK.WORK_NO — NOT NULL
- USE_YN — CHAR(1)
TBL_POSITION_PAY
- PP_NO — NUMBER — 기본 키 — NOT NULL
- SAL_NO — NUMBER — 외래 키 → TBL_SALARY.SAL_NO — NOT NULL
- POS_CODE — VARCHAR2(30) — 외래 키 → TBL_CODE.CODE_NO
- PP_ADD_PAY — NUMBER
- USE_YN — CHAR(1)
TBL_REMINDER
- REMINDER_NO — NUMBER — 기본 키 — NOT NULL
- CAL_NO — NUMBER — 외래 키 → TBL_CALENDAR.CAL_NO — NOT NULL
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- RECIPIENT_PHONE — VARCHAR2(50)
- REMINDER_CONTENT — VARCHAR2(300)
- REMINDER_DATE — DATE
- USE_YN — CHAR(1)
TBL_RESOUCE
- RESOURCE_NO — NUMBER — 기본 키 — NOT NULL
- RESOUCE_TYPE — VARCHAR2(30)
- RESOURCE_NAME — VARCHAR2(50)
- RESOURCE_MAX — NUMBER
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
- CREARTER — NUMBER
- MODIFIER — NUMBER
- RESOURCE_USE_YN — CHAR(1)
- USE_START_TIME — DATE
- USE_END_TIME — DATE
- USE_YN — CHAR(1)
TBL_RESOURCE_RESERVATION
- RESOURCE_NO — NUMBER — 외래 키 → TBL_RESOUCE.RESOURCE_NO — NOT NULL
- CAL_NO — NUMBER — 외래 키 → TBL_CALENDAR.CAL_NO — NOT NULL
TBL_SALARY
- SAL_NO — NUMBER — 기본 키 — NOT NULL
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- DEDU_NO — NUMBER — 외래 키 → TBL_DEDUTION.DEDU_NO — NOT NULL
- SAL_BASE — NUMBER
- SAL_MEAL — NUMBER
- SAL_BONUS — NUMBER
- SAL_ACTUAL — NUMBER
- SAL_DATE — DATE
- USE_YN — CHAR(1)
- CREATER — NUMBER
- CREATE_DATE — DATE
- MODIFIER — NUMBER
- MODIFY_DATE — DATE
TBL_SEARCH
- SEARCH_NO — NUMBER — 기본 키 — NOT NULL
- SEARCH_KEYWORD — VARCHAR2(50)
- SEARCH_ADDRESS — VARCHAR2(1000)
- SEARCH_CODE — VARCHAR2(20)
TBL_SETTING
- SETTING_NO — NUMBER — 기본 키 — NOT NULL
- COMPANY_NAME — VARCHAR2(50)
- COMPANY_LOGO — VARCHAR2(300)
- COMPANY_ADDRESS — VARCHAR2(3000)
- COMPANY_PHONE — VARCHAR2(1000)
- COMPANY_EMAIL — VARCHAR2(1000)
- COMPANY_CEO_STAMP — VARCHAR2(1000)
TBL_SURVEY
- SURVEY_NO — NUMBER — 기본 키 — NOT NULL
- SURVEY_TITLE — VARCHAR2(200)
- SURVEY_START — DATE
- SURVEY_END — DATE
- SURVEY_TYPE — VARCHAR2(50)
- SURVEEY_QUESTION — VARCHAR2(2000)
- CREARTER — NUMBER
- MODIFIER — NUMBER
- CREATE_DATE — DATE
- MODIFY_DATE — DATE
- USE_YN — CHAR(1)
TBL_SURVEY_ANSWER
- SURVEY_NO — NUMBER — 외래 키 → TBL_SURVEY_QUESTION.SURVEY_NO — NOT NULL
- QUESTION_NO — NUMBER — 외래 키 → TBL_SURVEY_QUESTION.QUESTION_NO — NOT NULL — SEQ_SQUENSE로
- USER_INFOR — VARCHAR2(100)
- ANSWER_COMENT — VARCHAR2(2000)
TBL_SURVEY_QUESTION
- QUESTION_NO — NUMBER — 기본 키 — NOT NULL — SEQ_SQUENSE로
- SURVEY_NO — NUMBER — 외래 키 → TBL_SURVEY.SURVEY_NO — NOT NULL
- QUESTION_TITLE — VARCHAR2(3000)
TBL_UPLOADFILE
- FUPLOADFILE_NO — NUMBER — 기본 키 — NOT NULL — SEQ_SQUENSE로
- BOARD_NO — NUMBER — 외래 키 → TBL_BOARD.BOARD_NO — NOT NULL — SEQ_SQUENSE로
- ORI_FILENAME — VARCHAR2(3000)
- RE_FILENAME — VARCHAR2
TBL_VACATION
- VAC_NO — NUMBER — 기본 키 — NOT NULL
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- VAC_COUNT — NUMBER
- VAC_USED — NUMBER
- VAC_OPTION — VARCHAR2(100)
- CREATER — NUMBER
- CREATE_DATE — DATE
- MODIFIER — NUMBER
- MODIFY_DATE — DATE
- USE_YN — CHAR(1)
- EDOC_NO — VARCHAR2(100) — 외래 키 → TBL_EDOC.EDOC_NO — NOT NULL
- VAC_PERMIT — VARCHAR2(10)
TBL_VACATION_BYYEAR
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- VAC_YEAR — VARCHAR(20)
- VAC_LEFT — NUMBER
- CREATER — NUMBER
- CREATE_DATE — DATE
- MODIFIER — NUMBER
- MODIFY_DATE — DATE
TBL_WORK
- WORK_NO — NUMBER — 기본 키 — NOT NULL
- EMP_NO — NUMBER — 외래 키 → TBL_EMPLOYEE.EMP_NO — NOT NULL
- WORK_TYPE_CODE — VARCHAR2(30)
- WORK_DAY — DATE
- WORK_START_TIME — DATE
- WORK_END_TIME — DATE
- WORK_PERMIT — VARCHAR2(10)
- CREATER — NUMBER
- CREATE_DATE — DATE
- MODIFIER — NUMBER
- MODIFY_DATE — DATE
- USE_YN — CHAR(1)
TBL_WORK_REALTIME
- WORK_NO — NUMBER — 외래 키 → TBL_WORK.WORK_NO — NOT NULL
- WORK_LATE — VARCHAR2(10)
- WORK_FAST_END — VARCHAR2(10)
- WORK_ABSENCE — VARCHAR2(10)