DB Schema Beta model
Tables (7)
HANDSON_LIST_TB
- HANDSON_ID — NUMBER — Primary key — NOT NULL
- HANDSON_TITLE — VARCHAR2(50) — NOT NULL
- HANDSON_SCRIPT — VARCHAR2(2000) — NOT NULL
- HANDSON_ZIP_FILE_PATH — VARCHAR2(20) — NOT NULL
- HANDSON_IMAGE_FILE_PATH — VARCHAR2(20) — NOT NULL
HANDSON_STEPINFO_TB
- STEP_ID — NUMBER — Primary key — NOT NULL
- HANDSON_ID — NUMBER — Foreign key → HANDSON_LIST_TB.HANDSON_ID — NOT NULL
- STEP_TITLE — VARCHAR2(40) — NOT NULL
- STEP_TITLE — VARCHAR2(40) — NOT NULL
- STEP_SCRIPT — VARCHAR2(40)
- STEP_VIDEO_PATH — VARCHAR(100)
- TESTCASE_INPUT_FILE_PATH — VARCHAR(100) — NOT NULL
- TESTCASE_OUTPUT_FILE_PATH — VARCHAR(100) — NOT NULL
- RUNTIME — VARCHAR2(40)
- MEMORY_USAGE — VARCHAR2(40)
- CODE_QUALITY — VARCHAR2(40)
- UK_ID — NUMBER — Foreign key → UK_INFO_TB.UK_ID — NOT NULL
- STEP_LEVEL — NUMBER
MC_PROBLEM_INFO_TB
- PROBLEM_ID — NUMBER — Foreign key → PROBLEM_DEFAULT_INFO_TB.PROBLEM_ID — NOT NULL
- CORRECT_ANSWERS_LIST — VARCHAR(200) — NOT NULL
- WRONG_ANSWERS_LIST — VARCHAR(200) — NOT NULL
- NUMBER_OF_OPTIONS — NUMBER — NOT NULL
PROBLEM_DEFAULT_INFO_TB
- PROBLEM_ID — NUMBER — Primary key — NOT NULL
- PROBLEM_MAKER_INFO — VARCHAR(200) — NOT NULL
- PROBLEM_TYPE — VARCHAR(20) — NOT NULL
- PROBLEM_TITLE — VARCHAR(100) — NOT NULL
- PROBLEM_SCRIPT — VARCHAR(200) — NOT NULL
- IMAGE_FILE_PATH — VARCHAR(100)
- PROBLEM_LEVEL — NUMBER
- UK_ID — NUMBER — Foreign key → UK_INFO_TB.UK_ID — NOT NULL
- MAKER_ID — NUMBER — NOT NULL
SA_PROBLEM_INFO_TB
- PROBLEM_ID — NUMBER — Primary key — Foreign key → PROBLEM_DEFAULT_INFO_TB.PROBLEM_ID — NOT NULL
- MAIN_ANSWER — VARCHAR(200) — NOT NULL
- SIB_ANSWERS_LIST — VARCHAR(200)
SUBJECT_INFO_TB
- SUBJECT_ID — NUMBER — Primary key — NOT NULL
- SUBJECT_NAME — VARCHAR(200) — NOT NULL
UK_INFO_TB
- UK_ID — NUMBER — Primary key — NOT NULL
- UK_NAME — VARCHAR(50) — NOT NULL
- SUBJECT_ID — NUMBER — Foreign key → SUBJECT_INFO_TB.SUBJECT_ID — NOT NULL