created author and book relations, created tricks file, created fullname virtual column