newsfeed
테이블 (5)
comment (댓글)
- comment_id (PK) — BIGINT — 기본 키 — NOT NULL
- post_id (FK1) — BIGINT — 외래 키 → post.id — NOT NULL
- user_id (FK2) — BIGINT — 외래 키 → 사용자.id — NOT NULL
- content (Field) — VARCHAR
- created_at (Field2) — DATETIME
- modified_at (Field3) — DATETIME
friendship (친구)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (FK) — BIGINT — 외래 키 → 사용자.id — NOT NULL
- deleted (Field) — bit(1)
- created_at (Field2) — DATETIME
- modified_at (Field3) — DATETIME
- deleted_at (Field4) — DATETIME
frined_request (친구요청)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (FK) — BIGINT — 외래 키 → 사용자.id — NOT NULL
- deleted (Field) — bit(1)
- created_at (Field2) — DATETIME
- modified_at (Field3) — DATETIME
- deleted_at (Field4) — DATETIME
post (게시글)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (FK) — BIGINT — 외래 키 → 사용자.id — NOT NULL
- image_url (Field) — VARCHAR
- contents (Field2) — VARCHAR
- created_at (Field3) — DATETIME
- modified_at (Field4) — DATETIME
- deleted_at (Field5) — DATETIME
- num_of_comments (Field6) — BIGINT
사용자 (users)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- 아이디 (email) — VARCHAR
- profile_image_url (Field4) — VARCHAR
- email (Field2) — VARCHAR
- password (Field3) — VARCHAR
- status_message (Field5) — VARCHAR
- created_at (Field6) — DATETIME
- modified_at (Filed7) — DATETIME
- deleted_at (Filed8) — DATETIME