DB 설계

[sallyjellyy]

요구사항 분석을 토대로 한 ERD 과정

관계 설정은 아직..

Originally posted by @min27604 in #3 (comment)

[sallyjellyy]

여기까지 나온 스키마

CREATE TABLE IF NOT EXISTS `baseball`.`game` (
    `id` BIGINT PRIMARY KEY AUTO_INCREMENT,
    `home_team` VARCHAR(45) NOT NULL,
    `away_team` VARCHAR(45) NOT NULL
);

CREATE TABLE IF NOT EXISTS `baseball`.`team` (
    `id` BIGINT PRIMARY KEY AUTO_INCREMENT,
    `name` VARCHAR(45) NOT NULL,
    `is_home` TINYINT(1) NOT NULL,
    `is_playable` TINYINT(1) NOT NULL,
    `pitcher_id` BIGINT 
);

CREATE TABLE IF NOT EXISTS `baseball`.`player` (
    `id` BIGINT PRIMARY KEY AUTO_INCREMENT,
    `name` VARCHAR(45) NOT NULL,
    `at_bat` INT DEFAULT 0,
    `hit` INT DEFAULT 0,
    `out` INT DEFAULT 0,
    `batting_order` INT,
    `back_number` INT,
    `is_pitcher` TINYINT(1)
);