CREATE TABLE Hastalar ( PatientID INT PRIMARY KEY AUTO_INCREMENT, Ad VARCHAR(50) NOT NULL, Soyad VARCHAR(50) NOT NULL, TCKN CHAR(11) UNIQUE NOT NULL, DogumTarihi DATE NOT NULL, Cinsiyet ENUM('Erkek', 'Kadın', 'Diğer') NOT NULL, Telefon VARCHAR(20), Eposta VARCHAR(100), Adres TEXT, Boy DECIMAL(5,2), Kilo DECIMAL(5,2), SigortaTuru ENUM('SGK', 'Özel', 'Yok'), Alerjiler TEXT, KronikHastaliklar TEXT, KanGrubu ENUM('A+', 'A-', 'B+', 'B-', 'AB+', 'AB-', 'O+', 'O-') );
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter