sns

Tables (5)

Member (Untitled)

  • 식별자 (USER_ID) — NOT NULL — Primary key — NOT NULL
  • 이름 (USER_NAME) — NOT NULL
  • 이메일 (E-MAIL) — NOT NULL
  • 패스워드 (PASSWORD) — NOT NULL
  • 생년월일 (BIRTH_DATE) — NOT NULL
  • 닉네임 (NICKNAME) — NOT NULL
  • 소개 (COMMENT) — NOT NULL
  • 생성일 (CREATED_DATE) — NOT NULL
  • 수정일 (UPDATED_DATE) — NOT NULL

Memberstatus (Untitled3)

  • 식별자 (STATUS_ID) — NOT NULL — Primary key — NOT NULL
  • 식별자 (SEND_MEMBER_ID) — NOT NULL — Foreign key → Member.식별자 — NOT NULL
  • 식별자 (RECEIVE_MEMBER_ID) — NOT NULL
  • 상태값 (STATUS_VALUE) — NOT NULL

News Feed (Untitled2)

  • 식별자 (NEWSFEED_ID) — NOT NULL — Primary key — NOT NULL
  • 식별자 (USER_ID) — NOT NULL — Foreign key → Member.식별자 — NOT NULL
  • 제목 (TITLE) — NOT NULL
  • 컨텐츠 (CONTENTS) — NOT NULL
  • 작성일 (CREATED_DATE) — NOT NULL
  • 수정일 (UPDATED_DATE) — NOT NULL

NewsFeedLikes (Untitled4)

  • 식별자 (LIKE_ID) — NOT NULL — Primary key — NOT NULL
  • 식별자 (NEWSFEED_ID) — NOT NULL — Foreign key → News Feed.식별자 — NOT NULL
  • 식별자 (USER_ID) — NOT NULL — Foreign key → Member.식별자 — NOT NULL

Newsfeed Comment (Untitled5)

  • 식별자 (COMMENT_ID) — NOT NULL — Primary key — NOT NULL
  • 식별자 (USER_ID) — NOT NULL — Foreign key → Member.식별자 — NOT NULL
  • 식별자 (NEWSFEED_ID) — NOT NULL — Foreign key → News Feed.식별자 — NOT NULL
  • 생성일 (CREATED_DATE) — NOT NULL
  • 수정일 (UPDATED_DATE) — NOT NULL
  • 댓글 (CONTENTS) — NOT NULL