-- --------------------------------------------------------
-- Host:                         127.0.0.1
-- Server version:               10.4.22-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Version:             11.3.0.6295
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!50503 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


-- Dumping database structure for quan_ly_bong_da
CREATE DATABASE IF NOT EXISTS `quan_ly_bong_da` /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */;
USE `quan_ly_bong_da`;

-- Dumping structure for table quan_ly_bong_da.cauthu
CREATE TABLE IF NOT EXISTS `cauthu` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ma_cau_thu` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ten_cau_thu` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ngay_sinh` datetime DEFAULT NULL,
  `quoc_tich` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table lưu trữ thông tin cầu thủ';

-- Dumping data for table quan_ly_bong_da.cauthu: ~5 rows (approximately)
/*!40000 ALTER TABLE `cauthu` DISABLE KEYS */;
INSERT INTO `cauthu` (`id`, `ma_cau_thu`, `ten_cau_thu`, `ngay_sinh`, `quoc_tich`) VALUES
	(1, 'CT001', 'Dương Nguyễn Phú Cường', '1989-06-11 03:04:48', 'Việt Nam'),
	(2, 'CT002', 'Nguyễn Cầu Thủ 2', '1993-04-15 00:00:00', 'Việt Nam'),
	(3, 'CT003', 'Trần Cầu Thủ 3', '1995-09-09 17:15:00', 'Việt Nam'),
	(4, 'CT004', 'Dương Văn Thủ 4', '1969-04-22 03:06:05', 'Việt Nam'),
	(5, 'CT005', 'Trần Văn 5', '1999-04-22 03:12:00', 'Việt Nam');
/*!40000 ALTER TABLE `cauthu` ENABLE KEYS */;

-- Dumping structure for table quan_ly_bong_da.doibong
CREATE TABLE IF NOT EXISTS `doibong` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ma_doi_bong` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ten_doi_bong` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ngay_thanh_lap` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table lưu trữ thông tin Đội bóng';

-- Dumping data for table quan_ly_bong_da.doibong: ~3 rows (approximately)
/*!40000 ALTER TABLE `doibong` DISABLE KEYS */;
INSERT INTO `doibong` (`id`, `ma_doi_bong`, `ten_doi_bong`, `ngay_thanh_lap`) VALUES
	(1, 'DB001', 'Đội Cần Thơ', '2000-01-01 00:00:06'),
	(2, 'DB002', 'Đội Sóc Trăng', '2001-03-01 00:00:00'),
	(3, 'DB003', 'Đội Vĩnh Long', '2005-06-07 00:00:00');
/*!40000 ALTER TABLE `doibong` ENABLE KEYS */;

-- Dumping structure for table quan_ly_bong_da.doibong_banhuanluyen
CREATE TABLE IF NOT EXISTS `doibong_banhuanluyen` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `doibong_id` bigint(20) unsigned NOT NULL,
  `hlv_id` bigint(20) unsigned NOT NULL,
  `vaitro` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `doibong_id_hlv_id` (`doibong_id`,`hlv_id`),
  KEY `FK_doibong_banhuanluyen_huanluyenvien` (`hlv_id`),
  CONSTRAINT `FK_doibong_banhuanluyen_doibong` FOREIGN KEY (`doibong_id`) REFERENCES `doibong` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_doibong_banhuanluyen_huanluyenvien` FOREIGN KEY (`hlv_id`) REFERENCES `huanluyenvien` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Table lưu trữ thông tin về Thành viên đội bóng (Chỉ các cầu thủ)';

-- Dumping data for table quan_ly_bong_da.doibong_banhuanluyen: ~3 rows (approximately)
/*!40000 ALTER TABLE `doibong_banhuanluyen` DISABLE KEYS */;
INSERT INTO `doibong_banhuanluyen` (`id`, `doibong_id`, `hlv_id`, `vaitro`) VALUES
	(1, 1, 1, 'Huấn luyện viên Trưởng'),
	(2, 1, 2, 'Huấn luyện viên Phó 1'),
	(3, 1, 3, 'Huấn luyện viên Phó 2');
/*!40000 ALTER TABLE `doibong_banhuanluyen` ENABLE KEYS */;

-- Dumping structure for table quan_ly_bong_da.doibong_thanhvien
CREATE TABLE IF NOT EXISTS `doibong_thanhvien` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `doibong_id` bigint(20) unsigned NOT NULL,
  `cauthu_id` bigint(20) unsigned NOT NULL,
  `vaitro` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `doibong_id_cauthu_id` (`doibong_id`,`cauthu_id`),
  KEY `FK_doibong_thanhvien_cauthu` (`cauthu_id`),
  CONSTRAINT `FK_doibong_thanhvien_cauthu` FOREIGN KEY (`cauthu_id`) REFERENCES `cauthu` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_doibong_thanhvien_doibong` FOREIGN KEY (`doibong_id`) REFERENCES `doibong` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table lưu trữ thông tin về Thành viên đội bóng (Chỉ các cầu thủ)';

-- Dumping data for table quan_ly_bong_da.doibong_thanhvien: ~5 rows (approximately)
/*!40000 ALTER TABLE `doibong_thanhvien` DISABLE KEYS */;
INSERT INTO `doibong_thanhvien` (`id`, `doibong_id`, `cauthu_id`, `vaitro`) VALUES
	(1, 1, 1, 'Chính thức'),
	(2, 1, 2, 'Chính thức'),
	(3, 1, 3, 'Dự bị'),
	(4, 2, 4, 'Chính thức'),
	(5, 2, 5, 'Chính thức');
/*!40000 ALTER TABLE `doibong_thanhvien` ENABLE KEYS */;

-- Dumping structure for table quan_ly_bong_da.huanluyenvien
CREATE TABLE IF NOT EXISTS `huanluyenvien` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ma_hlv` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ten_hlv` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ngay_sinh` datetime DEFAULT NULL,
  `quoc_tich` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC COMMENT='Table lưu trữ thông tin cầu thủ';

-- Dumping data for table quan_ly_bong_da.huanluyenvien: ~3 rows (approximately)
/*!40000 ALTER TABLE `huanluyenvien` DISABLE KEYS */;
INSERT INTO `huanluyenvien` (`id`, `ma_hlv`, `ten_hlv`, `ngay_sinh`, `quoc_tich`) VALUES
	(1, 'HLV001', 'Luyện viên 1', '1950-04-22 03:07:41', 'Việt Nam'),
	(2, 'HLV002', 'Luyen luyen', '1973-06-15 03:08:02', 'Lào'),
	(3, 'HLV003', 'Patrick Beck', '1958-07-08 03:08:45', 'Pháp');
/*!40000 ALTER TABLE `huanluyenvien` ENABLE KEYS */;

-- Dumping structure for table quan_ly_bong_da.trandau
CREATE TABLE IF NOT EXISTS `trandau` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ma_tran_dau` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ten_tran_dau` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ngay_thi_dau` datetime DEFAULT NULL,
  `san_thi_dau` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `doibong_id_1` bigint(20) unsigned NOT NULL,
  `doibong_id_2` bigint(20) unsigned NOT NULL,
  `ty_so` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_trandau_doibong` (`doibong_id_1`),
  KEY `FK_trandau_doibong_2` (`doibong_id_2`),
  CONSTRAINT `FK_trandau_doibong` FOREIGN KEY (`doibong_id_1`) REFERENCES `doibong` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_trandau_doibong_2` FOREIGN KEY (`doibong_id_2`) REFERENCES `doibong` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table lưu trữ thông tin chung về Trận đấu';

-- Dumping data for table quan_ly_bong_da.trandau: ~1 rows (approximately)
/*!40000 ALTER TABLE `trandau` DISABLE KEYS */;
INSERT INTO `trandau` (`id`, `ma_tran_dau`, `ten_tran_dau`, `ngay_thi_dau`, `san_thi_dau`, `doibong_id_1`, `doibong_id_2`, `ty_so`) VALUES
	(1, 'TD001', 'Trận đấu mở màn Seagame 9999', '2023-04-22 19:00:00', 'Sân vận động Cần Thơ', 1, 2, '0-0');
/*!40000 ALTER TABLE `trandau` ENABLE KEYS */;

-- Dumping structure for table quan_ly_bong_da.trandau_dienbien
CREATE TABLE IF NOT EXISTS `trandau_dienbien` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `trandau_id` bigint(20) unsigned NOT NULL,
  `cauthu_id` bigint(20) unsigned NOT NULL,
  `thoigian` datetime NOT NULL,
  `sukien` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_trandau_dienbien_cauthu` (`cauthu_id`),
  KEY `FK_trandau_dienbien_trandau` (`trandau_id`),
  CONSTRAINT `FK_trandau_dienbien_cauthu` FOREIGN KEY (`cauthu_id`) REFERENCES `cauthu` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_trandau_dienbien_trandau` FOREIGN KEY (`trandau_id`) REFERENCES `trandau` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table lữu trữ thông tin diễn biến của trận đấu';

-- Dumping data for table quan_ly_bong_da.trandau_dienbien: ~5 rows (approximately)
/*!40000 ALTER TABLE `trandau_dienbien` DISABLE KEYS */;
INSERT INTO `trandau_dienbien` (`id`, `trandau_id`, `cauthu_id`, `thoigian`, `sukien`) VALUES
	(1, 1, 1, '2023-04-22 19:02:30', 'Ghi bàn'),
	(2, 1, 1, '2023-04-22 19:30:00', 'Thẻ vàng'),
	(3, 1, 2, '2023-04-22 19:32:15', 'Thẻ vàng'),
	(4, 1, 4, '2023-04-22 20:00:00', 'Ghi bàn'),
	(5, 1, 5, '2023-04-22 20:03:05', 'Thẻ đỏ');
/*!40000 ALTER TABLE `trandau_dienbien` ENABLE KEYS */;

-- Dumping structure for table quan_ly_bong_da.trandau_trongtai
CREATE TABLE IF NOT EXISTS `trandau_trongtai` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `trandau_id` bigint(20) unsigned NOT NULL,
  `trongtai_id` bigint(20) unsigned NOT NULL,
  `vaitro` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `trandau_id_trongtai_id` (`trandau_id`,`trongtai_id`),
  KEY `FK_trandau_trongtai_trongtai` (`trongtai_id`),
  CONSTRAINT `FK_trandau_trongtai_trandau` FOREIGN KEY (`trandau_id`) REFERENCES `trandau` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `FK_trandau_trongtai_trongtai` FOREIGN KEY (`trongtai_id`) REFERENCES `trongtai` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- Dumping data for table quan_ly_bong_da.trandau_trongtai: ~3 rows (approximately)
/*!40000 ALTER TABLE `trandau_trongtai` DISABLE KEYS */;
INSERT INTO `trandau_trongtai` (`id`, `trandau_id`, `trongtai_id`, `vaitro`) VALUES
	(1, 1, 1, 'Trọng tài chính'),
	(2, 1, 2, 'Trọng tài biên 1'),
	(3, 1, 3, 'Trọng tài biên 2');
/*!40000 ALTER TABLE `trandau_trongtai` ENABLE KEYS */;

-- Dumping structure for table quan_ly_bong_da.trongtai
CREATE TABLE IF NOT EXISTS `trongtai` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `ma_trong_tai` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ten_trong_tai` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ngay_sinh` datetime DEFAULT NULL,
  `quoc_tich` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Table lưu trữ thông tin về Trọng tài';

-- Dumping data for table quan_ly_bong_da.trongtai: ~3 rows (approximately)
/*!40000 ALTER TABLE `trongtai` DISABLE KEYS */;
INSERT INTO `trongtai` (`id`, `ma_trong_tai`, `ten_trong_tai`, `ngay_sinh`, `quoc_tich`) VALUES
	(1, 'TT001', 'Nguyễn Trọng Tài 1', '1993-06-08 03:06:34', 'Việt Nam'),
	(2, 'TT002', 'Nguyễn Tài 2', '1990-04-22 03:06:44', 'Việt Nam'),
	(3, 'TT003', 'Trần Tài 3', '2001-09-07 03:07:05', 'Việt Nam');
/*!40000 ALTER TABLE `trongtai` ENABLE KEYS */;

/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;