0.3.1 • Published 3 years ago

multiuser-meeting-scheduler v0.3.1

Weekly downloads
-
License
MIT
Repository
github
Last release
3 years ago

MultiUser-Meeting-Scheduler

GithubAction Test & Build License: MIT

Purpose

This web aims to arrange each other's schedule, by input of each user's schedule.

Try our web to reach arrangement of available time!

Sample App Image

Requirement

- MySQL
- Node

Usage

$ git clone https://github.com/lim-it-ing/MultiUser-Meeting-Scheduler.git

Go into the project directory and run the command:

localhost

$ nodemon index.js
or
$ node index.js

Open http://localhost:PORT and enjoy!

API

Before Run

Add this in config/database.js

module.exports = {
    host     : hostip,
    user     : user,
    password : password
    database : name_of_database
};

config/config.json

{
  "development": {
    "username": "root",
    "password": null,
    "database": "database_development",
    "host": "127.0.0.1",
    "dialect": "mysql",
      "port": 3306
  },
  "test": {
    "username": "root",
    "password": null,
    "database": "database_test",
    "host": "127.0.0.1",
    "dialect": "mysql",
      "port": 3306
  },
  "production": {
    "username": "root",
    "password": null,
    "database": "database_production",
    "host": "127.0.0.1",
    "dialect": "mysql",
      "port": 3306
  }
}

.env

SECRET_KEY = yoursecretkey
JWT_SECRET = yourjwtsecret

Database Structure

User

각 User의 개인정보를 저장합니다.

TypeComment
uidstringprimary유저 고유의 아이디
passwordstring(40)unique유저의 이름
namestringunique유저의 이메일

Schedule

시간표를 공유할 인원들이 속한 그룹 정보입니다.

TypeComment
idintauto_increment
primary
nameStringUnique
sched_dayDate날짜
uidStringForeign Key스케줄 유저

UserTimes

유저 일정의 시작 및 끝 시간을 정의합니다.

TypeComment
idintauto_increment
useridint
groupidint
startTimehh:mm
endTimehh:mm

UserSchedule

Linked Table Between User - Schedule

API Structure

Link : https://navy-sting-049.notion.site/APIs-7aa8d40df52b42b4baf65dcd07bd4f2e