| 字段 | 类型 | 键 | 可空 | 默认 | 注释 |
|---|---|---|---|---|---|
| id | char(36) | PRI | NO | ||
| event_id | char(36) | MUL | NO | ||
| user_id | char(36) | MUL | YES | ||
| member_id | char(36) | YES | |||
| signup_no | varchar(64) | UNI | NO | ||
| checkin_code | varchar(64) | YES | |||
| quantity | int(11) | YES | 1 | ||
| contact_name | varchar(100) | YES | |||
| contact_phone | varchar(20) | YES | |||
| status | varchar(20) | YES | pending | ||
| checked_in_at | datetime(3) | YES | |||
| checked_in_by | char(36) | YES | |||
| remark | longtext | YES | |||
| is_deleted | tinyint(1) | YES | 0 | ||
| created_at | datetime(3) | YES | CURRENT_TIMESTAMP(3) | ||
| updated_at | datetime(3) | YES | CURRENT_TIMESTAMP(3) |
| 索引名 | 字段 | 类型 |
|---|---|---|
| idx_event | event_id | 普通 |
| idx_user | user_id | 普通 |
| PRIMARY | id | 唯一 |
| uk_signup_no | signup_no | 普通 |
| id | event_id | user_id | member_id | signup_no | checkin_code | quantity | contact_name | contact_phone | status | checked_in_at | checked_in_by |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 120b97db-0bf5-533d-bb6b-26cf6a8f8e7c | 2cb9edad-d477-523b-9bad-d9104a994e49 | c209cb11-f325-4299-b14a-ef12aa7caad2 | c209cb11-f325-4299-b14a-ef12aa7caad2 | BMSH03001 | HXSH03001 | 1 | 社** | confirmed | NULL | NULL | |
| 2a1fe149-41e1-5506-84f5-b428e90980b9 | 2cb9edad-d477-523b-9bad-d9104a994e49 | 5f56da1c-8699-4c29-afc2-8f9bccd11c41 | 5f56da1c-8699-4c29-afc2-8f9bccd11c41 | BMSH03002 | HXSH03002 | 1 | 社** | confirmed | NULL | NULL | |
| 2a35f56f-2b1c-583f-b7b8-36123d01aff4 | 76bf1787-a990-50b6-966e-1d5175d57cf3 | c209cb11-f325-4299-b14a-ef12aa7caad2 | c209cb11-f325-4299-b14a-ef12aa7caad2 | BMLTZG01001 | HXLTZG01001 | 1 | 社** | confirmed | NULL | NULL |