erd

Tables (13)

member (Untitled9)

  • member_id (Key) — Primary key — NOT NULL
  • nickname (Field2)
  • token (Field3)
  • type (Field4)

message (mongo) (Untitled10)

  • message_id (Key) — Primary key — NOT NULL
  • text (Field)
  • send_date (Field2)
  • sender (Field3)
  • receiver (Field4)

message_report (Untitled11)

  • message_id (Key) — Foreign key → message (mongo).message_id — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • detail (Field)

musicmate (Untitled12)

  • mate_id (Key2) — Primary key — NOT NULL
  • member_id (Key) — Foreign key → member.member_id — NOT NULL
  • request_date (Field)
  • is_mate (Field2)
  • is_block (Field3)

postcard (Untitled4)

  • post_url (Key3) — Primary key — NOT NULL
  • post_date (Field2)
  • is_public (Field3)
  • tag (Field4)
  • song_id (Key) — Foreign key → song.song_id — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL

postcard_emogi (Untitled6)

  • post_url (Key3) — Foreign key → postcard.post_url — NOT NULL
  • emoji1 (Field)
  • emoji2 (Field2)
  • emoji3 (Field3)

postcard_feedback (Untitled5)

  • feedback_url (Key2) — Primary key — NOT NULL
  • feedback_date (Field2)
  • member_id (Key) — Foreign key → member.member_id — NOT NULL
  • post_url (Key3) — Foreign key → postcard.post_url — NOT NULL

postcard_message (Untitled7)

  • post_url (Key3) — Primary key — NOT NULL
  • post_date (Field2)
  • is_public (Field3)
  • code (Field4)
  • song_id (Key) — Foreign key → song.song_id — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL
  • addressee (Key4) — Foreign key → member.member_id — NOT NULL

postcard_report (CopyOfUntitled11)

  • post_url (Key3) — Foreign key → postcard.post_url — NOT NULL
  • member_id (Key) — Foreign key → member.member_id — NOT NULL
  • detail (Field)

region (Untitled8)

  • name (Field)
  • address (Field2)

song (Untitled)

  • song_id (Key) — Primary key — NOT NULL
  • cover_image (Field2)
  • name (Field3)
  • singer (Field4)

song_feedback (Untitled3)

  • post_url (Key3) — Primary key — NOT NULL
  • post_date (Field3)
  • song_id (Key) — Foreign key → song.song_id — NOT NULL
  • member_id (Key2) — Foreign key → member.member_id — NOT NULL

song_info (Untitled2)

  • song_id (Key) — Foreign key → song.song_id — NOT NULL
  • recommended_date (Field2)
  • recommended_number (Field3)
  • like (Field4)