NEW
Tables (8)
Achievements
- Acievements_id — Integer — Primary key — NOT NULL
- Icon — Varchar(255)
- Detail — Varchar(50)
- Achievement — condition`
- Category — Varchar(10)
Admin
- User_id — Varchar(30) — Primary key — NOT NULL
- Password — Varchar(20)
- Nickname — Varchar(미정)
DeleteUser
- User_id — Varchar(30) — Primary key — NOT NULL
- Password — Varchar(20)
- Nickname — Varchar(미정)
- Profile — Varchar(255)
- Level — Integer
- Exp — Integer
Follow
- Follow_id — Integer — Primary key — NOT NULL
- From_user — Varchar(30) — Foreign key → User.User_id — NOT NULL
- To_user — Varchar(30) — NOT NULL
Record
- Log_id — Integer — Primary key — NOT NULL
- User_id — Varchar(30) — Foreign key → User.User_id — NOT NULL
- Coordinates — VARCHAR(255)
- Distance — Float
- Taken — time`
- Creation — date`
- Detail — Varchar(40)
- Thumbnail — Varchar(255)
- RecentImage — Varchar(255)
Route
- Route_id — Integer — Primary key — NOT NULL
- User_id — Varchar(30) — Foreign key → User.User_id — NOT NULL
- Maker — Varchar(20)
- Route — json
- Creation — date`
- Thumbnail — Varchar(255)
- Title — Varchar(16)
User
- User_id — Varchar(30) — Primary key — NOT NULL
- Password — Varchar(20)
- Nickname — Varchar(미정)
- Profile — Varchar(255)
- Level — Integer
- Exp — Integer
User-Achievements
- User_id — Varchar(30) — Foreign key → User.User_id — NOT NULL
- Acievements_id — Integer — Foreign key → Achievements.Acievements_id — NOT NULL