TheCp
Tables (3)
Items (Untitled2)
- ItemGUID — CHAR(36) — Primary key — NOT NULL
- ItemName — NVARCHAR(50)
- ItemContent — NVARCHAR(MAX)
- ItemIMG — VARCHAR(MAX)
- ItemRegdate — DATETIME
- Field
Untitled
- UserGUID — CHAR(36) — Foreign key → Users.UserGUID
- Field
Users
- UserGUID — CHAR(36) — Primary key
- UserID — VARCHAR(20) — NOT NULL
- Email — VARCHAR(100) — NOT NULL
- Name — VARCHAR(50) — NOT NULL
- Phone — VARCHAR(20)
- BirthDay — DATE
- CreateDate — DATETIME
- Status — ENUM('Active', 'Inactive')