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