<?php

declare(strict_types=1);

namespace LinkCheckup\Shared\Database;

final class Tables {

	public function __construct( private string $prefix ) {
	}

	public function links(): string {
		return $this->prefix . 'link_checkup_links';
	}

	public function uses(): string {
		return $this->prefix . 'link_checkup_uses';
	}

	public function fixes(): string {
		return $this->prefix . 'link_checkup_fixes';
	}

	public function link_columns(): string {
		return 'links.*, (SELECT COUNT(*) FROM ' . $this->uses()
			. ' uses WHERE uses.link_id = links.id) AS uses_count';
	}
}