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)