1021

Tables (6)

Ariticle (Article)

  • Key — Primary key — NOT NULL
  • title (Field) — varchar(10)
  • content (Field2) — text
  • created_at (Field3) — date
  • updated_at (Field4) — date
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL

Comment

  • Key — Primary key — NOT NULL
  • content (Field) — text
  • created_at (Field2) — date
  • updated_at (Field3) — date
  • article_id (Key2) — integer — Foreign key → Ariticle.Key — NOT NULL
  • user_id (Key3) — Foreign key → User.user_id — NOT NULL

Follow

  • Key — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL

Like

  • Key — Primary key — NOT NULL
  • article_id (Key2) — int — Foreign key → Ariticle.Key — NOT NULL
  • user_id (Key3) — int — Foreign key → User.user_id — NOT NULL

Profile

  • Key — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.user_id — NOT NULL
  • image (Field)
  • nickname (Field2) — text

User

  • user_id (Key) — Primary key — NOT NULL
  • username (Field) — text
  • first_name (Field2) — text
  • last_name (Field3) — text
  • email (Field4) — text