| 字段 | 类型 | 键 | 可空 | 注释 |
|---|---|---|---|---|
| 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 |