wsin
Tables (8)
attr_theme_map (속성-테마-매핑)
- attr_theme_map_seq (Key) — long — Primary key — NOT NULL
- attr_seq (Field) — long
- attr_elmt_seq (Field2) — long
- dsp_odr (Field3) — int
- theme_seq (Key2) — Long — Foreign key → theme.theme_seq — NOT NULL
brand_theme_map (브랜드-테마-매핑)
- brand_seq (Key) — long — Primary key — NOT NULL
- maker_seq (Key3) — long — Primary key — NOT NULL
- theme_seq (Key2) — Long — Foreign key → theme.theme_seq — NOT NULL
cate_keyword_map (키워드-카테고리-매핑)
- cate_keyword_seq (Key2) — long — Primary key — NOT NULL
- cate_cd (key) — long
- reg_id (Field) — varchar
- reg_dt (Field2) — datetime
- chg_id (Field3) — varchar
- chg_dt (Field4) — datetime
- keyword (Key) — varchar — Foreign key → keyword.keyword — NOT NULL
keyword (키워드)
- keyword (Key) — varchar — Primary key — NOT NULL
keyword_theme_map (키워드-테마-매핑)
- keyword (Key) — varchar — Primary key — NOT NULL
- theme_seq (Key2) — Long — Foreign key → theme.theme_seq — NOT NULL
maker_theme_map (제조사-테마-매핑)
- maker_seq (Key2) — long — Primary key — NOT NULL
- theme_seq (Key) — Long — Foreign key → theme.theme_seq — NOT NULL
series_theme_map (시리즈-테마-매핑)
- series_seq (Key) — long — Primary key — NOT NULL
- brand_seq (Key2) — long — Primary key — NOT NULL
- theme_seq (Key3) — Long — Foreign key → theme.theme_seq — NOT NULL
theme (테마)
- theme_seq (Key) — Long — Primary key — NOT NULL
- main_search_word (Field) — varchar
- cate_cd (Field2) — long
- theme_nm (Field3) — varchar
- dsp_yn (Field4) — char(1)
- reg_id (Field5) — varchar
- reg_dt (Field6) — datetime
- chg_id (Field7) — varchar
- chg_dt (Field8) — datetime
- main_yn (Field9) — char(1)
- dsp_start_dt (Field10) — datetime
- dsp_end_dt (Field11) — datetime
- min_price (Field12) — int
- max_price (Field13) — int
- five_star_rate (Field14) — int