Skip to content

Instantly share code, notes, and snippets.

@workmaster2n

workmaster2n/EXPLAIN SELECT

Created April 11, 2012 22:42
Show Gist options
  • Save workmaster2n/2363255 to your computer and use it in GitHub Desktop.
Save workmaster2n/2363255 to your computer and use it in GitHub Desktop.
Download ZIP
slow order by
Raw
account indexes
+----------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+----------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| accounts | 0 | PRIMARY | 1 | id | A | 28927 | NULL | NULL | | BTREE | | |
| accounts | 1 | AccountId | 1 | AccountId | A | 28927 | NULL | NULL | YES | BTREE | | |
| accounts | 1 | Name | 1 | Name | A | 28927 | NULL | NULL | YES | BTREE | | |
| accounts | 1 | id_name | 1 | id | A | 206 | NULL | NULL | | BTREE | | |
| accounts | 1 | id_name | 2 | Name | A | 206 | NULL | NULL | YES | BTREE | | |
+----------+------------+-----------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
Raw
accounts
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| AccountId | varchar(255) | YES | MUL | NULL | |
| AccountIdTemp | varchar(255) | YES | | NULL | |
| HighSchoolTempId | varchar(255) | YES | | NULL | |
| IsActive | tinyint(1) | YES | | NULL | |
| IsVisible | tinyint(1) | YES | | NULL | |
| IsPaidAd | varchar(255) | YES | | NULL | |
| boolean | varchar(255) | YES | | NULL | |
| Name | varchar(255) | YES | MUL | NULL | |
| CommonName | varchar(255) | YES | | NULL | |
| ShortName | varchar(255) | YES | | NULL | |
| AbbreviatedName | varchar(255) | YES | | NULL | |
| OtherName | varchar(255) | YES | | NULL | |
| NickName | varchar(255) | YES | | NULL | |
| FemaleNickName | varchar(255) | YES | | NULL | |
| KeywordAlias | varchar(255) | YES | | NULL | |
| AccountTypeId | int(11) | YES | | NULL | |
| TribuneName | varchar(255) | YES | | NULL | |
| Division | varchar(255) | YES | | NULL | |
| ConferenceId | int(11) | YES | | NULL | |
| Address | varchar(255) | YES | | NULL | |
| AddressLine2 | varchar(255) | YES | | NULL | |
| City | varchar(255) | YES | | NULL | |
| State | varchar(255) | YES | | NULL | |
| Zip | varchar(255) | YES | | NULL | |
| Zip4 | int(11) | YES | | NULL | |
| Country | varchar(255) | YES | | NULL | |
| Website | varchar(255) | YES | | NULL | |
| VideoLink | varchar(255) | YES | | NULL | |
| SiteProvider | varchar(255) | YES | | NULL | |
| VideoProvider | varchar(255) | YES | | NULL | |
| Latitude | varchar(255) | YES | | NULL | |
| Longitude | varchar(255) | YES | | NULL | |
| TimeZone | varchar(255) | YES | | NULL | |
| Colors | varchar(255) | YES | | NULL | |
| Logo | varchar(255) | YES | | NULL | |
| LogoImage | varchar(255) | YES | | NULL | |
| MonthlyFee | varchar(255) | YES | | NULL | |
| AnnualFee | varchar(255) | YES | | NULL | |
| RadioStation | varchar(255) | YES | | NULL | |
| TVStation | varchar(255) | YES | | NULL | |
| TicketOfficeLink | varchar(255) | YES | | NULL | |
| TicketOfficePhone | varchar(255) | YES | | NULL | |
| DST | varchar(255) | YES | | NULL | |
| Mascot | varchar(255) | YES | | NULL | |
| NCES_PSS_Id | varchar(255) | YES | | NULL | |
| County | varchar(255) | YES | | NULL | |
| CountyFipsId | varchar(255) | YES | | NULL | |
| Phone | varchar(255) | YES | | NULL | |
| PublicSchool | varchar(255) | YES | | NULL | |
| LocaleCode | varchar(255) | YES | | NULL | |
| NumberOfStudents | varchar(255) | YES | | NULL | |
| Enrollment_9to12 | varchar(255) | YES | | NULL | |
| MaleStudents | varchar(255) | YES | | NULL | |
| FemaleStudents | varchar(255) | YES | | NULL | |
| Coed | varchar(255) | YES | | NULL | |
| LowestGradeLevel | varchar(255) | YES | | NULL | |
| HighestGradeLevel | varchar(255) | YES | | NULL | |
| Title1 | varchar(255) | YES | | NULL | |
| SchoolType | varchar(255) | YES | | NULL | |
| SEC_Comb | varchar(255) | YES | | NULL | |
| Affiliation | varchar(255) | YES | | NULL | |
| SearchSortorder | varchar(255) | YES | | NULL | |
| CreationDate | varchar(255) | YES | | NULL | |
| CreatedBy | varchar(255) | YES | | NULL | |
| LastModifiedDate | varchar(255) | YES | | NULL | |
| LastModifiedBy | varchar(255) | YES | | NULL | |
| CompName | varchar(255) | YES | | NULL | |
| Show | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
Raw
EXPLAIN SELECT
+----+-------------+----------+--------+---------------------+---------+---------+------------------------------------+-------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------+--------+---------------------+---------+---------+------------------------------------+-------+---------------------------------+
| 1 | SIMPLE | teams | ALL | fk_teams_account_id | NULL | NULL | NULL | 15707 | Using temporary; Using filesort |
| 1 | SIMPLE | accounts | eq_ref | PRIMARY | PRIMARY | 4 | mysql_development.teams.account_id | 1 | |
+----+-------------+----------+--------+---------------------+---------+---------+------------------------------------+-------+---------------------------------+
2 rows in set (0.00 sec)
Raw
EXTENDED EXPLAIN
mysql> EXPLAIN EXTENDED SELECT * FROM teams INNER JOIN accounts ON teams.account_id = accounts.id ORDER BY accounts.Name\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: teams
type: ALL
possible_keys: fk_teams_account_id
key: NULL
key_len: NULL
ref: NULL
rows: 15707
filtered: 100.00
Extra: Using temporary; Using filesort
*************************** 2. row ***************************
id: 1
select_type: SIMPLE
table: accounts
type: eq_ref
possible_keys: PRIMARY
key: PRIMARY
key_len: 4
ref: mysql_development.teams.account_id
rows: 1
filtered: 100.00
Extra:
2 rows in set, 1 warning (0.00 sec)
| Note | 1003 | select `mysql_development`.`teams`.`id` AS `id`,`mysql_development`.`teams`.`IsActive` AS `IsActive`,`mysql_development`.`teams`.`IsVisible` AS `IsVisible`,`mysql_development`.`teams`.`AccountId` AS `AccountId`,`mysql_development`.`teams`.`AccountIdTemp` AS `AccountIdTemp`,`mysql_development`.`teams`.`Name` AS `Name`,`mysql_development`.`teams`.`SportTypeId` AS `SportTypeId`,`mysql_development`.`teams`.`ConferenceId` AS `ConferenceId`,`mysql_development`.`teams`.`Division` AS `Division`,`mysql_development`.`teams`.`NationalRanking` AS `NationalRanking`,`mysql_development`.`teams`.`CreationDate` AS `CreationDate`,`mysql_development`.`teams`.`CreatedBy` AS `CreatedBy`,`mysql_development`.`teams`.`LastModifiedDate` AS `LastModifiedDate`,`mysql_development`.`teams`.`LastModifiedBy` AS `LastModifiedBy`,`mysql_development`.`teams`.`LeagueID` AS `LeagueID`,`mysql_development`.`teams`.`ChildConferenceID` AS `ChildConferenceID`,`mysql_development`.`teams`.`Show` AS `Show`,`mysql_development`.`teams`.`NextLevel` AS `NextLevel`,`mysql_development`.`teams`.`HomeVenue` AS `HomeVenue`,`mysql_development`.`teams`.`SD_SportID` AS `SD_SportID`,`mysql_development`.`teams`.`SD_SportName` AS `SD_SportName`,`mysql_development`.`teams`.`SD_LeagueID` AS `SD_LeagueID`,`mysql_development`.`teams`.`SD_LeagueName` AS `SD_LeagueName`,`mysql_development`.`teams`.`SD_TeamID` AS `SD_TeamID`,`mysql_development`.`teams`.`LoadID` AS `LoadID`,`mysql_development`.`teams`.`RosterLink` AS `RosterLink`,`mysql_development`.`teams`.`ScheduleLink` AS `ScheduleLink`,`mysql_development`.`teams`.`created_at` AS `created_at`,`mysql_development`.`teams`.`updated_at` AS `updated_at`,`mysql_development`.`teams`.`account_id` AS `account_id`,`mysql_development`.`accounts`.`id` AS `id`,`mysql_development`.`accounts`.`AccountId` AS `AccountId`,`mysql_development`.`accounts`.`AccountIdTemp` AS `AccountIdTemp`,`mysql_development`.`accounts`.`HighSchoolTempId` AS `HighSchoolTempId`,`mysql_development`.`accounts`.`IsActive` AS `IsActive`,`mysql_development`.`accounts`.`IsVisible` AS `IsVisible`,`mysql_development`.`accounts`.`IsPaidAd` AS `IsPaidAd`,`mysql_development`.`accounts`.`boolean` AS `boolean`,`mysql_development`.`accounts`.`Name` AS `Name`,`mysql_development`.`accounts`.`CommonName` AS `CommonName`,`mysql_development`.`accounts`.`ShortName` AS `ShortName`,`mysql_development`.`accounts`.`AbbreviatedName` AS `AbbreviatedName`,`mysql_development`.`accounts`.`OtherName` AS `OtherName`,`mysql_development`.`accounts`.`NickName` AS `NickName`,`mysql_development`.`accounts`.`FemaleNickName` AS `FemaleNickName`,`mysql_development`.`accounts`.`KeywordAlias` AS `KeywordAlias`,`mysql_development`.`accounts`.`AccountTypeId` AS `AccountTypeId`,`mysql_development`.`accounts`.`TribuneName` AS `TribuneName`,`mysql_development`.`accounts`.`Division` AS `Division`,`mysql_development`.`accounts`.`ConferenceId` AS `ConferenceId`,`mysql_development`.`accounts`.`Address` AS `Address`,`mysql_development`.`accounts`.`AddressLine2` AS `AddressLine2`,`mysql_development`.`accounts`.`City` AS `City`,`mysql_development`.`accounts`.`State` AS `State`,`mysql_development`.`accounts`.`Zip` AS `Zip`,`mysql_development`.`accounts`.`Zip4` AS `Zip4`,`mysql_development`.`accounts`.`Country` AS `Country`,`mysql_development`.`accounts`.`Website` AS `Website`,`mysql_development`.`accounts`.`VideoLink` AS `VideoLink`,`mysql_development`.`accounts`.`SiteProvider` AS `SiteProvider`,`mysql_development`.`accounts`.`VideoProvider` AS `VideoProvider`,`mysql_development`.`accounts`.`Latitude` AS `Latitude`,`mysql_development`.`accounts`.`Longitude` AS `Longitude`,`mysql_development`.`accounts`.`TimeZone` AS `TimeZone`,`mysql_development`.`accounts`.`Colors` AS `Colors`,`mysql_development`.`accounts`.`Logo` AS `Logo`,`mysql_development`.`accounts`.`LogoImage` AS `LogoImage`,`mysql_development`.`accounts`.`MonthlyFee` AS `MonthlyFee`,`mysql_development`.`accounts`.`AnnualFee` AS `AnnualFee`,`mysql_development`.`accounts`.`RadioStation` AS `RadioStation`,`mysql_development`.`accounts`.`TVStation` AS `TVStation`,`mysql_development`.`accounts`.`TicketOfficeLink` AS `TicketOfficeLink`,`mysql_development`.`accounts`.`TicketOfficePhone` AS `TicketOfficePhone`,`mysql_development`.`accounts`.`DST` AS `DST`,`mysql_development`.`accounts`.`Mascot` AS `Mascot`,`mysql_development`.`accounts`.`NCES_PSS_Id` AS `NCES_PSS_Id`,`mysql_development`.`accounts`.`County` AS `County`,`mysql_development`.`accounts`.`CountyFipsId` AS `CountyFipsId`,`mysql_development`.`accounts`.`Phone` AS `Phone`,`mysql_development`.`accounts`.`PublicSchool` AS `PublicSchool`,`mysql_development`.`accounts`.`LocaleCode` AS `LocaleCode`,`mysql_development`.`accounts`.`NumberOfStudents` AS `NumberOfStudents`,`mysql_development`.`accounts`.`Enrollment_9to12` AS `Enrollment_9to12`,`mysql_development`.`accounts`.`MaleStudents` AS `MaleStudents`,`mysql_development`.`accounts`.`FemaleStudents` AS `FemaleStudents`,`mysql_development`.`accounts`.`Coed` AS `Coed`,`mysql_development`.`accounts`.`LowestGradeLevel` AS `LowestGradeLevel`,`mysql_development`.`accounts`.`HighestGradeLevel` AS `HighestGradeLevel`,`mysql_development`.`accounts`.`Title1` AS `Title1`,`mysql_development`.`accounts`.`SchoolType` AS `SchoolType`,`mysql_development`.`accounts`.`SEC_Comb` AS `SEC_Comb`,`mysql_development`.`accounts`.`Affiliation` AS `Affiliation`,`mysql_development`.`accounts`.`SearchSortorder` AS `SearchSortorder`,`mysql_development`.`accounts`.`CreationDate` AS `CreationDate`,`mysql_development`.`accounts`.`CreatedBy` AS `CreatedBy`,`mysql_development`.`accounts`.`LastModifiedDate` AS `LastModifiedDate`,`mysql_development`.`accounts`.`LastModifiedBy` AS `LastModifiedBy`,`mysql_development`.`accounts`.`CompName` AS `CompName`,`mysql_development`.`accounts`.`Show` AS `Show`,`mysql_development`.`accounts`.`created_at` AS `created_at`,`mysql_development`.`accounts`.`updated_at` AS `updated_at` from `mysql_development`.`teams` join `mysql_development`.`accounts` where (`mysql_development`.`accounts`.`id` = `mysql_development`.`teams`.`account_id`) order by `mysql_development`.`accounts`.`Name` |
Raw
SHOW CREATE TABLE accounts
Create Table: CREATE TABLE `accounts` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`AccountId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`AccountIdTemp` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`HighSchoolTempId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`IsActive` tinyint(1) DEFAULT NULL,
`IsVisible` tinyint(1) DEFAULT NULL,
`IsPaidAd` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`boolean` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`CommonName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ShortName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`AbbreviatedName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`OtherName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`NickName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`FemaleNickName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`KeywordAlias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`AccountTypeId` int(11) DEFAULT NULL,
`TribuneName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Division` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ConferenceId` int(11) DEFAULT NULL,
`Address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`AddressLine2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`City` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`State` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Zip` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Zip4` int(11) DEFAULT NULL,
`Country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Website` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`VideoLink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SiteProvider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`VideoProvider` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Latitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Longitude` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`TimeZone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Colors` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LogoImage` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`MonthlyFee` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`AnnualFee` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`RadioStation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`TVStation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`TicketOfficeLink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`TicketOfficePhone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`DST` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Mascot` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`NCES_PSS_Id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`County` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`CountyFipsId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`PublicSchool` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LocaleCode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`NumberOfStudents` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Enrollment_9to12` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`MaleStudents` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`FemaleStudents` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Coed` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LowestGradeLevel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`HighestGradeLevel` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Title1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SchoolType` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SEC_Comb` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Affiliation` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SearchSortorder` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`CreationDate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`CreatedBy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LastModifiedDate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LastModifiedBy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`CompName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`Show` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `AccountId` (`AccountId`),
KEY `Name` (`Name`)
) ENGINE=InnoDB AUTO_INCREMENT=28445 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Raw
SHOW CREATE TABLE teams
Create Table: CREATE TABLE `teams` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`IsActive` tinyint(1) DEFAULT NULL,
`IsVisible` tinyint(1) DEFAULT NULL,
`AccountId` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`AccountIdTemp` int(11) DEFAULT NULL,
`Name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SportTypeId` int(11) DEFAULT NULL,
`ConferenceId` int(11) DEFAULT NULL,
`Division` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`NationalRanking` int(11) DEFAULT NULL,
`CreationDate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`CreatedBy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LastModifiedDate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LastModifiedBy` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LeagueID` int(11) DEFAULT NULL,
`ChildConferenceID` int(11) DEFAULT NULL,
`Show` tinyint(1) DEFAULT NULL,
`NextLevel` int(11) DEFAULT NULL,
`HomeVenue` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SD_SportID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SD_SportName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SD_LeagueID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SD_LeagueName` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`SD_TeamID` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`LoadID` int(11) DEFAULT NULL,
`RosterLink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`ScheduleLink` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` datetime NOT NULL,
`updated_at` datetime NOT NULL,
`account_id` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `AccountId` (`AccountId`),
KEY `fk_teams_account_id` (`account_id`),
CONSTRAINT `teams_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46311 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
1 row in set (0.00 sec)
Raw
sql
SELECT *
FROM teams
INNER JOIN accounts
ON teams.account_id = accounts.id
ORDER BY accounts.Name
Raw
teams
+-------------------+--------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------------+--------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| IsActive | tinyint(1) | YES | | NULL | |
| IsVisible | tinyint(1) | YES | | NULL | |
| AccountId | varchar(255) | YES | MUL | NULL | |
| AccountIdTemp | int(11) | YES | | NULL | |
| Name | varchar(255) | YES | | NULL | |
| SportTypeId | int(11) | YES | | NULL | |
| ConferenceId | int(11) | YES | | NULL | |
| Division | varchar(255) | YES | | NULL | |
| NationalRanking | int(11) | YES | | NULL | |
| CreationDate | varchar(255) | YES | | NULL | |
| CreatedBy | varchar(255) | YES | | NULL | |
| LastModifiedDate | varchar(255) | YES | | NULL | |
| LastModifiedBy | varchar(255) | YES | | NULL | |
| LeagueID | int(11) | YES | | NULL | |
| ChildConferenceID | int(11) | YES | | NULL | |
| Show | tinyint(1) | YES | | NULL | |
| NextLevel | int(11) | YES | | NULL | |
| HomeVenue | varchar(255) | YES | | NULL | |
| SD_SportID | varchar(255) | YES | | NULL | |
| SD_SportName | varchar(255) | YES | | NULL | |
| SD_LeagueID | varchar(255) | YES | | NULL | |
| SD_LeagueName | varchar(255) | YES | | NULL | |
| SD_TeamID | varchar(255) | YES | | NULL | |
| LoadID | int(11) | YES | | NULL | |
| RosterLink | varchar(255) | YES | | NULL | |
| ScheduleLink | varchar(255) | YES | | NULL | |
| created_at | datetime | NO | | NULL | |
| updated_at | datetime | NO | | NULL | |
| account_id | int(11) | YES | MUL | NULL | |
+-------------------+--------------+------+-----+---------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment