如何在Boat母类与子类的依赖关系中执行INSERT操作？

这种在关系型数据库里处理类继承的方式，属于**"表每类（Table Per Class）"**映射策略，刚好匹配你的需求：父类Boat存储所有船只的通用属性，子类sailing和motor各自存储特有属性，通过外键关联父类主键实现关联。

具体插入逻辑可按场景拆分：

• 仅创建帆船：先插入Boat表，再插入sailing表，跳过motor表操作

  INSERT INTO boat (registration, name) VALUES('XXXXXXX','A');
  INSERT INTO sailing (registration, quantity) VALUES ('XXXXXXX',3);
  

• 仅创建摩托艇：先插入Boat表，再插入motor表，跳过sailing表操作

  INSERT INTO boat (registration, name) VALUES('XXXXXXX','B');
  INSERT INTO motor(registration, power) VALUES ('XXXXXXX',35);
  

• 创建兼具两种属性的船只：按你最初的思路，依次插入Boat、motor、sailing三张表即可

  INSERT INTO boat (registration, name) VALUES('XXXXXXX','C');
  INSERT INTO motor(registration, power) VALUES ('XXXXXXX',35);
  INSERT INTO sailing (registration, quantity) VALUES ('XXXXXXX',3);
  

额外注意事项 #

• 建议给子类表的registration外键设置**ON DELETE CASCADE**约束，这样删除Boat表的记录时，子类对应的关联记录会自动删除，避免产生孤立的冗余数据。
• 把同一条船只的所有插入操作放在一个事务中执行，比如用BEGIN TRANSACTION和COMMIT包裹，确保某一步插入失败时，所有操作都会回滚，保证数据一致性：

  BEGIN TRANSACTION;
  INSERT INTO boat (registration, name) VALUES('XXXXXXX','C');
  INSERT INTO motor(registration, power) VALUES ('XXXXXXX',35);
  INSERT INTO sailing (registration, quantity) VALUES ('XXXXXXX',3);
  COMMIT;
  

内容的提问来源于stack exchange，提问作者Math Enjoyer