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)