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