community-server
Tables (4)
Comments (댓글)
- commentId (댓글고유값) — INT — Primary key — NOT NULL
- comment (댓글내용) — STRING
- createdAt (생성시간) — DATE
- updatedAt (수정시간) — DATE
- userId (회원고유값) — INT — Foreign key → Users.userId — NOT NULL
- postId (게시글고유값) — INT — Foreign key → Posts.postId — NOT NULL
Likes (좋아요)
- likeId (좋아요 고유값) — INT — Primary key — NOT NULL
- userId (회원고유값) — INT — Foreign key → Users.userId — NOT NULL
- postId (게시글고유값) — INT — Foreign key → Posts.postId — NOT NULL
Posts (게시글)
- postId (게시글고유값) — INT — Primary key — NOT NULL
- title (제목) — STRING
- content (내용) — STRING
- fileUrl (파일URL) — STRING
- filename (파일이름) — STRING
- createdAt (생성시간) — DATE
- updatedAt (수정시간) — DATE
- userId (회원고유값) — INT — Foreign key → Users.userId — NOT NULL
Users (회원)
- userId (회원고유값) — INT — Primary key — NOT NULL
- email (아이디) — STRING
- nickname (별명) — STRING
- password (암호) — STRING
- createdAt (생성시간) — DATE
- updatedAt (수정시간) — DATE