kakasoo/commerce-example-sql

create e-commerce tables and dummy data for MySQL

Hello, I'm kakasoo.

• Developer who knows the benefits of having the same language between backend and frontend ( TypeScript ) 👨‍💻
  • deep understanding of type systems
• Developer interested in business and organizational culture
• With domain knowledge of commerce and marketing
• Developer with my own philosophy, whether it's about code or not.

blog1 : https://kscodebase.tistory.com
blog2 : https://velog.io/@kakasoo
gmail : [email protected]
linkedIn : https://www.linkedin.com/in/%EA%B2%BD%EC%88%98-%EA%B0%95-2b8254211/

stats of public repo

• Include only public repository as statistics.

📚 Experience

Type	Date	Contents	Organization
🌃 Company	2024.06 ~	B.E. developer	Wrtn
🏫 Education(Reviewer)	2023.09 ~ 2023.10	Boostcamp membership 8 reviewer	NAVER CONNECT
🌃 Company	2023.07 ~ 2024.06	B.E. developer	Imweb
🏫 Education(Reviewer)	2022.09 ~ 2022.10	Boostcamp membership 7 reviewer	NAVER CONNECT
🌃 Company	2022.04 ~ 2023.05	B.E. developer	B2B startup
🌃 Company	2021.10 ~ 2022.03	B.E. developer	commerce startup
🏫 Education	2020.08 ~ 2020.12	Boostcamp membership 5	NAVER CONNECT
🏫 Education	2020.07 ~ 2020.08	Boostcamp challenge 5	NAVER CONNECT
🏫 Education	2016.03 ~ 2022.06	Department of computer engineering (double major)	Gachon University
🏫 Education	2016.03 ~ 2022.06	Department of architect engineering	Gachon University

commerce-example-sql's Issues

10/18일자 - 정한수

1

datetime = 8bytes의 문자열
timestamp = 4bytes의 숫자형 (+3 bytes의 초단위)
timestamp는 시스템의 표준시간대를 토대로 utc로 변환하여 저장한다.

1-1

createdAt : 언제 해당 레코드가 생성되었는지를 의미한다.
updatedAt : 해당 레코드가 최근에 언제 수정되었는지를 의미한다.
deletedAt : 해당 레코드가 논리 삭제를 당한 일자를 의미한다. 물리적으로 삭제하기에는 사용자가 실수로 해당 데이터를 지우거나 하는 등의 이유로 복구를 요청하는 등의 위험성이 있기 때문.

2번은 써놓은 대로

3-c

select avg(c.count) from (select count(*) as count from guest as g group
by g.user_id) as c;

3-d

select avg(c.count) from (select count(*) as count from guest as g group
by g.user_id having count(*) != 1) as c;

이 부분에 대한 내용 정리

          ex. 이거에 대해서 공부하세요

Ex. 암호화

• 만약 ~ A 라면? 어떻게 하실래요?

Originally posted by @kakasoo in #2 (comment)