MySql question please CREATE the tables with their given constraints!!!!!

TASK1: create schemas below Constraint Primary key Table Doctors Attributes Data Type Doctor.id Integer D Name Varchar(50) Date joined Date Gender Char(1) Speciality Varchar(50) Office Phone number Char(9) Work email address, Varchar(50) Check if only numbers are inserted and if it starts with 04 Check if proper format of work email address which is 2 letters, followed by 3 numbers and then the @ symbol followed by hosp.ae Example: zh445@hosp.ae Constraint Primary key Table Patients Attributes Data Type Patient id Integer Patient name Varchar(50) Registration date date Gender Char(1) Dob date Text Phone number Char(10) Email address Varchar(50) Check if only numbers are inserted and if it starts with 05 Check if proper format of personal email address which is a series of lettersumbers followed by the @ symbol and a series of letters followed by Followed by more letters Example: suraj99@gmail.com Table Appointments Attributes Data Type Patient id Integer Doctor.id Integer Appointment date time datetime Status enum Constraint References patients table References doctors table Confirmed or waiting