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