사전스터디(1)
테이블 (5)
Comment
- commentID — BIGINT — 기본 키 — NOT NULL
- MemberID — VARCHAR(255) — NOT NULL
- postID — BIGINT — NOT NULL
- content — TEXT
- createdAt — DATETIME — NOT NULL
- deleted — BOOLEAN — NOT NULL
Image
- ImageID — BIGINT — 기본 키 — NOT NULL
- postID — BIGINT — NOT NULL
- imageURL — VARCHAR(255) — NOT NULL
Like
- LikeID — BIGINT — 기본 키 — NOT NULL
- MemberID — VARCHAR(255) — NOT NULL
- postID — BIGINT — NOT NULL
Member
- MemberID — VARCHAR(255) — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME
- is_deleted — BOOLEAN — NOT NULL
Post
- postID — BIGINT — 기본 키 — NOT NULL
- MemberID — VARCHAR(255) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- createdAt — DATETIME — NOT NULL
- updatedAt — DATETIME
- count_likes — INT — NOT NULL
- count_comments — INT — NOT NULL