I thought we could use "FiberPosition" table to manage the fiducial fibers as well, but the basic information for fiducial fibers is different from that for science fibers. So, I propose to add separate tables for "CobraPosition" and "FiducialFiberPosition". Information we should store is based on https://github.com/Subaru-PFS/pfs_utils/tree/master/data/fiberids

The current idea is that we prepare "FiberPosition" which includes:

"Fiber Position"

• fiberId (Integer)
• ftype   (String)    # fiber type e.g., cobra / fiducial
• x         (Float)     # PFI x coordinate
• y         (Float)     # PFI y coordinate

And then, we prepare "CobraPosition" and "FiducialFiberPosition" with "fiberId" as a foreign key

"CobraPosition"

• cobraId      (Integer)
• fiberId        (Integer)
• fld              (Integer)
• cf               (Integer)
• mf              (Integer)
• cm             (Integer)
• mod           (String)
• x                (Float)
• y                (Float)
• r                 (Float)
• sp              (Integer)
• fh               (Integer)
• sfib            (Integer)
• fiberIdLNA (String)

"FiducialFiberPosition"

• ffId      (Integer)
• fiberId (Integer)
• ff         (Integer)
• fff        (Integer)
• fftype  (String)
• fft        (Integer)
• x         (Float)
• y         (Float)