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)