WorkOffice
Tables (7)
approval
- approval_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- approval_title — VARCHAR(200) — NOT NULL
- approval_content — TEXT — NOT NULL
- approval_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
board
- board_id — BIGINT — Primary key — NOT NULL
- board_name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
board_post
- post_id — BIGINT — Primary key — NOT NULL
- board_id — BIGINT — Foreign key → board.board_id — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- post_title — VARCHAR(200) — NOT NULL
- post_content — TEXT — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
department
- department_id — BIGINT — Primary key — NOT NULL
- department_name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification
- notification_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- notification_title — VARCHAR(200) — NOT NULL
- notification_content — VARCHAR(500) — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
schedule
- schedule_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- schedule_title — VARCHAR(100) — NOT NULL
- schedule_content — TEXT
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- department_id — BIGINT — Foreign key → department.department_id — NOT NULL
- user_name — VARCHAR(50) — NOT NULL
- email_address — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- job_position — VARCHAR(30) — NOT NULL
- user_role — VARCHAR(20) — NOT NULL
- account_status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL