profile

Tables (6)

interests

  • id — bigint — Foreign key → profile.id — NOT NULL
  • 관심사 (my_interest) — varchar

languages

  • id — bigint — Foreign key → profile.id — NOT NULL
  • 사용언어 (using_language) — varchar

member

  • id — bigint — Primary key — NOT NULL
  • name — varchar
  • email — varchar
  • password — varchar
  • permission — tinyint

nation

  • id — bigint — Foreign key → profile.id — NOT NULL
  • 국가코드 (code) — tinyint

profile

  • id — bigint — Foreign key → member.id — NOT NULL
  • nickname — varchar
  • 자기소개 (introduce) — varchar(400)
  • 성별 (gender) — bool
  • 등록여부 (registration) — bool

sns

  • id — bigint — Foreign key → profile.id — NOT NULL
  • 주소 (sns_link) — varchar