gouz7514 / db_design

DB 설계 프로젝트 UI

DB_DESIGN

• 2020 단국대학교 DB 설계 프로젝트
  
• Team : SCENE kimchi (2조)
  member: 김영훈, 김학재, 남호철, 안석진, 윤지아
  

environment

Windows

in windows env.

• MySQL 8.0 (download)
• Node.js v12.19.0 (download)
• npm v6.14.8 (will automatically install with nodejs)

Linux

in linux env.

sudo apt-get update
sudo apt-get install mysql-server
sudo apt-get install nodejs
sudo apt-get install build-essential

install

DB Setting

• User Setting
  make user for project with

  create user 'dbdesign'@'%' identified with mysql_native_password BY 'P@ssw0rd';
  grant all privileges on kimchi.* to 'dbdesign'@'%';

  on root or other user in MySQL who have privileges.
  user id = dbdesign, pw = P@ssw0rd
  MySQL uses default port(3306)

• DB Scheme Setting on mysql shell run script by

  mysql> source <PROJECT_PATH>/model/DAO/dbSetting.sql
  mysql> source <PROJECT_PATH>/model/DAO/dataSetting.sql

Run node.js Server

• package install
  first install npm packages with package.json

  npm install

• run node server
  just run server with

  node ./app.js

  but if you are developer and want to realtime modification on source code.

  supervisor ./app.js

  or if on deployment start and stop server with

  forever start ./app.js
  forever stop ./app.js

• connect with web browser
  This project using prot 3000 on node server.
  in yout brower vou can go index page with
  "http://localhost:3000" or "http://127.0.0.1:3000"

screenshot