회원인증탬플릿
테이블 (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