blocks|key|2808729|text|SQLite3中的触发器强制执行外键约束。Link+https://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers将帮助您解决第一个问题。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|2808730|entityMap|0|LINK|mutability|MUTABLE|url|https://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers^0|Q|1K|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

Triggers in SQLite3 enforces foreign key constraints. Link <a href="https://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers" rel="nofollow">https://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers</a> would help you out to solve your first question.

blocks|key|189255|text|我找不到使用“数据库结构”选项卡定义外键约束的方法。我强烈建议使用脚本来定义表定义和约束，而不是使用图形化编辑器来构建它们-这使得创建新数据库和跟踪对模式的更改变得更加容易。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|189256|举个例子，假设我们有两个表:一个定义文件名，另一个指定压缩方法，我们可以在定义file_definition表时给它添加一个外键约束。|189257|CREATE+TABLE+[compression_state]+(
++++[compression_state_id]+INTEGER++PRIMARY+KEY+NOT+NULL,
++++[value]+TEXT++NOT+NULL
);

CREATE+TABLE+[file_definition]+(
++++[file_id]+INTEGER++NOT+NULL++PRIMARY+KEY+AUTOINCREMENT,
++++[compression_state_id]+INTEGER++NOT+NULL,
++++[name]+TEXT+NOT+NULL,
++++FOREIGN+KEY(compression_state_id)+REFERENCES+compression_state(compression_state_id)
);|code-block|syntax|javascript|189258|但是，默认情况下，SQLite不会强制执行约束，因此每次连接到数据库时，都必须发出以下命令来启用约束检查。|189259|PRAGMA+foreign_keys+=+ON;|189260|有关更多详细信息，请参阅documentation。|offset|length|189261|如果表已经存在，而您不想构建一个完整的脚本，那么您就不走运了，一旦生成了表，SQLite就不支持添加外键，请参见此处：SQL+Features+That+SQLite+Does+Not+Implement|189262|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqlite.org/foreignkeys.html|1|http://www.sqlite.org/omitted.html^0|0|0|0|0|0|C|D|0|0|1N|17|1|0^^$0|@$1|2|3|4|5|6|7|12|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|13|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|14|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|15|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|16|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|17|8|@]|9|@$O|18|P|19|1|1A]]|A|$]]|$1|Q|3|R|5|6|7|1B|8|@]|9|@$O|1C|P|1D|1|1E]]|A|$]]|$1|S|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]]|T|$U|$5|V|W|X|A|$Y|Z]]|10|$5|V|W|X|A|$Y|11]]]]

I couldn't find a way of defining foreign key constraints using the "Database Structure" tab. I'd strongly recommend defining table definitions and constraints using a script rather than building them using the graphical editor - it makes it much easier to create new databases and to track changes to the schema. 

By way of an example, assume we have two tables: one defining file names and one specifying the method used for compression, we can add a foreign key constraint to the file_definition table when defining it.

<pre><code>CREATE TABLE [compression_state] (
 [compression_state_id] INTEGER PRIMARY KEY NOT NULL,
 [value] TEXT NOT NULL
);

CREATE TABLE [file_definition] (
 [file_id] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 [compression_state_id] INTEGER NOT NULL,
 [name] TEXT NOT NULL,
 FOREIGN KEY(compression_state_id) REFERENCES compression_state(compression_state_id)
);
</code></pre>

However, by default, SQLite will not enforce the constraint, therefore every time you connect to the database, you must issue the following command to enable constraint checking.

<pre><code>PRAGMA foreign_keys = ON;
</code></pre>

Further details in the <a href="http://www.sqlite.org/foreignkeys.html">documentation</a>.

If the tables already exist and you don't want to build a complete script then you're out of luck, SQLite doesn't support adding foreign keys once the table has been generated, see here: <a href="http://www.sqlite.org/omitted.html">SQL Features That SQLite Does Not Implement</a>

blocks|key|2808881|text|从SQLite文档中：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2808882|CREATE+TABLE+artist(
++artistid++++INTEGER+PRIMARY+KEY,+
++artistname++TEXT
);
CREATE+TABLE+track(
++trackid+++++INTEGER,
++trackname+++TEXT,+
++trackartist+INTEGER+++++--+Must+map+to+an+artist.artistid!
);++|code-block|syntax|javascript|2808883|最后：|2808884|CREATE+TABLE+track(
++trackid+++++INTEGER,+
++trackname+++TEXT,+
++trackartist+INTEGER,
++FOREIGN+KEY(trackartist)+REFERENCES+artist(artistid)
);|2808885|在SQLite环境的DB浏览器(v3.8.0-SQLitev3.9.2)中，当您添加track表的DB字段以及PK、AI和其他列时，您可以找到一个外键列。|offset|length|style|CODE|2808886|在这里，对于本例，您只需在trackartist行中添加artist(artistid)。|2808887|然后创建外键约束。|2808888|entityMap^0|0|0|0|0|16|5|0|D|B|S|G|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@$M|11|N|12|O|P]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|13|8|@$M|14|N|15|O|P]|$M|16|N|17|O|P]]|9|@]|A|$]]|$1|S|3|T|5|6|7|18|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|19|8|@]|9|@]|A|$]]]|V|$]]

From the SQLite Documentation :

<pre><code>CREATE TABLE artist(
 artistid INTEGER PRIMARY KEY, 
 artistname TEXT
);
CREATE TABLE track(
 trackid INTEGER,
 trackname TEXT, 
 trackartist INTEGER -- Must map to an artist.artistid!
); 
</code></pre>

and in the end :

<pre><code>CREATE TABLE track(
 trackid INTEGER, 
 trackname TEXT, 
 trackartist INTEGER,
 FOREIGN KEY(trackartist) REFERENCES artist(artistid)
);
</code></pre>

In the DB Browser for SQLite Environment (v 3.8.0 - Sqlite v 3.9.2) when you add the DB fields for the <code>track</code> table along with 
the PK ,AI and other columns you can find a Foreign Key Column. 

In there , and for this example, you just add <code>artist(artistid)</code> in the <code>trackartist</code> row. 
Then the foreign key constraint is created.

blocks|key|2808929|text|我知道这个问题很久以前就被问过了，但我找到了。它直接内置于GUI中。您只需拖动并使这些名称、类型选项卡小一点，即可为外键选项卡腾出空间。将鼠标指针放在末尾，然后拖动标题。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2808930|我的SQLite浏览器版本是3.7.0。|2808931|​|2808932|📷|atomic|offset|length|2808933|2808934|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/591bc1fbe0e0285183d30467ad84bc8e.png|imageAlt^0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|X|8|@]|9|@$I|Y|J|Z|1|10]]|A|$]]|$1|K|3|E|5|6|7|11|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|M|$N|$5|O|P|Q|A|$R|S|T|-4]]]]

I know this question has been asked long ago but I found it. Its built right into GUI. You just need to drag and make those Name, Type tabs little bit small to make space for the Foreign Key tab. Place your mouse pointer at the end and drag the header.

My version of SQLite Browser is Version 3.7.0.

<a href="https://i.stack.imgur.com/DtvNW.png" rel="noreferrer"><img src="https://i.stack.imgur.com/DtvNW.png" alt="enter image description here"></a>

blocks|key|2808967|text|在DB浏览器中，在Edit+Table+Definition窗口中，双击外键的空白区域，将激活一个文本框。你可以在那里添加你的外键。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2808968|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

In DB Browser, in the Edit Table Definition window, you can double click the blank area of Foreign Key and a text box will activate. You can add your Foreign Key there.

blocks|key|3021637|text|转到编辑表定义窗口|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3021638|单击添加字段|3021639|命名为Type+:+Integer|3021640|向右滚动并查找外键列|3021641|双击新行中的外键列下|3021642|选择主表及其id字段|3021643|单击确定|3021644|单击写入更改|3021645|​|3021646|📷|atomic|offset|length|3021647|3021648|entityMap|0|IMAGE|mutability|IMMUTABLE|imageUrl|https://ask.qcloudimg.com/http-save/yehe-900000/fe04bb5bca0fc0608350087cf141f97d.png|imageAlt^0|0|0|0|0|0|0|0|0|0|0|1|0|0|0^^$0|@$1|2|3|4|5|6|7|16|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|17|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|18|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|19|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1A|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1B|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1C|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1D|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1E|8|@]|9|@]|A|$]]|$1|R|3|S|5|T|7|1F|8|@]|9|@$U|1G|V|1H|1|1I]]|A|$]]|$1|W|3|Q|5|6|7|1J|8|@]|9|@]|A|$]]|$1|X|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|Y|$Z|$5|10|11|12|A|$13|14|15|-4]]]]

Go to edit table definition window
Click on Add field
Name it with Type : Integer
Scroll right and find Foreign Key column
Double click under Foreign Key column in new row
Select master table and its id field
Click OK
Click Write Changes
<img src="https://i.stack.imgur.com/iKlQL.png" alt="enter image description here" />

blocks|key|187287|text|这真的很简单，只需转到编辑表定义窗口即可|type|unstyled|depth|inlineStyleRanges|entityRanges|data|187288|右键单击要关联的表(外部表)|187289|选择[修改表|187290|在[约束]选项卡上，选择[添加约束]按钮，然后选择[外键]，您可以在此处关联表，然后返回到字段选项卡并执行以下操作|187291|命名为Type+:+Integer|187292|向右滚动并查找外键列|187293|双击新行中的外键列下|187294|选择主表及其id字段|187295|单击确定|187296|单击写入更改|187297|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|V|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|W|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|X|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|Y|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|Z|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|10|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|11|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|12|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|13|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|14|8|@]|9|@]|A|$]]|$1|T|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|U|$]]

it's really very easy , just do this
Go to edit table definition window
Right click on the table that you want to relate ( foreign table )
choose modify table
on Constraints tab select add constraints button and choose foreign key
you can relate tables here and then back to fields tab and do
Name it with Type : Integer
Scroll right and find Foreign Key column
Double click under Foreign Key column in new row
Select master table and its id field
Click OK
Click Write Changes

blocks|key|189384|text|我不确定这是否完全正确，但我是这样做的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|189385|189386|我在UserID字段选项卡中添加了变量"UserID“，并选中了框”+key“|unordered-list-item|offset|length|style|BOLD|189387|我转到constraints选项卡，并在"UserID"|189388|Then上添加了外键E29类型约束。我返回到<>E112字段选项卡，双击打开并添加了该键所在的表的名称和变量名称的E215字段。|189389|189390|entityMap^0|0|0|Y|5|0|0|S|0|0|1S|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|R|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|S|8|@$F|T|G|U|H|I]]|9|@]|A|$]]|$1|J|3|K|5|E|7|V|8|@$F|W|G|X|H|I]]|9|@]|A|$]]|$1|L|3|M|5|E|7|Y|8|@$F|Z|G|10|H|I]]|9|@]|A|$]]|$1|N|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|P|$]]

I am not sure whether this is entirely right but here's what I did:
<ul>
<li>I added the variable &quot;UserID&quot; in the fields tab an checked the box &quot;primary key&quot;</li>
<li>The I went to the constraints tab and added a foreign key Type constraint on the &quot;UserID&quot;</li>
<li>Then I went back to fields tab and double clicked on the foreign key field that opened and added the name of the table where that key is and the name of the variable</li>
</ul>

Sorry for novice question.

I have created my tables using SQLite database browser, but:

<ol>
<li>I do not know how can I specify my foreign keys using the application?</li>
<li>How can I create a relationship diagram between tables?</li>
</ol>

Create a foreign key in SQLite database browser

数据库

SQLite

对于新手的问题，很抱歉。我使用SQLite数据库浏览器创建了我的表，但是：我不知道如何使用application?How指定我的外键我可以创建表之间的关系图吗？

问在SQLite数据库浏览器中创建外键
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQLite数据库浏览器中创建外键EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQLite数据库浏览器中创建外键
EN