-- Kullanıcılar tablosu
CREATE TABLE Users (
UserID INT PRIMARY KEY,
Username NVARCHAR(50) NOT NULL,
Password NVARCHAR(50) NOT NULL,
Email NVARCHAR(100) NOT NULL,
RegistrationDate DATETIME
);
-- Makaleler tablosu
CREATE TABLE Articles (
ArticleID INT PRIMARY KEY,
Title NVARCHAR(100) NOT NULL,
Content NVARCHAR(MAX) NOT NULL,
AuthorID INT,
PublishDate DATETIME,
CategoryID INT,
FOREIGN KEY (AuthorID) REFERENCES Authors(AuthorID),
FOREIGN KEY (CategoryID) REFERENCES Categories(CategoryID)
);
-- Yazarlar tablosu
CREATE TABLE Authors (
AuthorID INT PRIMARY KEY,
AuthorName NVARCHAR(100) NOT NULL
);
-- Kategoriler tablosu
CREATE TABLE Categories (
CategoryID INT PRIMARY KEY,
CategoryName NVARCHAR(100) NOT NULL
);
-- Yorumlar tablosu
CREATE TABLE Comments (
CommentID INT PRIMARY KEY,
ArticleID INT,
UserID INT,
CommentText NVARCHAR(MAX) NOT NULL,
CommentDate DATETIME,
FOREIGN KEY (ArticleID) REFERENCES Articles(ArticleID),
FOREIGN KEY (UserID) REFERENCES Users(UserID)
);