SQLQuery2.sql

USE LibraryManagementSystem

CREATE TABLE users (
    id INT PRIMARY KEY IDENTITY(1,1),
    email NVARCHAR(100),
    username NVARCHAR(50),
    password NVARCHAR(100),
    date_register DATE
)

CREATE TABLE books (
    id INT PRIMARY KEY IDENTITY(1,1),
    book_title VARCHAR(100),
    author VARCHAR(100),
    published DATE,
    status VARCHAR(50),
    date_insert DATETIME DEFAULT GETDATE(),
    date_updated DATETIME NULL,
    date_deleted DATETIME NULL,
    image VARCHAR(50)
)

CREATE TABLE issue_books (
    id INT PRIMARY KEY IDENTITY(1,1),
    issue_id INT,
    full_name VARCHAR(100),
    contact VARCHAR(50),
    email VARCHAR(100),
    book_title VARCHAR(100),
    author VARCHAR(100),
    image VARCHAR(100),
    issue_date DATE,
    return_date DATE,
    date_insert DATETIME,
    date_update DATETIME,
    date_deleted DATETIME,
    status VARCHAR(50)
)
USE LibraryManagementSystem
SELECT*FROM users 
SELECT*FROM books
SELECT*FROM issue_books