[IRUDA v4.3] 메인 레이아웃

테이블 (6)

ird_main_chart

  • component_id — varchar(50) — 기본 키 — NOT NULL
  • chart_id — varchar(50)
  • chart_type — varchar(50)
  • frst_rgpr — varchar(200)
  • frst_reg_dttm — timestamp
  • lst_chpr — varchar(200)
  • lst_chg_dttm — timestamp

ird_main_community

  • component_id — varchar(50) — 기본 키 — NOT NULL
  • community_id — varchar(50)
  • display_rows — numeric
  • frst_rgpr — varchar(200)
  • frst_reg_dttm — timestamp
  • lst_chpr — varchar(200)
  • lst_chg_dttm — timestamp

ird_main_component_mapping

  • component_type — varchar(50) — 기본 키 — NOT NULL
  • main_id — varchar(50) — 외래 키 → ird_main_config.main_id — NOT NULL
  • component_id — varchar(50) — 외래 키 → ird_main_chart.component_id — NOT NULL
  • component_id (component_id2) — varchar(50) — 외래 키 → ird_main_community.component_id — NOT NULL
  • component_id (component_id3) — varchar(50) — 외래 키 → ird_main_image_link.component_id — NOT NULL
  • component_id (component_id4) — varchar(50) — 외래 키 → ird_main_state_ranking.component_id — NOT NULL
  • frst_rgpr — varchar(200)
  • frst_reg_dttm — timestamp
  • lst_chpr — varchar(200)
  • lst_chg_dttm — timestamp

ird_main_config

  • main_id — varchar(50) — 기본 키 — NOT NULL
  • main_name — varchar(200)
  • frst_rgpr — varchar(200)
  • frst_reg_dttm — timestamp
  • lst_chpr — varchar(200)
  • lst_chg_dttm — timestamp

ird_main_image_link

  • component_id — varchar(50) — 기본 키 — NOT NULL
  • file_id — varchar(36)
  • menu_id — varchar(36)
  • menu_name — varchar(200)
  • link_url — varchar(1000)
  • frst_rgpr — varchar(200)
  • frst_reg_dttm — timestamp
  • lst_chpr — varchar(200)
  • lst_chg_dttm — timestamp

ird_main_state_ranking

  • component_id — varchar(50) — 기본 키 — NOT NULL
  • state_type — varchar(50)
  • state_ranking_name — varchar(200)
  • display_rows — numeric
  • frst_rgpr — varchar(200)
  • frst_reg_dttm — timestamp
  • lst_chpr — varchar(200)
  • lst_chg_dttm — timestamp