GUIDE
Tables (3)
building (Untitled)
- Building_name (VARCHAR(30)) — Primary key — NOT NULL
- Address (VARCHAR(255))
- Class_keyword (VARCHAR(10))
client (Untitled2)
- ID (VARCHAR(10)) — Primary key — NOT NULL
- Password (VARCHAR(15))
- Name (VARCHAR(30))
- Nickname (VARCHAR(20))
- Email (VARCHAR(25))
review (Untitled3)
- NUM (INT(11)) — auto_increment — Primary key — NOT NULL
- Building_name (VARCHAR(30)) — Foreign key → building.Building_name — NOT NULL
- ID (VARCHAR(10)) — Foreign key → client.ID — NOT NULL
- Review (VARCHAR(255))