| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| id | bigint | PRI | NO | |
| family_id | bigint | MUL | NO | |
| person_uid | varchar | — | YES | |
| item_type | varchar | — | NO | photo letter oral story motto ritual |
| title | varchar | — | NO | |
| content | text | — | YES | |
| media_url | varchar | — | YES | |
| geo_tag | varchar | — | YES | GEO标签 地点+年代 |
| generation_no | int | — | YES | |
| visibility | varchar | — | YES | private family clan public |
| created_at | datetime | — | YES |