newsfeed
Tables (4)
comment (댓글)
- id (댓글 식별자) — NOTNULL — Primary key — NOT NULL
- id (게시글 식별자) — NOTNULL — Foreign key → post.id — NOT NULL
- id (프로필 식별자) — NOTNULL — Foreign key → post.id — NOT NULL
- contents (내용) — NOTNULL
- created_time (생성 시간) — NOTNULL
- updated_time (수정시간) — NOTNULL
follwo (팔로우)
- id (팔로우 식별자) — NOTNULL — Primary key — NOT NULL
- id (프로필 식별자) — NOTNULL — Foreign key → profile.id — NOT NULL
- to_user (팔로우) — NULL
- from_user (팔로잉) — NULL
post (게시글)
- id (게시글 식별자) — NOTNULL — Primary key — NOT NULL
- id (프로필 식별자) — NOTNULL — Foreign key → profile.id — NOT NULL
- contents (내용) — NULL
- img (이미지) — NOTNULL
- tag (해시태그) — NULL
- created_time (생성시간) — NOTNULL
- updated_time (수정시간) — NOTNULL
- mention (멘션) — NOTNULL
- like (좋아요) — NOTNULL
profile (프로필)
- id (프로필 식별자) — NOTNULL — Primary key — NOT NULL
- email (이메일) — NOTNULL
- password (패스워드) — NOTNULL
- user_id (아이디) — NOTNULL
- name (이름) — NOTNULL
- intro (소개) — NULL
- profileImg (프로필이미지) — NOTNULL
- birthday (생일) — NOTNULL
- follow (팔로워) — NOTNULL
- following (팔로잉) — NOTNULL
- phone (전화번호) — NOTNULL
- is_withdrawn (탈퇴여부) — NOTNULL