쏘이스토리

인별그램과 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