Wecodi

Tables (7)

Article (articles)

  • id (PK) — AutoField — Primary key — NOT NULL
  • category (FK2) — ForeignKey — Foreign key → ArticleCategory.id — NOT NULL
  • title (Field) — CharField
  • thumb_img (Field6) — CharField
  • content (Field2) — CharField
  • view_count (Field3) — IntegerField
  • style_tag (FK) — ForeignKey
  • created_at (Field4)
  • updated_at (Field5)

ArticleCategory (article_categories)

  • id (PK) — AutoField — Primary key — NOT NULL
  • name (Field) — CharField

Comment (comments)

  • id (PK) — AutoField — Primary key — NOT NULL
  • article (FK1) — ForeignKey — Foreign key → Article.id — NOT NULL
  • user (FK2) — CharField — Foreign key → User.id — NOT NULL
  • comment (Field) — TextField
  • deleted (Field2) — BooleanField
  • created_at (Field3) — DateTimeField
  • updated_at (Field4) — DateTimeField

Like (likes)

  • id (PK) — AutoField — Primary key — NOT NULL
  • user (FK) — ForeignKey — Foreign key → User.id — NOT NULL
  • article (FK2) — ForeignKey — Foreign key → Article.id — NOT NULL
  • created_at (Field) — DateTimeField

Profile (profiles)

  • user (PK) — OneToOneField — Foreign key → User.id — NOT NULL
  • nickname (Field2) — CharField
  • bio (Field) — CharField
  • profile_img (Field3) — CharField

Tag (style_tags)

  • id (PK) — AutoField — Primary key — NOT NULL
  • article (FK) — ForeignKey — Foreign key → Article.id — NOT NULL
  • name (Field) — CharField

User (users)

  • id (PK) — AutoField — Primary key — NOT NULL
  • email (Field6) — EmailField
  • first_name (Field1) — CharField
  • last_name (Field2) — CharField
  • password (Field3) — CharField
  • social_id (Field12) — CharField
  • Profile (FK) — ForeignKey
  • is_admin (Field4) — Boolean
  • is_blocked (Field11) — Boolean
  • last_login (Field10) — DateTime
  • visit_count (Field9) — IntField
  • deleted (Field5) — Boolean
  • created_at (Field7) — DateTime
  • updated_at (Field8) — DateTime