I have a class called daily census which has only two attributes
Also I have classes like doctor daily census and nurse daily census which has daily census as the parent class
Now the doctor daily census and nurse daily census has 1 attribute in common
Patient with not null patient id
Because the daily census is the parent class to both of these classes whenever I save data I encounter this issue
java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: NOT NULL check constraint; SYS_CT_12485 table: HREMS_DAILY_CENSUS column: PATIENT_ID at org.hsqldb.jdbc.Util.sqlException(Unknown Source)
how can I remove this .?
I will attach screenshots for better understanding