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)