PPL

Tables (3)

Interest (Untitled2)

  • id (Key2) — int — Primary key — NOT NULL
  • user_id (Key) — int — Foreign key → User.Key — NOT NULL
  • name (Field) — VARCHAR(120)
  • level (Field2) — int

Paper (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → User.Key — NOT NULL
  • abstract (Field) — Text
  • author (Field2) — VARCHAR(255)
  • category (Field3) — VARCHAR(255)
  • link (Field4) — VARCHAR(120)
  • title (Field5) — VARCHAR(120)
  • year (Field6) — int

User (Untitled)

  • Key — int — Primary key — NOT NULL
  • email (Field) — VARCHAR(120)
  • password_hash (Field2) — VARCHAR(120)
  • username (Field3) — VARCHAR(120)