[야구 관리 프로그램] - 테이블 설계(1)

미니프로젝트 1 - 야구 관리 프로그램.pdf - Google Drive

미니프로젝트 1 - 야구 관리 프로그램.pdf

 

야구장 테이블(3개)

create table stadium (
    id integer primary key auto_increment,
    name varchar(255),
    created_at timestamp
);

 

팀 테이블(3팀)

create table team (
    id integer primary key auto_increment,
    stadium_id integer,
    name varchar(255),
    created_at timestamp,
    foreign key (stadium_id) references stadium(id)
);

 

선수 테이블(9명)

create table player (
    id integer primary key auto_increment,
    team_id integer,
    name varchar(255),
    position varchar(255),
    created_at timestamp,
    foreign key (team_id) references team(id),
    unique (team_id,position) -- 같은 팀 내 포지션 중복x
);

 

퇴출 선수 테이블

create table out_player (
    id integer primary key auto_increment,
    player_id integer,
    reason varchar(255),
    created_at timestamp,
    foreign key (player_id) references player(id)
);

 

테이블 다이어그램

• 야구장 1 : 팀 N
• 팀 1 : 선수 N
• 선수 1 : 퇴출 선수 N

// Use DBML to define your database structure
// Docs: https://dbml.dbdiagram.io/docs

Table stadium {
  id integer
  name varchar
  created_at timestamp 
}

Table team {
  id integer [primary key]
  stadium_id varchar 
  name varchar
  created_at timestamp
}

Table player {
  id integer [primary key] 
  team_id integer
  name varchar 
  position varchar
  created_at timestamp
}

Table out_player {
  id integer [primary key]
  plyaer_id intesger
  reason varchar
  created_at timestamp
}

Ref: "stadium"."id" < "team"."stadium_id"
Ref: "team"."id" < "player"."team_id"
Ref: "player"."id" < "out_player"."plyaer_id"