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