cswki

Tables (5)

Edit (Untitled4)

  • id (Key) — long — Primary key — NOT NULL
  • userId (Key2) — long — Foreign key → User.id — NOT NULL
  • wikiId (Key3) — long — Foreign key → Wiki.id — NOT NULL

User (Untitled)

  • id (Key) — long — Primary key — NOT NULL
  • email (Field) — text
  • pw (Field2) — text

VersionHistory (Untitled3)

  • id (Key) — long — Primary key — NOT NULL
  • id (Key2) — Foreign key → Wiki.id — NOT NULL
  • userId (Field) — long
  • oldValue (Field2) — text
  • newValue (Field3) — enum
  • diffType (Field4)
  • diffField (Field5)

Wiki (Untitled2)

  • id (Key) — long — Primary key — NOT NULL
  • imgUrl (Field) — text
  • title (Field2) — text
  • courseCode (Field3) — text

WikiContent (Untitled5)

  • id (Key) — long — Primary key — NOT NULL
  • wikiId (Key3) — Wiki — Foreign key → Wiki.id — NOT NULL
  • content (Field) — text
  • orderIndex (Field2) — long
  • parentId (Field3) — long