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)