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