jhdsa
Tables (6)
comments
- comment_id — BIGINT — Primary key — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- content — TEXT — NOT NULL
- creation_time — DATETIME — NOT NULL
- is_edited — TINYINT(1) — NOT NULL
like
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
post
- post_id — BIGINT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.user_id — NOT NULL
- title — VARCHAR(26) — NOT NULL
- content — MEDIUMTEXT — NOT NULL
- created — DATETIME — NOT NULL
- is_edited — TINYINT(1) — NOT NULL
post_image
- image_id — BIGINT — Primary key — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- pos — INT — NOT NULL
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
post_info
- post_id — BIGINT — Foreign key → post.post_id — NOT NULL
- view_cnt — INT — NOT NULL
- likes_cnt — INT — NOT NULL
- comments_cnt — INT — NOT NULL
user
- user_id — INT — Primary key — NOT NULL
- nickname — VARCHAR(10) — NOT NULL
- email — VARCHAR(320) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- profile_pic — VARCHAR(255)