maack

Tables (5)

member (회원)

  • id (회원id) — bigint — Primary key — NOT NULL
  • name (회원이름) — varchar(100)
  • password (회원비밀번호) — text
  • role (회원역할) — enum
  • social_type (소셜로그인) — enum
  • social_id (소셜id) — bigint
  • email (회원이메일) — varchar(100)
  • profileImgUrl (프로필이미지url) — text

midiFile (악보 미디)

  • id (미디파일id) — bigint — Primary key — NOT NULL
  • pdf_file_id (pdf파일id) — bigint — Foreign key → pdfFile.id — NOT NULL
  • filename (파일이름) — varchar(255)
  • url (파일url) — varchar(1000)
  • filesize (파일크기) — bigint

musicXMLFile (musicXML파일)

  • id (musicXML파일id) — bigint — Primary key — NOT NULL
  • midi_file_id (미디파일id) — bigint — Foreign key → midiFile.id — NOT NULL
  • filename (파일이름) — varchar(255)
  • url (파일url) — varchar(1000)
  • filesize (파일크기) — bigint

pdfFile (악보pdf)

  • id (pdf파일id) — bigint — Primary key — NOT NULL
  • sheet_music_id (악보id) — bigint — Foreign key → sheet.id — NOT NULL
  • filename (파일이름) — varchar(255)
  • url (파일url) — varchar(1000)
  • filesize (파일크기) — bigint

sheet (악보)

  • id (악보id) — bigint — Primary key — NOT NULL
  • member_id (회원id) — bigint — Foreign key → member.id — NOT NULL