chartflow

Tables (8)

Amblum (Untitled7)

  • amblumId (Key) — int — Primary key — NOT NULL
  • name (Field) — string

Article (Untitled3)

  • articleId (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → User.userId — NOT NULL
  • likes (Field) — int
  • views (Field2) — int
  • registertime (Field3) — datetime
  • content (Field4) — string

Comment (Untitled4)

  • Key2 — Primary key — NOT NULL
  • articleId (Key) — int — Foreign key → Article.articleId — NOT NULL
  • content (Field) — string
  • registertime (Field2) — datetime
  • Field3
  • userId (Key3) — int — Foreign key → User.userId — NOT NULL

Example (Untitled2)

  • Key — Primary key — NOT NULL
  • content (Field) — string
  • quizId (Key2) — int — Foreign key → Quiz.Key — NOT NULL

Quiz (Untitled5)

  • Key — Primary key — NOT NULL
  • question (Field) — string
  • answer (Field2) — string

ReComment (Untitled6)

  • Key — Primary key — NOT NULL
  • commentId (Key2) — int — Foreign key → Comment.Key2 — NOT NULL
  • userId (Key3) — int — Foreign key → User.userId — NOT NULL
  • content (Field) — string
  • registertime (Field2) — datetime

User (Untitled)

  • userId (Key) — int — Primary key — NOT NULL
  • money (Field) — int
  • coin (Field2) — int
  • rank (Field4) — int
  • cancel (Field5) — bool
  • name (Field6) — string

user_amblum (Untitled8)

  • Key — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → User.userId — NOT NULL
  • amblumId (Key3) — int — Foreign key → Amblum.amblumId — NOT NULL