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