SpringReact
Tables (8)
Comments (Untitled2)
- cid (Key) — INT — Primary key — NOT NULL
- bid (Key3) — INT — Foreign key → Post.bid — NOT NULL
- uid (Key32) — INT — Foreign key → Post.uid — NOT NULL
- comment_content (Field) — LONGTEXT
- nickname (Field2) — VARCHAR
- date (Field3)
Message
- mid (Key2) — Primary key — NOT NULL
- uid (Key) — INT — Foreign key → User.uid — NOT NULL
- recv_id (Field) — INT
- note (Field2) — LONGTEXT
- send_date (Field3) — DATE
- Field4
Post
- bid (Key) — INT — Primary key — NOT NULL
- uid (Key3) — INT — Foreign key → User.uid — NOT NULL
- nickname (Field) — VARCHAR
- title (Field2) — VARCHAR
- contents (Field3) — LONGTEXT
- date (Field4) — DATE
- category (Field5) — INT
- views (Field6) — INT
PostLikes (Likes)
- bid (Key) — INT — Foreign key → Post.bid — NOT NULL
- uid (Key2) — INT — Foreign key → User.uid — NOT NULL
- count (Field) — INT
ReviewLikes (Untitled)
- rid (Key) — INT — Foreign key → Reviews.rid — NOT NULL
- uid (Key3) — INT — Foreign key → Reviews.uid — NOT NULL
- count (Field) — INT
Reviews
- rid (Key) — INT — Primary key — NOT NULL
- uid (Key3) — INT — Foreign key → User.uid — NOT NULL
- nickname (Field) — VARCHAR
- semester (Field5) — VARCHAR
- univ_name (Field2) — INT
- subject_name (Field3) — VARCHAR
- content (Field4) — LONGTEXT
- Rating (Field6) — INT
- Test_type (Field7) — VARCHAR
- professor (Field8) — VARCHAR
Scrap
- rid (Key) — INT — Foreign key → Reviews.rid — NOT NULL
- uid (Key2) — INT — Foreign key → User.uid — NOT NULL
- bid (Key3) — INT — Foreign key → Post.bid — NOT NULL
User
- uid (Key) — INT — Primary key — NOT NULL
- password (Field3) — INT
- email (Field) — VARCHAR
- nickname (Field2) — VARCHAR
- univ (Field4) — INT