kiano

Tables (4)

chart (Untitled3)

  • chart_id(pk) (Key) — UUID — Primary key — NOT NULL
  • sheet_id(fk) (Key2) — UUID — Primary key — NOT NULL
  • chart_data (Field)

playing session (Untitled4)

  • session_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — UUID — Primary key — NOT NULL
  • chart_id (Key3) — UUID — Primary key — NOT NULL
  • user_id(pk) (Key4) — varchar(10) — Foreign key → user.user_id(pk) — NOT NULL
  • chart_id(pk) (Key5) — UUID — Foreign key → chart.chart_id(pk) — NOT NULL
  • sheet_id(fk) (Key22) — UUID — Foreign key → chart.sheet_id(fk) — NOT NULL
  • play_time (Field)

sheet_music (Untitled2)

  • sheet_id(pk) (Key) — UUID — Primary key — NOT NULL
  • user_id(fk) (Key2) — UUID — Primary key — NOT NULL
  • user_id(pk) (Key3) — varchar(10) — Foreign key → user.user_id(pk) — NOT NULL
  • title (Field)
  • artist (Field2) — varchar(10)
  • sheet_data (Field3) — varchar(255)
  • chart_id(pk) (Key4) — UUID — Foreign key → chart.chart_id(pk) — NOT NULL
  • sheet_id(fk) (Key22) — UUID — Foreign key → chart.sheet_id(fk) — NOT NULL

user (Untitled)

  • user_id(pk) (Key) — varchar(10) — Primary key — NOT NULL
  • e_mail (Field)
  • password (Field2) — varchar(16)
  • profile_image (Field3)
  • customization_setting (Field4)
  • username (Field5) — varchar(9)