텀블벅

테이블 (5)

Category (Untitled4)

  • CategoryId (categoryId) — INT(11) — 기본 키 — NOT NULL
  • Game (game) — VARCHAR(255)
  • Fashion (fashion) — VARCHAR(255)
  • Culture (culture) — VARCHAR(255)
  • Beauty (beauty) — VARCHAR(255)
  • Pet (pet) — VARCHAR(255)

Fund (Untitled3)

  • fundId — INT(11) — 기본 키 — NOT NULL
  • userId — INT(11) — 외래 키 → Users.userId — NOT NULL

Project (Untitled2)

  • projectId — INT(11) — 기본 키 — NOT NULL
  • CategoryId (categoryId) — INT(11) — 외래 키 → Category.CategoryId — NOT NULL
  • userId — INT(11) — 외래 키 → Users.userId — NOT NULL
  • Summary (summary)
  • Title (title)
  • ThumbnailUrl (thumbnailUrl)
  • Goal (goal)
  • StartDate (startDate)
  • EndDate (endDate)
  • Plan (plan)
  • ImgeUrl (imgUrl)
  • CreatorName (creatorName)
  • CreatorBiography (creatorBigography)

Reward (Untitled5)

  • RewordId (rewardId) — INT(11) — 기본 키 — NOT NULL
  • projectId — INT(11) — 외래 키 → Project.projectId — NOT NULL
  • RewardItem (rewardItem)
  • FundingPrice (fundingPrice)

Users (Untitled)

  • userId — INT(11) — 기본 키 — NOT NULL
  • Name (name) — VARCHAR(255)
  • Password (password)
  • Email (email)