회원-권한
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