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