assignment

Tables (3)

Resumes

  • Key (resumesId) — INT(11) — Primary key — NOT NULL
  • Key (userId) — INT(11) — Foreign key → Users.Key — NOT NULL
  • Field (title) — VARCHAR(191)
  • Field (abuotMe) — VARCHR(191)
  • Field (authorName) — VARCHAR(191)
  • Field (status) — VARCHR(191)
  • Field (createdAt) — DATETIME(3)
  • Field (updatedAt) — DATETIME(3)

UserInfo

  • Key (userInfoId) — INT(11) — Primary key — NOT NULL
  • Key (userId) — INT(11) — Foreign key → Users.Key — NOT NULL
  • Field (name) — VARCHAR(191)
  • Field (age) — INT(11)
  • Field (gender) — VARCHAR(191)
  • Field (profileImage) — VARCHR(191)?
  • Field (createdAt) — DATETIME(3)
  • Field (updatedAt) — DATETIME(3)

Users

  • Key (userId) — INT(11) — Primary key — NOT NULL
  • Field (email) — VARCHAR(191)
  • Field (password) — VARCHAR(191)
  • Field (createdAt) — DATETIME(3)
  • Field (updatedAt) — DATETIME(3)