capstone
Tables (14)
Cocoments (Untitled9)
- PostCode (PostCode2) — int — Foreign key → Comments.PostCode — NOT NULL
- Nickname — varchar
- ProfilePicture — url
- Contents — varchar
- Date — Date
Comments (Untitled8)
- PostCode (PostCode2) — int — Foreign key → Post.PostCode — NOT NULL
- NickName — varchar
- ProfilePicture — url
- Contents — varchar
- Date — Date
Copy Of Cocoments (CopyOfUntitled9)
- PlaceCode — int — Foreign key → Place.PlaceCode — NOT NULL
- Nickname — varchar
- ProfilePicture — url
- Contents — varchar
- Date — Date
- Score — float
CurrentPlayer (CopyOfCopyOfUntitled7)
- googleID — varchar — Primary key — NOT NULL
- NickName — varchar
Friend (Untitled3)
- googleID — varchar — Foreign key → UserData.googleID — NOT NULL
- Nickname — varchar
Meeting (CopyOfUntitled7)
- PostCode — int — Primary key — NOT NULL
- NickName — varchar
- PreferGenre — varchar
- Region — varchar
- Contents — varchar
- Date — Date
- Title — varchar
- Place — varchar
- TotalPlayer — int
- CurrentPlayerList — int
Meeting info (CopyOfCopyOfUntitled72)
- PostCode (PostCode2) — int — Foreign key → Meeting.PostCode — NOT NULL
- NickName — varchar
- PreferGenre — varchar
- Region — varchar
- Contents — varchar
- Date — Date
- Title — varchar
- Place — varchar
- TotalPlayer — int
- CurrentPlayerList — int
- PlaceCode — int
- Memo — varchar
- Placereview — varchar
Message (Untitled6)
- GoogleID — varchar — Primary key — NOT NULL
- Nickname
- Message — int — Foreign key → MessageCode.ChattingCode — NOT NULL
MessageCode (Untitled4)
- ChattingCode — int — Primary key — NOT NULL
- TalkerList — varchar
- MessageList — varcahr
Place (Untitled10)
- PlaceCode — int — Primary key — NOT NULL
- Storename — varchar
- Location — varchar
- Score — float
- Review — varchar
Post (Untitled7)
- PostCode — int — Primary key — NOT NULL
- BoardName — varchar
- NickName — varchar
- ProfilePicture — url
- Title — varchar
- Contents — varchar
- Date — Date
- Good — int
- CommentsList — varchar
- CommentsCnt — int
Talker (Untitled5)
- googleID — varchar — Primary key — NOT NULL
- Nickname — varchar — Foreign key → MessageCode.ChattingCode — NOT NULL
User (Untitled)
- googleID — varchar — Primary key — NOT NULL
- NIckname (Nickname) — varchar
- ProfilePicture (Profilepicture) — url
- PreferGenre — varchar
- MeetingCnt — int
- ClassPoints — int
- Region — varchar
- City — varchar
- Sex — varchar
- PrimaryGame — varchar
- Good — int
- NotBad — int
- Bad — int
- penalty — int
UserData (Untitled2)
- googleID — varchar — Primary key — NOT NULL
- NickName — varchar
- FriendList — varchar
- MymeetingList — int
- PostList — int
- CommentList — int
- ChattingCodelist — int