TMAX_PROBLEM

Tables (6)

ATTRIBUTE (속성)

  • attribute_id (Key) — Primary key — NOT NULL
  • component_id (Key2) — Foreign key → COMPONENT.component_id — NOT NULL
  • color (Field7)
  • size (Field4)
  • font (Field)
  • pictuire_location (Field2)

COMPONENT (구성요소)

  • component_id (Key) — Primary key — NOT NULL
  • component_type (Field)
  • content_data (Field6)
  • create_time (Field5)

CONTENT_DATA (실질 데이터)

  • component_id (Key) — Foreign key → COMPONENT.component_id — NOT NULL
  • content (Field)
  • pictuire_url (Field3)

PROBLEM_MASTER (Untitled)

  • problem_master_id (Key) — Primary key — NOT NULL
  • component_id_list (Field)
  • problem_name (Field2)
  • domain (Field3)
  • category (Field7)
  • difficulty (Field5)
  • source (Field6)
  • create_time (Field4)

RELATION (관계)

  • relation_id (Key) — Primary key — NOT NULL
  • component_id (Key2) — Foreign key → COMPONENT.component_id — NOT NULL
  • next_component_location (Field3)
  • parent_component_id (Field4)
  • child_component_id (Field5)

SUBMIT (제출)

  • submit_id (Key2) — Primary key — NOT NULL
  • problem_master_id (Key) — Foreign key → PROBLEM_MASTER.problem_master_id — NOT NULL
  • user_id (Field2)
  • answer (Field3)
  • score (Field6)
  • domain (Field7)
  • create_time (Field4)