tasker
Tables (8)
Category (카테고리)
- 카테고리 index (categoryId) — Primary key — NOT NULL
- 색깔 index (colorId) — Foreign key → Color.색깔 index — NOT NULL
- 유저 index (userId) — Foreign key → User.유저 index — NOT NULL
- Field (name)
Color (색깔)
- 색깔 index (colorId) — Primary key — NOT NULL
- Field (colorBack)
- Field2 (colorText)
Note (노트)
- 노트 index (noteId) — Primary key — NOT NULL
- 테스크 index (taskId) — Foreign key → Task.테스크 index — NOT NULL
- Field (content)
Report (신고)
- 신고 index (reportId) — Primary key — NOT NULL
- 유저 index (userId) — Foreign key → User.유저 index — NOT NULL
- 테스크 index (taskId) — Foreign key → Task.테스크 index — NOT NULL
- Field (reportType) — enum
Task (테스크)
- 테스크 index (taskId) — Primary key — NOT NULL
- 유저 index (userId) — Foreign key → User.유저 index — NOT NULL
- 카테고리 index (categoryId) — Foreign key → Category.카테고리 index — NOT NULL
- Field (title) — String
- Field2 (date) — String
- Field3 (timeStart) — String
- Field4 (timeEnd) — String
- Field (status) — Integer
TaskBook (테스크북)
- 테스크북 index (taskBookId) — Primary key — NOT NULL
- 카테고리 index (categoryId) — Foreign key → Category.카테고리 index — NOT NULL
- 주제 (topic) — enum
- 제목 (title)
- 소개 (introduction)
User (유저)
- 유저 index (userId) — Primary key — NOT NULL
- Field (phoneNumber)
- Field (profileIntro)
- Field (profileImg)
- Field (phoneNumberSha)
UserRefreshToken (Untitled)
- Key (userRefreshTokenId) — Primary key — NOT NULL
- 유저 index (userId) — Foreign key → User.유저 index — NOT NULL
- Field (userRefreshToken)