Users ERD Examples
Tables (9)
user (users)
- id — bigint(20) — Primary key — NOT NULL
- userToken (user_token) — varchar(40) — NOT NULL — 파이어베이스 인증키 저장용, 장기적으로는 createId로 대체하고 싶음
- version — bigint(20) — NOT NULL
- createId (create_id) — varchar(40) — NOT NULL — CUID-UUID 형식으로 고유번호를 채번, 테이블간 릴레이션을 위한 FK로 사용
- type — varchar(10) — NOT NULL — CREATOR, CLASSMATE, ADMIN
- accessToken (access_token) — varchar(255)
- countryCode (country_code) — varchar(10)
- accountType (account_type) — varchar(10) — NOT NULL
- email — varchar(50) — NOT NULL
- name — varchar(20)
- legalName (legal_name) — varchar(50)
- nickname — varchar(20)
- address — varchar(50)
- detailAddress (detail_address) — varchar(50)
- zoneCode (zone_code) — varchar(10)
- phoneNumber (phone_number) — varchar(16)
- photoUrl (photo_url) — varchar(2083)
- loginAt (login_at) — datetime(6) — 로그인한 날짜 기준으로 휴면 계정을 판단
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6)
user (user_device)
- id — bigint(20) — Primary key — NOT NULL
- userId (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
- userToken (user_token) — varchar(40) — NOT NULL
- osType (os_type) — varchar(10) — IOS, ANDROID, OTHER
- pushToken (push_token) — varchar(40) — NOT NULL
- idfa — varchar(40)
- idfv — varchar(40)
- gaid — varchar(40)
- isUsable (is_usable) — tinyint(1) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
user (roles)
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(40) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
user (menu)
- id — bigint(20) — Primary key — NOT NULL
- name — varchar(40) — NOT NULL
- order — bigint(20) — NOT NULL
- isUsable (is_usable) — tinyint(1) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
user (user_roles)
- id — bigint(20) — Primary key — NOT NULL
- userId (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
- roleId (role_id) — bigint(20) — Foreign key → user.id — NOT NULL
- userToken (user_token) — varchar(40) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
user (inactive_users)
- id — bigint(20) — Primary key — NOT NULL
- userToken (user_token) — varchar(40) — NOT NULL — 파이어베이스 인증키 저장용, 장기적으로는 createId로 대체하고 싶음
- releaseType (release_type) — varchar(20) — NOT NULL — ARCHIVED, DELETED
- type — varchar(10) — NOT NULL — CREATOR, CLASSMATE, ADMIN
- accessToken (access_token) — varchar(255)
- accountType (account_type) — varchar(10) — NOT NULL
- email — varchar(50)
- name — varchar(20)
- nickname — varchar(20)
- address — varchar(50)
- detailAddress (detail_address) — varchar(50)
- zoneCode (zone_code) — varchar(10)
- phoneNumber (phone_number) — varchar(16)
- photoUrl (photo_url) — varchar(2083)
- reason — varchar(255)
- signedAt (signed_at) — datetime(6) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
user (menu_item)
- id — bigint(20) — Primary key — NOT NULL
- menuId (menu_id) — bigint(20) — Foreign key → user.id — NOT NULL
- name — varchar(40) — NOT NULL
- order — bigint(20) — NOT NULL
- isUsable (is_usable) — tinyint(1) — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
user (role_menu_item)
- id — bigint(20) — Primary key — NOT NULL
- roldId (rold_id) — bigint(20) — Foreign key → user.id — NOT NULL
- menuItemId (menu_item_id) — bigint(20) — Foreign key → user.id — NOT NULL
- createdAt (created_at) — datetime(6) — NOT NULL
- updatedAt (updated_at) — datetime(6) — NOT NULL
user (user_agreement)
- id — bigint(20) — Primary key — NOT NULL
- userId (user_id) — bigint(20) — Foreign key → user.id — NOT NULL
- userToken (user_token) — varchar(40) — NOT NULL
- isAgreementAd (is_agreement_at) — tinyint(1) — IOS, ANDROID, OTHER
- agreementAdUpdatedAt (agreement_ad_updated_at) — datetime(6)
- isAgreementPushKlass (is_agreement_push_klass) — tinyint(1)
- agreementPushKlassUpdatedAt (agreement_push_klass_updated_at) — datetime(6)
- isAgreementPushUser (is_agreement_push_user) — tinyint(1)
- agreementPushUserUpdatedAt (agreement_push_user_updated_at) — datetime(6)
- isAgreementPushEvent (is_agreement_push_event) — tinyint(1)
- agreementPushEventUpdatedAt (agreement_push_event_updated_at) — datetime(6)