Blccu V2

Tables (13)

announcement (Untitled2)

  • id (Key) — UUID — Primary key — NOT NULL
  • title (Field) — string — NOT NULL
  • content (Field2) — string — NOT NULL
  • date_created (Field3) — datetime — NOT NULL
  • date_updated (Field5) — datetime — NOT NULL
  • date_deleted (Field4) — datetime

comment (Untitled10)

  • id (Key) — UUID — Primary key — NOT NULL
  • post_id (Key3) — UUID — Foreign key → posts.id — NOT NULL
  • content (Field2) — string — NOT NULL
  • user_name (Field) — string — NOT NULL
  • date_created (Field3) — datetime — NOT NULL
  • date_updated (Field4) — datetime
  • date_deleted (Field6) — datetime
  • blame_count (Field5) — number — NOT NULL
  • parent_id (Key4) — UUID — Foreign key → comment.id
  • writer_id (Field62) — number — Foreign key → user.kakaoId — NOT NULL

like (Untitled13)

  • id (Key) — UUID — Primary key — NOT NULL
  • from_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
  • post_id (Key2) — UUID — Foreign key → posts.id — NOT NULL

neighbor (Untitled3)

  • id (Key) — UUID — Primary key — NOT NULL
  • from_user (Key2) — number — Foreign key — NOT NULL
  • to_user (Field6) — number — Foreign key → user.kakaoId — NOT NULL

notification (Untitled9)

  • id (Key) — UUID — Primary key — NOT NULL
  • target_user_id (Key3) — UUID — Foreign key
  • user_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
  • not_type (Field) — number — NOT NULL
  • not_url (Field2) — string
  • not_message (Field3) — string — NOT NULL
  • date_created (Field4) — datetime — NOT NULL
  • date_deletedd (Field7) — datetime
  • is_checked (Field5) — boolean — NOT NULL

post_background (Untitled5)

  • id (Key) — UUID — Primary key — NOT NULL
  • image_url (Field) — string — NOT NULL

post_category (Untitled7)

  • id (Key) — UUID — Primary key — NOT NULL
  • name (Field) — varchar(50) — NOT NULL
  • user_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL

posts (Untitled4)

  • id (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • postBackgroundId (Key3) — UUID — Foreign key → post_background.id — NOT NULL
  • postCategoryId (Key5) — UUID — Foreign key → post_category.id — NOT NULL
  • userKakaoId (Field62) — number — Foreign key → user.kakaoId — NOT NULL
  • title (Field) — string — NOT NULL
  • like_count (Field4) — number — NOT NULL
  • view_count (Field5) — number — NOT NULL
  • comment_count (Field13) — number — NOT NULL
  • allow_comment (Field6) — boolean — NOT NULL
  • scope (Field7) — number — NOT NULL
  • date_created (Field3) — datetime — NOT NULL
  • date_updated (Field8) — datetime — NOT NULL
  • date_deleted (Field9) — datetime
  • isPublished (Field2) — boolean — NOT NULL
  • content (Field11) — longtext — NOT NULL
  • image_url (Field10) — string
  • main_image_url (Field12) — string

report (Untitled6)

  • id (Key) — UUID — Primary key — NOT NULL
  • user_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
  • title (Field) — string — NOT NULL
  • content (Field2) — string — NOT NULL
  • date_created (Field3) — datetime — NOT NULL
  • report_url (Field4) — string

sticker (Untitled8)

  • id (Key) — UUID — Primary key — NOT NULL
  • user_id (Field6) — number — Foreign key → user.kakaoId — NOT NULL
  • isDefault (Field2) — boolean — NOT NULL
  • image_url (Field) — number — NOT NULL

sticker_block (Untitled12)

  • id (Key3) — UUID — Primary key — NOT NULL
  • sticker_id (Key2) — UUID — Foreign key → sticker.id — NOT NULL
  • post_id (Key) — UUID — Foreign key → posts.id — NOT NULL
  • depth (Field) — number — NOT NULL
  • fill (Field2) — string — NOT NULL
  • x (Field3) — point — NOT NULL
  • y (Field4) — point — NOT NULL
  • width (Field5) — string — NOT NULL
  • height (Field6) — string — NOT NULL

sticker_category (Untitled11)

  • id (Key) — uuid — Primary key — NOT NULL
  • name (Field) — string
  • sticker_id (Key2) — UUID — Foreign key → sticker.id — NOT NULL

user (Untitled)

  • kakaoId (Field6) — number — Primary key — NOT NULL
  • username (Field) — varchar(15) — NOT NULL
  • description (Field2) — varchar(255) — NOT NULL
  • profile_image (Field3) — varchar(255)
  • date_created (Field4) — datetime — NOT NULL
  • date_deleted (Field5) — datetime
  • current_refresh_token (Field7) — string — NOT NULL
  • isAdmin (Field8) — boolean — NOT NULL