Encountered in the sample application schema for Mouthful located in experiments/schema-annot/annotated/mouthful-annotated.sql
K9db cannot accurately capture the Author column in the Comment table which refers to a data subject that owns all data. (The entire application contains just two tables: Comment and Thread).
CREATE TABLE Thread(
Id int PRIMARY KEY,
CreatedAt datetime not null,
Path text not null
);
CREATE TABLE Comment(
Id int PRIMARY KEY,
ThreadId int not null,
Body text not null,
Author text not null,
Confirmed int not null,
CreatedAt datetime not null,
ReplyTo int not null,
DeletedAt datetime not null,
FOREIGN KEY(ThreadId) references Thread(Id),
);
Work around: modify schema by adding a separate user table
CREATE DATA_SUBJECT TABLE user (
id text PRIMARY KEY
);
and then adding a foreign key to user(id) in Comment
Encountered in the sample application schema for Mouthful located in
experiments/schema-annot/annotated/mouthful-annotated.sql
K9db cannot accurately capture the
Author
column in theComment
table which refers to a data subject that owns all data. (The entire application contains just two tables:Comment
andThread
).Work around: modify schema by adding a separate user table
and then adding a foreign key to
user(id)
inComment