쇼핑몰인증블로그ERDSQL 설계

빌드업

빌드업ERD빌드업ERD빌드업ERD빌드업ERD빌드업ERD빌드업ERD빌드업ERD빌드업ERD빌드업ERD빌드업ERD빌드업ERD

테이블: 23개
관계: 34개
작성자: PSK
업데이트: 2026년 9월 14일

USERS

USER_ID	numeric
LOGIN_ID	varchar
PASSWORD	varchar
NICKNAME	varchar
EMAIL	varchar
CREATED_AT	timestamp
UPDATED_AT	timestamp
FAVORITE_TEAM	numeric
ROLE_CODE	varchar
POINT	numeric

TEAMS

TEAM_ID	numeric
TEAM_NAME	varchar
HISTORY	text
EMBLEM_URL	varchar
ANTHEM_URL	varchar
FOUNDED_YEAR	date
UPDATED_AT	timestamp
HOME_GROUND	varchar

PLAYERS

PLAYER_ID	numeric
NAME	varchar
BACK_NUMBER	numeric
MAIN_POSITION	varchar
NATIONALITY	varchar
teams_id	numeric

TEAM_STATS

TEAM_ID	numeric
CURRENT_RANK	numeric
MATCHES_PLAYED	numeric
WINS	numeric
DRAWS	numeric
LOSSES	numeric
POINTS	numeric
GOALS_FOR	numeric
GOALS_AGAINST	numeric
GOAL_DIFF	numeric
YELLOW_CARDS	numeric
RED_CARDS	numeric
UPDATED_AT	timestamp

PLAYER_STATS

PLAYER_ID	numeric
GOALS	numeric
ASSISTS	numeric
MOM_COUNT	numeric
YELLOW_CARDS	numeric
RED_CARDS	numeric
IS_INJURED	varchar
INJURY_NOTE	text
IS_SUSPENDED	varchar

STAFFS

STAFF_ID	numeric
NAME	varchar
NATIONALITY	varchar
TEAM_ID	numeric
STAFF_ROLE_ID	numeric

MATCHES

MATCH_ID	numeric
MATCH_DATE	timestamp
HOME_SCORE	numeric
AWAY_SCORE	numeric
STATUS	varchar
HOME_TEAM_ID	numeric
AWAY_TEAM_ID	numeric

USER_PREDICTS

PREDICT_WIN	numeric
PREDICT_TOTAL	numeric
UPDATED_AT	timestamp
USER_ID	numeric

USER_ROLES

ROLE_CODE	varchar
ROLE_NAME	varchar

STAFF_ROLES

STAFF_ROLE_ID	numeric
ROLE_NAME	varchar

MATCH_LINEUPS

LINEUP_ID	numeric
MATCH_POSITION	varchar
IS_STARTER	varchar
PLAYER_ID	numeric
MATCH_ID	numeric
TEAM_ID	numeric

PREDICTIONS

PREDICTION_ID	numeric
CREATED_AT	timestamp
PREDICT_RESULT	varchar
IS_SUCCESS	varchar
MATCH_ID	numeric
USER_ID	numeric

CUSTOM_TEAMS

CUSTOM_TEAM_ID	numeric
TEAM_NAME	varchar
FORMATION	varchar
CREATED_AT	timestamp
USER_ID	numeric

CUSTOM_SQUADS

SQUAD_ID	numeric
POSITION_NO	numeric
PLAYER_ID	numeric
CUSTOM_TEAM_ID	numeric

AI_MATCHES

AI_MATCH_ID	numeric
HOME_SCORE	numeric
AWAY_SCORE	numeric
AI_REVIEW	text
CREATED_AT	timestamp
HOME_TEAM_ID	numeric
AWAY_TEAM_ID	numeric

POSTS

POST_ID	numeric
TITLE	varchar
CONTENT	text
VIEW_COUNT	numeric
LIKE_COUNT	numeric
CREATED_AT	timestamp
UPDATED_AT	timestamp
IS_BLIND	varchar
TEAM_ID	numeric
CATEGORY_ID	numeric
USER_ID	numeric

COMMENTS

COMMENT_ID	numeric
CONTENT	text
IS_BLIND	varchar
CREATED_AT	timestamp
UPDATED_AT	timestamp
P_COMMENT_ID	numeric
POST_ID	numeric
USER_ID	numeric

POST_LIKES

USER_ID	numeric
POST_ID	numeric
CREATED_AT	timestamp

COMMENT_LIKES

USER_ID	numeric
COMMENT_ID	numeric
CREATED_AT	timestamp

EVENT_TYPE

EVENT_TYPE_CODE	numeric
EVENT_TYPE_NAME	varchar
EVENT_ICON_URL	varchar

MATCH_EVENTS

EVENT_ID	numeric
EVENT_TIME	numeric
EVENT_TYPE	numeric
PLAYER_ID	numeric
ASSIST_PLAYER_ID	numeric
MATCH_ID	numeric
TEAM_ID	numeric

POINT_HISTORY

POINT_HISTORY_ID	numeric
created_at	timestamp
PREDICTION_ID	numeric
AMOUNT	numeric
BALANCE_AFTER	numeric
DESCRIPTION	text
USER_ID	numeric

설계 개요

이 ERD는 빌드업 도메인의 핵심 데이터를 테이블 단위로 나누고, 외래 키 관계를 통해 주요 업무 흐름을 표현합니다.

23개 테이블과 34개 관계로 핵심 도메인 흐름을 분리했습니다.

기본키와 외래키를 명시해 테이블 간 참조 방향을 빠르게 확인할 수 있습니다.

주요 식별자와 참조 컬럼을 중심으로 SQL DDL 초안을 만들 수 있습니다.

테이블 구성

USERS

USERS 테이블 · 컬럼 10개

PK:: USER_ID
FK:: FAVORITE_TEAM, ROLE_CODE

TEAMS

TEAMS 테이블 · 컬럼 8개

PK:: TEAM_ID
FK:: 없음

PLAYERS

PLAYERS 테이블 · 컬럼 6개

PK:: PLAYER_ID
FK:: teams_id

TEAM_STATS

TEAM_STATS 테이블 · 컬럼 13개

PK:: TEAM_ID
FK:: TEAM_ID

PLAYER_STATS

PLAYER_STATS 테이블 · 컬럼 9개

PK:: PLAYER_ID
FK:: PLAYER_ID

STAFFS

STAFFS 테이블 · 컬럼 5개

PK:: STAFF_ID
FK:: TEAM_ID, STAFF_ROLE_ID

MATCHES

MATCHES 테이블 · 컬럼 7개

PK:: MATCH_ID
FK:: HOME_TEAM_ID, AWAY_TEAM_ID

USER_PREDICTS

USER_PREDICTS 테이블 · 컬럼 4개

PK:: USER_ID
FK:: USER_ID

USER_ROLES

USER_ROLES 테이블 · 컬럼 2개

PK:: ROLE_CODE
FK:: 없음

STAFF_ROLES

STAFF_ROLES 테이블 · 컬럼 2개

PK:: STAFF_ROLE_ID
FK:: 없음

MATCH_LINEUPS

MATCH_LINEUPS 테이블 · 컬럼 6개

PK:: LINEUP_ID
FK:: PLAYER_ID, MATCH_ID, TEAM_ID

PREDICTIONS

PREDICTIONS 테이블 · 컬럼 6개

PK:: PREDICTION_ID
FK:: MATCH_ID, USER_ID

주요 관계

TEAMS.TEAM_ID→TEAM_STATS.TEAM_ID1:1

PLAYERS.PLAYER_ID→PLAYER_STATS.PLAYER_ID1:1

TEAMS.TEAM_ID→STAFFS.TEAM_ID1:n

TEAMS.TEAM_ID→USERS.FAVORITE_TEAM1:n

TEAMS.TEAM_ID→MATCHES.HOME_TEAM_ID1:n

TEAMS.TEAM_ID→MATCHES.AWAY_TEAM_ID1:n

USERS.USER_ID→USER_PREDICTS.USER_ID1:1

USER_ROLES.ROLE_CODE→USERS.ROLE_CODE1:n

SQL DDL 예시

전체 SQL은 플레이그라운드에서 데이터베이스 종류를 선택해 생성할 수 있습니다.

CREATE TABLE users (
  user_id numeric NOT NULL PRIMARY KEY,
  login_id varchar NOT NULL,
  password varchar NOT NULL,
  nickname varchar NOT NULL,
  email varchar,
  created_at timestamp NOT NULL,
  updated_at timestamp,
  favorite_team numeric
);

CREATE TABLE teams (
  team_id numeric NOT NULL PRIMARY KEY,
  team_name varchar NOT NULL,
  history text NOT NULL,
  emblem_url varchar NOT NULL,
  anthem_url varchar NOT NULL,
  founded_year date NOT NULL,
  updated_at timestamp,
  home_ground varchar NOT NULL
);

CREATE TABLE players (
  player_id numeric NOT NULL PRIMARY KEY,
  name varchar NOT NULL,
  back_number numeric NOT NULL,
  main_position varchar NOT NULL,
  nationality varchar NOT NULL,
  teams_id numeric NOT NULL
);

활용 방법

이 구조를 복제한 뒤 테이블명, 컬럼 타입, 관계를 프로젝트 상황에 맞게 수정하세요. 완성한 ERD는 SQL, PNG, SVG로 내보낼 수 있습니다.

다른 공개 ERD 더 보기