问当我将一个子实体插入到父表中时，我需要在该子实体中插入一个ID

EN

CREATE TABLE Device (
   deviceCatalogID varchar(5),
   deviceCatalogName varchar(20),
   deviceDescription varchar(300),
   availabilityStatus boolean,

   CONSTRAINT pk_device_catalogID PRIMARY KEY (deviceCatalogID)
 );

 CREATE TABLE Visual_Device (
   deviceCatalogID varchar(5),
   frBrand varchar(20),
   frModel varchar(20),
   lensSerialN varchar(20),
   lensVisionType varchar(20),
   lensTint set('1','2','3'),
   lensThinnessLevel set('1','2','3'),

   CONSTRAINT pk_visionDevice_catalogID PRIMARY KEY (deviceCatalogID),
   CONSTRAINT fk_visualDevice_catalogID FOREIGN KEY (deviceCatalogID) references device(deviceCatalogID)
 );

 CREATE TABLE Hearing_Device (
   deviceCatalogID varchar(5),
   hdMake varchar(20),
   hdModel varchar(20),

   CONSTRAINT pk_hearingDevice_catalogID PRIMARY KEY (deviceCatalogID),
   CONSTRAINT fk_hearingDevice_catalogID FOREIGN KEY (deviceCatalogID) references device(deviceCatalogID)
 );