회원-권한

JWT 인증 방식의 회원 - 권한 ERD 설계

테이블 (7)

권한 (Role)

  • role_id — Long — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → 회원.member_id — NOT NULL
  • apartment_id — Long — 외래 키 → 아파트.apartment_id — NOT NULL
  • authority — varchar(10) — NOT NULL

동의여부 (Subscription)

  • subscription_id — Long — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → 회원.member_id — NOT NULL
  • terms_service — boolean — NOT NULL
  • marketing_information_receive — boolean — NOT NULL
  • private_information_collection — boolean — NOT NULL
  • terms_service_at — datetime — NOT NULL
  • marketing_information_receive_at — datetime — NOT NULL
  • private_information_collection_at — datetime — NOT NULL

아파트 (apartment)

  • apartment_id — Long — 기본 키 — NOT NULL
  • name — varchar(30) — NOT NULL
  • sido — varcar(7) — NOT NULL
  • gugun — varchar(7) — NOT NULL
  • road_name — varchar(7) — NOT NULL
  • zipcode (zipcdoe) — varchar(7) — NOT NULL
  • icon — varchar(255) — NOT NULL
  • banner — varchar(255) — NOT NULL
  • mamagement_office_number (management_office_number) — varchar(18) — NOT NULL
  • business_hours — varchar(30) — NOT NULL

자택 (Home)

  • home_id — Long — 기본 키 — NOT NULL
  • apartment_id — Long — 외래 키 → 아파트.apartment_id — NOT NULL
  • dong — varchar(8) — NOT NULL
  • ho — varchar(8) — NOT NULL

토큰저장소 (TokenStorage)

  • token_storage_id — Long — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → 회원.member_id — NOT NULL
  • refresh_token — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL

회원 (Member)

  • member_id — Long — 기본 키 — NOT NULL
  • username — varchar(20) — NOT NULL
  • password — varchar(255) — NOT NULL
  • nickname — varchar(16) — NOT NULL
  • phone — varchar(18) — NOT NULL
  • legal_name — varchar(16) — NOT NULL
  • birth_first — varchar(8)
  • gender — varchar(1)
  • modified_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • authentication_at (authentication_At) — datetime
  • authentication_status (autnentication_status) — boolean — NOT NULL
  • resign_status — boolean — NOT NULL

회원자택 (Member_Home)

  • member_home_id — Long — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → 회원.member_id — NOT NULL
  • home_id (home_id2) — Long — 외래 키 → 자택.home_id — NOT NULL