news

Tables (7)

comments (댓글)

  • comment_id (댓글번호) — int — Primary key — NOT NULL
  • parent_comment_id (댓글부모번호) — int
  • content (내용) — varchar(500)
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime
  • use_yn (사용여부) — int — 0 사용안함 1 사용
  • user_id (유저번호) — int — Foreign key → users.user_id — NOT NULL
  • news_id (뉴스번호) — int — Foreign key → news_feed.news_id — NOT NULL

comments_like (댓글좋아요로그)

  • like_id (좋아요번호) — int — Primary key — NOT NULL
  • created_at (생성일자) — datetime
  • comment_id (댓글번호) — int — Foreign key → comments.comment_id — NOT NULL
  • user_id (유저번호) — int — Foreign key → users.user_id — NOT NULL

friends_request (친구요청)

  • req_id (요청번호) — int — Primary key — NOT NULL
  • created_at (생성일자) — datetime
  • status (상태) — int — 0 사용안함 1 사용
  • from_user_id (요청자) — int — Foreign key → users.user_id — NOT NULL
  • to_user_id (수신자) — int — Foreign key → users.user_id — NOT NULL

news_feed (뉴스피드)

  • news_id (뉴스번호) — int — Primary key — NOT NULL
  • title (제목) — varchar(100)
  • content (내용) — text
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime
  • deleted_at (삭제일자) — datetime
  • view_count (조회수) — int
  • user_id (유저번호) — int — Foreign key → users.user_id — NOT NULL

news_files (뉴스피드파일)

  • file_id (파일번호) — int — Primary key — NOT NULL
  • path (경로) — varchar(300)
  • original_name (원본명) — varchar(100)
  • size (사이즈) — int
  • created_at (생성일자) — datetime — current_timestamp
  • user_id (유저번호) — int — Foreign key → users.user_id — NOT NULL
  • news_id (뉴스번호) — int — Foreign key → news_feed.news_id — NOT NULL

news_like (뉴스좋아요로그)

  • like_id (좋아요번호) — int — Primary key — NOT NULL
  • created_at (생성일자) — datetime
  • news_id (뉴스번호) — int — Foreign key → news_feed.news_id — NOT NULL
  • user_id (유저번호) — int — Foreign key → users.user_id — NOT NULL

users (사용자)

  • user_id (유저번호) — int — Primary key — NOT NULL
  • email (이메일) — varchar(100)
  • password (비밀번호) — varchar(100)
  • nickname (닉네임) — varchar(50)
  • created_at (생성일자) — datetime — current_timestamp
  • updated_at (수정일자) — datetime — current_timestamp
  • deleted_at (삭제일자) — datetime
  • profile_image_url (이미지경로) — varchar(255)