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)