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)