sansinryong

Tables (10)

Chat (chat)

  • Chat_Uid (chat_uid) — VARCHAR — Primary key — NOT NULL
  • UserName (username) — VARCHAR
  • Message (message) — VARCHAR
  • TimeStamp (timestamp) — VARCHAR

Dangers (dangers)

  • Dangers_Uid (dangers_uid) — VARCHAR — Primary key — NOT NULL
  • Number (number) — INT
  • Explanation (explanation) — VARCHAR
  • LocationName (locationName) — VARCHAR
  • Latitude (latitude) — DOUBLE
  • Longitude (longitude) — DOUBLE

MountainComment (mountaincomment)

  • MountainComment_Uid (mountaincomment_uid) — VARCHAR — Primary key — NOT NULL
  • Username (username) — VARCHAR
  • Content (content) — VARCHAR
  • Star (star) — LONG

Mountain_Bookmark (mountain_bookmark)

  • Mountain_Bookmark_Uid (mountain_bookmark_uid) — VARCHAR — Primary key — NOT NULL
  • Address (address) — VARCHAR
  • Feature (feature) — VARCHAR
  • Height (height) — VARCHAR
  • Img (img) — VARCHAR
  • Name (name) — VARCHAR
  • MountainComment_Uid (mountaincomment_uid) — VARCHAR — Foreign key → MountainComment.MountainComment_Uid — NOT NULL

Notice (notice)

  • Notice_Uid (notice_uid) — VARCHAR — Primary key — NOT NULL
  • DocumentId (documentid) — VARCHAR
  • NtTitle (nttitle) — VARCHAR
  • NtContent (ntcontent) — VARCHAR

Plans (plans)

  • Plans_Uid (plans_uid) — VARCHAR — Primary key — NOT NULL
  • Stardate (stardate) — VARCHAR
  • Enddate (enddate) — VARCHAR
  • Mountain (mountain) — VARCHAR
  • Bak (bak) — VARCHAR
  • Members (members) — VARCHAR

Talk (talk)

  • Talk_Uid (talk_uid) — VARCHAR — Primary key — NOT NULL
  • Title (title) — VARCHAR
  • Contents (contents) — VARCHAR
  • Formats (formats) — VARCHAR
  • Publisher (publisher) — VARCHAR
  • Id (id) — VARCHAR
  • TalkComment_Uid (talkcomment_uid) — VARCHAR — Foreign key → TalkComment.TalkComment_Uid — NOT NULL

TalkComment (talkcomment)

  • TalkComment_Uid (talkcomment_uid) — VARCHAR — Primary key — NOT NULL
  • Author (author) — VARCHAR
  • Text (text) — VARCHAR

Users (users)

  • Users_Uid (users_uid) — VARCHAR — Primary key — NOT NULL
  • Name (name) — VARCHAR
  • PhoneNumber (phonenumber) — VARCHAR
  • Address (address) — VARCHAR
  • PhotoUrl (photourl) — VARCHAR
  • Email (email) — VARCHAR
  • Role (role) — VARCHAR
  • Mountain_Bookmark_Uid (mountain_bookmark_uid) — VARCHAR — Foreign key → Mountain_Bookmark.Mountain_Bookmark_Uid — NOT NULL
  • Plans_Uid (plans_uid) — VARCHAR — Foreign key → Plans.Plans_Uid — NOT NULL

WeatherData (weatherdata)

  • WeatherData_Uid (weatherdata_uid) — VARCHAR — Primary key — NOT NULL
  • TmEf (tmEf) — VARCHAR
  • Wf (wf) — VARCHAR
  • Tmn (tmn) — VARCHAR
  • Tmx (tmx) — VARCHAR
  • City (city) — VARCHAR