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