Make owner & channel Tables
Closed this issue · 0 comments
yi1306c12 commented
from data/channels.csv
| ownerName | channelName | channelId |
|---|---|---|
| Alice | Alice.ch | UCXXXX...XXXX |
| Bob | Bob.ch | UCXXXX...XXXX |
| ... | ... | ... |
erDiagram
owner ||--|{ channel : "has"
owner {
INT ownerNo PK "AUTOINCREMENT"
STRING ownerName "UK, channel: ownerName"
}
channel {
INT channelNo PK "AUTOINCREMENT"
INT ownerNo FK
STRING channelName
STRING channelId "UK"
}