bssm-portfolio

Tables (6)

comment (CopyOfUntitled)

  • commentId — int — Primary key — NOT NULL
  • portfolioId — int — Foreign key → portfolio.portfolioId — NOT NULL
  • nickName — varchar(50)
  • content — varchar(200)

great (Untitled3)

  • userId — int — Foreign key → user.userId — NOT NULL
  • portfolioId — int — Foreign key → portfolio.portfolioId — NOT NULL

participant (Untitled4)

  • portfolioId — int — Foreign key → portfolio.portfolioId — NOT NULL
  • userId — int — Foreign key → user.userId — NOT NULL

portfolio (Untitled)

  • portfolioId — int — Primary key — NOT NULL
  • video — varchar(100) — NOT NULL
  • thumbNail — varchar(100) — NOT NULL
  • title — varchar(100)
  • theme — varchar(10)
  • isPublic — bool
  • url — varchar(100)
  • description — text
  • githubUrl — vharchar(100)
  • like — int

reply (CopyOfCopyOfUntitled)

  • id — int — Primary key — NOT NULL
  • commentId — int — Foreign key → comment.commentId — NOT NULL
  • nickName — varchar(50)
  • content — varchar(200)

user (Untitled2)

  • userId — int — Primary key — NOT NULL
  • email — varchar(50)
  • nickName — varchar(50)
  • password
  • auth — varchar(50)