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