economy

Tables (5)

Custom_word (커스텀 단어)

  • custom_word_id (커스텀단어 아이디) — int — Primary key — NOT NULL
  • custom_word_name (단어) — varchar
  • custom_word_description (설명) — text
  • custom_word_member_id (회원아이디) — int — Foreign key → Member.member_id — NOT NULL

Economy_word (경제단어)

  • economy_word_id (경제단어 아이디) — int — Primary key — NOT NULL
  • economy_word_name (단어) — varchar
  • economy_word_abbreviation (줄임말) — varchar
  • economy_word_description (설명) — text

Favorite_word (즐겨찾는단어)

  • favorite_word_id (즐겨찾는단어 아이디) — int — Primary key — NOT NULL
  • economy_word_id (단어 아이디) — int — Foreign key → Economy_word.economy_word_id — NOT NULL
  • favorite_word_member_id (회원 아이디) — int — Foreign key → Member.member_id — NOT NULL

Member (회원)

  • member_id (회원아이디) — int — Primary key — NOT NULL
  • username (프로바이더+프로바이더아이디) — varchar
  • member_name (이름) — varchar
  • member_provider (회원프로바이더) — varchar
  • member_provider_id (회원프로바디어아이디) — varchar

Related_word (관련단어)

  • related_word_id (관련단어 아이디) — int — Primary key — NOT NULL
  • from_word_id (원래단어) — int — Foreign key → Economy_word.economy_word_id — NOT NULL
  • to_word_id (연관단어) — int — Foreign key → Economy_word.economy_word_id — NOT NULL