sns_system_db

Tables (3)

comments (Untitled2)

  • comment_id (Key) — bigint(20) — Primary key — NOT NULL
  • content (Field2) — varchar(255)
  • created_at (Field3) — datetime
  • post_id (Key2) — bigint(20) — Foreign key → posts.post_id — NOT NULL
  • user_id (id) — bigint(20) — Foreign key → users.user_id — NOT NULL

posts (Untitled)

  • post_id (Key) — bigint(20) — Primary key — NOT NULL
  • title (Field2) — varchar(255)
  • content (Field3) — TEXT
  • created_at (Field) — datetime
  • user_id (id) — bigint(20) — Foreign key → users.user_id — NOT NULL

users (사용자)

  • user_id (id) — bigint(20) — Primary key — NOT NULL
  • name — varchar(255)
  • email — varchar(255)