use-case

Tables (7)

dataset_industry

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • desc — VARCHAR(255)
  • is_active — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

dataset_purpose

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(255)
  • desc — VARCHAR(255)
  • is_active — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

keyword

  • id — BIGINT — Primary key — NOT NULL
  • type — VARCHAR(255)
  • name — VARCHAR(255)

usecase

  • id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255)
  • is_active — BOOLEAN
  • is_best — BOOLEAN
  • main_image_url — VARCHAR(255)
  • period_start — DATETIME
  • period_end — DATETIME
  • company_name — VARCHAR(255)
  • business_num — VARCHAR(255)
  • address — VARCHAR(255)
  • industry_id — BIGINT — Foreign key → dataset_industry.id
  • purpose_id — BIGINT — Foreign key → dataset_purpose.id
  • intro — TEXT
  • target_process — TEXT
  • problem — TEXT
  • detailed_purpose — TEXT
  • dataset_form — TEXT
  • data_count — VARCHAR(255)
  • dataset_total — VARCHAR(255)
  • analysis — TEXT
  • data_collection_storage — TEXT
  • data_preprocessing_analysis — TEXT
  • expected_effect — TEXT
  • detail_html — TEXT
  • view_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME
  • Field

usecase_editor_image

  • id — BIGINT — Primary key — NOT NULL
  • usecase_id — BIGINT — Foreign key → usecase.id — NOT NULL
  • editor_url — VARCHAR(255)

usecase_keyword

  • id — BIGINT — Primary key — NOT NULL
  • usecase_id — BIGINT — Foreign key → usecase.id — NOT NULL
  • keyword_id — BIGINT — Foreign key → keyword.id — NOT NULL

usecase_reference_image

  • id — BIGINT — Primary key — NOT NULL
  • usecase_id — BIGINT — Foreign key → usecase.id — NOT NULL
  • reference_url — VARCHAR(255)