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