[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