psk

Tables (3)

Problems (P)

  • Id (Key) — int — Primary key — NOT NULL
  • platform (Field) — int
  • problemNum (Field2) — int
  • title (Field3) — varchar
  • rank (Field4) — varchar

Users (U)

  • Id (Key) — int — Primary key — NOT NULL
  • email (Field2) — varchar
  • name (Field) — varchar

posts (Untitled)

  • Id (Key) — int — Primary key — NOT NULL
  • pId (Key2) — int — Foreign key → Problems.Id — NOT NULL
  • uid (Key3) — int — Foreign key → Users.Id — NOT NULL
  • code (Field2) — text
  • content (Field3) — text
  • createdDate (Field4) — Datetime