ㅇㅇ
Tables (9)
profile_tenant_memberships
- id — INT
- profile_id — INT
- tenant_id — INT
- role — VARCHAR(32)
- joined_at — TIMESTAMP
profile_tenant_service_roles
- id — INT
- profile_id — INT
- tenant_id — INT
- service_id — INT
- role_id — INT
- granted_at — TIMESTAMP
profiles
- id — INT
- user_id — INT
- profile_name — VARCHAR(50)
- profile_type — VARCHAR(32)
- created_at — TIMESTAMP
service_roles
- id — INT
- service_id — INT
- role_code — VARCHAR(64)
- role_name — VARCHAR(128)
services
- id — INT
- service_code — VARCHAR(64)
- service_name — VARCHAR(128)
- created_at — TIMESTAMP
social_accounts
- id — INT
- user_id — INT
- provider — VARCHAR(32)
- provider_uid — VARCHAR(128)
- linked_at — TIMESTAMP
tenant_services
- id — INT
- tenant_id — INT
- service_id — INT
- service_status — VARCHAR(32)
- joined_at — TIMESTAMP
tenants
- id — INT
- tenant_code — VARCHAR(64)
- tenant_name — VARCHAR(128)
- created_at — TIMESTAMP
users
- id — VARCHAR(50) — Primary key — NOT NULL
- username — VARCHAR(50)
- email — VARCHAR(100)
- password_hash — VARCHAR(255)
- created_at — TIMESTAMP
- status — VARCHAR(20)