sqlite_company.db•16.4 kB
SQLite format 3 @ .�)
F }+F �b �tableemployeesemployeesCREATE TABLE employees (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL,
department_id INTEGER,
salary REAL,
FOREIGN KEY (department_id) REFERENCES departments(id)
)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)� ##�GtabledepartmentsdepartmentsCREATE TABLE departments (
id INTEGER PRIMARY KEY AUTOINCREMENT,
name TEXT NOT NULL
)
� ��� 财务部 市场部 技术部
� ��
employees#departments
� �����
陈七*� 赵六2� 王五.�
李四>�
张三:�