GroupWare

Tables (8)

approval

  • approval_num — int(11) — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → user.user_id — NOT NULL
  • approval_name — varchar(50) — NOT NULL
  • approval_detail — varchar(255) — NOT NULL
  • approval_status — varchar(50) — NOT NULL
  • approval_category — varchar(50) — NOT NULL
  • approval_date — date
  • approval_result — varchar(50)
  • approval_sign1 — varchar(50)
  • approval_sign2 — varchar(50)
  • approval_receiver — varchar(50)
  • approval_donedate — datetime

approval_history

  • approval_historynum — int(11) — Primary key — NOT NULL
  • approval_num — int(11) — Foreign key → approval.approval_num — NOT NULL
  • approval_result — varchar(50)
  • approval_user — varchar(50)
  • original_status — varchar(50) — NOT NULL
  • update_status — varchar(50)
  • update_date — datetime

board

  • board_num — int(11) — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → user.user_id — NOT NULL
  • board_title — varchar(50) — NOT NULL
  • board_detail — varchar(255) — NOT NULL
  • category — varchar(20) — NOT NULL
  • board_date — date
  • board_hits — int(11) — NOT NULL

board_file

  • file_id — int(11) — Primary key — NOT NULL
  • board_num — int(11) — Foreign key → board.board_num — NOT NULL
  • original_filename — varchar(255) — NOT NULL
  • saved_filename — varchar(255) — NOT NULL

comment

  • comment_num — int(11) — Primary key — NOT NULL
  • user_id — varchar(50) — Primary key — NOT NULL
  • board_num — int(11) — Foreign key → board.board_num — NOT NULL
  • comment_detail — varchar(255)
  • comment_date — date

schedule

  • schedule_num — int(11) — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → user.user_id — NOT NULL
  • schedule_id — varchar(50) — NOT NULL
  • schedule_title — varchar(100) — NOT NULL
  • schedule_start — varchar(100) — NOT NULL
  • schedule_end — varchar(100) — NOT NULL
  • schedule_color — varchar(100) — NOT NULL
  • schedule_textcolor — varchar(100) — NOT NULL
  • schedule_allday — varchar(100) — NOT NULL
  • schedule_private — varchar(10)

todolist

  • todolist_id — int(11) — Primary key — NOT NULL
  • user_id — varchar(50) — Foreign key → user.user_id — NOT NULL
  • do_name — varchar(50) — NOT NULL
  • do_detail — varchar(255)
  • do_start — date — NOT NULL
  • do_end — date — NOT NULL

user

  • user_id — varchar(50) — Primary key — NOT NULL
  • user_password — varchar(255) — NOT NULL
  • user_name — varchar(50) — NOT NULL
  • user_position — varchar(50) — NOT NULL
  • user_email — varchar(50)
  • user_phoneNumber — varchar(50)
  • user_role — varchar(50)
  • dept — varchar(50) — NOT NULL