practice

Tables (4)

Event

  • Key — Primary key — NOT NULL
  • header_id — Foreign key → Header.header_id — NOT NULL
  • event_id
  • user_answer
  • user_note
  • event_result
  • level_max

Header (Untitled)

  • header_id — Primary key — NOT NULL
  • pname
  • pdesc
  • level_max

Question

  • id — Primary key — NOT NULL
  • parent_id — Primary key — NOT NULL
  • header_id — Foreign key → Header.header_id — NOT NULL
  • qlevel
  • order_no
  • qname
  • qdesc

Result

  • Key — Primary key — NOT NULL
  • header_id — Foreign key → Header.header_id — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4