-
Notifications
You must be signed in to change notification settings - Fork 0
DB model
Juho Kang edited this page Aug 30, 2020
·
11 revisions
미정된부분은 italic
- 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);
- 아이디(식별용) 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
);