project

Tables (5)

User (Untitled)

  • Key — integer — Primary key — NOT NULL
  • Password (Field) — varchar(128)
  • Username (Field2) — varchar(128)
  • Nickname (Field3) — varchar(128)
  • Is_active (Field4) — bool
  • Is_superuser (Field5) — bool

article (Untitled3)

  • Key — integer — Primary key — NOT NULL
  • Key (Key2) — integer — Foreign key → User.Key — NOT NULL
  • Title (Field) — varchar(128)
  • Rating (Field2) — integer
  • Contents (Field3) — textfield
  • Images (Field4) — filefield

comment (Untitled2)

  • Key — integer — Primary key — NOT NULL
  • Key (Key2) — integer — Foreign key → User.Key — NOT NULL
  • Key (Key3) — integer — Foreign key → article.Key — NOT NULL
  • Comment (Field) — varchar(128)
  • Rating (Field2) — integer
  • Created_at (Field3) — datetime
  • Updated_at (Field4) — datetime
  • Likes (Field5) — bool

post_tag (Untitled4)

  • Key — integer — Primary key — NOT NULL
  • Key (Key2) — integer — Foreign key → tag.Key — NOT NULL
  • Key (Key3) — integer — Foreign key → article.Key — NOT NULL
  • Field (article_id)

tag (Untitled5)

  • Key — integer — Primary key — NOT NULL
  • Tagname (Field) — varchar(128)