Blccu

Tables (10)

comment (Untitled10)

  • id (Key) — UUID — Primary key — NOT NULL
  • user_id (Key2) — UUID — Foreign key → user.id — NOT NULL
  • post_id (Key3) — UUID — Foreign key → post.id — NOT NULL
  • content (Field2) — varchar(1500) — NOT NULL
  • user_name (Field) — varchar(15) — NOT NULL
  • date_created (Field3) — datetime — NOT NULL
  • date_updated (Field4) — datetime
  • date_deleted (Field6) — datetime
  • blame_count (Field5) — int(11) — NOT NULL
  • parent_id (Key4) — UUID — Foreign key → comment.id
  • children_id (Key5) — UUID — Foreign key → comment.id

neighbor (Untitled3)

  • from_user (Key2) — UUID — Foreign key → user.id — NOT NULL
  • to_user (Key3) — UUID — Foreign key → user.id — NOT NULL

notification (Untitled9)

  • id (Key) — UUID — Primary key — NOT NULL
  • user_id (Key2) — UUID — Foreign key → user.id — NOT NULL
  • target_user_id (Key3) — UUID — Foreign key → user.id
  • post_id (Key4) — UUID — Foreign key → post.id
  • not_type (Field) — int(11) — NOT NULL
  • not_url (Field2) — varchar(255)
  • not_message (Field3) — varchar(255) — NOT NULL
  • date_created (Field4) — datetime — NOT NULL
  • is_checked (Field5) — bit(1) — NOT NULL

post (Untitled4)

  • id (Key) — UUID — Primary key — NOT NULL
  • user_id (Key2) — UUID — Foreign key → user.id — NOT NULL
  • post_background_id (Key3) — UUID — Foreign key → post_background.id — NOT NULL
  • post_image_id (Key6) — UUID — Foreign key → post_image.id — NOT NULL
  • post_category_id (Key5) — UUID — Foreign key → post_category.id — NOT NULL
  • title (Field) — varchar(100) — NOT NULL
  • content (Field2) — longtext — NOT NULL
  • like_count (Field4) — int(11) — NOT NULL
  • view_count (Field5) — int(11) — NOT NULL
  • allow_comment (Field6) — bit(1) — NOT NULL
  • scope (Field7) — int(11) — NOT NULL
  • date_created (Field3) — datetime — NOT NULL
  • date_updated (Field8) — datetime — NOT NULL
  • date_deleted (Field9) — datetime

post_background (Untitled5)

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

post_category (Untitled7)

  • id (Key) — UUID — Primary key — NOT NULL
  • name (Field) — varchar(50) — NOT NULL

post_image (Untitled6)

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

sticker (Untitled8)

  • id (Key) — UUID — Primary key — NOT NULL
  • image_url (Field) — varchar(255) — NOT NULL
  • user_id (Key2) — UUID — Foreign key → user.id

user (Untitled)

  • id (Key) — UUID — 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

user_auth (Untitled2)

  • id (Key) — UUID — Primary key — NOT NULL
  • user_id (Key2) — UUID — Foreign key → user.id — NOT NULL
  • authorization_code (Field2) — varchar(255) — NOT NULL
  • refresh_token (Field3) — varchar(255)