sns project

Tables (9)

ACTIVITIES

  • activity_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • from_user_id — INT — NOT NULL
  • post_id — INT — NOT NULL
  • type — ENUM('like') — NOT NULL
  • created_at — DATETIME — NOT NULL

COMMENTS

  • comment_id — INT — Primary key — NOT NULL
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT — NOT NULL
  • parent_comment_id — INT
  • created_at — DATETIME — NOT NULL

COMMENT_TAGS

  • comment_id — INT — NOT NULL
  • tagged_user_id — INT — NOT NULL

FOLLOWERS

  • follower_id — INT — Primary key — NOT NULL
  • following_id — INT — Primary key — NOT NULL
  • created_at — DATETIME — NOT NULL

LIKES

  • like_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • post_id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

POSTS

  • post_id — INT — Primary key — NOT NULL
  • user_id (user_id2) — INT — Foreign key → USERS.user_id — NOT NULL
  • user_id — INT — NOT NULL
  • content — TEXT
  • created_at — DATETIME — NOT NULL

POST_IMAGES

  • image_id — INT — Primary key — NOT NULL
  • post_id — INT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • sort_order — INT

POST_TAGS

  • post_id — INT — NOT NULL
  • tagged_user_id — INT — NOT NULL

USERS

  • user_id — INT — Primary key — NOT NULL
  • userName — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100)
  • pwd — VARCHAR(255) — NOT NULL
  • birth — DATE
  • profile_image — VARCHAR(255)
  • nickname — VARCHAR(30)
  • website — VARCHAR(255)
  • bio — TEXT