clone

Tables (20)

Calendar_table

  • Calendar_number — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • department_number — number — Foreign key → department.department_number — NOT NULL
  • cal_start_date — date
  • cal_end_date — date
  • cal_title — nvarchar2(30)
  • cal_story — nvarchar2(300)
  • cal_color — varchar2(20)
  • cal_category — varchar2(20)
  • writer_dept_num — number

Messenger

  • messenger_number — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • messenger_group_number — number
  • original_messenger_number — number
  • title — varchar2(20)
  • contents — varchar2(100)
  • did_read — number
  • did_attach — number
  • write_date — date
  • messenger_number2 — number — NOT NULL
  • employee_id2 — number — NOT NULL

attach_file_table

  • attach_file_number — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • attach_file_type — varchar2(20)
  • filename — varchar2(100)
  • upload_filename — varchar2(200)

commute_table

  • commute_time — date — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • work_hour — number
  • leave_time — date
  • extra_work_time — number

department

  • department_number — number — Primary key — NOT NULL
  • department_head_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL

department_mapping

  • department_head_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • department_number — number — Foreign key → department.department_number — NOT NULL

draft_table

  • Document_number — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • draft_title — varchar2(20)
  • draft_content — varchar2(100)
  • hope_end_date — date
  • icon — varchar2(20)
  • write_date — date
  • filename — varchar2(100)
  • upload_filename — varchar2(200)
  • file_size — number

employee_rank

  • rank_num — number — Primary key — NOT NULL
  • rank_name — varchar2(30)

employees

  • employee_id — number — Primary key — NOT NULL
  • department_number — number — Foreign key → department.department_number — NOT NULL
  • rank_num — number — Foreign key → employee_rank.rank_num — NOT NULL
  • employee_name — varchar2(20)
  • employee_email — varchar2(20)
  • employee_password — varchar2(20)
  • employee_salary_pertime — number
  • employee_start_date — date
  • employee_RRN — varchar2(100)
  • employee_end_date — date
  • employee_phone — varchar2(20)
  • employee_address — varchar2(100)
  • employee_salary_account — varchar2(20)
  • employee_self_introduction — nvarchar2(300)
  • employee_status — varchar2(20)
  • employee_last_name — varchar2(20)
  • employee_first_name — varchar2(20)
  • employee_profile_color — varchar2(20)

history

  • Document_number — number — Foreign key → draft_table.Document_number — NOT NULL
  • rank_num — number — Foreign key → draft_table.rank_num — NOT NULL
  • employee_name — nvarchar2(10)
  • contents — nvarchar2(100)
  • sign_history_date — date

leave

  • leave_history_number — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • leave_genre — nvarchar2(30)
  • leave_start_date — date
  • leave_end_date — date
  • memo — nvarchar2(300)

messenger_attach_table

  • attach_file_number — number — Primary key — NOT NULL
  • messenger_number — number — Foreign key → Messenger.messenger_number — NOT NULL
  • rank_num — number — Foreign key → Messenger.rank_num — NOT NULL
  • messenger_group_number — number
  • original_attach_file_name — varchar2(100)
  • tomcat_file_name — number

news_table

  • news_number — number — Primary key — NOT NULL
  • url1 — number
  • url2 — number
  • news_contents — nvarchar2(300)
  • news_Emoji — number
  • did_read — number
  • news_date — date

notice_comments_table

  • comments_number — number — Primary key — NOT NULL
  • notice_number — number — Foreign key → notice_table.notice_number — NOT NULL
  • employee_id — number — Foreign key → notice_table.employee_id — NOT NULL
  • rank_num — number — Foreign key → notice_table.rank_num — NOT NULL
  • comments_contents — nvarchar2(300)
  • comments_date — date

notice_table

  • notice_number — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • notice_level — number
  • write_date — date
  • notice_title — varchar2(100)
  • notice_contents — clob
  • notice_view — number
  • comments_view — number
  • notice_status — number
  • attach_file_name — varchar2(100)
  • original_attach_file_name — varchar2(100)
  • attach_file_size — number
  • attach_file_number — number

personal_transfer_record

  • PTR_number — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • department_number2 — number — Foreign key → employees.department_number — NOT NULL
  • memo — nvarchar2(300)
  • transfer_date — date
  • transfer_label — nvarchar2(30)
  • befor_position — nvarchar2(30)
  • befor_ddepartment_number — number

salary_table

  • salary_month — date — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • salary — number
  • extra_salary — number

sign

  • sign_number — number — Primary key — NOT NULL
  • Document_number — number — Foreign key → draft_table.Document_number — NOT NULL
  • rank_num — number — Foreign key → draft_table.rank_num — NOT NULL
  • sign_level — number
  • sign_status — number
  • sign_date — date
  • did_sign — number

vacation

  • vacation_num — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → vacation_Application.employee_id — NOT NULL
  • vacation_name — nvarchar2(10)

vacation_Application

  • VA_number — number — Primary key — NOT NULL
  • employee_id — number — Foreign key → employees.employee_id — NOT NULL
  • rank_num — number — Foreign key → employees.rank_num — NOT NULL
  • vacation_num — number — Foreign key → vacation.vacation_num — NOT NULL
  • Calendar_number — number — Foreign key → Calendar_table.Calendar_number — NOT NULL
  • vacation_start_date — date
  • vacation_end_date — date
  • vacation_days — number
  • vacation_reason — varchar2(100)
  • vacation_status — number