사내그룹웨어

테이블 (18)

approval

  • approval_id — NUMBER — 기본 키 — NOT NULL
  • write_date — DATE — NOT NULL
  • content — CLOB — NOT NULL
  • employees_emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • approval_category_id — NUMBER — 외래 키 → approval_category.approval_category_id — NOT NULL

approval_category

  • approval_category_id — NUMBER — 기본 키 — NOT NULL
  • approval_name — VARCHAR2(100) — NOT NULL
  • approval_form — CLOB — NOT NULL

approval_file

  • approval_file_id — NUMBER — 기본 키 — NOT NULL
  • approval_id — NUMBER — 외래 키 → approval.approval_id — NOT NULL
  • approval_file_name — VARCHAR2(100)
  • approval_file_size — VARCHAR2(50)
  • approval_file_content_type — VARCHAR2(50)
  • approval_file_data — BLOB

approval_line

  • approval_approval_id — NUMBER — 외래 키 → approval.approval_id — NOT NULL
  • emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • seq — NUMBER — NOT NULL

attendance

  • attendance_id — NUMBER — 기본 키 — NOT NULL
  • emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • clock_in — TIMESTAMP
  • clock_out — TIMESTAMP
  • attendance_date — DATE
  • status — VARCHAR2(30)

departments

  • dept_id — NUMBER — 기본 키 — NOT NULL
  • dept_name — VARCHAR2(40) — NOT NULL
  • employees_emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id

email

  • email_id — NUMBER — 기본 키 — NOT NULL
  • received_emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • sent_emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • email_date — DATE — NOT NULL
  • read_date — DATE
  • email_content_id — NUMBER — 외래 키 → email_content.email_content_id — NOT NULL
  • trash_id — VARCHAR2(100) — 외래 키 → trash.emp_id
  • email_type — CHAR(1) — NOT NULL — 송/수신
  • origin_email_id — NUMBER — 외래 키 → email.email_id
  • is_deleted — CHAR(1) — NOT NULL

email_content

  • email_content_id — NUMBER — 기본 키 — NOT NULL
  • title — VARCHAR2(300) — NOT NULL
  • content — CLOB

email_file

  • email_file_id — NUMBER — 기본 키 — NOT NULL
  • email_content_id — NUMBER — 외래 키 → email_content.email_content_id — NOT NULL
  • email_file_name — VARCHAR2(200) — NOT NULL
  • email_file_size — VARCHAR2(50)
  • email_file_data — BLOB
  • email_file_content_type — VARCHAR2(100)

employees

  • emp_id — VARCHAR2(100) — 기본 키 — NOT NULL
  • manager_id — VARCHAR2(100) — 외래 키 → employees.emp_id
  • dept_id — NUMBER — 외래 키 → departments.dept_id — NOT NULL
  • team_id — NUMBER — 외래 키 → teams.team_id — NOT NULL
  • grade_id — NUMBER — 외래 키 → grade.grade_id — NOT NULL
  • emp_no — NUMBER — NOT NULL
  • password — VARCHAR2(40) — NOT NULL
  • name — VARCHAR2(16) — NOT NULL
  • phone — VARCHAR2(20) — NOT NULL
  • birth — DATE — NOT NULL
  • hire_date — DATE — NOT NULL
  • resign_date — DATE
  • profile_name — VARCHAR2(100)
  • profile_size — NUMBER
  • profile_content_type — VARCHAR2(50)
  • profile_data — BLOB
  • dayoff_remain — NUMBER — NOT NULL
  • add_dayoff_remain — NUMBER

grade

  • grade_id — NUMBER — 기본 키 — NOT NULL
  • grade_name — VARCHAR2(20) — NOT NULL
  • dayoff_count — NUMBER — NOT NULL

notice_board

  • notice_id — NUMBER — 기본 키 — NOT NULL
  • notice_title — VARCHAR2(300) — NOT NULL
  • notice_content — VARCHAR2(500) — NOT NULL
  • write_date — DATE — NOT NULL
  • writer — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • category — VARCHAR2(50) — NOT NULL

notice_file

  • notice_file_id — NUMBER — 기본 키 — NOT NULL
  • notice_id — NUMBER — 외래 키 → notice_board.notice_id — NOT NULL
  • notice_file_name — VARCHAR2(200)
  • notice_file_size — VARCHAR2(50)
  • notice_file_content_type — VARCHAR2(50)
  • notice_file_data — BLOB

teams

  • team_id — NUMBER — 기본 키 — NOT NULL
  • team_name — VARCHAR2(40) — NOT NULL
  • dept_id — NUMBER — 외래 키 → departments.dept_id — NOT NULL
  • emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id

temp_email

  • temp_email_id — NUMBER — 기본 키 — NOT NULL
  • sent_emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • received_emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id
  • temp_date — DATE — NOT NULL
  • email_content_id — NUMBER — 외래 키 → email_content.email_content_id — NOT NULL

trash

  • emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • trash_date — DATE — NOT NULL

vacation

  • vacation_id — NUMBER — 기본 키 — NOT NULL
  • content — VARCHAR2(500)
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • type — VARCHAR2(30) — NOT NULL
  • emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL
  • vacation_file_name — VARCHAR2(100)
  • vacation_file_content_type — VARCHAR2(50)
  • vacation_file_data — BLOB
  • vacation_file_size — VARCHAR2(50)

vacation_line

  • vacation_line_id — NUMBER — 기본 키 — NOT NULL
  • vacation_id — NUMBER — 외래 키 → vacation.vacation_id — NOT NULL
  • emp_id — VARCHAR2(100) — 외래 키 → employees.emp_id — NOT NULL