everytime
Tables (3)
comment (댓글)
- id (댓글ID) — pk,ai,nn,uq — Primary key — NOT NULL
- postID (게시글ID) — pk,ai,nn,uq — Foreign key → post.id — NOT NULL
- id (유저ID) — pk,ai,nn,uq — Foreign key → user.id — NOT NULL
- content (내용) — nn
- regDate (생성일) — nn
post (게시글)
- id (게시글ID) — pk,ai,nn,uq — Primary key — NOT NULL
- writerID (유저ID) — pk,ai,nn,uq — Foreign key → user.id — NOT NULL
- title (제목) — nn
- content (내용) — nn
- regDate (생성일) — nn
- likeCount (좋아요 수) — nn
- publicStatus (공개여부) — nn
user (유저)
- id (유저ID) — pk,ai,nn,uq — Primary key — NOT NULL
- email (이메일) — uq, nn
- nickname (닉네임) — uq, nn
- password (비밀번호) — nn
- school (소속학교) — nn