Groupware is an S-Tier enterprise solution integrating all core collaboration capabilities. It provides electronic approval (multi-step, amount-based routing, delegation/proxy, notifications), calendar (personal/department/company-wide events), attendance management (QR/NFC/app check-in with 52-hour weekly limit enforcement per Korean Labor Standards Act), and messenger (channels, threads, card messages) as its foundation. S-Tier extensions add project management (7 tables: projects, phases, tasks with WBS hierarchy, comments, attachments, dependencies, members), document management (5: folders, documents with versioning and check-out, versions, permissions, reviews), wiki/knowledge base (4: spaces, hierarchical pages, version history, comments), meeting room/resource reservation (3: shared resources, reservations, attendees), bulletin boards (3: boards, posts, comments), TODO (2: lists, items), email integration (2: accounts, send/receive logs), meetings (2: meetings, minutes), surveys (3: surveys, questions, responses), calendar/chat extensions (4: event attendees, chat reactions, file sharing, notification preferences), and workflow infrastructure (DMN decision tables, workflow versioning, compensation handlers, signal subscriptions).
Solution Scale
| Category | Count | Description |
|---|
| Tables | 55 | 53 domain + 2 system |
| Relationships | 40+ | Domain FKs + SYSTEM_REF links |
| Workflows | 8 | Electronic approval, attendance, leave request, project lifecycle, document review, room reservation, survey, board moderation |
| Admin Screens | 17 | Lists / dashboards |
| Dashboard Widgets | 5 | KPI cards, pie chart, stat card, line chart |
Core Domains
Document Structure
| Document | Contents | Tables |
|---|
| Electronic Approval | Form Templates, Delegation Rules, Amount Rules, Approval Documents, Approval Lines | 5 |
| Calendar & Attendance | Calendar Events, Attendance Records, Leave Balances | 3 |
| Messaging & Chat | Chat Channels, Chat Messages, Channel Members | 3 |
| Project Management | Projects, Phases, Tasks, Comments, Attachments, Dependencies, Members | 7 |
| Documents & Wiki | Document Folders, Documents, Versions, Permissions, Reviews, Wiki Spaces, Pages, Version History, Comments | 9 |
| S-Tier Extensions | Meeting Room/Resource, Bulletin Board, TODO, Email, Meetings, Surveys, Calendar/Chat Extensions, Notification Preferences, Integration/Audit, Workflow Infrastructure | 28 |
| Menu Group | Primary Screens |
|---|
| Electronic Approval (AuditOutlined, admin) | Approval Inbox, Approval Lines, Form Templates, Delegation Management, Amount Rules |
| Calendar / Schedule (CalendarOutlined, admin) | Calendar |
| Attendance Management (ClockCircleOutlined, hr) | Attendance Status, Leave Balances |
| Messenger (MessageOutlined, admin) | Chat Channels, Channel Members |
| Organization Management (TeamOutlined, hr) | HR Sync History |
| Groupware Settings (SettingOutlined, admin) | ERP Event Mapping, Audit Trail, Task Delegation, Compensation Handlers, Signal Subscriptions |
Workflow List
| Workflow | Nodes | Trigger | Key Process |
|---|
| Electronic Approval (WF1) | 12 | Document created | Start -> Draft -> Validate lines -> Check delegation -> Multi-step approval -> [Approved -> Notification -> Post-actions / Rejected -> Notification -> Revise/Abandon] -> Complete |
| Attendance (WF2) | 8 | Record created | Start -> Check-in -> Check-out -> Calculate hours -> Weekly cumulative check -> [Warning -> 52-hour alert / Normal] -> Complete |
| Leave Request (WF3) | 9 | HR form submitted | Start -> Request -> Team lead approval -> [Approved -> Deduct balance -> Register calendar -> Notification / Rejected -> Notification] -> Complete |
| Project Lifecycle (WF4) | 11 | Project created | Start -> Planning -> Approval -> [Approved -> Kickoff notification -> Execution -> Progress aggregation -> [Complete -> Close / Continue -> Loop] / Rejected -> End] -> Complete |
| Document Review (WF5) | 8 | Document updated to published | Start -> Submit -> Review -> [Approved -> Publish / Rejected -> Notification -> Revise/Abandon] -> Complete |
| Room Reservation (WF6) | 8 | Reservation created | Start -> Request -> Conflict check -> [Available -> Approval needed? -> [Yes -> Admin approval / No -> Auto-confirm] -> Confirm / Conflict -> End] -> Complete |
| Survey (WF7) | 7 | Survey status changed to active | Start -> Design -> Distribute -> Collect responses -> Close -> Analyze results -> Complete |
| Board Moderation (WF8) | 6 | Post created | Start -> Write -> Auto-check (forbidden words/spam) -> [Pass -> Publish / Violation -> Revise/Delete] -> Complete |
| Widget | Type | Data Source | Description |
|---|
| Pending Approvals | KPI Card | approval_documents | Count of documents with pending status |
| Approval by Status | Pie Chart | approval_documents | Approval document distribution by status |
| Today's Attendance | Stat Card | attendance_records | Count of check-ins for today |
| 52-Hour Warning Count | KPI Card | attendance_records | Number of employees flagged for 52-hour warning |
| Approval Processing Trend | Line Chart | approval_documents | Daily approval document processing trend |
Groupware Entity Relationship Diagram