eras

Tables (3)

codebook (CopyOfCopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • desc (Field2)
  • order_no (Field3)
  • type (Field4)

field (Untitled)

  • id (Key) — Primary key — NOT NULL
  • title (Field)
  • desc (Field2)
  • activated (Field3)
  • order_no (Field4)
  • collection_id (Field5)
  • type (Field7)
  • caption (Field6)
  • required (Field8)
  • format (Field9)
  • min (Field10)
  • max (Field11)
  • formula (Field12)
  • codebook_id (Key2) — Foreign key → codebook.id — NOT NULL
  • parent_id (Field13)
  • match_value (Field14)

lookup (CopyOfUntitled2)

  • id (Key) — Primary key — NOT NULL
  • codebook_id (Key2) — Foreign key → codebook.id — NOT NULL
  • title (Field)
  • desc (Field2)
  • order_no (Field3)