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