likelion_page

Tables (3)

comment

  • id (Key) — INTEGER — Primary key — NOT NULL
  • id (Key2) — INTEGER — Foreign key → post.id — NOT NULL
  • id (Key22) — INTEGER — Foreign key → post.id — NOT NULL
  • content (Field) — TEXT
  • created_at (Field2) — TIMESTAMP
  • updated_at (Field3) — TIMESTAMP
  • like_count (Field4) — INTEGER
  • dislike_count (Field5) — INTEGER
  • parent_comment_id (Field6) — INTEGER
  • depth (Field7) — INTEGER

post

  • id (Key) — INTEGER — Primary key — NOT NULL
  • id (Key2) — INTEGER — Foreign key → user.id — NOT NULL
  • title (Field3) — VARCHAR
  • content (Field) — TEXT
  • created_at (Field2) — TIMESTAMP
  • updated_at (Field4) — TIMESTAMP
  • view_count (Field5) — INTEGER
  • like_count (Field6) — INTEGER
  • comment_count (Field7) — INTEGER

user

  • id (Key) — INTEGER — Primary key — NOT NULL
  • username (Field) — VARCHAR
  • email (Field2) — VARCHAR
  • password (Field3) — VARCHAR
  • created_at (Field4) — TIMESTAMP
  • updated_at (Field5) — TIMESTAMP
  • profile_picture (Field6) — VARCHAR
  • last_login (Field7) — TIMESTAMP