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)