ERD 명세서
테이블 (9)
Bookmark (Untitled7)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- post_id (FK) — BIGINT — 외래 키 → Post.id — NOT NULL
- user_id (FK2) — BIGINT — 외래 키 → User.id — NOT NULL
- created_at (Field) — DATETIME
- modified_at (Field2) — DATETIME
Comment (Untitled3)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- post_id (FK) — BIGINT — 외래 키 → Post.id — NOT NULL
- user_id (FK2) — BIGINT — 외래 키 → User.id — NOT NULL
- content (Field) — VARCHAR
- created_at (Field2) — DATETIME
- modified_at (Field3) — DATETIME
Follow (Untitled6)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (FK) — BIGINT — 외래 키 → User.id — NOT NULL
- following_user_id (Field) — BIGINT
Hashtag (Untitled4)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- post_id (FK) — BIGINT — 외래 키 → Post.user_id — NOT NULL
- tag_name (Field) — VARCHAR
- createdAt (Field2) — DATETIME
- modifiedAt (Field3) — DATETIME
Hashtag (Untitled9)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- name (Field) — VARCHAR
Like (Untitled5)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- post_id (Key2) — BIGINT — 외래 키 → Post.user_id — NOT NULL
- user_id (Key3) — BIGINT — 외래 키 → User.id — NOT NULL
- created_at (Field) — DATETIME
- modified_at (Field2) — DATETIME
Post (Untitled)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- user_id (FK) — BIGINT — 외래 키 → User.id — NOT NULL
- title (Field) — VARCHAR
- content (Field2) — VARCHAR
- created_at (Field3) — DateTime
- modified_at (Field4) — DateTime
- version (Field5) — BIGINT
- likes_count (Field6) — BIGINT
PostHashtag (Untitled8)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- post_id (FK) — BIGINT — 외래 키 → Post.id — NOT NULL
- hashtag_id (FK2) — BIGINT — 외래 키 → Hashtag.id — NOT NULL
- created_at (Field) — DATETIME
- modified_at (Field2) — DATETIME
User (Untitled2)
- id (PK) — BIGINT — 기본 키 — NOT NULL
- name (Field) — VARCHAR
- age (Field2) — INT
- email (Field3) — VARCHAR
- password (Field4) — VARCHAR
- created_at (Field5) — DATETIMEe
- modified_at (Field6) — DATETIME
- is_usable (Field7) — BIT