Untitled

CREATE TABLE Randevu (
    RandevuID INT NOT NULL,
    RandevuTarih VARCHAR(10) NULL,
    RandevuSaat VARCHAR(5) NULL,
    RandevuBrans VARCHAR(30) NULL,
    RandevuDoktor VARCHAR(20) NULL,
    RandevuDurum BIT NULL,
    HastaTC VARCHAR(11) NULL,
    HastaSikayet VARCHAR(250) NULL,
    PRIMARY KEY (RandevuID)
);



CREATE TABLE Duyuru (
    DuyuruID SMALLINT NOT NULL,
    Duyuru VARCHAR(200) NULL,
    PRIMARY KEY (DuyuruID)
);



CREATE TABLE Brans (
    BransID TINYINT NOT NULL,
    BransAd VARCHAR(30) NULL,
    PRIMARY KEY (BransID)
);



CREATE TABLE Sekreter (
    SekreterID TINYINT NOT NULL,
    SekreterAdSoyad VARCHAR(20) NULL,
    SekreterTC CHAR(11) NULL,
    SekreterSifre VARCHAR(10) NULL,
    PRIMARY KEY (SekreterID)
);