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)