[ERD]유저와 글과의 관계 정보
[ERD]유저와 글과의 관계본문
https://mermaid-js.github.io/mermaid-live-editor/
에 아래를 넣어 보면
erDiagram
MEMBERS ||--o{ ARTICLES : hasMany
ARTICLES ||--o{ FILES : hasMany
ARTICLES || --o{ LINKS : hasMany
ARTICLES || --o{ CATEGORIES: hasMany
ARTICLES }o--o{ TAGS: manyToMany
MEMBERS {
int id
varchar userid
varchar username
varchar nickname
date nickname_date
}
ARTICLES {
int id
int num
varchar subject
text content
}
FILES {
int id
varchar file
int download
text content
tinyint type
}
LINKS {
int id
text link
int hit
}
CATEGORIES {
int id
varchar name
}
TAGS {
int id
varchar name
}
0