blog
Tables (9)
blog (블로그)
- blog_id (primary) — BIGINT(20) — Primary key — NOT NULL
- user_id (primary2) — BIGINT(20) — Foreign key → user.user_id — NOT NULL
- blog_name (Field) — VARCHAR(50)
comment (댓글)
- comment_id (primary) — BIGINT(20) — Primary key — NOT NULL
- post_id (primary2) — BIGINT(20) — Foreign key → post.post_id — NOT NULL
- user_id (primary3) — BIGINT(20) — Foreign key → user.user_id — NOT NULL
- series_id (primary32) — BIGINT(20) — Foreign key → post.series_id — NOT NULL
- comment (Field) — TEXT
- created_date (Field2) — tiemstamp
- modify_date (Field3) — timestamp
- status (Field4) — enum
fallow (팔로잉)
- fallow_id (primary) — BIGINT(20) — Primary key — NOT NULL
- Field
- follower_id (FK) — BIGINT(20) — Foreign key → user.user_id — NOT NULL
- followee_id (FK2) — BIGINT(20) — Foreign key → user.user_id — NOT NULL
image (이미지)
- file_id (primary) — BIGINT(20) — Primary key — NOT NULL
- file_path (Field) — VARCHAR(255)
- file_name (Field2) — VARCHAR(255)
- file_type (Field3) — enum
- create_date (Field4) — tiemstamp
- modify_date (Field5) — timestamp
like (좋아요)
- like_id (primary) — BIGINT(20) — Primary key — NOT NULL
- user_id (primary2) — BIGINT(20) — Foreign key → user.user_id — NOT NULL
- post_id (primary3) — BIGINT(20) — Foreign key → post.post_id — NOT NULL
- series_id (primary32) — BIGINT(20) — Foreign key → post.series_id — NOT NULL
- create_date (Field) — tiemstamp
post (게시글)
- post_id (primary) — BIGINT(20) — Primary key — NOT NULL
- blog_id (primary2) — BIGINT(20) — Foreign key → blog.blog_id — NOT NULL
- series_id (primary3) — BIGINT(20) — Foreign key → series.series_id — NOT NULL
- post_title (Field) — VARCHAR(255)
- context (Field2) — TEXT
- created_date (Field3) — timestamp
- modify_date (Field4) — timestamp
- status (Field5) — enum
- view (Field6) — Integer
- like (Field7) — Integer
- file_id (Field8) — BIGINT(20)
reply (답글)
- reply_id (primary) — BIGINT(20) — Primary key — NOT NULL
- comment_id (primary2) — BIGINT(20) — Foreign key → comment.comment_id — NOT NULL
- series_id (primary32) — BIGINT(20) — Foreign key → comment.series_id — NOT NULL
- comment (Field) — TEXT
- created_date (Field2) — tiemstamp
- modify_date (Field3) — timestamp
- status (Field4) — enum
series (시리즈)
- series_id (primary) — BIGINT(20) — Primary key — NOT NULL
- series_name (Field) — VARCHAR(255)
user (사용자)
- user_id (primary) — BIGINT(20) — Primary key — NOT NULL
- email (Field) — VARCHAR(50)
- password (Field2) — VARCHAR(50)
- blog_title (Field3) — VARCHAR(50)
- created_date (Field4) — tiemstamp
- modify_date (Field5) — timestamp
- authority (Field6) — enum
- file_id (primary2) — BIGINT(20) — Foreign key → image.file_id — NOT NULL