السلام عليكم قمت بعمل هذه الجداول

بس المشكله ما اعرف ارسم ممكن المساعدة با

Database model diagram

وهل الجداول صحيحه لمكتب سياحي

طبعا بسيط

ولكم جزيل الشكر

CREATE TABLE `our_destinations` (

`our_destinations_id` INT(10) NOT NULL DEFAULT '0',
`country` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`city` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
PRIMARY KEY (`our_destinations_id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;



****************************************************


CREATE TABLE `tours` (
`tour_id` INT(10) NOT NULL DEFAULT '0',
`tour_length` INT(2) NULL DEFAULT NULL,
`tour_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`tour_description` TEXT NULL COLLATE 'utf8_unicode_ci',
PRIMARY KEY (`tour_id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;



*****************************************************

CREATE TABLE `hotel` (
`hotel_id` INT(10) NOT NULL DEFAULT '0',
`hotel_name` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`hotel_category` VARCHAR(15) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`hotel_image` VARCHAR(300) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`country` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
PRIMARY KEY (`hotel_id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;


*****************************************************

CREATE TABLE `booking` (
`booking_id` INT(10) NOT NULL DEFAULT '0',
`full_name` VARCHAR(100) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`phone` INT(20) NULL DEFAULT NULL,
`passport_number` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`destnation` VARCHAR(20) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`hotel_name` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`num_of_nights` INT(2) NULL DEFAULT NULL,
`num_of_persons` INT(2) NULL DEFAULT NULL,
`date_of_flight` DATE NULL DEFAULT NULL,
PRIMARY KEY (`booking_id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;


*******************************************************

CREATE TABLE `gallery` (
`gallery_id` INT(10) NOT NULL DEFAULT '0',
`country` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`city` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`photo` VARCHAR(300) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
PRIMARY KEY (`gallery_id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;


*********************************************************


CREATE TABLE `customer_comments` (
`comment_id` INT(10) NOT NULL DEFAULT '0',
`comment_title` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8_unicode_ci',
`comment_subject` TEXT NULL COLLATE 'utf8_unicode_ci',
PRIMARY KEY (`comment_id`)
)
COLLATE='utf8_unicode_ci'
ENGINE=InnoDB;

اخواني ممكن المساعدة تكفون