Cloud Resource ERD
Tables (11)
account (리소스 계정)
- account_id (Key) — INT(11) — Primary key — NOT NULL
- platform_type (Field2) — VARCHAR(10)
- account_identifier_id (Field5) — VARCHAR(50)
- account_name (Field1) — VARCHAR(50)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
cloud_resource_extend (클라우드 리소스(cluster 구분 이전))
- cloud_resorce_extend_id (Field5) — INT(11) — Primary key
- account_id (Key) — INT(11) — NOT NULL — ID|고유식별자|
- service_name (Field4) — VARCHAR(30)
- resource_contents (Field1) — JSON
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
resource (클라우드 리소스)
- resource_id (PK) — INT(11) — Primary key — NOT NULL
- account_id (Key) — INT(11) — Foreign key → account.account_id — NOT NULL
- service_name (Field2) — VARCHAR(30)
- resource_contents (Field5) — JSON
- created_at (Field6) — DATETIME
- updated_at (Field7) — DATETIME
resource_com_code (Untitled2)
- com_code_id (Key) — INT(11) — Primary key — NOT NULL
- group_code_id (Key2) — VARCHAR(50) — Foreign key → resource_com_group_code.group_code_id — NOT NULL
- resource_type_code (Field2) — INT(5)
- code_contents (Field3) — VARCHAR(100)
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
- Field
resource_com_group_code (Untitled)
- group_code_id (Key) — VARCHAR(50) — Primary key — NOT NULL
- code_contents (Field) — VARCHAR(100)
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
resource_ec2_os_user (EC2 계정 정보 테이블)
- user_id (PK) — INT(11) — Primary key — NOT NULL
- resource_id (PK2) — INT(11) — Foreign key → resource.resource_id — NOT NULL
- account_name (Field2) — VARCHAR(50)
- ec2_id (Field) — VARCHAR(45)
- status (Field6) — tinyint(4)
- user_name (Field3) — VARCHAR(20)
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
resource_rds_db (클라우드 리소스 중 RDS)
- resource_db_id (PK) — INT(11) — Primary key — NOT NULL
- resource_id [UK] (PK2) — INT(11) — Foreign key → resource.resource_id — NOT NULL
- db_name [UK] (Field) — VARCHAR(50)
- db_size (Field2) — DECIMAL(5,2)
- character_set_name (Field3) — VARCHAR(50)
- collation_name (Field4) — VARCHAR(50)
- updated_at (Field12) — DATETIME
- created_at (Field11) — DATETIME
resource_rds_db_table (schema 내 테이블)
- table_id (PK) — INT(11) — Primary key — NOT NULL
- resource_id[UK] (PK2) — INT(11) — Foreign key → resource.resource_id — NOT NULL
- db_name [UK] (Field10) — VARCHAR(50)
- table_name[UK] (Field3) — VARCHAR(50)
- table_size (Field) — DECIMAL(5,2)
- auto_incement_size (Field2) — BIGINT(30)
- partition_type (Field7) — VARCHAR(30)
- table_rows (Field6) — BIGINT(30)
- table_collation (Field8) — VARCHAR(30)
- table_comment (Field9) — VARCHAR(500)
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
resource_rds_user (RDS 계정 정보 테이블)
- user_id (PK) — INT(11) — Primary key — NOT NULL
- resource_id (PK2) — INT(11) — Foreign key → resource.resource_id — NOT NULL
- user_name [UK] (Field2) — VARCHAR(30)
- host [UK] (Field) — VARCHAR(20)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
resource_rds_user_lock (Untitled4)
- user_lock_id (Key) — INT(11) — Primary key — NOT NULL
- resource_id (PK) — INT(11) — Foreign key → resource.resource_id — NOT NULL
- user_name [UK] (Field6) — VARCHAR(30)
- host [UK] (Field8) — VARCHAR(20)
- account_locked (Field) — VARCHAR(3)
- authentication_string (Field7) — VARCHAR(100)
- password_expired (Field2) — VARCHAR(3)
- password_last_changed (Field3) — DATETIME
- password_lifetime (Field9) — INT(5)
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
resource_rds_user_privilege (Untitled3)
- user_privilege_id (Key) — INT(11) — Primary key — NOT NULL
- resource_id (PK) — INT(11) — Foreign key → resource.resource_id — NOT NULL
- user_name (Field8) — VARCHAR(30)
- host (Field) — VARCHAR(20)
- priv_level (Field2) — int(4)
- access_db (Field3) — VARCHAR(30)
- access_table (Field4) — VARCHAR(50)
- access_priv (Field5) — VARCHAR(30)
- created_at (Field6) — DATETIME
- updated_at (Field7) — DATETIME