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)