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