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)