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