NewsFeed
Tables (4)
Comments (댓글)
- id (Key) — BIGINT — Primary key — NOT NULL
- contents (Field) — VARCHAR(200) — NOT NULL
- created_at (Field2) — DATETIME(6) — NOT NULL
- modified_at (Field3) — DATETIME(6) — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
- post_id (Key3) — BIGINT — Foreign key → Posts.id — NOT NULL
Followers (팔로우 관리)
- id (Key) — BIGINT — Primary key — NOT NULL
- following_user_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
- follower_user_id (Key3) — BIGINT — Foreign key → Users.id — NOT NULL
Posts (게시물)
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(50) — NOT NULL
- contents (Field2) — LONGTEXT — NOT NULL
- created_at (Field3) — DATETIME(6) — NOT NULL
- modified_at (Field4) — DATETIME(6) — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → Users.id — NOT NULL
Users (유저)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(255) — NOT NULL
- password (Field2) — VARCHAR(255) — NOT NULL
- username (Field3) — VARCHAR(50) — NOT NULL
- address (Field4) — VARCHAR(100) — NOT NULL
- created_at (Field6) — DATETIME(6) — NOT NULL
- modified_at (Field7) — DATETIME(6) — NOT NULL
- deleted_at (Field5) — DATETIME(6)