Teiren_Account_Manager

Tables (15)

Policy (Untitled2)

  • policy_id (Key) — LONG — Primary key — NOT NULL
  • policy_name (정책 이름) — String
  • policy_type (정책 타입) — String
  • description (설명) — String

agreement (동의서)

  • agreement_id (Key) — LONG — Primary key — NOT NULL
  • code (분류 코드) — privacy | marketing
  • name (동의서 이름) — STRING
  • content (동의서 내용) — STRING
  • is_required (필수 여부) — boolean

base_model (슈퍼 클래스)

  • created_at (생성시간) — TIMESTAMP
  • updated_at (수정시간) — TIMESTAMP
  • deleted_at (삭제시간) — TIMESTAMP

group (Untitled6)

  • group_id (그냥 pk 임) — LONG — Primary key — NOT NULL
  • root_id (멤버 아이디) — LONG — Foreign key → root_member.root_id — NOT NULL
  • group_name (그룹 이름) — String

group_permission (Untitled7)

  • Key — Primary key — NOT NULL
  • group_id (그냥 pk 임) — LONG — Foreign key → group.group_id — NOT NULL
  • permission_id (permission id) — LONG — Foreign key → permission.permission_id — NOT NULL

group_policy (Untitled8)

  • Key — Primary key — NOT NULL
  • group_id (그냥 pk 임) — LONG — Foreign key → group.group_id — NOT NULL
  • policy_id (Key2) — LONG — Foreign key → Policy.policy_id — NOT NULL

iam_permission (Untitled4)

  • iam_permission_id (Key) — LONG — Primary key — NOT NULL
  • iam_id (iam 계정 아이디) — LONG — Foreign key → iam_user.iam_id — NOT NULL
  • permission_id (permission id) — LONG — Foreign key → permission.permission_id — NOT NULL

iam_policy (Untitled5)

  • iam_policy_id (Key) — LONG — Primary key — NOT NULL
  • policy_id (Key2) — LONG — Foreign key → Policy.policy_id — NOT NULL
  • iam_id (iam 계정 아이디) — LONG — Foreign key → iam_user.iam_id — NOT NULL

iam_user (IAM 멤버)

  • iam_id (iam 계정 아이디) — LONG — Primary key — NOT NULL
  • root_id (멤버 아이디) — LONG — Foreign key → root_member.root_id — NOT NULL
  • email (이메일) — String
  • id (아이디) — String
  • password (비밀번호) — String
  • domain_id (도메인 아이디) — String
  • department (부서) — String
  • is_mfa (mfa 등록여부) — Boolean

iam_user_group (Untitled9)

  • Key — Primary key — NOT NULL
  • group_id (그냥 pk 임) — LONG — Foreign key → group.group_id — NOT NULL
  • root_id (멤버 아이디) — LONG — Foreign key → group.root_id — NOT NULL
  • iam_id (iam 계정 아이디) — LONG — Foreign key → iam_user.iam_id — NOT NULL
  • root_id (멤버 아이디2) — LONG — Foreign key → iam_user.root_id — NOT NULL

mfa

  • mfa_id (mfa 아이디) — LONG — Primary key — NOT NULL
  • root_id (멤버 아이디) — LONG — Foreign key → root_member.root_id — NOT NULL
  • iam_id (iam 계정 아이디) — LONG — Foreign key → iam_user.iam_id — NOT NULL
  • root_id (멤버 아이디2) — LONG — Foreign key → iam_user.root_id — NOT NULL
  • secret_key (비밀키) — Base 32
  • account_name (mfa 이름) — String
  • Field

permission (Untitled)

  • permission_id (permission id) — LONG — Primary key — NOT NULL
  • action (Field) — String
  • resource (Field2) — String
  • service (Field4) — String

permission_policy (Untitled3)

  • Key — Primary key — NOT NULL
  • permission_id (permission id) — LONG — Foreign key → permission.permission_id — NOT NULL
  • policy_id (Key2) — LONG — Foreign key → Policy.policy_id — NOT NULL
  • Field
  • Field2

root_member (루트 멤버)

  • root_id (멤버 아이디) — LONG — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • first_name (이름) — String
  • last_name (성) — String
  • department (부서) — String
  • job_title (직업 이름) — String
  • phone_number (전화번호) — String
  • company_name (회사 이름) — String
  • company_address (회사 주소) — String
  • business_number (사업자 번호) — String or LONG
  • is_mfa (mfa 등록 여부) — Boolean
  • domain_id (도메인 아이디) — String

user_agreement (동의서 - 유저 중간테이블)

  • user_agreement (Key) — LONG — Primary key — NOT NULL
  • root_id (멤버 아이디) — LONG — Foreign key → root_member.root_id — NOT NULL
  • agreement_id (Key2) — LONG — Foreign key → agreement.agreement_id — NOT NULL
  • agree (Field) — boolean