member
테이블 (8)
내 관심 글(구인구직) (Untitled42)
- My interest id (my_interestid) — int(10) — 기본 키 — NOT NULL
- Member id (member_id) — varchar(10) — 외래 키 → 멤버.Member id — NOT NULL
내 관심 글(스트리머) (Untitled4)
- My interest id (my_interestid) — int(10) — 기본 키 — NOT NULL
- Member id (member_id) — varchar(10) — 외래 키 → 멤버.Member id — NOT NULL
내 관심 글(일러스트) (Untitled41)
- My interest id (my_interestid) — int(10) — 기본 키 — NOT NULL
- Member id (member_id) — varchar(10) — 외래 키 → 멤버.Member id — NOT NULL
내 관심 글(장비) (Untitled40)
- My interest id (my_interestid) — int(10) — 기본 키 — NOT NULL
- Member id (member_id) — varchar(10) — 외래 키 → 멤버.Member id — NOT NULL
멤버 (Untitled)
- Member id (member_id) — varchar(10) — 기본 키 — NOT NULL
- Member pw (member_pw) — varchar(12~100)
- Email (email) — varchar(100)
- Birth (birth) — Date(10)
- Phone (phone) — Int(11)
- Nickname (nick_name) — varchar(10)
- Manage (manage) — tinyint(1)
- join date (join_date) — date(10)
- Essential (essential) — tinyint(1)
알림 (Untitled2)
- Noti id (noti_id) — int(10) — 기본 키 — NOT NULL
- Member id (member_id) — varchar(10) — 외래 키 → 멤버.Member id — NOT NULL
- Noti data (noti_data) — varchar(255)
- isread — tinyint(1)
약관 (Untitled5)
- Term id (term_id) — int(10) — 기본 키
- Term name (term_name) — varchar(255)
- Term data (term_data) — varchar(255)
- create date (create_date) — date(10)
약관 동의 (Untitled6)
- Member id (member_id) — varchar(10) — 외래 키 → 멤버.Member id — NOT NULL
- Term id (term_id) — int(10) — 외래 키 → 약관.Term id
- Term agree (term_agree) — tinyint(1)
- Agree date (agree_date) — date(10)