iba

Tables (3)

Group (그룹)

  • 그룹id (group_id) — int — Primary key — NOT NULL
  • 그룹명 (group_name) — int
  • 창립일 (created_date) — date

Member (회원정보)

  • 회원id (member_id) — int — Primary key — NOT NULL
  • 이름 (member_name) — char
  • 귀여운포인트 (cute_point) — varchar
  • 장래희망 (dream_hope) — varchar
  • 좋아하는 색 (favorite_color) — char
  • MBTI (mbti) — char
  • 프로필사진 (profile_image) — BLOB

Member_Group (회원_그룹 중개테이블)

  • id — int — Primary key — NOT NULL
  • 회원id (member_id) — int — Foreign key → Member.회원id — NOT NULL
  • 그룹id (group_id) — int — Foreign key → Group.그룹id — NOT NULL