fp

Tables (6)

chunk_jobs

  • chunk_job_id — uuid
  • dataset_id — uuid — NOT NULL
  • library — varchar(64) — NOT NULL
  • output_format — varchar(16) — NOT NULL
  • language — varchar(8) — NOT NULL
  • unit — varchar(16) — NOT NULL
  • max_length — int
  • overlap — int
  • delimiters_json — jsonb
  • fallback_delimiters_json — jsonb
  • status — varchar(16) — NOT NULL
  • created_by — uuid
  • started_at — timestamptz
  • finished_at — timestamptz

chunks

  • chunk_id — uuid
  • chunk_job_id — uuid — NOT NULL
  • dataset_id — uuid — NOT NULL
  • chunk_no — int — NOT NULL
  • page_no — int
  • offset_start — int
  • offset_end — int
  • content — text — NOT NULL
  • metadata — jsonb
  • created_at — timestamptz — NOT NULL

data_source_files

  • file_id — uuid
  • datasource_id — uuid — NOT NULL
  • original_name — varchar(500) — NOT NULL
  • file_type — varchar(50)
  • size_kb — bigint
  • storage_path — varchar(2048)
  • checksum — varchar(128)
  • created_by — uuid
  • created_at — timestamptz — NOT NULL

data_sources

  • datasource_id — uuid
  • name — varchar(200) — NOT NULL
  • description — text
  • source_type — varchar(20) — NOT NULL
  • base_path — varchar(1024)
  • created_by — uuid
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

parse_jobs

  • parse_job_id — uuid
  • dataset_id — uuid — NOT NULL
  • parser_tool — varchar(64) — NOT NULL
  • output_format — varchar(32) — NOT NULL
  • schedule_type — varchar(16) — NOT NULL
  • description — text
  • status — varchar(16) — NOT NULL
  • created_by — uuid
  • scheduled_at — timestamptz
  • started_at — timestamptz
  • finished_at — timestamptz

users

  • user_id — uuid
  • email — varchar(255) — NOT NULL
  • password_hash — varchar(255)
  • name — varchar(100)
  • mobile — varchar(30)
  • status — varchar(20) — NOT NULL — 사용자
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL
  • last_login_at — timestamptz