# jcfnba

**Repository Path**: cyyffc/jcfnba

## Basic Information

- **Project Name**: jcfnba
- **Description**: No description available
- **Primary Language**: Unknown
- **License**: AFL-3.0
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2023-12-21
- **Last Updated**: 2023-12-23

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

```mysql
CREATE TABLE teams (
    team_id INT PRIMARY KEY AUTO_INCREMENT,
    team_name VARCHAR(255) NOT NULL
);

CREATE TABLE players (
    player_id INT PRIMARY KEY AUTO_INCREMENT,
    player_name VARCHAR(255) NOT NULL,
    team_id INT,
    FOREIGN KEY (team_id) REFERENCES teams(team_id)
);

CREATE TABLE users (
    user_id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(255) UNIQUE NOT NULL,
    password VARCHAR(255) NOT NULL,
    role VARCHAR(20) NOT NULL,
    team_id INT,
    FOREIGN KEY (team_id) REFERENCES teams(team_id)
);
INSERT INTO teams (team_name) VALUES
                                  ('Los Angeles Lakers'),
                                  ('Golden State Warriors'),
                                  ('Boston Celtics'),
                                  ('Chicago Bulls'),
                                  ('Miami Heat'),
                                  ('San Antonio Spurs'),
                                  ('Houston Rockets'),
                                  ('Philadelphia 76ers'),
                                  ('Toronto Raptors'),
                                  ('Dallas Mavericks'),
                                  ('New York Knicks'),
                                  ('Denver Nuggets'),
                                  ('Portland Trail Blazers'),
                                  ('Oklahoma City Thunder'),
                                  ('Milwaukee Bucks'),
                                  ('Utah Jazz'),
                                  ('Indiana Pacers'),
                                  ('Atlanta Hawks'),
                                  ('Detroit Pistons'),
                                  ('Orlando Magic');

```