dataracy

Tables (19)

Topic (도메인 토픽)

  • topic_id (PK) — Long — Primary key — NOT NULL
  • domain (Field) — String
  • name (Field2) — String

Users (유저)

  • user_id (PK) — Long — Primary key — NOT NULL
  • provider (Field) — ENUM
  • provider_id (Field2) — String
  • role (Field3) — ENUM
  • email (Field6) — String
  • password (Field5) — String
  • nickname (Field4) — String
  • author_level_id (FK) — Long — Foreign key → author_level.author_level_id — NOT NULL
  • occupation_id (FK2) — Long — Foreign key → occupation.occupation_id — NOT NULL
  • visit_source_id (FK3) — Long — Foreign key → visit_source.visit_source_id — NOT NULL
  • profile_image_url (Field7) — String
  • introduction_text (Field12) — String
  • is_ad_terms_agreed (Field9) — boolean
  • is_deleted (Field10) — boolean
  • created_at (Field8) — LocalDateTime
  • updated_at (Field11) — LocalDateTime

Users_Topic (유저와 도메인 토픽을 연결하는 테이블)

  • users_topic_id (PK) — Long — Primary key — NOT NULL
  • user_id (FK) — Long — Foreign key → Users.user_id — NOT NULL
  • topic_id (FK2) — Long — Foreign key → Topic.topic_id — NOT NULL
  • created_at (Field) — LocalDateTime
  • updated_at (Field2) — LocalDateTime

analysis_purpose (분석 목적)

  • analysis_purpose_id (PK) — Long — Primary key — NOT NULL
  • value (Field) — String
  • label (Field2) — String

author_level (작성자 유형)

  • author_level_id (PK) — Long — Primary key — NOT NULL
  • value (Field) — String
  • label (Field2) — String

comment (댓글)

  • comment_id (PK) — Long — Primary key — NOT NULL
  • project_id (FK) — Long — Foreign key → project.project_id — NOT NULL
  • user_id (FK2) — Long — Foreign key → Users.user_id — NOT NULL
  • content (Field) — String
  • parent_id (FK3) — Long — Foreign key → comment.comment_id — NOT NULL
  • like_count (Field3) — Long
  • created_at (Field4) — LocalDateTime
  • updated_at (Field5) — LocalDateTime

data (데이터)

  • data_id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • topic_id (Fk) — Long — Foreign key → Topic.topic_id — NOT NULL
  • user_id (FK2) — Long — Foreign key → Users.user_id — NOT NULL
  • data_source_id (FK3) — Long — Foreign key → data_source.data_source_id — NOT NULL
  • data_type_id (FK4) — Long — Foreign key → data_type.data_type_id — NOT NULL
  • start_date (Field2) — LocalDate
  • end_date (Field3) — LocalDate
  • description (Field4) — String
  • analysis_guide (Field5) — String
  • data_file_url (Field6) — String
  • data_thumbnail_url (Field7) — String
  • download_count (Field8) — int
  • size_bytes (Field9) — Long
  • is_deleted (Field12) — Boolean
  • created_at (Field10) — LocalDateTime
  • updated_at (Field11) — LocalDateTime

data_es_projection_dlq (데이터셋 DLQ)

  • id (PK) — Long — Primary key — NOT NULL
  • data_id (FK) — Long — Foreign key → data.data_id — NOT NULL
  • delta_download (Field2) — Integer
  • set_deleted (Field4) — Boolean
  • last_error (Field5) — String

data_es_projection_queue (데이터셋 큐)

  • id (PK) — Long — Primary key — NOT NULL
  • data_id (FK) — Long — Foreign key → data.data_id — NOT NULL
  • delta_download (Field2) — Integer
  • set_deleted (Field4) — Boolean
  • status (Field) — ENUM
  • retry_count (Field3) — Integer
  • next_run_at (Field6) — LocalDateTime
  • last_error (Field5) — String

data_metadata (데이터셋 메타데이터)

  • data_metadata_id (Key) — Long — Primary key — NOT NULL
  • data_id (FK) — Long — Foreign key → data.data_id — NOT NULL
  • row_count (Field) — Integer
  • column_count (Field2) — Integer
  • preview_json (Field3) — String

data_source (데이터 출처)

  • data_source_id (PK) — Long — Primary key — NOT NULL
  • value (Field) — String
  • label (Field2) — String

data_type (데이터 유형)

  • data_type_id (PK) — Long — Primary key — NOT NULL
  • value (Field) — String
  • label (Field2) — String

like (좋아요)

  • like_id (PK) — Long — Primary key — NOT NULL
  • target_id (FK1) — Long — Foreign key → comment.comment_id — NOT NULL
  • target_id (FK) — Long — Foreign key → project.project_id — NOT NULL
  • target_type (Field) — ENUM
  • user_id (FK2) — Long — Foreign key → Users.user_id — NOT NULL
  • created_at (Field2) — LocalDateTime
  • updated_at (Field3) — LocalDateTime

occupation (직업)

  • occupation_id (PK) — Long — Primary key — NOT NULL
  • value (Field) — String
  • label (Field2) — String

project (프로젝트)

  • project_id (PK) — Long — Primary key — NOT NULL
  • title (Field) — String
  • user_id (FK2) — Long — Foreign key → Users.user_id — NOT NULL
  • analysis_purpose_id (FK3) — Long — Foreign key → analysis_purpose.analysis_purpose_id — NOT NULL
  • data_source_id (FK4) — Long — Foreign key → data_source.data_source_id — NOT NULL
  • author_level_id (FK5) — Long — Foreign key → author_level.author_level_id — NOT NULL
  • topic_id (FK) — Long — Foreign key → Topic.topic_id — NOT NULL
  • is_continue (Field2) — Boolean
  • parent_project_id (FK6) — Long — Foreign key → project.project_id — NOT NULL
  • content (Field4) — String
  • thumbnail_url (Field5) — String
  • comment_count (Field6) — Long
  • like_count (Field7) — Long
  • view_count (Field8) — Long
  • is_deleted (Field3) — Boolean
  • created_at (Field9) — LocalDateTime
  • updated_at (Field10) — LocalDateTime

project_data (프로젝트와 데이터를 연결하는 테이블)

  • project_data_id (Key) — Long — Primary key — NOT NULL
  • project_id (FK) — Long — Foreign key → project.project_id — NOT NULL
  • data_id (FK2) — Long — Foreign key → data.data_id — NOT NULL
  • created_at (Field) — LocalDateTime
  • updated_at (Field2) — LocalDateTime

project_es_projection_dlq (프로젝트 DLQ)

  • id (PK) — Long — Primary key — NOT NULL
  • project_id (FK) — Long — Foreign key → project.project_id — NOT NULL
  • delta_comment (Field2) — Integer
  • delta_like (Field3) — Integer
  • delta_view (Field) — Long
  • set_deleted (Field4) — Boolean
  • last_error (Field5) — String

project_es_projection_queue (프로젝트 큐)

  • id (PK) — Long — Primary key — NOT NULL
  • project_id (FK) — Long — Foreign key → project.project_id — NOT NULL
  • delta_comment (Field) — Integer
  • delta_like (Field2) — Integer
  • delta_view (Field3) — Long
  • set_deleted (Field4) — Boolean
  • status (Field5) — ENUM
  • retry_count (Field6) — Integer
  • next_run_at (Field7) — LocalDateTime
  • last_error (Field8) — String

visit_source (방문 경로)

  • visit_source_id (PK) — Long — Primary key — NOT NULL
  • value (Field) — String
  • label (Field2) — String