|
(4, 'Kamol Ikromov', '2022-11-09', 'gripp,shamollash', 'coronavirus')
|
bet | 3/4 | Sana | 27.01.2023 | Hajmi | 1.41 Mb. | | #39841 |
Bog'liq 410-21 RamazonovUmrzoq 30. Konstruksion materiallar texnologiyasi. Mirboboyev V.A, 1.Psixologiya fanining predmeti, maqsad va vazifalari, moliya va fiskal siyosati, Behzod(4, 'Kamol Ikromov', '2022-11-09', 'gripp,shamollash', 'coronavirus'),
(5, 'Xalima Yunusova', '2022-11-20', 'sariq kasalligi', 'sariq kasal');
Oxirgi yaratadigan jadval nomi esa doktorlar nomli jadval
4-rasm.Diseaseds jadvali
CREATE TABLE `Doctors` (
`id` int NOT NULL,
`doctor_name` varchar(35) NOT NULL,
`position` text NOT NULL,
Primary Key(id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
Bu jadvalga ma’lumot kiritamiz.
INSERT INTO `Doctors` (`id`, `doctor_name`, `position`) VALUES
(1, 'Otabek Usmonov', 'Vrach'),
(2, 'Soliha Nosirova', 'Katta Hamshira'),
(3, 'Bahodir Turdiyev', 'Bosh Shifokor'),
(4, 'Robiya To\'xtayeva', 'Stomatolog'),
(5, 'G\'anisher Abdullayev', 'Ko\'z shifokori');
5-rasm.Doctors jadvali
Keyingi jadvalimiz asosiy jadval bo’lib bemor haqida umumiy ma’lumot beradigan bemorga biriktirilgan doktor,bemorning kasalligi va bemor haqidagi ma’lumotlarni o’z ichiga oladigan ‘general_information’ jadvali hisoblanadi.Bu jadvalda biz doctors,dieases,diseades jadvallaridagi id larni FOREIGN KEY orqali ulashni ko’rib chiqamiz
CREATE TABLE `general_information` (
`id` int NOT NULL,
`diseased_name` varchar(30) NOT NULL,
`diseaes_id` int NOT NULL,
`diseaseds_id` int NOT NULL,
`doctors_id` int NOT NULL,
Primary Key(id),
FOREIGN KEY(diseaes_id) REFERENCES Diseaes(id),
|
| |