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