Just to make it an alternate reality:
Capt. Picard - Captain of the Enterprise; same as TNG; did have a family, but they left and he never remarried.
Cdr Riker - Riker commanded the Enterprise at the Borg Incident after Wolf 359; he was promoted to captain and given command of his own ship.
Commander Shelby - first officer for season 4, 5; she learns to temper her ambitions and her impulsiveness and earns the trust and respect of the crew, making her a better officer and better command candidate
Counselor Troi (Brandy Ledford) - the rare blonde Betazoid is an accomplished psychologist, and very intelligent. Her sister Kestra, is an accomplished engineer, like her father, and her mother babies Deanna and Kestra, often commenting that Deanna could do more like her older sister. All Betazoids have Blue or Green eyes, rarely purple.
Dr. Crusher (
Catherine Segal) - Crusher is a widower who brought her daughter, Leslie A Crusher, with her onto the Enterprise D.
Data - Operations Officer, Second Officer, an android lifeform, Data is second officer until Riker and Shelby leave, when he assumes the first officer position for Seasons 6 and 7.
Lt. Cdr Worf - Operations Officer of Enterprise after Data is promoted. Originally a tactical officer, but is placed into a command track after his actions in Best of Both Worlds. He resumes his tactical position after Hernandez moves to the Titan.
Lt. Cdr. Geordi La Forge - Engineering officer who is promoted to Chief after Season 1
Lt. Macha Hernandez, security/tactical officer --26-year-old woman of unspecified Latin descent, blonde haired, who serves as the starship's security chief. She has the physique of a fitness model, but is very curvy and feminine-appearing. She has a fire in her eyes and much of her strength comes from attitude. Macha has an almost obsessive devotion to protecting the ship and its crew and treats Captain Picard and First Officer as if they were saints. Becomes Chief Security in Season 2; moves to Titan with Riker, where Worf takes tactical.
Lt. Tasha Yar, Chief of Security - as written in TNG, grooms Hernandez into a competent officer to take over after she dies in the season 1 cliffhanger.
Lt. Cdr. Miles O'Brien - assistant Chief Engineer, commissioned officer. He does not desire the command responsibilities of Chief. Worked Conn in 2364 for his bridge duty requirement.
Leslie Crusher - a young female who displays a high degree of intelligence, but does not like starship life. She looks at Picard as a father figure. She becomes an acting ensign in Season 3 when her actions rescue the ship from a temporal recursion loop. She moves off to the Academy in Season 4.
Riker's Ship (Star Trek: Titan, 1st spin-off; DS9 is 2nd)
Captain Riker - based on his heroic actions during the Borg Incident, Riker is given his choice of command, which he takes after a few months for a ship to be commissioned for him.
Commander Mark Talbot - Titan's first officer is an ideal officer, and very efficient in his duties. He and Riker are close friends, and it hurts when he is killed in 2368.
Commander Shelby (after leaving the Enterprise) - First Officer, Shelby is now more seasoned, and more experienced as a first officer under Captain Picard's tutelage. She and Riker have a mutual respect for each other.
Counselor Staadi - Older sister to the (future) Helm officer on Voyager, she is full Betazoid and a calm presence that Riker looks to for advice.
Lt. Sela Yar (Ellen Pompeo) - Operations officer, second officer; after the Enterprise repairs a temporal fissure involving the Enteprise C, an alternate Tasha Yar goes back in time and has a half-Romulan Child. This child and mother are rescued by a Klingon vessel, and smuggled back to the Federation. Tasha is killed in the escape attempt, but her daughter is raised on Earth with her cousins. She is half-Romulan, and embraces her human half.
Dr. Pulaski - same as from TNG, CMO
Lt. Macha Hernandez - Chief of Security
Lt. Cdr. Miles O'Brien - Chief Engineer from the Enterprise, until transfer to DS9 in TNG's 6th Season.
Lt. Cdr. Kestra Troi - Asst. Chief Engineer, Deanna's sister is a very competent and capable officer, very popular, and very attractive. She is the model older sibling and officer who seems perfect to the observer. Will sees a very capable engineer in her, who works well with Miles. She becomes Chief Engineer once O'Brien moves to DS9.