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