1 个赞
写了标准文档： 画了一个 E-R 图 （实体-关系图）
屏幕截图（10个）
笔记的内容
---
up:
- "[[Collection]]"
keywords:
- "[[Bilibili]]"
- "[[User]]"
down:
- "[[Chubbyemu]]"
- "[[隅野贝]]"
- "[[PiKaChu345]]"
- "[[3Blue1Brown]]"
- "[[瑛之诗]]"
- "[[历史影像馆]]"
- "[[铁打的郎中]]"
- "[[bili_62511222486]]"
- "[[茄子蒜泥儿]]"
- "[[杨雨坤-Yukun]]"
- "[[原子能]]"
bases:
- "[[Bilibili User Base.base]]"
ctime: 2025-08-05T00:44:53+08:00
mtime: 2025-11-11T17:13:51+08:00
---
# Bilibili User
- up: [[Collection]]
- keywords: [[Bilibili]] [[User]]
- base: [[Bilibili User Base.base]]
- template: [[TP - Bilibili User]]
| Category | Users |
| ------------------ | ------------------------------ |
| [[G898 游戏]] | [[瑛之诗]] |
| [[J2 绘画]] | [[隅野贝]] |
| [[K 历史、地理]] | [[历史影像馆]]、[[茄子蒜泥儿]] |
| [[O1 数学]] | [[PiKaChu345]]、[[3Blue1Brown]] |
| [[Q189 神经科学]] | [[杨雨坤-Yukun]] |
| [[R1 预防医学、卫生学]] | [[Chubbyemu]]、[[铁打的郎中]] |
| [[TP 自动化技术、计算机技术]] | [[原子能]] |
| [[Z 综合性图书]] | [[bili_62511222486]] |
![[Bilibili User Base.base]]
## Schema
```mermaid
erDiagram
Record {
Link up FK "ref Collection"
string title
string[] aliases
string description
DateTime ctime
DateTime mtime
string url
Link icon FK "ref ImageFile"
Link cover FK "ref ImageFile"
}
Record }|--|| Collection: belongs
Record }o--o{ Keyword: have
Record }o--o{ Category: have
BilibiliUser {
Link record FK "ref Record"
int biliuseridnum
string bulletin
}
BilibiliUser ||--|| Record: is
BilibiliVideo {
Link record FK "ref Record"
}
BilibiliVideo ||--|| Record: is
BilibiliUserVideoRelation ||--|{ BilibiliVideo : have
BilibiliUserVideoRelation ||--|{ BilibiliUser : have
```
### Record Schema
| order | prop-name | type | required | chk | ref | default |
| ----- | ----------- | ---------- | -------- | ----------------------- | ------------------ | ------- |
| 1 | recordid | `Link` | 1 | | Record | |
| 2 | up | `Link[]` | 1 | | [[Collection]]\[\] | |
| 3 | description | `string` | | | | |
| 4 | categories | `Link[]` | | length(categories) == 1 | [[中国图书馆分类法]]\[\] | |
| 5 | keywords | `Link[]` | | | | |
| 6 | markeditems | `Link[]` | | | | |
| 7 | aliases | `string[]` | | | | |
| 8 | url | `string` | | isURL(url) | | |
| 9 | icon | `Link` | | | ImageFile | |
| 10 | cover | `Link` | | | ImageFile | |
| 11 | ctime | `DateTime` | | | | now() |
| 12 | mtime | `DateTime` | | | | now() |
### Bilibili User Schema
| order | prop-name | type | required | chk | ref | default |
| ----- | ------------- | -------- | -------- | --- | ------ | ------- |
| 1 | recordid | `Link` | 1 | | Record | |
| 2 | biliuseridnum | `int` | | | | |
| 3 | bulletin | `string` | | | | |
### Bilibili Video Schema
| order | prop-name | type | required | chk | ref | default |
| ----- | --------- | ------ | -------- | --- | ------ | ------- |
| 1 | recordid | `Link` | 1 | | Record | |
### Bilibili User Video Relation Schema
| order | prop-name | type | required | chk | ref | default |
| ----- | ------------- | ------ | -------- | --- | ------------------ | ------- |
| 1 | bilibiliuser | `Link` | | | [[Bilibili User]] | |
| 2 | bilibilivideo | `Link` | | | [[BiliBili Video]] | |
什么鬼，还画E-R图，哈哈！