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