Jazzify
Tables (7)
ChordInfo (Untitled5)
- id (Key) — Long — Primary key — NOT NULL
- sheet_project_id (Key2) — Long — Foreign key → SheetProject.id
- chord_project_id (Key3) — Long — Foreign key → ChordProject.id
- sessionId (Key4) — Long — Foreign key → Session.id — NOT NULL
- chord (Field) — String — NOT NULL
- publicId (Field2) — String — NOT NULL
- length (Field3) — Enum — NOT NULL — QUATER,HALF,WHOLE
- sort_order (Field4) — int — NOT NULL
ChordProject (Untitled3)
- id (Key) — Long — Primary key — NOT NULL
- publicId (Field) — String — NOT NULL
- title (Field2) — String — NOT NULL
- key (Field3) — String — NOT NULL
- sessionId (Key2) — Long — Foreign key → Session.id
Session (Untitled6)
- id (Key) — Long — Primary key — NOT NULL
- publicId (Field) — String — NOT NULL
- title (Field2) — String
SessionMessage (CopyOfUntitled6)
- id (Key) — Long — Primary key — NOT NULL
- sessionId (Key2) — Long — Foreign key → Session.id — NOT NULL
- publicId (Field) — String — NOT NULL
- role (Field2) — String — NOT NULL
- content (Field3) — String — NOT NULL
- sort_order (Field4) — int — NOT NULL
SheetFile (Untitled4)
- id (Key) — Long — Primary key — NOT NULL
- publicId (Field) — String — NOT NULL
- originalFileName (Field2) — String
- savedFileName (Field3) — String
- filePath (Field4) — String
- fileType (Field5) — Enum — NOT NULL
SheetProject (Untitled2)
- id (Key2) — Long — Primary key — NOT NULL
- user_id (Key) — Long — Foreign key → User.id — NOT NULL
- file_id (Key3) — Long — Foreign key → SheetFile.id — NOT NULL
- sessionId (Key4) — Long — Foreign key → Session.id
- publicId (Field) — String — NOT NULL
- title (Field2) — String — NOT NULL
- key (Field3) — String
User (Untitled)
- id (Key) — Long — Primary key — NOT NULL
- publicId (Field) — String — NOT NULL
- name (Field2) — String — NOT NULL
- username (Field3) — String — NOT NULL
- password (Field4) — String — NOT NULL