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)