piggyrun

Tables (9)

Untitled (post)

  • Key (p_id) — int — Primary key — NOT NULL
  • Field (memo) — varchar(500)
  • Field (image) — varchar(200) — NOT NULL
  • Field (regdate) — datetime — NOT NULL
  • Field (update) — datetime — NOT NULL
  • Field (visited) — tinyint(1) — NOT NULL
  • Field (like) — tinyint(1)
  • id (u_id) — int — Foreign key → user.id — NOT NULL
  • Key (s_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (store)

  • Key (s_id) — int — Primary key — NOT NULL
  • Field (name) — varchar(50) — NOT NULL
  • Field (tel) — varchar(20)
  • Field (address) — varchar(100) — NOT NULL
  • Field (latitude) — double — NOT NULL
  • Field (longitude) — double — NOT NULL
  • Field (category) — set
  • Key (r_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (region)

  • Key (r_id) — int — Primary key — NOT NULL
  • Field (city) — varchar(20) — NOT NULL
  • Field (area) — varchar(20) — NOT NULL

Untitled (menu)

  • Key (m_id) — int — Primary key — NOT NULL
  • Field (name) — varchar(20) — NOT NULL
  • Field (price) — int — NOT NULL
  • Key (s_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (areabased)

  • id (u_id) — int — Foreign key → user.id — NOT NULL
  • Field (stores) — set — NOT NULL
  • Field (regdate) — datetime — NOT NULL
  • Key (r_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (userbased)

  • id (u_id) — int — Foreign key → user.id — NOT NULL
  • Field (stores) — set — NOT NULL
  • Field (regdate) — datetime — NOT NULL

Untitled (match)

  • Key (ma_id) — int — Primary key — NOT NULL
  • Field (stoes) — set — NOT NULL
  • Field (newstores) — set — NOT NULL
  • Field (regdate) — datetime — NOT NULL
  • id (userid) — int — Foreign key → user.id — NOT NULL
  • id (friendid) — int — Foreign key → user.id — NOT NULL

Untitled2 (category)

  • Key (c_id) — int — Primary key — NOT NULL
  • Field (field) — varchar(20) — NOT NULL

user

  • id (u_id) — int — Primary key — NOT NULL
  • Field (nickname) — varchar(20) — NOT NULL
  • Field2 (email) — varchar(50) — NOT NULL
  • Field (password) — varchar(20) — NOT NULL
  • Field (rank) — int — NOT NULL
  • Field (image) — varchar(200)