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)