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)