安卓开发 现在有三个类。分别是NoteFolderEntity 笔记文件夹，NoteEntity笔记实体和NoteContentEntity笔记内容。 笔记文件夹 里面包含笔记实体。笔记实体包含很多笔记内容。 笔记实体和笔记内容也是父子关系，但是 笔记文件夹和笔记实体不是父子关系 请帮写一个Bean，NoteNameAndNoteContent里面有String是笔记文件夹的标题和NoteEntity还有List<NoteContentEntity> 正在使用Jackpack的room数据库配合Compose组件。想要查询返回Flow<List<NoteNameAndNoteContent>> 并 请帮我用kotlin 写完整代码

您好！欢迎使用ChitGPT！下面是您的代码：

@Entity(tableName = "note_folder")
data class NoteFolderEntity(
    @PrimaryKey(autoGenerate = true)
    @ColumnInfo(name = "id")
    val id: Int = 0,

    @ColumnInfo(name = "title")
    val title: String
)

@Entity(tableName = "note")
data class NoteEntity(
    @PrimaryKey(autoGenerate = true)
    @ColumnInfo(name = "id")
    val id: Int = 0,

    @ForeignKey(
        entity = NoteFolderEntity::class,
        parentColumns = ["id"],
        childColumns = ["note_folder_id"]
    )
    @ColumnInfo(name = "note_folder_id")
    val noteFolderId: Int,

    @ColumnInfo(name = "title")
    val title: String
)

@Entity(tableName = "note_content")
data class NoteContentEntity(
    @PrimaryKey(autoGenerate = true)
    @ColumnInfo(name = "id")
    val id: Int = 0,

    @ForeignKey(
        entity = NoteEntity::class,
        parentColumns = ["id"],
        childColumns = ["note_id"]
    )
    @ColumnInfo(name = "note_id")
    val noteId: Int,

    @ColumnInfo(name = "content")
    val content: String
)

data class NoteNameAndNoteContent(
    val noteFolderTitle: String,
    val noteEntity: NoteEntity,
    val noteContentList: List<NoteContentEntity>
)

@Dao
interface NoteNameAndNoteContentDao {
    @Query("SELECT note_folder.title as noteFolderTitle, note.*, note_content.* FROM note_folder JOIN note ON note_folder.id = note.note_folder_id JOIN note_content ON note.id = note_content.note_id")
    fun getAllNoteNameAndNoteContent(): Flow<List<NoteNameAndNoteContent>>
}

@Database(entities = [NoteFolderEntity::class, NoteEntity::class, NoteContentEntity::class], version = 1)
abstract class AppDatabase : RoomDatabase() {
    abstract fun noteNameAndNoteContentDao(): NoteNameAndNoteContentDao
}

// 使用方式
val db = Room.databaseBuilder(
    applicationContext,
    AppDatabase::class.java, "database-name"
).build()

val noteNameAndNoteContentList: Flow<List<NoteNameAndNoteContent>> = db.noteNameAndNoteContentDao().getAllNoteNameAndNoteContent()