dafxzvz
Tables (15)
accept_backup
- accept_idx — number
- writer — varchar2(100) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- department_id — number — NOT NULL
- approval_title — varchar2(100) — NOT NULL
- approval_content — varchar2(2000) — NOT NULL
- type — char(1) — NOT NULL
- backup_filepath — varchar2(255) — NOT NULL
approval
- approval_idx — number
- writer — varchar2(100) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- department_id — number — NOT NULL
- isapprove — number(1)
- type — char(1)
- approval_title — varchar2(100) — NOT NULL
- approval_content — varchar2(2000) — NOT NULL
- approval_filepath — varchar2(255) — NOT NULL
board
- board_idx — number
- board_title — varchar2(100) — NOT NULL
- board_content — varchar2(2000) — NOT NULL
- write_date — date
- board_category — varchar2(100) — NOT NULL
- writer_id — number — NOT NULL
- isnotice — number(1)
board_file
- board_id — number — NOT NULL
- board_filepath — varchar2(255) — NOT NULL
chatting_join
- join_idx — number
- join_userid — varchar2(100) — NOT NULL
- room_id — number — NOT NULL
chatting_log
- log_idx — number
- log_message — varchar2(500) — NOT NULL
- log_date — date
- join_id — number — NOT NULL
chatting_room
- room_idx — number
- room_name — varchar2(100) — NOT NULL
- room_makedate — date
deny_backup
- deny_idx — number
- writer — varchar2(100) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- department_id — number — NOT NULL
- approval_title — varchar2(100) — NOT NULL
- approval_content — varchar2(2000) — NOT NULL
- type — char(1) — NOT NULL
- backup_filepath — varchar2(255) — NOT NULL
department
- department_idx — number
- department_name — varchar2(100) — NOT NULL
- manager_id — number — NOT NULL
department_work
- work_idx — number
- department_id — number — NOT NULL
- work_name — varchar2(100) — NOT NULL
employees
- employee_idx — number
- employee_userid — varchar2(100) — NOT NULL
- employee_password — varchar2(100) — NOT NULL
- employee_name — varchar2(100) — NOT NULL
- email — varchar2(100) — NOT NULL
- phone_number — varchar2(100) — NOT NULL
- birth_date — varchar2(100) — NOT NULL
- profile_fic — varchar2(255)
- job — varchar2(100) — NOT NULL
- hire_date — date
- manager_id — number — NOT NULL
- department_name — varchar2(100)
mail
- mail_idx — number
- mail_title — varchar2(100) — NOT NULL
- mail_content — varchar2(2000) — NOT NULL
- mail_writedate — date
- mail_writer — number — NOT NULL
mail_file
- mail_idx — number — NOT NULL
- mail_filepath — varchar2(255) — NOT NULL
reply
- reply_idx — number
- writer_id — number — NOT NULL
- board_id — number — NOT NULL
- reply_date — date
- reply_content — varchar2(2000) — NOT NULL
schedule
- schedule_idx — number
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- writer_id — number — NOT NULL
- type — char(1) — NOT NULL
- department_id — number — NOT NULL