Skip to content

insighteam/back_end

This branch is 1 commit ahead of master.

Folders and files

NameName
Last commit message
Last commit date

Latest commit

889c66c · Feb 12, 2022

History

39 Commits
Jul 30, 2019
Aug 1, 2019
Jul 31, 2019
Aug 1, 2019
Aug 1, 2019
Jul 30, 2019
Aug 2, 2019
Jul 31, 2019
Jul 30, 2019
Jul 30, 2019
Jul 30, 2019
Aug 2, 2019
Aug 2, 2019
Aug 1, 2019
Feb 12, 2022
Aug 1, 2019

Repository files navigation

back_end

back_end(이승진, 이성희, 구영진)

DB 설정

config/mysql-config.js에서 각자 설정

CREATE DATABASE moment;
use moment;

CREATE TABLE user(
	idx INT(11) NOT NULL auto_increment,
	id VARCHAR(45) NOT NULL,
	password VARCHAR(45) NOT NULL,
	name VARCHAR(45) NOT NULL,
	email VARCHAR(45) NOT NULL,
	address VARCHAR(100) NOT NULL,
	private_key VARCHAR(100),
	wallet_address VARCHAR(100)
	PRIMARY KEY(idx)
) DEFAULT CHARSET=UTF8;

CREATE TABLE capsule (
	idx INT(11) NOT NULL,
	capsule_address VARCHAR(100) NOT NULL,
	money INT(11) NOT NULL,
	PRIMARY KEY (idx, capsule_address),
	FOREIGN KEY (idx) REFERENCES user(idx)
) DEFAULT CHARSET=UTF8;	

CREATE TABLE invitation (
	id INT(11) NOT NULL auto_increment,
	idx INT(11) NOT NULL,
	latitude DOUBLE(20, 10) NOT NULL,
	longitude DOUBLE(20, 10) NOT NULL,
	money INT(11) NOT NULL,
	end_date DATE NOT NULL,
	PRIMARY KEY (id),
	FOREIGN KEY (idx) REFERENCES user(idx)
) DEFAULT CHARSET=UTF8;	

About

back_end(구영진, 이성희, 이승진)

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages