Database design

ㅡ Database design

Table of Contents

• Introduction
• Prerequisite
• Development
  • Testing
  • Commit
  • Role
• Result
• License
• About

Introduction

주어진 요구사항에 맞춰 db 를 직접 설계한다.

Prerequisite

Must run in the mysql environment.

• mysql: Design using mysql server and mysql workbench.

Development

Testing

$ select * from [schema.tablename]

Commit

We are following Angular’s commitizen rules for formatting git commit message. This allows you to read messages that are easy to understand when looking for project history. It also uses the git commit message to generate our CHANGELOG file.

$ npm install -g git-cz
$ git add .
$ git git-cz
$ git push

Role

db 설계(erd)부터 query select 까지 작성

Result

pk, fk 그리고 제1~3 정규화를 고려하여 설계

license

MIT License

About

Authored and maintained by ingyu