쏘이스토리
인별그램과 24월드의 혼종 + 메타버스의 움직임을 섞었습니다.
테이블 (24)
Deleted_member
- username — varchar2(50) — NOT NULL
- name — varchar2(50) — NOT NULL
- password — varchar2(300) — NOT NULL
- nickname — varchar2(50) — NOT NULL
- birthday — date — NOT NULL
- gender — char(1) — NOT NULL
- phone — varchar2(20) — NOT NULL
- email — varchar2(200) — NOT NULL
- provider — varchar2(50) — NOT NULL
- reg_date — date
- deleted_date — date
attachment
- id — number — 기본 키
- original_filename — varchar2(500) — NOT NULL
- renamed_filename — varchar2(500) — NOT NULL
- reg_date — date
attachment_photo_feed
- attachment_id — number — 외래 키 → attachment.id — NOT NULL
- photo_feed_id — number — 외래 키 → photo_feed.id — NOT NULL
attachment_profile
- attachment_id — number — 외래 키 → attachment.id — NOT NULL
- profile_id — number — 외래 키 → profile.id — NOT NULL
authorities
- authority — varchar2(1000) — 기본 키 — NOT NULL
- member_id — number — 외래 키 → member.id — NOT NULL
comments (comment)
- id — number — 기본 키
- writer_id — number — 외래 키 → member.id — NOT NULL
- content — varchar2(1000) — NOT NULL
- reg_date — date
comments_feed (comment_feed)
- comments_id (comment_id) — number — 외래 키 → comments.id — NOT NULL
- photo_feed_id — number — 외래 키 → photo_feed.id — NOT NULL
comments_question
- comment_id — number — 외래 키 → comments.id — NOT NULL
- question_id — number — 외래 키 → question.id — NOT NULL
dm
- id — number — 기본 키
- receiver_id — number — 외래 키 → member.id — NOT NULL
- sender_id — number — 외래 키 → member.id — NOT NULL
- content — number — NOT NULL
- dm_room_id — number — NOT NULL
- reg_date — date
follow
- id — number — 기본 키 — NOT NULL
- follwer (follower) — number — 외래 키 → member.id — NOT NULL
- followee — number — 외래 키 → member.id — NOT NULL
- reg_dat (reg_date) — date
guestbook
- id — number — 기본 키
- content — varchar2(1000) — NOT NULL
- reg_date — date
- writer_id — number — 외래 키 → member.id — NOT NULL
- member_id — number — 외래 키 → member.id — NOT NULL
like
- photo_feed_id — number — 외래 키 → member.id — NOT NULL
- member_id — number — 외래 키 → photo_feed.id — NOT NULL
member
- id — number — 기본 키
- username — varchar2(50) — NOT NULL
- name — varchar2(50) — NOT NULL
- password — varchar2(300) — NOT NULL
- nickname — varchar2(50) — NOT NULL
- birthday — date — NOT NULL
- gender — char(1) — NOT NULL
- phone — varchar2(20) — NOT NULL
- email — varchar2(200) — NOT NULL
- provider — varchar2(50) — NOT NULL
- reg_date — date
photo_feed
- id — number — 기본 키
- writer_id — number — 외래 키 → member.id — NOT NULL
- content — varchar2(1000) — NOT NULL
- reg_date — date
profile
- id — number — 기본 키
- member_id — number — 외래 키 → member.id — NOT NULL
- state — char(1) — NOT NULL
- introduction — varchar2(300)
question
- id — number — 기본 키
- writer_id — number — 외래 키 → member.id — NOT NULL
- content — varchar2(4000) — NOT NULL
- reg_date — date
report
- id — number — 기본 키
- reporter_id — number — 외래 키 → member.id — NOT NULL
- reported_id — number — 외래 키 → member.id — NOT NULL
- content — varchar2(1000) — NOT NULL
- reg_date — date
report_comments_feed (report_comment_feed)
- report_id — number — 외래 키 → report.id — NOT NULL
- comment_id — number — 외래 키 → comments_feed.comments_id — NOT NULL
report_dm
- report_id — number — 외래 키 → report.id — NOT NULL
- dm_id — number — 외래 키 → dm.id — NOT NULL
report_guestbook
- report_id — number — 외래 키 → report.id — NOT NULL
- guestbook_id — number — 외래 키 → guestbook.id — NOT NULL
report_photo_feed
- report_id — number — 외래 키 → report.id — NOT NULL
- photo_feed_id — number — 외래 키 → photo_feed.id — NOT NULL
report_profile
- report_idreport_id (report_id) — number — 외래 키 → report.id — NOT NULL
- profile_id — number — 외래 키 → profile.id — NOT NULL
report_story
- report_id — number — 외래 키 → report.id — NOT NULL
- story_id — number — 외래 키 → story.id — NOT NULL
story
- id — number — 기본 키
- writer_id — number — 외래 키 → member.id — NOT NULL
- content — varchar2(1000) — NOT NULL
- reg_date — date