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