멋사이트 DB

테이블 (6)

BigKeyword (big_keyword)

  • BigKeywordId (big_keyword_id) — INT — 기본 키 — NOT NULL
  • BigKeywordName (big_keyword_name) — VARCHAR
  • BigKeywordVoteTitle (big_keyword_vote_tile) — VARCHAR
  • BigKeywordVoteOption1 (Field)

BigKeywordAnalyze (big_keyword_analyze)

  • BigKeywordAnalyzeId (big_keyword_analyze_id) — INT — 기본 키 — NOT NULL
  • BigKeywordId (big_keyword_id) — INT — 외래 키 → BigKeyword.BigKeywordId — NOT NULL
  • BigKeywordAnalzyeContent (big_keyword_analyze_content) — VARCHAR
  • Order (order) — INT

BigKeywordChart (big_keyword_chart)

  • BigKeywordChartId (big_keyword_chart_id) — INT — 기본 키 — NOT NULL
  • BigKeywordId (big_keyword_id) — INT — 외래 키 → BigKeyword.BigKeywordId — NOT NULL

SmallKeyword (small_keyword)

  • SmallKeywordId (small_keyword_id) — INT — 기본 키 — NOT NULL
  • BigKeywordId (big_keyword_id) — INT — 외래 키 → BigKeyword.BigKeywordId — NOT NULL
  • SmallKeywordName (small_keyword_name) — VARCHAR
  • IsAnalyzed (is_analyed) — VARCHAR
  • Weight (weight) — INT

SmallKeywordAnalyze (CopyOfbig_keyword_analyze)

  • SmallKeywordAnalyzeId (small_keyword_analyze_id) — INT — 기본 키 — NOT NULL
  • SmallKeywordId (small_keyword_id) — INT — 외래 키 → SmallKeyword.SmallKeywordId — NOT NULL
  • SmallKeywordAnalzyeContent (small_keyword_analyze_content) — VARCHAR
  • Order (order) — INT

SmallKeywordChart (CopyOfbig_keyword_chart)

  • smallKeywordChartId (small_keyword_chart_id) — INT — 기본 키 — NOT NULL
  • SmallKeywordId (small_keyword_id) — INT — 외래 키 → SmallKeyword.SmallKeywordId — NOT NULL