DataLake
Tables (7)
batch
- id — UUID — Primary key — NOT NULL
- tenant_id — UUID — Foreign key → tenant.Key — NOT NULL
- resource_id — UUID — Foreign key → resource.Key — NOT NULL
- name (배치명) — varchar(255)
- status (배치상태) — batch_status
- remarks (비고) — varchar(255)
- created_by (생성자) — UUID — Foreign key → member.id — NOT NULL
- create_time (생성시간) — timestamp
- updated_by (수정자) — UUID — Foreign key → member.id — NOT NULL
- update_time (수정시간) — timestamp
batch_detail
- seq — int — Primary key — NOT NULL
- batch_id — UUID — Foreign key → batch.id — NOT NULL
- project_id — UUID — Foreign key → project.id — NOT NULL
- sample_id — UUID — Foreign key → sample.id — NOT NULL
- file_path — varchar(255)
- status (업로드상태) — varchar(255)
- created_by (생성자) — UUID — Foreign key → member.id — NOT NULL
- create_time (생성시간) — timestamp
- updated_by (수정자) — UUID — Foreign key → member.id — NOT NULL
- update_time (수정시간) — timestamp
member
- id — UUID — Primary key — NOT NULL
- tenant_id — UUID — Foreign key → tenant.Key — NOT NULL
- name (사원명) — varchar(255)
- password (비밀번호) — varchar(255)
- email (이메일) — varchar(255)
- avatar (프로필) — TEXT
- create_time (작성시간) — timestamp
- update_time (수정시간) — timestamp
project
- id — UUID — Primary key — NOT NULL
- tenant_id — UUID — Foreign key → tenant.Key — NOT NULL
- name (프로젝트명) — varchar(255)
- remarks (비고) — varchar(255)
- created_by (작성자) — UUID — Foreign key → member.id — NOT NULL
- created_time (작성시간) — timestamp
- updated_by (수정자) — UUID — Foreign key → member.id — NOT NULL
- updated_by (수정시간) — timestamp
resource
- Key (id) — UUID — Primary key — NOT NULL
- name (리소스명) — varchar(255)
- remarks (비고) — varchar(255)
- create_time (작성시간) — timestamp
- update_time (수정시간) — timestamp
sample
- id — UUID — Primary key — NOT NULL
- tenant_id — UUID — Foreign key → tenant.Key — NOT NULL
- project_id — UUID — Foreign key → project.id — NOT NULL
- name (샘플명) — varchar(255)
- remarks (비고) — varchar(255)
- created_by — UUID — Foreign key → member.id — NOT NULL
- created_time (작성시간) — timestamp
- updated_by — UUID — Foreign key → member.id — NOT NULL
- updated_by (수정시간) — timestamp
tenant
- Key (id) — UUID — Primary key — NOT NULL
- name
- remarks
- create_time — timestamp
- update_time — timestamp