DROP TABLE IF the EXISTS ` teams `;
The CREATE TABLE ` teams ` (
` id ` INT (64) NOT NULL COMMENT 'group id,
` name ` INT (64) NOT NULL COMMENT 'group ID,
` description ` INT (64) NOT NULL COMMENT 'group',
The PRIMARY KEY (` id `)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
/* Table structure for Table ` user ` */
DROP TABLE IF the EXISTS ` users `;
The CREATE TABLE ` users ` (
` id ` INT (64) NOT NULL COMMENT 'user id',
` team_id ` INT (64) NOT NULL COMMENT 'group ID,
The PRIMARY KEY (` id `)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
/* Table structure for Table ` tasks ` */
DROP TABLE IF the EXISTS ` tasks `;
The CREATE TABLE ` tasks ` (
` task_id ` INT (64) NOT NULL COMMENT 'task ID,
` user_id ` INT (64) NOT NULL COMMENT 'user ID',
` team_id ` INT (32) NOT NULL COMMENT 'group ID,
PRIMARY KEY (task_id `)
) ENGINE=INNODB DEFAULT CHARSET=utf8;
For output the following fields: count (users. Id) as user_count, count (tasks. Task_id) as tasks_count, name (team), id (team), the description (team).
CodePudding user response:
What meaning, don't understand,