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 (가중치)