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