CHF-CXS has a list block crosssectiondata, in which rows (cross section points) refer to features (cross sections) defined in packagedata. But points do not explicitly identify the cross section they are part of. The relation is entirely implicit in the number of points corresponding to each section, nxspoints. To identify the cross section a point is part of, one must count from the beginning of the block.
Consider introducing a foreign key field in crosssectiondata identifying the cross section the point is part of. This could be generically named ifno or specifically idcxs to make the PK/FK relation abundantly clear.
CHF-CXS has a list block
crosssectiondata, in which rows (cross section points) refer to features (cross sections) defined inpackagedata. But points do not explicitly identify the cross section they are part of. The relation is entirely implicit in the number of points corresponding to each section,nxspoints. To identify the cross section a point is part of, one must count from the beginning of the block.Consider introducing a foreign key field in
crosssectiondataidentifying the cross section the point is part of. This could be generically namedifnoor specificallyidcxsto make the PK/FK relation abundantly clear.