vvs

Tables (4)

Reviews (Untitled2)

  • uid (Key2) — int — Foreign key → User.uid — NOT NULL
  • email (Key22) — varchar — Foreign key → User.email — NOT NULL
  • title (Field) — varchar(255)
  • content (Field2) — text
  • create_at (Field3) — timestamp
  • update_at (Field4) — timestamp
  • notification (Field5) — tinyint
  • view_count (Field6)
  • deleted_at (Field7)

User (Untitled)

  • uid (Key) — int — Primary key — NOT NULL
  • email (Key2) — varchar — Primary key — NOT NULL
  • password (Field) — varchar
  • name (Field8) — varchar
  • phone (Field2) — varchar
  • remember_token (Field7) — varchar(100)
  • birth_date (Field3) — timestamp
  • create_at (Field4) — timestamp
  • update_at (Field5) — timestamp
  • last_login (Field10) — timestamp
  • activated (Field9) — tinyint(1)
  • pos (Field6) — int
  • confirm_code (Field11) — varchar(60)

password_resets (Untitled3)

  • email (Field) — varchar(255)
  • token (Field2) — varchar(255)
  • created_at (Field3) — timestamp

resv_list (Untitled4)