@Relation实现房间数据库中的关系,但与之混淆。。
学生桌
@Entity(tableName = "student")
data class Student(
@PrimaryKey(autoGenerate = false)
@ColumnInfo(name = "student_id")
var id: Int = 0,
@ColumnInfo(name = "student_name")
var name: String? = null,
@ColumnInfo(name = "student_email")
var email: String? = null,
@ColumnInfo(name = "student_created_date")
var created: Long = System.currentTimeMillis(),
var school_id: Int = -1
)主题表:
@Entity(tableName = "subject")
data class Subject(
@ColumnInfo(name = "subject_id")
var id: Int,
@ColumnInfo(name = "subject_name")
var name: String
)标记表
@Entity(tableName = "marks")
data class Marks(
@ColumnInfo(name = "student_id")
var stu_id: Int,
@ColumnInfo(name = "subject_id")
var sub_id: Int,
@ColumnInfo(name = "marks")
var marks: Int,
)我想取回学生与他们各自的分数,按科目。下面是我定义的类,但我不知道如何用关系定义three tables
data class StudentWithMarks(
@Embedded var student: Student,
@Relation(
parentColumn = "student_id",
entityColumn = "student_id"
)
var marks: List<Marks>
)发布于 2021-03-22 08:46:37
您可以向学生表中再添加一个名为columnInfo的subject_id,然后可以在学生和subject表之间创建关系。
https://stackoverflow.com/questions/66741212
复制相似问题