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