test diagram
Tables (11)
location (vl 단위)
- id — id — Primary key — NOT NULL
- 프로젝트 ID (project_id) — id — Foreign key → project.id — NOT NULL
location_vlmerge_storage (lvm)
- id — id — Primary key — NOT NULL
- id (location_id) — id — Foreign key → location.id — NOT NULL
- Field
location_volume
- id — id — Primary key — NOT NULL
- id (location_id) — id — Foreign key → location.id — NOT NULL
- id (vl_volume_id) — id — Foreign key → storage.id — NOT NULL
- 계층 ID (id2) — id — Foreign key → spatial_structure.계층 ID — NOT NULL
location_workflow (lw)
- id — id — Primary key — NOT NULL
- 로케이션 ID (location_id) — id — Foreign key → location.id — NOT NULL
- 워크플로우 ID (workflow_id) — id — Foreign key → workflow.워크플로우 ID — NOT NULL
- 사용된 워크플로우 ID (used_workflow_id) — id — Foreign key → workflow.워크플로우 ID — NOT NULL
- Field
project
- id — id — Primary key — NOT NULL
- Field
spatial_struct_dataset (location_dataset)
- id — id — Primary key — NOT NULL
- 계층 ID (spatial_structure_id) — id — Foreign key → spatial_structure.계층 ID — NOT NULL
- raw 볼륨 ID (raw_volume_id) — id — Foreign key → storage.id — NOT NULL
- data 볼륨 ID (data_volume_id) — id — Foreign key → storage.id — NOT NULL
- graph 볼륨 ID (graph_volume_id) — id — Foreign key → storage.id — NOT NULL
- map 볼륨 ID (map_volume_id) — id — Foreign key → storage.id — NOT NULL
spatial_structure (계층)
- 계층 ID (id) — id — Primary key — NOT NULL
- 프로젝트 ID (project_id) — id — Foreign key → project.id — NOT NULL
- Field
spatial_structure_globalgraph (ssg)
- id — id — Primary key — NOT NULL
- id (spature_structure_id) — id — Foreign key → spatial_structure.계층 ID — NOT NULL
- id (globalgraph_volume_id) — id — Foreign key → storage.id — NOT NULL
spatial_structure_workflow (spatial_structure)
- id — id — Primary key — NOT NULL
- 계층 ID (spatial_structure_id) — id — Foreign key → spatial_structure.계층 ID — NOT NULL
- 워크플로우 ID (workflow_id) — id — Foreign key → workflow.워크플로우 ID — NOT NULL
- 사용된 워크플로우 ID (used_workflow_id) — id — Foreign key → workflow.워크플로우 ID — NOT NULL
storage (volume)
- id — id — Primary key — NOT NULL
- project_id — id — Foreign key → project.id — NOT NULL
- pvc 이름 (pvc_name) — varchar
workflow (워크플로우)
- 워크플로우 ID (id) — id — Primary key — NOT NULL