sample

Tables (9)

tb_annot_label (어노테이션_레이블)

  • annot_label_id (어노테이션_레이블_아이디) — Primary key — NOT NULL
  • file_id (파일_아이디) — Foreign key → tb_file.file_id — NOT NULL
  • dataset_id (데이터셋_아이디) — Foreign key → tb_file.dataset_id — NOT NULL
  • main_label_id (주_레이블_아이디) — Foreign key → tb_sub_label.main_label_id — NOT NULL
  • sub_label_id (하위_클라스_아이디) — Foreign key → tb_sub_label.sub_label_id — NOT NULL
  • annot_work_id (어노테이션_작업_아이디) — Foreign key → tb_annot_work.annot_work_id — NOT NULL
  • annot_label_descript (어노테이션_레이블_추가설명)

tb_annot_work (어노테이션작업)

  • annot_work_id (어노테이션_작업_아이디) — Primary key — NOT NULL
  • dataset_id (데이터셋_아이디) — Foreign key → tb_dataset.dataset_id — NOT NULL
  • annot_work_name (어노테이션_작업_이름)
  • annot_date (어노테니션_날짜)
  • annot_worker (어노테이션_작업자)
  • annot_work_descript (어노테이션_작업_추가설명)

tb_dataset (데이터셋)

  • dataset_id (데이터셋_아이디) — Primary key — NOT NULL
  • dataset_name (데이터셋_이름)
  • dataset_date (데이터셋_날짜)
  • dataset_descript (데이터셋_추가설명)

tb_file (파일)

  • file_id (파일_아이디) — Primary key — NOT NULL
  • dataset_id (데이터셋_아이디) — Foreign key → tb_dataset.dataset_id — NOT NULL
  • file_defect_key_no (파일_결점키번호)
  • file_name (파일_이름)
  • file_descript (파일_추가설명)

tb_image_info (이미지_정보)

  • file_id (파일_아이디) — Foreign key → tb_file.file_id — NOT NULL
  • image_info_height (이미지_높이)
  • image_info_width (이미지_너비)
  • image_info_chnnels (이미지_채널개수)

tb_line_info (라인정보)

    tb_main_label (주_클래스_이름_목록)

    • main_label_id (주_레이블_아이디) — Primary key — NOT NULL
    • main_label_name (주_레이블_이름)
    • main_label_descript (주_레이블_추가설명)

    tb_metadata (메타정보)

    • file_id (파일_아이디) — Foreign key → tb_file.file_id — NOT NULL
    • enclosingRectMm_x1 (메타정보_x1)
    • enclosingRectMm_y1 (메타정보_y1)
    • enclosingRectMm_x2 (메타정보_x2)
    • enclosingRectMm_y2 (메타정보_y2)
    • fragmentCount (메타정보_파편수)

    tb_sub_label (하위_클래스_이름_목록)

    • sub_label_id (하위_클래스_아이디) — Primary key — NOT NULL
    • main_label_id (주_레이블_아이디) — Foreign key → tb_main_label.main_label_id — NOT NULL
    • self_sub_label_id ((자기참조)상위_클라스_아이디) — Foreign key → tb_sub_label.sub_label_id — NOT NULL
    • sub_label_name (하위_클래스_이름)
    • sub_label_descript (하위_클래스_추가설명)