week1

Tables (3)

comments

  • id — INTEGER — Primary key — NOT NULL
  • post_id — INTEGER — Foreign key → postss.author_id — NOT NULL
  • author_id — INTEGER — Foreign key → users.id — NOT NULL
  • text — TEXT — NOT NULL
  • created_at — DATETIME

postss (posts)

  • id — INTEGER — Primary key — NOT NULL
  • author_id — INTEGER — Foreign key → users.id — NOT NULL
  • image_url — VARCHAR(255)
  • content — TEXT
  • like_count — INTEGER
  • created_at — DATETIME

users

  • id — INTEGER — Primary key — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • avatar — VARCHAR(255)
  • created_at — DATETIME