사내그룹웨어
테이블 (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_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