test
Tables (10)
absence
- absence_date_no — number — Primary key — NOT NULL
- absentee_id — varchar2(20) — Foreign key → employee.employee_id — NOT NULL
- proxy_id — varchar2(20) — Foreign key → employee.employee_id — NOT NULL
- absence_start_date — date — NOT NULL
- absence_end_date — date — NOT NULL
- absence_reason — varchar2(60) — NOT NULL
- absence_usage — varchar2(10) — NOT NULL
- noti_in_date — date — NOT NULL
- absence_read_status — date
approval_line
- approval_line_no — number — Primary key — NOT NULL
- document_no — number — Foreign key → document.document_no — NOT NULL
- approver_id — varchar2(20) — Foreign key → employee.employee_id — NOT NULL
- orders — number — NOT NULL
- opinion — varchar2(100)
- approval_date — date
- approval_status — varchar2(10) — NOT NULL
approval_process_noti
- process_noti_no — number — Primary key — NOT NULL
- document_no — number — Foreign key → document.document_no — NOT NULL
- process_read_status — date
approval_request_noti
- request_noti_no — number — Primary key — NOT NULL
- approval_line_no — number — Foreign key → approval_line.approval_line_no — NOT NULL
- noti_in_date — date — NOT NULL
- request_read_status — date
comment_noti
- comment_noti_no — number — Primary key — NOT NULL
- comment_no — number — Foreign key → comments.comment_no — NOT NULL
- recipient_id — varchar2(20) — Foreign key → employee.employee_id — NOT NULL
- comment_read_status — date
- document_no — number — Foreign key → comments.document_no — NOT NULL
comments
- comment_no — number — Primary key — NOT NULL
- document_no — number — Foreign key → document.document_no — NOT NULL
- writer_id — varchar2(20) — Foreign key → employee.employee_id — NOT NULL
- comment_contents — varchar2(100) — NOT NULL
- comment_in_date — date — NOT NULL
- comment_up_date — date
- del_status — date
default_approval_line
- default_approval_line_no — number — Primary key — NOT NULL
- form_id — varchar2(10) — Foreign key → document_form.form_id — NOT NULL
- rank — varchar2(6) — NOT NULL
- orders — number — NOT NULL
document
- document_no — number — Primary key — NOT NULL
- employee_id — varchar2(20) — Foreign key → employee.employee_id — NOT NULL
- form_id — varchar2(10) — Foreign key → document_form.form_id — NOT NULL
- title — varchar2(60) — NOT NULL
- contents — varchar2(600) — NOT NULL
- draft_date — date
- approved_document_no — varchar2(20)
- process_status — varchar2(10) — NOT NULL
- completion_date — date
- temporary_save_date — date
- deadline — date — NOT NULL
document_form
- form_id — varchar2(10) — Primary key — NOT NULL
- manager_id — varchar2(20) — Foreign key → employee.employee_id — NOT NULL
- form_category — varchar2(6) — NOT NULL
- form_name — varchar2(30) — NOT NULL
- form_content — varchar2(100) — NOT NULL
- form_description — varchar2(60) — NOT NULL
- form_usage — boolean — NOT NULL
employee
- employee_id — varchar2(20) — Primary key — NOT NULL
- name — varchar2(30) — NOT NULL
- password — varchar2(20) — NOT NULL
- department — varchar2(6)
- rank — varchar2(6) — NOT NULL
- access_permission — boolean — NOT NULL
- manager_permission — boolean — NOT NULL