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