lin

Tables (6)

category (Untitled2)

  • id (Key) — varchar(3) — Primary key — NOT NULL
  • name (Field) — varchar(20) — NOT NULL

content (Untitled)

  • id (Key) — varchar(15) — Primary key — NOT NULL
  • uid (Key2) — varchar(15) — Foreign key → user.id — NOT NULL
  • category_id (Key3) — varchar(15) — Foreign key → category.id — NOT NULL
  • title (Field) — varchar(30) — NOT NULL
  • text (Field2) — longtext — NOT NULL
  • view_count (Field3) — int — NOT NULL
  • create_time (Field4) — datetime — NOT NULL
  • modify_time (Field5) — datetime — NOT NULL
  • likes (Field6) — int — NOT NULL

notification (Untitled4)

  • id (Key) — varchar(15) — Primary key — NOT NULL
  • content_id (Key4) — varchar(15) — Foreign key → content.id
  • sender_id (Key2) — varchar(15) — Foreign key → user.id — NOT NULL
  • receiver_id (Key22) — varchar(15) — Foreign key → content.uid — NOT NULL
  • type (Field) — enum — NOT NULL
  • text (Field2) — longtext

reply (Untitled5)

  • id (Key) — varchar(15) — Primary key — NOT NULL
  • content_id (Key2) — varchar(15) — Foreign key → content.id — NOT NULL
  • uid (Key3) — varchar(15) — Foreign key → user.id — NOT NULL
  • text (Field) — longtext — NOT NULL
  • create_time (Field2) — datetime — NOT NULL
  • modify_time (Field3) — datetime — NOT NULL
  • isDeleted (Field4) — bool — NOT NULL
  • isRe (Field5) — bool — NOT NULL
  • reply_id (Field6) — varchar(15)
  • Field7

report (Untitled3)

  • id (Key) — varchar(15) — Primary key — NOT NULL
  • reporter_uid (Key5) — varchar(15) — Foreign key → user.id — NOT NULL
  • reported_uid (Key2) — varchar(15) — Foreign key → user.id — NOT NULL
  • content_id (Key3) — bigint — Foreign key → content.id
  • reply_id (Key4) — bigint — Foreign key → reply.id
  • text (Field) — longtext — NOT NULL

user

  • id (Key) — varchar(15) — Primary key — NOT NULL
  • email (Field) — varchar(255) — NOT NULL
  • username (Field2) — varchar(15)
  • image_link (Field3) — varchar(255)