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))