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