side-project
Tables (13)
Background (background)
- Background Id (backgroundId) — INT(11) — Primary key — NOT NULL
- User Id (userId) — INT(11) — Foreign key → User.User Id — NOT NULL
- Image Id (imageId) — INT(11) — Foreign key → Image.Image Id — NOT NULL
Date (ymd)
- Date Id (ymdId) — INT(11) — Primary key — NOT NULL
- Year (ymd) — CHAR(8) — NOT NULL
Follow (follow)
- Follow Id (followId) — INT(11) — Primary key — NOT NULL
- Follower Id (followerId) — INT(11) — Foreign key → User.User Id — NOT NULL
- User Id (followingId) — INT(11) — Foreign key → User.User Id — NOT NULL
- Create Date (createdAt) — DATETIME — NOT NULL
Image (image)
- Image Id (imageId) — INT(11) — Primary key — NOT NULL
- Image Url (url) — VARCHAR(30)
- Field (deletedAt) — DATETIME
Oauth (oauth)
- Oauth Id (oauthId) — INT(11) — Primary key — NOT NULL
- User Id (userId) — INT(11) — Foreign key → User.User Id — NOT NULL
- Provider (provider) — VARCHAR(20) — NOT NULL
- Field (refreshToken) — VARCHAR(100)
Password (password)
- Password Id (passwordId) — INT(11) — Primary key — NOT NULL
- User Id (userId) — INT(11) — Foreign key → User.User Id — NOT NULL
- password — VARCHAR(255)
- Update Date (updatedAt) — DATETIME — NOT NULL
Profile (profile)
- Profile Id (profileId) — INT(11) — Primary key — NOT NULL
- Image Id (imageId) — INT(11) — Foreign key → Image.Image Id — NOT NULL
- nickname — VARCHAR(20) — NOT NULL
- Bio (bio) — TEXT
- Field (deletedAt) — DATETIME
Role (role)
- Role Id (roleId) — INT(11) — Primary key — NOT NULL
- Role (role) — VARCHAR(20)
Routine (routine)
- Routine Id (routineId) — INT(11) — Primary key — NOT NULL
- User Id (userId) — INT(11) — Foreign key → User.User Id — NOT NULL
- Tile (title) — VARCHAR(20) — NOT NULL
- Description (description) — VARCHAR(40)
- Start Time (startAt) — VARCHAR(4) — NOT NULL
- End Time (endAt) — VARCHAR(4) — NOT NULL
- Field (active) — BIT(1) — NOT NULL
RoutineHistory (routine_history)
- R.H Id (routineHistoryid) — INT(11) — Primary key — NOT NULL
- Routine Id (routineId) — INT(11) — Foreign key → Routine.Routine Id — NOT NULL
- Date Id (ymdId) — INT(11) — Foreign key → Date.Date Id — NOT NULL
- Done (done) — BIT(1) — NOT NULL
Schedule (schedule)
- Schedule Id (scheduleId) — INT(11) — Primary key — NOT NULL
- Date Id (ymdId) — INT(11) — Foreign key → Date.Date Id — NOT NULL
- Field (title) — VARCHAR(20) — NOT NULL
- Field (description) — TEXT
- Start Time (startAt) — VARCHAR(4)
- End Time (endAt) — VARCHAR(4)
- Done (done) — BIT(1) — NOT NULL
Schedule_User (schedule_user)
- Shcedule-To-User Id (scheduleUserId) — INT(11) — Primary key — NOT NULL
- Schedule Id (scheduleId) — INT(11) — Foreign key → Schedule.Schedule Id — NOT NULL
- User Id (userId) — INT(11) — Foreign key → User.User Id — NOT NULL
- Date Id (ymdId) — INT(11) — Foreign key → Date.Date Id — NOT NULL
- Field (deletedAt) — DATETIME
User (user)
- User Id (userId) — INT(11) — Primary key — NOT NULL
- Profile Id (profileId) — INT(11) — Foreign key → Profile.Profile Id — NOT NULL
- Role Id (roleId) — INT(11) — Foreign key → Role.Role Id — NOT NULL
- E-mail (email) — VARCHAR(40) — NOT NULL
- Create Date (createdAt) — DATETIME — NOT NULL
- Field (deletedAt) — DATETIME