favicon_0317
Tables (6)
dataset (파일단위데이터)
- dataset_id — int — Primary key — NOT NULL
- resource_id (Key2) — int — Foreign key → resource.resource_id — NOT NULL
- title (Field1) — varchar(30)
- description (Field2) — varchar(255)
- view (Field5) — int
- download (Field3) — int
- name (Field4) — varchar(30)
- dataset_theme_id (Key) — int — Foreign key → dataset_theme.dataset_theme_id — NOT NULL
dataset_theme (메인카테고리)
- dataset_theme_id (Key) — int — Primary key — NOT NULL
- theme (질병,환경,기후)
indicator (세부카테고리 컬럼)
- indicator_id (Key4) — int — Primary key — NOT NULL
- dataset_theme_id (Key3) — int — Foreign key → dataset_theme.dataset_theme_id — NOT NULL
- indicator_name (Field) — varchar(30)
- unit (Field2) — varchar(30
region (Untitled2)
- region_name (Key) — varchar(50) — Primary key — NOT NULL
resource (Untitled)
- resource_id (Key) — int — Primary key — NOT NULL
- type (Field2)
- resource_url (Field3) — varchar(255)
value (data 값)
- value_id (Key) — int — Primary key — NOT NULL
- indicator_id (Key4) — int — Foreign key → indicator.indicator_id — NOT NULL
- dataset_theme_id (Key3) — int — Foreign key → indicator.dataset_theme_id — NOT NULL
- region_name (Key2) — varchar(50) — Foreign key → region.region_name — NOT NULL
- date (Field2) — date(yyyy-mm)
- value (Field3) — float