Skip to content

DB model

Juho Kang edited this page Aug 30, 2020 · 11 revisions

미정된부분은 italic

Member

  • no PK PRIMARY KEY
  • 아이디(식별용) id_string varchar(50)
  • 닉네임 nickname varchar(50)
  • 선호 메뉴 menu_preference varchar(20)
  • 자기 소개 self_intro varchar(1000)
  • 나이 age int
  • 성별 gender varchar(20)
create table member
(
	no serial primary key,
	id varchar(50) not null,
	nickname varchar(50) not null,
	self_intro varchar(1000) null,
	age int null,
	gender varchar(20) null
);

ALTER TABLE public.member
    ADD CONSTRAINT id_unique UNIQUE (id);

Meeting

  • 아이디(식별용) id int AUTO_INCREMENT PRIMARY KEY
  • 좌표 coordinates varchar(100)
  • 시간대 due varchar(100)
  • 가격대 price_range varchar(100)
  • 음식 menu varchar(100)
  • 인원 number_of_people int
CREATE TABLE meeting (
  id SERIAL PRIMARY KEY,
  coordinates varchar(100),
  due varchar(100),
  price_range varchar(100),
  menu varchar(100),
  number_of_people int 
);
Clone this wiki locally