erd
Tables (5)
Answer (Untitled3)
- aid (Key) — Long — Primary key — NOT NULL
- qid (Key2) — Long — Foreign key → Question.qid — NOT NULL
- uid (Key3) — Long — Foreign key → User.uid — NOT NULL
- content (Field) — Varchar
- createdAt (Field2) — Datetime
- modifiedAt (Field3) — Datetime
- isSelected (Field4) — Boolean
Answer Vote (Untitled5)
- arid (Key) — Long — Primary key — NOT NULL
- aid (Key2) — Long — Foreign key → Answer.aid — NOT NULL
- uid (Key4) — Long — Foreign key → User.uid — NOT NULL
Question (Untitled2)
- qid (Key) — Long — Primary key — NOT NULL
- uid (Key2) — Long — Foreign key → User.uid — NOT NULL
- title (Field) — Varchar
- content (Field2) — Varchar
- createdAt (Field3) — Datetime
- modifiedAt (Field4) — Datetime
- view (Field5) — Integer
Question Vote (Untitled4)
- qrid (Key) — Long — Primary key — NOT NULL
- qid (Key2) — Long — Foreign key → Question.qid — NOT NULL
- uid (Key3) — Long — Foreign key → User.uid — NOT NULL
User (Untitled)
- uid (Key) — Long — Primary key — NOT NULL
- email (Field) — Varchar
- username (Field2) — Varchar
- image (Field3) — Varchar
- password (Field4) — Varchar