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