wsuar
test1
Tables (12)
campushotplace
- No — int(11) — Primary key — NOT NULL
- Name — varchar(50)
- Number — varchar(50)
- Count — int(11)
shop_detail
- Number (number) — int(11) — Primary key — NOT NULL
- Id (id) — varchar(100)
- Name (name) — varchar(50)
- Menuname (menuname) — varchar(100)
- Menuprice (menuprice) — varchar(100)
- Image (image) — varchar(250)
shop_list
- Number (number) — int(11) — Primary key — NOT NULL
- Id (id) — varchar(100)
- Name (name) — varchar(50)
- Location (location) — varchar(50)
- Phone (phone) — varchar(50)
- Description (description) — varchar(50)
- Latitude (latitude) — double
- Longitude (longitude) — double
- Image (image) — varchar(250)
- Direction (direction) — int(11)
usercustomplace
- No — int(11) — Primary key — NOT NULL
- Id — varchar(100)
- UserLat — double
- UserLong — double
- Name — varchar(30)
- Text — varchar(50)
- State — tinyint(1)
userlocationlog
- No — int(11) — Primary key — NOT NULL
- Id — varchar(100)
- StartLat — double
- StartLong — double
- EndPoint — varchar(10)
- StartTime — varchar(50)
- EndTime — varchar(50)
wsu_ar_friend
- Key — Primary key — NOT NULL
- Number (number) — int(11)
- Sign_id (sign_id) — varchar(50)
- Receive_id (receive_id) — varchar(50)
- Latitude (latitude) — double
- Longitude (longitude) — double
- Time (time) — datetime
- Msg1 (msg1) — varchar(50)
- Msg2 (msg2) — varchar(50)
- Msg3 (msg3) — varchar(50)
wsu_ar_friend_place
- Number (number) — int(11) — Primary key — NOT NULL
- Sign_id (sign_id) — varchar(50)
- Receive_id (receive_id) — varchar(50)
- Latitude (latitude) — double
- Longitude (longitude) — double
- Time (time) — datetime
- Name (name) — varchar(50)
- Text (text) — varchar(50)
wsu_ar_friend_place_gps (wsu_ar_friend_place_gp)
- Number (number) — int(11) — Primary key — NOT NULL
- Sign_id (sign_id) — varchar(50)
- Receive_id (receive_id) — varchar(50)
- Latitude (latitude) — double
- Longitude (longitude) — double
- Time (time) — datetime
- Name (name) — varchar(50)
- Text (text) — varchar(50)
- UserLat (userlat) — double
- UserLong (userlong) — double
wsu_building
- No (no) — int(11) — Primary key — NOT NULL
- Name (name) — varchar(50)
- Phone (phone) — varchar(50)
- Long_location (long_location) — double
- Lat_location (lat_location) — double
- Number (number) — varchar(50)
- Image (image) — varchar(250)
- Engname (engname) — varchar(50)
- Direction (direction) — int(11)
wsu_department
- No (no) — int(11) — Primary key — NOT NULL
- Number (number) — varchar(50)
- Name (name) — varchar(50)
- Floor (floor) — varchar(50)
- Depart (depart) — varchar(50)
- Phone (phone) — varchar(50)
- Image (image) — varchar(250)
wsu_friends_list
- No (no) — int(11) — Primary key — NOT NULL
- Sign_id (sign_id) — varchar(50)
- Receive_id (receive_id) — varchar(50)
- Relationship (relationship) — tinyint(1)
wsu_membership
- Number (number) — int(11) — Primary key — NOT NULL
- Id (id) — varchar(100)
- Pw (pw) — varchar(50)
- Name (name) — varchar(50)
- Phone (phone) — varchar(50)
- Islogin (islogin) — tinyint(1)