-
Notifications
You must be signed in to change notification settings - Fork 0
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
[Data 환경 구축하기] 분석 환경_ 테이블 구조 짜고 ERD 그리기 #19
Comments
DBdiagram.io를 활용하여 ERD 완료 특이사항
크롤링 데이터 변경 컬럼
API 데이터 변경 컬럼
논의사항 & 결정사항
참고 : DBdiagram 작성 코드Table track {
id varchar(100) [pk]
name varchar(50)
difficulty int(20)
lap int(20)
length float(20)
direction varchar(20)
release_date timestmap
theme varchar(20)
}
Table match {
id varchar(100) [pk]
track_id varchar(100)
start_time timestamp
end_time timestamp
player_id int(20)
rank int(20)
retired int(20)
result int(20)
record int(20)
match_type_id varchar(20)
team_id int(20)
}
Table player {
id int(20) [pk]
name varchar(100)
license int(20)
}
Table match_type {
id varchar(100) [pk]
type varchar(100)
}
Ref: match.track_id > track.id
Ref: match.player_id <> player.id
Ref: match.match_type_id > match_type.id |
ERD 추가
참고 : DBdiagram 작성 코드Table track {
id varchar(100) [pk]
name varchar(50)
difficulty int(20)
lap int(20)
length float(20)
direction varchar(20)
release_date timestmap
theme varchar(20)
}
Table match {
id varchar(100) [pk]
track_id varchar(100)
start_time timestamp
end_time timestamp
player_id int(20)
rank int(20)
retired int(20)
result int(20)
record int(20)
match_type_id varchar(20)
team_id int(20)
}
Table player {
id int(20) [pk]
name varchar(100)
license int(20)
}
Table match_type {
id varchar(100) [pk]
type varchar(100)
}
Table track_straight{
track_id varchar(100) [pk]
jump int(20)
uphill int(20)
downhill int(20)
}
Table track_trigger{
track_id varchar(100) [pk]
accel int(20)
warp int(20)
decel int(20)
jump int (20)
}
Table track_curve{
track_id varchar(100) [pk]
hairpin int(20)
acute int(20)
obtuse int(20)
continuous int(20)
continuous_acute int(20)
continuous_obtuse int (20)
}
Table track_shortcut{
track_id varchar(100) [pk]
right int(20)
acute int(20)
obtuse int(20)
special int(20)
}
Table track_road{
track_id varchar(100) [pk]
fence_exist int(20)
mean_road_level int(20)
}
Table track_obstacle{
track_id varchar(100) [pk]
obstacle_fixed int(20)
obstacle_moved int(20)
}
Ref: match.track_id > track.id
Ref: match.player_id <> player.id
Ref: match.match_type_id > match_type.id
Ref: track.id - track_straight.track_id
Ref: track.id - track_curve.track_id
Ref: track.id - track_trigger.track_id
Ref: track.id - track_shortcut.track_id
Ref: track.id - track_road.track_id
Ref: track.id - track_obstacle.track_id |
hyeming-king
added a commit
that referenced
this issue
Nov 23, 2022
최종 ERD챰고 사항
참고 : DBdiagram 작성 코드Table track {
id varchar(100) [pk]
name varchar(50)
difficulty int(20)
lap int(20)
length float(20)
direction varchar(20)
release_date timestmap
theme varchar(20)
}
Table match {
id varchar(100) [pk]
track_id varchar(100)
start_time timestamp
end_time timestamp
player_id int(20)
rank int(20)
retired int(20)
result int(20)
record int(20)
match_type_id varchar(20)
team_id int(20)
}
Table match_type {
id varchar(100) [pk]
type varchar(100)
}
Table track_straight{
track_id varchar(100) [pk]
jump int(20)
uphill int(20)
downhill int(20)
all_selection int(20)
}
Table track_trigger{
track_id varchar(100) [pk]
accel int(20)
warp int(20)
decel int(20)
jump int (20)
}
Table track_curve{
track_id varchar(100) [pk]
hairpin int(20)
acute int(20)
obtuse int(20)
continuous int(20)
continuous_acute int(20)
continuous_obtuse int (20)
}
Table track_shortcut{
track_id varchar(100) [pk]
right int(20)
acute int(20)
obtuse int(20)
special int(20)
}
Table track_road{
track_id varchar(100) [pk]
fence_exist int(20)
mean_road_level int(20)
}
Table track_obstacle{
track_id varchar(100) [pk]
fixed int(20)
moved int(20)
}
Ref: match.track_id > track.id
Ref: match.match_type_id > match_type.id
Ref: track.id - track_straight.track_id
Ref: track.id - track_curve.track_id
Ref: track.id - track_trigger.track_id
Ref: track.id - track_shortcut.track_id
Ref: track.id - track_road.track_id
Ref: track.id - track_obstacle.track_id |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
아래 테이블을 저장할 구조 짜고 ERD 그리기
추가 수정사항
The text was updated successfully, but these errors were encountered: