회원인증탬플릿

테이블 (14)

account

  • account_id — BIGINT — 기본 키 — NOT NULL
  • realm_id — BIGINT — 외래 키 → auth_realm.realm_id — NOT NULL
  • login_id — VARCHAR(100) — NOT NULL
  • account_name — VARCHAR(100)
  • email — VARCHAR(255)
  • mobile — VARCHAR(30)
  • status — VARCHAR(20) — NOT NULL — ACTIVE, INACTIVE, LOCKED, WITHDRAWN
  • last_login_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

account_credential

  • credential_id — BIGINT — 기본 키 — NOT NULL
  • account_id — BIGINT — 외래 키 → account.account_id — NOT NULL
  • credential_type — VARCHAR(30) — NOT NULL — PASSWORD, KAKAO, NAVER, GOOGLE, SSO
  • credential_identifier — VARCHAR(255) — 소셜로그인 provider user id 등
  • password_hash — VARCHAR(255)
  • password_algorithm — VARCHAR(50)
  • password_changed_at — DATETIME
  • failed_attempt_count — INT — NOT NULL
  • locked_until — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

auth_realm

  • realm_id — BIGINT — 기본 키 — NOT NULL
  • realm_type — VARCHAR(30) — NOT NULL — ADMIN, MALL
  • realm_name — VARCHAR(100) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

buyer_member

  • buyer_member_id — BIGINT — 기본 키 — NOT NULL
  • mall_id — BIGINT — 외래 키 → mall.mall_id — NOT NULL
  • account_id — BIGINT — 외래 키 → account.account_id — NOT NULL
  • member_no — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100)
  • email — VARCHAR(255)
  • mobile — VARCHAR(30)
  • member_status — VARCHAR(20) — NOT NULL — ACTIVE, DORMANT, SUSPENDED, WITHDRAWN
  • joined_at — DATETIME — NOT NULL
  • withdrawn_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

mall

  • mall_id — BIGINT — 기본 키 — NOT NULL
  • seller_id — BIGINT — 외래 키 → seller.seller_id — NOT NULL
  • auth_realm_id — BIGINT — 외래 키 → auth_realm.realm_id — NOT NULL — 해당 몰 구매자 전용 인증 Realm
  • mall_code — VARCHAR(50) — NOT NULL
  • mall_name — VARCHAR(150) — NOT NULL
  • mall_type — VARCHAR(30) — NOT NULL — OWN_MALL, OPEN_MARKET
  • domain — VARCHAR(255)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

mall_vendor

  • mall_vendor_id — BIGINT — 기본 키 — NOT NULL
  • mall_id — BIGINT — 외래 키 → mall.mall_id — NOT NULL
  • vendor_id — BIGINT — 외래 키 → vendor.vendor_id — NOT NULL
  • tenant_id — BIGINT — 외래 키 → tenant.tenant_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • joined_at — DATETIME
  • terminated_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

member_role

  • tenant_member_id — BIGINT — 외래 키 → tenant_member.tenant_member_id — NOT NULL
  • role_id — BIGINT — 외래 키 → role.role_id — NOT NULL
  • assigned_by — BIGINT — 외래 키 → account.account_id — 역할을 부여한 account_id
  • assigned_at — DATETIME — NOT NULL

permission

  • permission_id — BIGINT — 기본 키 — NOT NULL
  • permission_code — VARCHAR(150) — NOT NULL
  • permission_name — VARCHAR(150) — NOT NULL
  • resource — VARCHAR(100) — NOT NULL — product, order, settlement 등
  • action — VARCHAR(50) — NOT NULL — read, create, update, delete, approve 등
  • description — VARCHAR(500)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

role

  • role_id — BIGINT — 기본 키 — NOT NULL
  • role_code — VARCHAR(100) — NOT NULL
  • role_name — VARCHAR(100) — NOT NULL
  • tenant_type — VARCHAR(30) — NOT NULL — PLATFORM, SELLER, MALL_VENDOR
  • is_system — TINYINT(1) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

role_permission

  • role_id — BIGINT — 외래 키 → role.role_id — NOT NULL
  • permission_id — BIGINT — 외래 키 → permission.permission_id — NOT NULL
  • created_at — DATETIME — NOT NULL

seller

  • seller_id — BIGINT — 기본 키 — NOT NULL
  • tenant_id — BIGINT — 외래 키 → tenant.tenant_id — NOT NULL
  • seller_code — VARCHAR(50) — NOT NULL
  • seller_name — VARCHAR(150) — NOT NULL
  • business_no — VARCHAR(20)
  • representative_name — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tenant

  • tenant_id — BIGINT — 기본 키 — NOT NULL
  • parent_tenant_id — BIGINT — 외래 키 → tenant.tenant_id
  • tenant_type — VARCHAR(30) — NOT NULL — PLATFORM, SELLER, MALL_VENDOR
  • tenant_name — VARCHAR(150) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

tenant_member

  • tenant_member_id — BIGINT — 기본 키 — NOT NULL
  • tenant_id — BIGINT — 외래 키 → tenant.tenant_id — NOT NULL
  • account_id — BIGINT — 외래 키 → account.account_id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • joined_at — DATETIME — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

vendor

  • vendor_id — BIGINT — 기본 키 — NOT NULL
  • vendor_code — VARCHAR(50) — NOT NULL
  • vendor_name — VARCHAR(150) — NOT NULL
  • business_no — VARCHAR(20)
  • representative_name — VARCHAR(100)
  • status — VARCHAR(20) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL