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