1

Tables (22)

category

  • id — Integer — Primary key — NOT NULL
  • name — Varchar

comment

  • id — Integer — Primary key — NOT NULL
  • userId — Integer — Foreign key → user.id — NOT NULL
  • postId — Integer — Foreign key → post.id — NOT NULL
  • createdTime — DateTime
  • updatedTime — DateTime
  • isDeleted — Boolean
  • body — Varchar
  • parentCommentId — Integer — NOT NULL

notification_comment

  • id — Integer — Primary key — NOT NULL
  • notificationControllerId — Integer — Foreign key → notification_controller.id — NOT NULL
  • commentId — Integer — Foreign key → comment.id — NOT NULL

notification_controller

  • id — Integer — Primary key — NOT NULL
  • notificationTypeId — Integer — Foreign key → notification_type.id — NOT NULL
  • sender — Integer — Foreign key → user.id — NOT NULL
  • receiver — Integer — NOT NULL
  • createdTime — DateTime
  • isViewed — Boolean
  • representMessage — Varchar

notification_post_like

  • id — Integer — Primary key — NOT NULL
  • notificationControllerId — Integer — Foreign key → notification_controller.id — NOT NULL
  • postLikeId — Integer — Foreign key → post_like.id — NOT NULL

notification_type

  • id — Integer — Primary key — NOT NULL
  • name — Varchar
  • description — Varchar

post

  • id — Integer — Primary key — NOT NULL
  • categoryId — Integer — Foreign key → category.id — NOT NULL
  • userId — Integer — Foreign key → user.id — NOT NULL
  • title — Varchar
  • originalImg — Varchar
  • smallImg — Varchar
  • likeCount — Integer
  • viewCount — Integer
  • createdTime — DateTime
  • updatedTime — DateTime
  • isDeleted — Boolean

post_favorite

  • id — Integer — Primary key — NOT NULL
  • userId — Integer — Foreign key → user.id — NOT NULL
  • postId — Integer — Foreign key → post.id — NOT NULL
  • isDeleted — Boolean
  • createdTime — DateTime

post_like

  • id — Integer — Primary key — NOT NULL
  • userId — Integer — Foreign key → user.id — NOT NULL
  • postId — Integer — Foreign key → post.id — NOT NULL
  • isDeleted — Boolean
  • createdTime — Datetime

post_to_tag

  • id — Integer — Primary key — NOT NULL
  • postId — Integer — Foreign key → post.id — NOT NULL
  • tagId — Integer — Foreign key → tag.id — NOT NULL

post_view

  • id — Integer — Primary key — NOT NULL
  • userId — Integer — Foreign key → user.id — NOT NULL
  • postId — Integer — Foreign key → post.id — NOT NULL
  • ip — Varchar
  • createdTime — Varchar

report_comment

  • id — Integer — Primary key — NOT NULL
  • reportControllerId — Integer — Foreign key → report_controller.id — NOT NULL
  • commentId — Integer — Foreign key → comment.id — NOT NULL

report_controller

  • id — Integer — Primary key — NOT NULL
  • userId — Integer — Foreign key → user.id — NOT NULL
  • reportTargetId — Integer — Foreign key → report_target.id — NOT NULL
  • reportTypeId — Integer — Foreign key → report_type.id — NOT NULL
  • createdTime — Datetime

report_etc_message

  • id — Integer — Primary key — NOT NULL
  • reportControllerid — Integer — Foreign key → report_controller.id — NOT NULL
  • reportEtcMessage — Varchar

report_port

  • id — Integer — Primary key — NOT NULL
  • reportControllerId — Integer — Foreign key → report_controller.id — NOT NULL
  • postId — Integer — Foreign key → post.id — NOT NULL

report_target

  • id — Integer — Primary key — NOT NULL
  • name — Varchar
  • description — Varchar

report_type

  • id — Integer — Primary key — NOT NULL
  • name — Varchar
  • description — Varchar

tag

  • id — Integer — Primary key — NOT NULL
  • name — Varchar
  • description — Varchar

user

  • id — Integer — Primary key — NOT NULL
  • userTypeId — Integer — Foreign key → user_type.id — NOT NULL
  • userStatusId — Integer — Foreign key → user_status.id — NOT NULL
  • userProviderId (id2) — Integer — Foreign key → user_provider.id — NOT NULL
  • nickName — Varchar
  • uniqueCode — Varchar
  • img — Varchar
  • lastLoginTime — Datetime
  • createdTime — Datetime
  • updatedTime — Datetime

user_provider

  • id — Integer — Primary key — NOT NULL
  • name — Varchar
  • description — Varchar

user_status

  • id — Integer — Primary key — NOT NULL
  • name — Varchar
  • description — Varchar

user_type

  • id — Integer — Primary key — NOT NULL
  • name — Varchar
  • description — Varchar