ㄹㄹ
Tables (29)
ClassItem
- id — VARCHAR(255) — Primary key — NOT NULL
- labelset_id — VARCHAR(255) — Foreign key → Labelset.id — NOT NULL
- name — str — NOT NULL
- color — str — NOT NULL
ClassLabel
- id — int — Primary key — NOT NULL
- label_id — int — Foreign key → Label.id — NOT NULL
- class_item_id — int — Foreign key → ClassItem.id — NOT NULL
DataDirLog
- Key — VARCHAR(255) — Primary key — NOT NULL
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
Group
- id — int — Primary key — NOT NULL
- rank — Enum — NOT NULL
Image
- id — int — Primary key — NOT NULL
- imageset_id — int — Foreign key → Imageset.id — NOT NULL
- creator_id — int
- image_group — int — 워크스페이스 아님
- filename — str — NOT NULL
- imagefield — filefield — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- channel — int — NOT NULL
- meta — JSONB — Dicom 저장 정보
- created_on — datetime — NOT NULL
- updated_on — datetime — NOT NULL
ImageGroup
- id — int — Primary key — NOT NULL
- imageset_id — int — Foreign key → Imageset.id — NOT NULL
- name — str — NOT NULL
- color — str — NOT NULL
- order — int — NOT NULL
- created_on — datetime — NOT NULL
- updated_on — datetime — NOT NULL
ImageTag
- id — int — Primary key — NOT NULL
- imageset_id — int — Foreign key → Imageset.id — NOT NULL
- name — str — NOT NULL
- color — str — NOT NULL
- order — int — NOT NULL
- created_on — datetime — NOT NULL
Image_ImageTag
- id — int — Primary key — NOT NULL
- tag_id — int — Foreign key → ImageTag.id — NOT NULL
- image_id — int — Foreign key → Image.id — NOT NULL
Imageset
- id — int — Primary key — NOT NULL
- workspace_id — int — Foreign key → Workspace.id — NOT NULL
- creator_id — int
- name — str — NOT NULL
- description — str — NOT NULL
- created_on — datetime — NOT NULL
- updated_on — datetime — NOT NULL
- status — str — NOT NULL
ImagesetFavor
- id — int — Primary key — NOT NULL
- imageset_id — int — Foreign key → Imageset.id — NOT NULL
- user_id — int — Foreign key → UserGroupWorkspace.id — NOT NULL
- is_favor — bool — NOT NULL
Label
- id — int — Primary key — NOT NULL
- image_id — int — Foreign key → Image.id — NOT NULL
- labelset_id — int — Foreign key → Labelset.id — NOT NULL
- division — int — NOT NULL
- retestset — int — NOT NULL
- patch_row_count — int
- patch_col_count — int
- angle — float — NOT NULL — default=0
- created_on — datetime — NOT NULL
- updated_on — datetime — NOT NULL
Labelset
- id — int — Primary key — NOT NULL
- imageset_id — int — Foreign key → Imageset.id — NOT NULL
- creator_id — int
- name — str — NOT NULL
- description — str
- lockstate — int — NOT NULL
- status — str — NOT NULL
- labeltype — int — NOT NULL
- ocrflag — int — NOT NULL — classset에서 옮김
- tableflag — int — NOT NULL — 표에서 깃발 체크하는 용도
- textrule_flag — bool — NOT NULL
- patch_width — int
- patch_height — int
- creasted_on — dastetime — NOT NULL
- updated_on — datetime — NOT NULL
PatchClassLabel
- id — int — Primary key — NOT NULL
- label_id — int — Foreign key → Label.id — NOT NULL
- class_item_id — int — Foreign key → ClassItem.id — NOT NULL
- patch_row — int — NOT NULL
- patch_col — int — NOT NULL
Permission (Permissions)
- id — int — Primary key — NOT NULL
- entity_name — string — Primary key — NOT NULL
- read — bool
- write — bool
PreProcessing
- id — int — Primary key — NOT NULL
- labelset_id — int — Foreign key → Labelset.id — NOT NULL
- original_h — int — NOT NULL
- original_w — int — NOT NULL
- mask — jsonb
- roi — jsonb
Region
- id — int — Primary key — NOT NULL
- label_id — int — Foreign key → Label.id — NOT NULL
- class_item_id — int — Foreign key → ClassItem.id
- blob — JSONB — NOT NULL
- angle — float — NOT NULL — default=0
- blob_type — str — NOT NULL — circle/polygon ...
- zindex — int — NOT NULL
TextRule
- id — int — Primary key — NOT NULL
- labelset_id — int — Foreign key → Labelset.id — NOT NULL
- is_selected — boolean — NOT NULL
- threshold — float — NOT NULL
- occurrence — int — NOT NULL
- width — int — NOT NULL
- height — int — NOT NULL
- x — int — NOT NULL
- y — int — NOT NULL
- min_matches — int — NOT NULL
- is_correction_all — bool — NOT NULL
- created_on — datetime — NOT NULL
- updated_on — datetime — NOT NULL
TextRuleBox
- id — int — Primary key — NOT NULL
- textrule_id — int — Foreign key → TextRule.id — NOT NULL
- order_column — int
- condition_category — int
- condition_fixed_value — string
- height — int — NOT NULL
- width — int — NOT NULL
- x — int — NOT NULL
- y — int — NOT NULL
- condition_priority — bool — NOT NULL
- correction_dict — jsonb — 예측결과 변경용
TextRulePreview
- id — VARCHAR(255) — Primary key — NOT NULL
- textrule_id — VARCHAR(255) — Foreign key → TextRule.id — NOT NULL
- label_id — VARCHAR(255) — Foreign key → Label.id — NOT NULL
- textrule_match_res — JSONB — NOT NULL
Untitled10
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field6 — VARCHAR(255)
- Field5 — VARCHAR(255)
Untitled11
- Field — VARCHAR(255)
- Field2 — VARCHAR(255)
- Field3 — VARCHAR(255)
- Field4 — VARCHAR(255)
Untitled12
- Field — JSONB
- Field3 — VARCHAR(255)
- Field2 — VARCHAR(255)
Untitled13
- Field — JSONB
- Field2 — VARCHAR(255)
- Field4 — VARCHAR(255)
- Field3 — VARCHAR(255)
Untitled3
- id — int — Primary key — NOT NULL
- labelset_id — int — Foreign key → Labelset.id — NOT NULL
- filepath — stirng
User
- id — int — Primary key — NOT NULL
- name — string — NOT NULL
- password — string — NOT NULL
- login_ip — str — NOT NULL
- last_login — datetime
- created_on — datetime — NOT NULL
- updated_on — datetime — NOT NULL
UserGroup
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- group_id — int — Foreign key → Group.id — NOT NULL
UserGroupPermission
- id — int — Primary key — NOT NULL
- user_group_id — int — Foreign key → Permission.id — NOT NULL
- permission_id — int — Foreign key → Group.id — NOT NULL
- Key — Foreign key → Permission.entity_name — NOT NULL
UserGroupWorkspace
- id — int — Primary key — NOT NULL
- workspace_id — int — Foreign key → Workspace.id — NOT NULL
- role — int — NOT NULL
- order — int — NOT NULL
Workspace
- id — int — Primary key — NOT NULL
- creator_id — int
- name — str — NOT NULL
- created_on — datetime — NOT NULL
- updated_on — datetime — NOT NULL
- status — str — NOT NULL