-
Notifications
You must be signed in to change notification settings - Fork 6
DB Schema
YUBEEN PARK / TRISHA edited this page Jul 18, 2021
·
2 revisions
No | ๋ ผ๋ฆฌ๋ช | ๋ฌผ๋ฆฌ๋ช | ์๋ฃํ | Key | Null | Default | ๋น๊ณ |
---|---|---|---|---|---|---|---|
1 | id | ์ผ๋ จ๋ฒํธ | INT | PK | NOT NULL | ย | AUTO_INCREMENT |
2 | username | ์ ์ ๋ค์ | VARCHAR(20) | UNI | |||
3 | ์ด๋ฉ์ผ | VARCHAR(255) | |||||
4 | pwd | ๋น๋ฐ๋ฒํธ | TEXT | ||||
5 | salt | salt | TEXT | ||||
6 | gitRepo | ๊น๋ ํฌ์ฃผ์ | VARCHAR(2083) | ||||
7 | company | ํ์ฌ๋ช | VARCHAR(30) | ||||
8 | createdAt | ์์ฑ์ผ | TIMESTAMP | ||||
9 | updatedAT | ์ ๋ฐ์ดํธ๋ ์ง | TIMESTAMP |
No | ๋ ผ๋ฆฌ๋ช | ๋ฌผ๋ฆฌ๋ช | ์๋ฃํ | Key | Null | Default | ๋น๊ณ |
---|---|---|---|---|---|---|---|
1 | id | ์ผ๋ จ๋ฒํธ | INT | PK | NOT NULL | ย | AUTO_INCREMENT |
2 | userId | ์ ์ ๋ฒํธ | INT | MUL | |||
3 | title | ์ ๋ชฉ | VARCHAR(50) | ||||
4 | createdAt | ์์ฑ์ผ | TIMESTAMP | ||||
5 | updatedAT | ์ ๋ฐ์ดํธ๋ ์ง | TIMESTAMP |
No | ๋ ผ๋ฆฌ๋ช | ๋ฌผ๋ฆฌ๋ช | ์๋ฃํ | Key | Null | Default | ๋น๊ณ |
---|---|---|---|---|---|---|---|
1 | id | ์ผ๋ จ๋ฒํธ | INT | PK | NOT NULL | ย | AUTO_INCREMENT |
2 | userId | ์ ์ ๋ฒํธ | INT | MUL | |||
3 | categoryId | ์นดํ ๊ณ ๋ฆฌ๋ฒํธ | INT | MUL | |||
4 | position | ์ ์ ๋ฒํธ | INT | ||||
5 | text | ์ค๋ช | TEXT | ||||
6 | url | ๋ถ๋งํฌ์ฃผ์ | VATCHAR(2083) | ||||
7 | importance | ์ค์๋ | TINYINT | ||||
8 | visitCounts | ๋ฐฉ๋ฌธํ์ | INT | ||||
9 | createdAt | ์์ฑ์ผ | TIMESTAMP | ||||
10 | updatedAT | ์ ๋ฐ์ดํธ๋ ์ง | TIMESTAMP |