ㅇㅇ

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)