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_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 (하위_클래스_추가설명)