newsfeed
Tables (6)
Bookmark (북마크)
- id (PK) — BIGINT — Primary key — NOT NULL
- id (PK2) — BIGINT — Foreign key → Post.id — NOT NULL
Comment (댓글)
- id (PK) — BIGINT — Primary key — NOT NULL
- id (PK3) — BIGINT — Foreign key → Post.id — NOT NULL
- id (PK2) — BIGINT — Foreign key → User.id — NOT NULL
- content (내용) — LONGTEXT
- createdAt (생성일시) — DATETIME
- updatedAt (수정일시) — DATETIME
Follow (친구)
- Key — BIGINT — Primary key — NOT NULL
- my_id (PK) — BIGINT — Foreign key → User.id — NOT NULL
Like (좋아요)
- id (PK) — BIGINT — Primary key — NOT NULL
- user_id (사용자) — BIGINT — Foreign key → User.id — NOT NULL
- post_id (포스트) — BIGINT — Foreign key → Post.id — NOT NULL
- comment_id (댓글) — BIGINT — Foreign key → Comment.id — NOT NULL
Post (게시글)
- id (PK) — BIGINT — Primary key — NOT NULL
- id (PK2) — BIGINT — Foreign key → User.id — NOT NULL
- title (제목) — VARCHAR(45)
- content (내용) — LONGTEXT
- createdAt (생성일시) — DATETIME
- updatedAt (수정일시) — DATETIME
- Field
User (사용자)
- id (PK) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(45)
- name (이름) — VARCHAR(45)
- password (비밀번호) — VARCHAR(45)
- interest (tag) — VACHAR(255)
- delete_flag (삭제여부) — BOOLEAN
- role (역할) — ENUM
- createdAt (생성일시) — DATETIME
- updatedAt (수정일시) — DATETIME