pjt1

Tables (8)

anonymous (Untitled8)

  • id (Key2) — integer — Primary key — NOT NULL
  • user_id (Key) — integer — Foreign key → article.id — NOT NULL
  • article_id (id) — integer — Foreign key → user.id — NOT NULL
  • number (Field) — integer
  • id (Key3) — integer — Foreign key → article.id — NOT NULL

article (Untitled3)

  • id (Key) — integer — Primary key — NOT NULL
  • title (Field) — varchar(50)
  • content (Field2) — text
  • created_at (Field3) — datetime
  • updated_at (Field4) — datetime
  • category_id (Key2) — integer — Foreign key → category.id — NOT NULL
  • user_id (id) — integer — Foreign key → user.id — NOT NULL

category (Untitled5)

  • id (Key) — integer — Primary key — NOT NULL
  • name (Field) — varchar(15)

comment (Untitled6)

  • id (Key) — integer — Primary key — NOT NULL
  • user_id (id) — integer — Foreign key → user.id — NOT NULL
  • article_id (Key2) — integer — Foreign key → article.id — NOT NULL
  • content (Field) — varchar(200)
  • anonymous (Field2) — integer

follow (Untitled7)

  • id (Key) — integer — Primary key — NOT NULL
  • from_user_id (id) — integer — Foreign key → user.id — NOT NULL
  • to_user_id (id2) — integer — Foreign key → user.id — NOT NULL

like (Untitled4)

  • id (Key2) — integer — Primary key — NOT NULL
  • article_id (Key) — integer — Foreign key → article.id — NOT NULL
  • user_id (id) — integer — Foreign key → user.id — NOT NULL

oauthid (Untitled2)

  • id (Key) — integer — Primary key — NOT NULL
  • user_id — integer — Foreign key → user.id — NOT NULL
  • access_token (Field) — varchar(255)
  • provider (Field2) — varchar(255)

user (Untitled)

  • id — integer — Primary key — NOT NULL
  • username — varchar(15)
  • password — varchar(128)
  • mbti (Field) — varchar(10)