SnearkerHead Community

Tables (5)

Comments (Untitled2)

  • commentId (id) — int — Primary key — NOT NULL
  • comment (commets) — text
  • comfortable — float
  • Field
  • sneakersId (id2) — int — Foreign key → sneakersInfo.sneakersId — NOT NULL
  • memberId (id3) — int — Foreign key → sneakerHead.memberId — NOT NULL

board (Untitled4)

  • boardID (id) — int — Primary key — NOT NULL
  • boardTitle (title) — char
  • boardText (text) — text
  • createdTime (create) — time
  • memberId (id2) — int — Foreign key → sneakerHead.memberId — NOT NULL
  • sneakersId (id3) — int — Foreign key → sneakersInfo.sneakersId — NOT NULL

isHip (Untitled5)

  • memberId (id) — int — Foreign key → sneakerHead.memberId — NOT NULL
  • sneakersId (id2) — int — Foreign key → sneakersInfo.sneakersId — NOT NULL
  • answer — boolean

sneakerHead (Untitled3)

  • memberId (id) — int — Primary key — NOT NULL
  • nickname — char
  • password — char

sneakersInfo (Untitled)

  • sneakersId (id) — int — Primary key — NOT NULL
  • snekersName — char
  • model (modelNumber) — char
  • brand — char
  • comfortableScore (comfortable) — float
  • HipScore(percent) (isHip) — float