view_paper.php?year=2025&volume=1&serial=0

i want the link of each and every paper like this only 

how to make 

-- Users Table
CREATE TABLE users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  email VARCHAR(255) NOT NULL UNIQUE,
  password_hash VARCHAR(255) NOT NULL,
  role ENUM('author','reviewer','publisher','admin') NOT NULL,
  affiliation VARCHAR(255),
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Volumes Table
CREATE TABLE volumes (
  id INT AUTO_INCREMENT PRIMARY KEY,
  volume_number INT NOT NULL,
  year INT NOT NULL,
  UNIQUE KEY unique_volume_year (volume_number, year)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Issues Table
CREATE TABLE issues (
  id INT AUTO_INCREMENT PRIMARY KEY,
  volume_id INT NOT NULL,
  issue_number INT NOT NULL,
  month VARCHAR(20),
  publication_date DATE,
  cover_image_path VARCHAR(255),
  FOREIGN KEY (volume_id) REFERENCES volumes(id) ON DELETE CASCADE,
  UNIQUE KEY unique_volume_issue (volume_id, issue_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Submitted Papers Table
CREATE TABLE submitted_papers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  abstract TEXT NOT NULL,
  keywords VARCHAR(255),
  pdf_path VARCHAR(255) NOT NULL,
  is_peer_reviewed TINYINT(1) DEFAULT 0,
  status ENUM('Submitted','Reviewed','Published') DEFAULT 'Submitted',
  submission_date DATETIME DEFAULT CURRENT_TIMESTAMP,
  registered_author_id INT NOT NULL,
  fee_structure VARCHAR(255),
  transaction_id VARCHAR(255),
  payment_slip_path VARCHAR(255),
  volume_id INT NULL,
  issue_id INT NULL,
  FOREIGN KEY (registered_author_id) REFERENCES users(id),
  FOREIGN KEY (volume_id) REFERENCES volumes(id) ON DELETE SET NULL,
  FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Papers (Published) Table
CREATE TABLE papers (
  id INT AUTO_INCREMENT PRIMARY KEY,
  title VARCHAR(255) NOT NULL,
  abstract TEXT NOT NULL,
  keywords VARCHAR(255),
  pdf_path VARCHAR(255) NOT NULL,
  is_peer_reviewed TINYINT(1) DEFAULT 0,
  status ENUM('Published') DEFAULT 'Published',
  registered_author_id INT NOT NULL,
  submission_date DATETIME,
  volume_id INT NULL,
  issue_id INT NULL,
  fee_structure VARCHAR(255),
  transaction_id VARCHAR(255),
  payment_slip_path VARCHAR(255),
  views INT DEFAULT 0,
  FOREIGN KEY (registered_author_id) REFERENCES users(id),
  FOREIGN KEY (volume_id) REFERENCES volumes(id) ON DELETE SET NULL,
  FOREIGN KEY (issue_id) REFERENCES issues(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Paper Authors Table (many-to-many)
CREATE TABLE paper_authors (
  id INT AUTO_INCREMENT PRIMARY KEY,
  paper_id INT NOT NULL,
  user_id INT NULL,
  author_order INT NOT NULL,
  corresponding BOOLEAN DEFAULT FALSE,
  author_name VARCHAR(255), -- Needed if author is external, i.e., no user_id
  FOREIGN KEY (paper_id) REFERENCES papers(id) ON DELETE CASCADE,
  FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE SET NULL,
  UNIQUE KEY unique_paper_author_order (paper_id, author_order)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Peer Review Comments Table
CREATE TABLE peer_review_comments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  paper_id INT NOT NULL,
  comment_number INT NOT NULL,
  comment_text TEXT NOT NULL,
  created_by INT NOT NULL,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (paper_id) REFERENCES papers(id) ON DELETE CASCADE,
  FOREIGN KEY (created_by) REFERENCES users(id),
  UNIQUE KEY unique_paper_comment_number (paper_id, comment_number)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

this is database