ex

Tables (3)

Member (Untitled2)

  • 멤버ID (member_id) — Primary key — NOT NULL
  • OAUth 식별자ID (account_id)
  • 직원이름 (name)
  • 전화번호 (phone)
  • OAuth 제공자 (provider_type) — ENUM

memberRefreshToken (Untitled)

  • 멤버리프레시토큰ID (member_refresh_token_id) — Primary key — NOT NULL
  • OAuth식별자ID (member_account_id)
  • 리프래시토큰 (refresh_token)

member_store_relation (Untitled3)

  • 멤버가게관계ID (member_store_relation) — NULL — Primary key — NOT NULL
  • 가게ID (store_id) — Foreign key → Member.멤버ID — NOT NULL
  • 직원ID (member_id)
  • 권한 (role)
  • 직급 (position)