Skip to content
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.

Sign up for GitHub

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

Jump to bottom

DB 설계 #3

Closed
memoer opened this issue Jun 9, 2022 · 0 comments · Fixed by #26 or #28
Closed

DB 설계 #3

memoer opened this issue Jun 9, 2022 · 0 comments · Fixed by #26 or #28
Assignees
@memoer
Labels
Type: Setting 개발 환경 설정
Projects
AirJnC Project
Milestone
CI/CD 및 설정

Comments

@memoer
Copy link
Contributor

memoer commented Jun 9, 2022

해당 이슈에 대한 설명을 적어주세요

AirJnC 프로젝트에 사용할 DB를 설계합니다.

해당 이슈가 왜 필요한가요?

프로젝트 진행시 DB를 사용하기로 결정하였고, 이를 위해선 DB Table이 필요합니다.
때문에, DB를 설계해야 합니다.

기타

그 외로 적어야 할 것들을 적어주세요
@memoer memoer added the chore label Jun 9, 2022
@memoer memoer self-assigned this Jun 9, 2022
@memoer memoer added this to To do in AirJnC Project via automation Jun 9, 2022
memoer added a commit that referenced this issue Jun 9, 2022
@memoer
chore(#3): DB 설계 초본 이미지 및 sql
de2c082
memoer added a commit that referenced this issue Jun 9, 2022
@memoer
chore(#3): DB 설계 초본 이미지 및 sql
705e73d
memoer added a commit that referenced this issue Jun 9, 2022
@memoer
chore(#3): DB 설계 초본 이미지 및 sql
8b42f0d
@memoer memoer mentioned this issue Jun 9, 2022
Closed
memoer added a commit that referenced this issue Jun 9, 2022
@memoer
chore(#3): DB 설계 초본 이미지 및 sql
cdd2c29
memoer added a commit that referenced this issue Jun 9, 2022
@memoer
chore(#3): DB 설계 초본 이미지 및 sql
361b122
@memoer memoer removed chore labels Jun 10, 2022
memoer added a commit that referenced this issue Jun 10, 2022
@memoer
chore(#3): DB 설계 초본 이미지 및 sql
9bade1b
memoer added a commit that referenced this issue Jun 10, 2022
@memoer
chore(#3): DB 설계 초본 이미지 및 sql
438a988
@memoer memoer added the Type: Setting 개발 환경 설정 label Jun 10, 2022
@memoer memoer added this to the 초기 설정 milestone Jun 10, 2022
hoon25 pushed a commit that referenced this issue Jun 11, 2022
chore(#3): DB 1차설계
fa70849
hoon25 added a commit that referenced this issue Jun 11, 2022
@hoon25
chore(#3): DB 1차설계
1daead0
hoon25 added a commit that referenced this issue Jun 11, 2022
@hoon25
chore(#3): DB 1차설계
c376477
@hoon25 hoon25 mentioned this issue Jun 11, 2022
Closed
memoer added a commit that referenced this issue Jun 13, 2022
@memoer
chore(#3): DB 설계
047140f
@memoer memoer mentioned this issue Jun 13, 2022
Closed
memoer added a commit that referenced this issue Jun 14, 2022
@memoer
chore(#3): DB 설계
d08a995
memoer added a commit that referenced this issue Jun 15, 2022
@memoer
chore(#3): DB 설계
a8db0af
@memoer memoer mentioned this issue Jun 15, 2022
Merged
memoer added a commit that referenced this issue Jun 15, 2022
@memoer
chore(#3): DB 설계
39df288
memoer added a commit that referenced this issue Jun 15, 2022
@memoer
chore(#3): DB 설계
69149b6
memoer added a commit that referenced this issue Jun 15, 2022
@memoer
chore(#3): DB 설계
4964a11
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): weekly_price->weekly_discount_price 컬럼 이름 변경
f526c7a
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): DB 설계 수정본
8a9c2d8 
- 테이블 이름 변경
  - room_category -> room_root_category
  - room_category_detail -> room_leaf_category
  - room_category_detail__room_type -> room_category
- room_leaf_category에 컬럼 추가 `is_several_rooms`
  - 해당 카테고리를 선택한 방은 방의 개수를 설정해야 한다/안한다 여부
- room_price 테이블의 `weekly_price` 컬럼 이름 변경 -> `weekly_discount_price`
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): room_price 컬럼 weekly_price -> weekly_discount_price
c7b2219
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): DB 최종본 sql
2a85840
AirJnC Project automation moved this from To do to Done Jun 16, 2022
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): DB 설계
b99e466
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): weekly_price->weekly_discount_price 컬럼 이름 변경
3aebddd
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): DB 설계 수정본
7b6b38e 
- 테이블 이름 변경
  - room_category -> room_root_category
  - room_category_detail -> room_leaf_category
  - room_category_detail__room_type -> room_category
- room_leaf_category에 컬럼 추가 `is_several_rooms`
  - 해당 카테고리를 선택한 방은 방의 개수를 설정해야 한다/안한다 여부
- room_price 테이블의 `weekly_price` 컬럼 이름 변경 -> `weekly_discount_price`
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): room_price 컬럼 weekly_price -> weekly_discount_price
b358059
memoer added a commit that referenced this issue Jun 16, 2022
@memoer
chore(#3): DB 최종본 sql
ec73904
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): DB 최종본 sql"
f5cbe02 
This reverts commit ec73904.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): room_price 컬럼 weekly_price -> `weekly_discount…
5bd73da 
…_price`"

This reverts commit b358059.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): DB 설계 수정본"
080c7a3 
This reverts commit 7b6b38e.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): weekly_price->weekly_discount_price 컬럼 이름 변경"
a6394b5 
This reverts commit 3aebddd.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): DB 설계"
08a2bc1 
This reverts commit b99e466.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): DB 최종본 sql"
24b5ea9 
This reverts commit ec73904.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): room_price 컬럼 weekly_price -> `weekly_discount…
c4b74f5 
…_price`"

This reverts commit b358059.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): DB 설계 수정본"
413934a 
This reverts commit 7b6b38e.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): weekly_price->weekly_discount_price 컬럼 이름 변경"
d7699c0 
This reverts commit 3aebddd.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
Revert "chore(#3): DB 설계"
889e5c9 
This reverts commit b99e466.
memoer added a commit that referenced this issue Jun 17, 2022
@memoer
chore(#3): DB 설계 고정 데이터들 ENUM으로 변경
f5ee566 
- category 관련 테이블 모두 room_category 테이블로 묶음
- facility_category 테이블은 facilitry 테이블의 category 컬럼으로 넣음
- 고정 데이터들은 자바 애플리케이션 단에서 ENUM으로 관리하기로 결정
@memoer memoer mentioned this issue Jun 17, 2022
Merged
memoer added a commit that referenced this issue Jun 21, 2022
@memoer
chore(#3): room_category 컬럼 변경
02854c4 
- category name 하나만 가져가기로 결정
- 해당 컬럼의 값 -> "부티크 호텔, 게스트 하우스, 저택, 아파트, ... "
memoer added a commit that referenced this issue Jun 21, 2022
@memoer
chore(#3): DB 설계 고정 데이터들 ENUM으로 변경
33a4314 
- category 관련 테이블 모두 room_category 테이블로 묶음
- facility_category 테이블은 facilitry 테이블의 category 컬럼으로 넣음
- 고정 데이터들은 자바 애플리케이션 단에서 ENUM으로 관리하기로 결정
memoer added a commit that referenced this issue Jun 21, 2022
@memoer
chore(#3): room_category 컬럼 변경
61193d3 
- category name 하나만 가져가기로 결정
- 해당 컬럼의 값 -> "부티크 호텔, 게스트 하우스, 저택, 아파트, ... "
@hoon25 hoon25 linked a pull request Aug 2, 2022 that will close this issue
[#3] DB 설계 #20
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@memoer memoer

Labels
Type: Setting 개발 환경 설정
Projects
AirJnC Project
Done
Milestone
CI/CD 및 설정
1 participant
@memoer