lv4
Tables (4)
cmts (댓글)
- Key — int — Primary key — NOT NULL
- userId — int — Foreign key → user.userId — NOT NULL
- postId — int — Foreign key → posts.postId — NOT NULL
- content — str
posts (게시글)
- postId — int — Primary key — NOT NULL
- userId — int — Foreign key → user.userId — NOT NULL
- title — str
- content — str
- like — int
user (유저)
- userId — Primary key — NOT NULL
- email — str
- password — int
userInfo (유저 정보)
- userInfoId — Primary key — NOT NULL
- userId — Foreign key → user.userId — NOT NULL
- userDesc — str
- createdAt — date
- updatedAt — date