| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| store_id | char(36) | MUL | YES | ||
| merchant_id | char(36) | MUL | YES | ||
| user_id | char(36) | MUL | YES | 关联 profiles.id | |
| staff_no | varchar(32) | YES | 工号 | ||
| staff_name | varchar(64) | YES | |||
| phone | varchar(32) | YES | |||
| position | varchar(32) | YES | manager店长/cashier收银/stock库管/sales导购/delivery配送 | ||
| hire_date | date | YES | |||
| leave_date | date | YES | |||
| status | tinyint(4) | YES | 1 | 1在职 0离职 | |
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | |||
| updated_at | datetime(3) | YES |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_staff_store | store_id,status | 普通 |
| idx_staff_user | user_id | 普通 |
| PRIMARY | id | 唯一 |
| uk_staff_no | merchant_id,staff_no | 普通 |
| id | store_id | merchant_id | user_id | staff_no | staff_name | phone | position | hire_date | leave_date | status | is_deleted |
|---|---|---|---|---|---|---|---|---|---|---|---|
| st-0001-0000-4000-8000-000000000001 | 4ad3efb6-6913-4a67-af89-5304861bf08e | de000063-1000-4000-8000-000000000003 | NULL | CH001 | 周店长 | 138****0001 | manager | 2026-01-05 | NULL | 1 | 0 |
| st-0002-0000-4000-8000-000000000002 | 4ad3efb6-6913-4a67-af89-5304861bf08e | de000063-1000-4000-8000-000000000003 | NULL | CH002 | 吴收银 | 138****0011 | cashier | 2026-03-01 | NULL | 1 | 0 |
| st-0003-0000-4000-8000-000000000003 | 4ad3efb6-6913-4a67-af89-5304861bf08e | de000063-1000-4000-8000-000000000003 | NULL | CH003 | 郑库管 | 138****0012 | stock | 2026-05-10 | NULL | 1 | 0 |