hearts

Tables (5)

Categories (Untitled)

  • Id (id) — int — Primary key — NOT NULL
  • Id (id2) — int — Foreign key → users.Id — NOT NULL
  • Id (id22) — int — Foreign key → users.Id — NOT NULL
  • Id (id222) — int — Foreign key → users.Id — NOT NULL
  • Tilte (title) — varchar(255)
  • Created_at (created_at) — datetime
  • Updated_at (updated_at) — datetime

likes (Untitled4)

  • id — int — Primary key — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • user_id — int
  • post_id — int

posts (Untitled2)

  • id — int — Primary key — NOT NULL
  • Id (id2) — int — Foreign key → users.Id — NOT NULL
  • Id (id22) — int — Foreign key → users.Id — NOT NULL
  • Id (id222) — int — Foreign key → users.Id — NOT NULL
  • content — varchar(255)
  • total_like — int
  • share_cnt — int
  • visit_cnt — int
  • created_at — datetime
  • updated_at — datetime

tags (Untitled3)

  • id — int — Primary key — NOT NULL
  • title — varchar(255)
  • created_at — datetime
  • updated_at — datetime

users

  • Id (id) — int — Primary key — NOT NULL
  • Id (id2) — int — Foreign key → Categories.Id — NOT NULL
  • Id (id22) — int — Foreign key → Categories.Id — NOT NULL
  • Name (name) — varchar(255)
  • Email (email) — varchar(255)
  • Created_at (created_at) — datetime
  • Updated_at (updated_at) — datetime