BABBLE
Tables (5)
comments
- comment_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — VARCHAR(255) — NOT NULL
- updated_at — VARCHAR(255)
- is_deleted — BOOLEAN — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
likes
- like_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
notification
- notification_id — BIGINT — Primary key — NOT NULL
- receiver_id — BIGINT — Foreign key → users.user_id — NOT NULL
- post_id — BIGINT — Foreign key → posts.post_id
- type — VARCHAR(20) — NOT NULL
- content — VARCHAR(255)
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
posts
- post_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- post_image — VARCHAR(255)
- created_at — VARCHAR(255) — NOT NULL
- updated_at — VARCHAR(255)
- comment_count — INT — NOT NULL
- like_count — INT — NOT NULL
- view_count — INT — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(50) — NOT NULL
- password — VARCHAR(20) — NOT NULL
- nickname — VARCHAR(10) — NOT NULL
- profileImage — VARCHAR(255)
- is_deleted — BOOLEAN — NOT NULL