meetmate
Tables (4)
Subway (지하철정보)
- id (Key) — Primary key — NOT NULL
- x (x좌표) — float
- y (y좌표) — float
- name (이름) — string
- line (호선) — string
category (카테고리)
- id (Key) — Primary key — NOT NULL
- name (카테고리명)
- p_id (상위카테고리id) — Foreign key → category.id — NOT NULL
location (위치 정보)
- id (Key) — Primary key — NOT NULL
- x (x좌표) — float
- y (y좌표) — float
- address (주소) — string
- name (이름) — string
- category_id (카테고리id) — Foreign key → category.id — NOT NULL
- place_url (세부url)
- rate (별점)
user (사용자)
- id (Key) — Primary key — NOT NULL
- userId (회원번호)
- nickname (별명)
- email (이메일)
- weight (가중치)