Demo_2024_ex1
Tables (18)
Accounts (유저)
- Key — Primary key — NOT NULL
PictureFiles (Untitled9)
- Key — Primary key — NOT NULL
ProjectUserPosts (Untitled)
- ID (Id) — Foreign key → UserPosts.ID — NOT NULL
- ProjectId (Key) — Foreign key → Projects.ProjectId — NOT NULL
Projects (프로젝트)
- ProjectId (Key) — Primary key — NOT NULL
Topic (게시판 토픽)
- ID (Id) — Primary key — NOT NULL
- 카테고리명 (Name)
- 모집 여부 (Field)
- 활성화 여부 (Field2)
- 삭제여부 (Field3)
- order (Field4)
- viewBanner (Field5)
TopicBanner (Untitled3)
- Key — Primary key — NOT NULL
- ID (Id) — Foreign key → Topic.ID — NOT NULL
- fileId (Field2)
- order (Field3)
UserCommentReports (댓글 신고)
- ID (CommentReportId) — Primary key — NOT NULL
- 유저ID (AccountId) — Foreign key → Accounts.Key — NOT NULL
- 댓글ID (CommentId) — Foreign key → UserPostComments.Key — NOT NULL
- 내용 (Content)
- 이유 (Reason)
- 상태 (State)
- 생성일 (CreatedAt)
- 처리일 (ProcessedAt)
UserPostComments (댓글)
- Key (Id) — Primary key — NOT NULL
- 유저ID (Key3) — Foreign key → Accounts.Key — NOT NULL
- 내용 (Field)
- 부모아이디 (Field2)
- 태그 유저 id (Field3)
- 생성일 (Field4)
- 삭제일 (Field5)
- 수정일 (Field6)
UserPostLikes (게시글 좋아요)
- 유저id (LikerId) — Foreign key → Accounts.Key — NOT NULL
- 게시글ID (PostId) — Foreign key → UserPosts.ID — NOT NULL
- 생성일 (LikedAt)
- 취소일 (DislikedAt)
UserPostLink (Untitled2)
- Key — Primary key — NOT NULL
- ID (Id) — Foreign key → UserPosts.ID — NOT NULL
- Url (Field)
UserPostPictures (게시글 사진)
- 사진파일 ID (Key2) — Foreign key → PictureFiles.Key — NOT NULL
- 게시글ID (Key) — Foreign key → UserPosts.ID — NOT NULL
UserPostReports (게시글 신고)
- ID (PostReportId) — Primary key — NOT NULL
- 유저ID (AccountId) — Foreign key → Accounts.Key — NOT NULL
- 게시글ID (PostId) — Foreign key → UserPosts.ID — NOT NULL
- 내용 (Content)
- 이유 (Reason)
- 상태 (State)
- 생성일 (CreatedAt)
- 처리일 (ProcessedAt)
UserPosts (게시글)
- ID (Id) — Primary key — NOT NULL
- 유저ID (WriterId) — Foreign key → Accounts.Key — NOT NULL
- 카테고리ID (CategoryId) — Foreign key → Topic.ID — NOT NULL
- 내용 (Content)
- 생성일 (CreatedAt)
- 삭제일 (DeletedAt)
- 수정일 (EditedAt)
- 조회수 (ViewCount)
- 제목 (Field)
UserRecruitments (모집)
- Id (Key) — Primary key — NOT NULL
- ID (UserPostId) — Foreign key → UserPosts.ID — NOT NULL
- State (Field2)
mappingTag (Untitled5)
- id (Key) — Foreign key → tag.id — NOT NULL
- id (Key2) — Foreign key → review.id — NOT NULL
review (Untitled6)
- id (Key) — Primary key — NOT NULL
- content (Field)
- userid (Field2)
tag (Untitled4)
- id (Key) — Primary key — NOT NULL
- title (Field)